Failed to prepare query!
Error: Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'thotsext_aspro3.a.object_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Query: SELECT a.sub_id, a.user_id, a.action_id, a.object_id, a.object_data, a.add_time, GROUP_CONCAT( AS ids, COUNT(a.user_id) AS cnt, FROM_UNIXTIME(a.add_time, '%Y-%m-%d %H') AS hourly, u.username, u.avatar, u.gender FROM activity AS a LEFT JOIN user AS u ON (u.user_id = a.user_id AND u.status = 1) WHERE a.user_id > 0 AND a.status = 1 GROUP BY a.sub_id, a.user_id, a.action_id, hourly ORDER BY a.add_time DESC LIMIT 100