select distinct h.title,h.id,h.price,h.capacity,c.name,hp.title as photo from Halls h left join Cities c on h.city_id = c.id left join (select hall_id, title,id from Halls_photo where status=1 GROUP by hall_id) as hp on hp.hall_id = h.id left join Halls_type ht on ht.hall_id= h.id where h.status=1 limit 6select distinct h.title,h.id,h.price,h.capacity,c.name,hp.title as photo from Halls h left join Cities c on h.city_id = c.id left join (select hall_id, title,id from Halls_photo where status=1 GROUP by hall_id) as hp on hp.hall_id = h.id left join Halls_type ht on ht.hall_id= h.id where h.status=1 and type_id=2 limit 6

رزرو سالن

مناسب جشن و مهمانی

سالنی یافت نشد.