Fatal Error: Error: Error writing file '/tmp/MYfd=130' (OS errno 28 - No space left on device)
Error No: 3
SELECT pd.name, p.product_id, p.points AS rating FROM product p LEFT JOIN product_store_stock pss ON (p.product_id = pss.product_id AND pss.store_id = 3) LEFT JOIN product_store_availability psa ON (p.product_id = psa.product_id AND psa.store_id = 3) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE p.status = 1 AND p.manufacturer_id = '1285' 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 2508,12 in /var/www/bookish-org/system/database/mysql_i.php on line 116