Untitled

SELECT o.*, a.name AS account_name, p.name AS product_name, c.first_name, c.last_name, s.name AS status_nameFROM (((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.idORDER BY name DESC LIMIT 100