Error writing file '/tmp/MYfd=479' (OS errno 28 - No space left on device) full query:

			SELECT
				store_products.*,
				store_product_types2customer_types.multiplier,
				customer_types.incvat AS incvat,
				store_warehouses.use_stock,
				store_warehouses.name AS warehouse_name,  
				IF(store_products.voidvat,store_products.price,(store_products.price*1.20000)) AS display_price,
				store_categories.full_url
			FROM
				store_products
			INNER JOIN
				store_products2categories ON
				store_products2categories.productid = store_products.id
			INNER JOIN
				store_categories ON
				store_categories.id = store_products2categories.categoryid AND
				store_categories.id = '9'
			INNER JOIN
				 store_product_types ON
				 store_product_types.id = store_products.typeid
			INNER JOIN
				 store_product_types2customer_types ON
				 store_product_types2customer_types.producttypeid = store_product_types.id
			INNER JOIN
				 customer_types ON
				 customer_types.id = store_product_types2customer_types.customertypeid
			
			INNER JOIN
				store_warehouses ON
				store_warehouses.id = store_products.warehouseid
			 
			WHERE
				store_products.active = '1' AND
				store_products.approved = '1' AND
				store_products.totallyhidden = '0' AND
				customer_types.id = '1'
				
				
			GROUP BY
				store_products.id
			ORDER BY
				store_products.buybutton DESC, store_products.`rank` DESC, store_products.sku ASC, store_products.price ASC
		
			LIMIT
				3872, 16