MySQL: error while complate query


									SELECT
											*
									FROM
											`bannersItems`
									WHERE
											`groupId` = '4' && `isOpen` = '1' 
									ORDER BY
											RAND()
									LIMIT
											0,1
											

Error: Disk full (/tmp/#sql-temptable-3bc-4b21b4d-c5cb0.MAI); waiting for someone to free some space...
(errno: 28 "No space left on device")

Query history: 
SET NAMES 'cp1251'

				SELECT
						`module`
				FROM
						`installedModules`
				WHERE
						`installed` = '1'
				

									SELECT
											`id`,
											`imageTitle`,
											`parentId`,
											`description`,
											`image`
									FROM
											`galleryImages`
									WHERE
											`id` = '598' && `lang` = 'ru'
											

									SELECT
											COUNT(*) AS `count`
									FROM
											`galleryImages`
									WHERE
											`parentId` = '72' && `id` < '598' && `lang` = 'ru'
											

									SELECT
											COUNT(*) AS `count`
									FROM
											`galleryImages`
									WHERE
											`parentId` = '72' && `lang` = 'ru'
											

									SELECT
											`id`,
											`imageTitle`,
											`parentId`,
											`description`,
											`image`
									FROM
											`galleryImages`
									WHERE
											`parentId` = '72' && `lang` = 'ru'
									LIMIT
											4, 2
											

									SELECT
											`id`,
											`imageTitle`,
											`parentId`,
											`description`,
											`image`
									FROM
											`galleryImages`
									WHERE
											`parentId` = '72' && `lang` = 'ru'
									LIMIT
											7, 2
											

									SELECT
											`id`,
											`name`,
											`text`,
											`email`,
											`module`,
											`item_id`
									FROM
											`feedback`
									WHERE
											`item_id` = '598'
											

						SELECT 
								`id`,
								`name`,
								`email`,
								`comment`,
								`rating`,
								`date`,
								`key`,
								`ipLong`,
								`userId`
								
								
						FROM
								`comments`
						WHERE
								`module` = 'gallery' &&
								`section` = 'photo' &&
								`groupIdentificator` = '72' &&
								`itemIdentificator` = '598' &&
								`status` = '1'
								
						ORDER BY
								`date`
						

						SELECT
								`id`,
								`pageTitle`,
								`address`,
								`pageOwnerId`,
								`redirect`
						FROM
								`pages`
						WHERE
								`pageOwnerId` = '0' && `publicTop` = '1' && `lang` = 'ru'
						ORDER BY
								`position`
								
SELECT * FROM `faq` WHERE `lang` = 'ru' && `status` = '1' ORDER BY `date` DESC LIMIT 0, 1

									SELECT
											`id`
									FROM
											`bannersGroups`
									WHERE
											`uniqueKey` = 'main'
									

									SELECT
											*
									FROM
											`bannersItems`
									WHERE
											`groupId` = '4' && `isOpen` = '1' 
									ORDER BY
											RAND()
									LIMIT
											0,1
											


Warning:  Unknown: write failed: No space left on device (28) in Unknown on line 0



Warning:  Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/var/www/redcross/data/bin-tmp/) in Unknown on line 0