LAKE VIEW

SELECT p.id as project_id, p.project_link, p.is_deleted, p.project_name, p.project_country, p.project_city, p.project_location, p.starting_price, p.price_currency, p.preview_rectangle, p.planned_time, p.payment_method, p.construction_year, p.project_status, p.second_hand, p.construction_month, pr.min_price, pr.currency, pg.image_array, pg.image_thumb_array, pg.image_int_array, MIN(pr.min_dollar) as min_dollar, MIN(pr.min_euro) as min_euro, MIN(pr.min_pound) as min_pound, MIN(pr.min_tl) as min_tl, MIN(pr.min_riyal) as min_riyal, MIN(pr.min_ruble) as min_ruble, MIN(pr.min_yuan) as min_yuan, MIN(pr.min_dirhem) as min_dirhem FROM projects as p LEFT JOIN project_rooms as pr ON pr.project_id = p.id LEFT JOIN project_gallery as pg ON pg.project_id = p.id WHERE p.is_deleted = 0 AND p.second_hand=0 AND pr.room_status = 1 AND (p.project_city LIKE "%Dubai%" OR p.project_location LIKE "%Dubai%") AND pr.min_price >= '342224' GROUP BY p.project_name ORDER BY p.id DESC LIMIT 3