Warning: mysql_query(): Unable to save result set in /home/ftpaccess/sites/pornohus.com/xxx/includes/db_modules/mysql.php on line 75

Fatal error: Uncaught exception 'Exception' with message 'Mysql error:: 3 (Error writing file '/tmp/MYWmiflR' (Errcode: 28 - No space left on device)) (ext_db_link) in query SELECT gr.name as category_name, gr_data.custom_name as category_custom_name, gr_data.description as category_description, gr.id as category_id, gr_data.group_keywords,
	gr_data.group_custom_var1, gr_data.group_custom_var2, gr_data.group_custom_var3, gr_data.status as group_status, gr.parent_id, tmp.*
	FROM rot_groups AS gr 
	JOIN rot_groups_data AS gr_data ON gr_data.group_id = gr.id and gr_data.site_id = '49' 

	LEFT OUTER JOIN (
		SELECT gi.url, g.*, gs.total_shows, gs.total_ctr, gd.alt, gd.description FROM rot_gallery_info AS gi 
	
		JOIN rot_galleries AS g ON g.gallery_md5 = gi.gallery_md5 and g.rgroup = 0 and g.sponsor_id = 0 and content_type = '0'

		JOIN rot_gallery_stats49 as gs on gs.thumb_id = g.id 
	
		JOIN rot_gallery_data AS gd ON gd.gallery_md5 = g.gallery_md5 

		WHERE gi.url != 0  and gi.source_url = '49' ) as tmp ON tmp.url = gr.id  
	WHERE gr.group_type = 'rotation' 
	
	 order by total_ctr desc. (pornohus.com) ' in /home/ftpaccess/sites/pornohus.com/xxx/includes/db_modules/mysql.php:62
Stack trace:
#0 /home/ftpaccess/sites/pornohus.com/xxx/includes/db_modules/mysql.php(75): db_error('SELECT gr.name ...', 3, 'Error writing f...', 'ext_db_link')
#1 /home/ftpaccess/sites/pornohus.com/xxx/includes/libs/tpl_functions.php(0): db_query('SELECT gr.name ...', 'ext_db_link')
#2 /home/ftpaccess/sites/pornohus.com/xxx/tube/index.php(0): load_categories()
#3 /home/ftpaccess/sites/pornohus.com/xxx/tube/index.php(0): preload_cache()
#4 {main}
  thrown in /home/ftpaccess/sites/pornohus.com/xxx/includes/db_modules/mysql.php on line 62