thin

SELECT listing_id, category, property_name, island, location, district, 	bedrooms, bathrooms, price, view_type, property_type, living_area, lot_size, 	media.type, media.filename, media.caption, media.sort 	FROM listings 	LEFT JOIN media ON listings.listing_id = media.parent_listing	WHERE featured='yes' 	AND (listings.category='residential' OR listings.category='rental') 	AND type='photo' 	ORDER BY RAND()