EXPLAIN SELECT SQL_CALC_FOUND_ROWS L.listing_id, L.category, L.property_name, L.listing_news, L.island, L.location, L.district, L.bedrooms, L.bathrooms, L.living_area, L.price
FROM listings AS L
LEFT JOIN list_views AS LV ON LV.listing_id = L.listing_id
LEFT JOIN categories AS C ON C.id = LV.view_type
WHERE cms_status = 'complete'
AND hide = 'no'
AND expiry > CURDATE( )
AND L.category = 'residential'
GROUP BY listing_id
ORDER BY price DESC
table type possible_keys key key_len ref rows Extra
L ref properpublic properpublic 32 const,const 460 Using where; Using temporary; Using filesort
LV index NULL view_list_id 12 NULL 622 Using index
C eq_ref PRIMARY PRIMARY 4 LV.view_type 1 Using index