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-4b1c5ca-65cc7.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`,
										`ownerId`,
										`groupTitle`,
										`mainTemplate`,
										`description`
								FROM
										`catalogGroups`
								WHERE
										`id` = '108'

								SELECT
										`id`,
										`ownerId`,
										`groupTitle`,
										`mainTemplate`
								FROM
										`catalogGroups`
								WHERE
										`id` = '0'

								SELECT
										`catalogProducts`.`id`,
										`productTitle`,
										`ownerId`,
										`redirect`,
										`productMainPhoto`,
										`smallDescription`,
										`fullDescription`,
										`data`,
										`language`,										
										`kod`,
										`year`,
										`author`,
										`org`,
										`nositel`,
										`exz`,
										`link`
								FROM
										`catalogProducts`
														
								WHERE
										`catalogProducts`.`id` = '11166'
										

							SELECT
									`photo`
							FROM
									`catalogProductsPhotos`
							WHERE
									`productId` = '11166'
									

								SELECT
										`id`,
										`file`,
										`size`
								FROM
										`catalogGroupsFiles`
								WHERE
										`groupId` = '108'
										

								SELECT
										`id`,
										`file`,
										`size`
								FROM
										`catalogProductsFiles`
								WHERE
										`productId` = '11166'
										
SELECT `groupTitle` FROM `catalogGroups` WHERE `id` = '108'
SELECT * FROM `catalogProducts` WHERE `ownerId` = '108'

						SELECT
								`id`,
								`pageTitle`,
								`address`,
								`pageOwnerId`,
								`redirect`
						FROM
								`pages`
						WHERE
								`pageOwnerId` = '0' && `publicTop` = '1' && `lang` = 'en'
						ORDER BY
								`position`
								
SELECT * FROM `faq` WHERE `lang` = 'en' && `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