Failed to execute prepared query!
Error: Disk full (/var/tmp/#sql_5119_0); waiting for someone to free some space...
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