1021 - Disk full (/tmp/#sql_377_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
SELECT DISTINCT p.*, pd.*, IF(s.status, s.specials_new_products_price, NULL) AS specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) AS final_price, p.products_quantity AS in_stock, IF(s.status, 1, 0) AS is_special FROM products p LEFT JOIN specials s ON p.products_id = s.products_id INNER JOIN products_description pd ON p.products_id = pd.products_id INNER JOIN products_to_categories p2c ON p.products_id = p2c.products_id INNER JOIN categories c ON p2c.categories_id = c.categories_id WHERE p.products_status = 1 AND c.parent_id = 250 AND pd.language_id = 1 ORDER BY p.products_id DESC LIMIT 4
[TEP STOP]
SELECT DISTINCT p.*, pd.*, IF(s.status, s.specials_new_products_price, NULL) AS specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) AS final_price, p.products_quantity AS in_stock, IF(s.status, 1, 0) AS is_special FROM products p LEFT JOIN specials s ON p.products_id = s.products_id INNER JOIN products_description pd ON p.products_id = pd.products_id INNER JOIN products_to_categories p2c ON p.products_id = p2c.products_id INNER JOIN categories c ON p2c.categories_id = c.categories_id WHERE p.products_status = 1 AND c.parent_id = 250 AND pd.language_id = 1 ORDER BY p.products_id DESC LIMIT 4
[TEP STOP]