Got error 28 from storage engine
SQL command:
				SELECT a_products_main.*, 
						a_rating.rating,
						GROUP_CONCAT(a_pics_products.filename) AS images
				FROM
						a_products_main
						LEFT JOIN (SELECT * FROM a_statprods WHERE type=1 ORDER BY stat LIMIT 50 ORDER BY stat DESC)	AS subtable ON a_products_main.id =subtable.productid
						LEFT JOIN a_pics_products ON (a_pics_products.itemid = a_products_main.id AND a_pics_products.ismain = 1 ) 
						LEFT JOIN a_rating ON a_products_main.id = a_rating.productid
				WHERE	a_products_main.isvisible = 1	
				AND		a_products_main.availability = 1	

						GROUP BY a_products_main.id
						ORDER BY RAND()
						LIMIT 6
						

		
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 (/tmp) in Unknown on line 0