Query: SELECT sv.video_id, sv.main_id, sv.title, sv.slug, sv.total_views, sv.duration,
                              sv.likes, sv.rating, sv.rated_by, sv.add_time, sv.thumb, sv.thumbs,
                              sv.source_id, sv.url, GROUP_CONCAT(svcc.category_id) AS ids
                       FROM 17_videos AS sv
                       INNER JOIN 17_videos_category AS svc ON (svc.video_id = sv.video_id AND svc.category_id = 231)                       
                       INNER JOIN video AS v ON (v.video_id = sv.main_id AND v.status = 1) LEFT JOIN 17_videos_category AS svcc ON (svcc.video_id = v.video_id)
                       WHERE sv.orientation IN (1) GROUP BY sv.video_id ORDER BY sv.add_time DESC LIMIT 120<br />Error Message: Disk full (/tmp/#sql_17a63_28.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")<br />Error Number: 1021