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 = H.userid LEFT JOIN cms_module_feusers_properties P ON = P.userid AND P.title = 'province' LEFT JOIN cms_module_feusers_properties P2 ON = P2.userid AND P2.title = 'ville' WHERE COALESCE(U.disabled,0) = 0 AND U.expires > '2019-01-17 09:04:26' AND LIKE '%q%%' GROUP BY ORDER BY 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