SELECT M.*,MG.mgalleryImageName FROM `mx_media` AS M LEFT JOIN `mx_media_gallery` AS MG ON M.mediaID = MG.mediaID WHERE M.status='1' AND M.mediaType='2' GROUP BY MG.mediaID SELECT M.*,MG.mgalleryImageName FROM `mx_media` AS M LEFT JOIN `mx_media_gallery` AS MG ON M.mediaID = MG.mediaID WHERE M.status='1' AND M.mediaType='2' GROUP BY MG.mediaID Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mounthil_mounthillrealty.M.mediaID' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
