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-eeca6-22bdb-345d.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` = '154'

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

									SELECT
											`groupTitle`,
											`description`,
											`groupTitle`,
											`redirect`,
											`photo`,
											`ownerId`
									FROM
											`catalogGroups`
									WHERE
											`id` = '154'
											
SELECT `photo` FROM `catalogGroupsPhotos` WHERE `groupId` = '154'

								SELECT
										`id`,
										`groupTitle`,
										`photo`,
										`redirect`,
										`description`
								FROM
										`catalogGroups`
								WHERE
										`ownerId` = '154'
								ORDER BY `position`
SELECT `id`, `productTitle` FROM `catalogProducts` WHERE `ownerId` = '153' ORDER BY `position`
SELECT `id`, `productTitle` FROM `catalogProducts` WHERE `ownerId` = '157' ORDER BY `position`
SELECT `id`, `productTitle` FROM `catalogProducts` WHERE `ownerId` = '158' ORDER BY `position`
SELECT `id`, `productTitle` FROM `catalogProducts` WHERE `ownerId` = '159' ORDER BY `position`
SELECT COUNT(`id`) AS `count` FROM `catalogProducts` 				WHERE
										`catalogProducts`.`ownerId` = '154'

								SELECT
										`catalogProducts`.`id` as `id`,
										`catalogProducts`.`productTitle` as `productTitle`,
										`catalogProducts`.`ownerId` as `ownerId`,
										`catalogProducts`.`smallDescription` as `smallDescription`,
										`catalogProducts`.`productMainPhoto` as `productMainPhoto`,										
										`catalogProducts`.`data` as `data`,
										`catalogProducts`.`language` as `language`,
										`catalogProducts`.`kod` as `kod`,
										`catalogProducts`.`year` as `year`,
										`catalogProducts`.`author` as `author`,
										`catalogProducts`.`org` as `org`,
										`catalogProducts`.`nositel` as `nositel`,
										`catalogProducts`.`exz` as `exz`,
										`catalogProducts`.`link` as `link`
										
										
								FROM
										`catalogProducts`
								LEFT JOIN
										`catalogProductsPhotos` ON `catalogProducts`.`id` = `catalogProductsPhotos`.`productId` 
								
												WHERE
										`catalogProducts`.`ownerId` = '154'

								GROUP BY
										`catalogProducts`.`id`
								ORDER BY
										`catalogProducts`.`position`
										
								LIMIT
										0,
										8
		
										

								SELECT
										`id`,
										`file`,
										`size`
								FROM
										`catalogProductsFiles`
								WHERE
										`productId` = '154'
										

								SELECT
										`id`,
										`file`,
										`size`
								FROM
										`catalogProductsFiles`
								WHERE
										`productId` = '154'
										

						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