|
|
|
|
|
|
|
|
Category
|
Show All Categories
|
|
Error: SELECT * ,count(complaynid) as totalcomplayns
FROM category ct
left join complayns cm on cm.categoryid=ct.categoryid
group by cm.categoryid
order by totalcomplayns desc limit 0,5 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'complayn.ct.categoryid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by | | | | |