Failed to prepare query!<br> 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<br>Query: 
            SELECT a.sub_id, a.user_id, a.action_id, a.object_id, a.object_data, a.add_time,
                   GROUP_CONCAT(a.id) 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