SELECT SQL_CALC_FOUND_ROWS g.gallery_id, g.title, g.place, g.date, g.description, fg.image_name AS imgName
FROM gallery AS g
LEFT JOIN forms_graphics AS fg ON fg.form_id = g.gallery_id AND fg.is_deleted = 0 AND fg.form_name = 'gallery_form'
WHERE g.is_deleted = 0 AND g.active = 1
GROUP BY g.gallery_id
ORDER BY g.date DESC
SCHL - Photo Gallery
