A Database Error Occurred

Error Number: 1055

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'c1new2hot.u.country' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT u.country,u.countryCode, u.region, u.regionCode, u.city, u.cityid,count(*) as total FROM users u WHERE u.accStatus='active' AND u.userType<>'consumer' AND u.userType<>'employee' AND u.cityId IN ('1206','1182','1205','1320','5794','5906','1230','7275','10068','11527','10182','7042','1242','11109','11039','7419','8198','40303','8816') GROUP BY u.cityId ORDER BY u.countryCode,total desc