1021
Disk full (/tmp/#sql_2cd_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
SELECT p.products_id, p.products_model, p.manufacturers_id, p.products_price, p.products_quantity, p.special_item, p.products_date_added, p.friendly_url as product_URL, (CASE WHEN p.products_quantity > 0 THEN 1 ELSE 0 END) AS in_stock, m.manufacturers_name, m.friendly_url as brand_URL, m.hide_price, pd.products_name, pd.meta_description, pf.file_path, pf.file_name, p.sale_price, p.sale_start_date, p.sale_expires_date FROM `products` p INNER JOIN `products_description` pd ON pd.products_id=p.products_id INNER JOIN `products_to_categories` p2c ON p.products_id=p2c.products_id LEFT JOIN `manufacturers` m ON p.manufacturers_id=m.manufacturers_id LEFT JOIN `products_files` pf ON p.products_id=pf.products_id AND pf.main=1 WHERE p.isArchived=0 AND pd.language_id='5' AND p2c.categories_id IN (43,44,48,47,45,49,50,46,67,51,73,53,65) GROUP BY p.products_id, pd.products_name, pd.meta_description, pf.file_path, pf.file_name ORDER BY in_stock DESC, p.products_date_added DESC