SELECT ibex_gallery_albums.*, ibex_gallery_images.title AS cover_title, ibex_gallery_images.src AS cover_src, ibex_gallery_images.caption AS cover_caption FROM `ibex_gallery_albums` JOIN `ibex_areas` ON ibex_areas.id = ibex_gallery_albums.area_id JOIN `ibex_modules` ON ibex_modules.name = 'gallery' AND ibex_modules.active = '1' LEFT JOIN `ibex_gallery_images` ON ibex_gallery_images.gallery_album_id = ibex_gallery_albums.id AND ibex_gallery_images.cover = 1 WHERE ibex_gallery_albums.active = '1' AND ibex_areas.name = 'front' GROUP BY ibex_gallery_albums.id ORDER BY `order` ASC LIMIT 4

Cedar Lake Village Gallery