SABINE MORITZ

    Exhibitions

    Error in the consult..

    SELECT p.exhibitionid,p.photoid,e.title_original,e.titleurl,e.locationid,e.cityid,e.countryid,DATE_FORMAT(e.date_start ,'%Y') AS date_start_year FROM photos p, exhibitions e WHERE p.categoryid='29' AND p.exhibitionid=e.exhibitionid GROUP BY p.exhibitionid ORDER BY e.date_start DESC

    Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sabinemo_live.p.photoid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by