A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY exhibitions.id HAVING exhibitions.featured = 1 ORDER BY ' at line 29

SELECT DISTINCT exhibitions.id, exhibitions.title, exhibitions.short_title, exhibitions.url, exhibitions.summary, exhibitions.description, exhibitions.location, exhibitions.start_date, exhibitions.end_date, exhibitions.ongoing, exhibitions.label, exhibitions.touring_information, exhibitions.logo, exhibitions.logo_link, exhibitions.color, exhibitions.featured, exhibitions.families, exhibitions.coming_soon, exhibitions.coming_soon_text, exhibitions.installation_label, exhibitions.created, exhibitions.modified, exhibitions_images.image_base, exhibitions_images.image_ext FROM exhibitions LEFT Join exhibitions_images ON exhibitions.id = exhibitions_images.exhibition_id WHERE GROUP BY exhibitions.id HAVING exhibitions.featured = 1 ORDER BY exhibitions.ongoing ASC, exhibitions.start_date ASC, exhibitions.title ASC