HOME
FAQ
TOP COMPLAYNTS
TOP SWEET
TOP SOUR
TOP COMPLAYNERS
RANDOM COMPLAYNTS
CONTACT
NEWSROOM
ABOUT
Go
Social Networking
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