URI: index.php?option=com_akgallery&task=album&id=10&Itemid=45 Message: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dogcom_new.cam.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT cam.id, cam.name, COUNT(*) as cnt
FROM elx_agal_images a,
elx_agal_cameras cam
WHERE cam.id = a.camera_id AND a.published=1 AND a.album_id=10
GROUP BY cam.name
ORDER BY 2