Nouvelle-Écosse

 
DEBUG: error in query
  QUERY = SELECT U.*, IFNULL(H.refdate, '1969-12-31 19:00:01') AS refdate FROM cms_module_feusers_users U LEFT JOIN (SELECT userid,action,MAX(refdate) AS refdate FROM cms_module_feusers_history GROUP BY userid,action HAVING action in ('change settings','login')) AS H ON U.id = H.userid LEFT JOIN cms_module_feusers_properties P ON U.id = P.userid AND P.title = 'province' LEFT JOIN cms_module_feusers_properties P2 ON U.id = P2.userid AND P2.title = 'code_postal' WHERE COALESCE(U.disabled,0) = 0 AND U.expires > '2018-12-16 02:09:10' AND P.data LIKE '%nouvelle-ecosse%' GROUP BY U.id ORDER BY P2.data ASC LIMIT 0, 100
  Error = Expression #11 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'H.refdate' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by