SELECT p.products_id, 
IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, 
IF(s.status, s.specials_new_products_price, NULL) as final_price 
FROM products p
 LEFT JOIN specials s 
    ON s.products_id = p.products_id 
WHERE specials_new_products_price < 1000


SELECT p.products_id, 
IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, 
IF(s.status, s.specials_new_products_price, NULL) as final_price 
FROM products p
 LEFT JOIN specials s 
    ON s.products_id = p.products_id 
WHERE final_price < 1000