SELECT *, DATE_FORMAT(,'%d.%m.%Y') AS date_created FROM simet_notiz_records AS a RIGHT JOIN simet_notiz_assoc AS b ON a.nid=b.nid WHERE a.enabled=1 AND a.rid=0 AND ncid NOT IN (2,3,4,5,6,7,8,9,10) GROUP BY (a.nid) ORDER BY UNIX_TIMESTAMP( DESC, UNIX_TIMESTAMP(a.date_created) DESC LIMIT 0,15
Unable to query MySQL! Please contact Administrator
MySQL Error: Expression #20 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'gvsimets_simetsin_db.b.ncid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by