1021 - Disk full (/tmp/#sql_377_1.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 = 368 AND pd.language_id = 1 ORDER BY p.products_id DESC LIMIT 4
[TEP STOP]