Invalid query: SELECT *,COUNT(cms_carbuncles_categories.carbunclecat_id) FROM cms_carbuncles_categories LEFT JOIN cms_carbuncles_nominations ON (cms_carbuncles_nominations.carbunclecat_id = cms_carbuncles_categories.carbunclecat_id) WHERE carbuncle_id = GROUP BY cms_carbuncles_categories.carbunclecat_id You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY cms_carbuncles_categories.carbunclecat_id' at line 4