SELECT o.*, a.name AS account_name, p.name AS product_name, c.first_name, c.last_name, s.name AS status_name
FROM (((opportunities o LEFT JOIN accounts a ON o.account_id=a.id)
LEFT JOIN product_types p ON o.product_id = p.id)
LEFT JOIN contacts c ON o.contact_id = c.id)
LEFT JOIN status_types s ON o.status_id = s.id
ORDER BY name DESC LIMIT 100