ALEKSANDAR ŠULUBURIĆ

Error: select crops.name, crop_storages.napomena, if(year(crop_storages.updated_at) > 2018, date_format(date(crop_storages.updated_at),'%d.%m.%Y.'),'') as updated_at, crop_storages.cena from crop_storages, storages, crops where storages.buyer_id = 1862 and storages.id = crop_storages.storage_id and crops.id = crop_storages.crop_id group by crops.name order by 1

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