SELECT count(*) AS comment_nums,poster,mail,url FROM pjax_comment where date >0 and poster !='Finally' and poster !='' and hide ='n' group by poster order by comment_nums DESC limit 0,100
error: 1055 , Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'emlog.pjax_comment.mail' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by