Fatal Error: Error: Error writing file '/tmp/MYfd=117' (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 = 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 p2c.category_id IN (2,193,24,129,130,131,132,25,133,134,135,26,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,157,158,159,160,161,27,1078,162,163,164,165,166,167,168,169,170,171,172,173,897,28,174,175,176,29,177,178,179,180,181,182,183,184,185,186,187,188,30,189,951,190,191,192,963,31,194,195,32,196,197,198,199,200,201,202,203,204,205,206,207,208,33,34,35,36,37,209,210,211,212,213,214,38,215,216) AND (EXISTS (SELECT 1 FROM product_store_stock pss WHERE pss.product_id = p.product_id AND pss.store_id IN (3,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 = 3 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 1068,12 in /var/www/bookish-org/system/database/mysql_i.php on line 116