SELECT *, DATE_FORMAT(a.date,'%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(a.date) 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