xonixx / zlo-search Goto Github PK

select nick, user_id, reg, COUNT(*) cnt from x_mipt_cc_messages
where msgDate BETWEEN (NOW() - INTERVAL 1 DAY) AND NOW()
group by nick
order by cnt desc;
-- ERROR 1055 (42000): Expression #2 of SELECT list is not in GROUP BY clause
-- and contains nonaggregated column 'xonix_search.x_mipt_cc_messages.user_id'
-- which is not functionally dependent on columns in GROUP BY clause;
-- this is incompatible with sql_mode=only_full_group_by