Fatal Error: Error: Error writing file '/tmp/MYfd=106' (OS errno 28 - No space left on device)
Error No: 3
SELECT pd.name, p.product_id, p.points AS rating FROM product p INNER JOIN product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN product_store_stock pss ON (p.product_id = pss.product_id AND pss.store_id = 2) LEFT JOIN product_store_availability psa ON (p.product_id = psa.product_id AND psa.store_id = 2) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE p.status = 1 AND p2c.category_id IN (78) AND (EXISTS (SELECT 1 FROM product_store_stock pss WHERE pss.product_id = p.product_id AND pss.store_id IN (2,1) AND pss.stock > 0) OR EXISTS (SELECT 1 FROM product_store_availability psa WHERE psa.product_id = p.product_id AND psa.store_id = 2 AND psa.stock_status_id IN (10,15,20))) GROUP BY pd.name, p.product_id, p.points ORDER BY CASE WHEN COALESCE(pss.stock, 0) + COALESCE((SELECT stock FROM product_store_stock WHERE product_id = p.product_id AND store_id = 1), 0) > 0 THEN 1 WHEN COALESCE(psa.stock_status_id, 0) IN (10,15,20) THEN 2 ELSE 3 END ASC, p.date_added DESC,pd.name ASC LIMIT 576,12 in /var/www/bookish-org/system/database/mysql_i.php on line 116