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