select p.products_id, p.master, m.producer, pd.products_name, pd.products_description, p.products_model, p.products_quantity, IFNULL(pi.image,p.products_image) as products_image, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, mi.manufacturers_name, p.products_status, pd.short_description, p.products_weight, p.delivery, p.products_quantity_order_min, p.products_quantity_order_units, p.barcode, pd.seo_description, pd.seo_title, pd.seo_keywords, p.certificates, pd.documents, s.currencies_code as special_currencies_code, p.currencies_code, IFNULL(DATE_FORMAT(s.expires_date,'%Y-%m-%d'),'') as expires_date, p.mpn from (products p join products_description pd on pd.products_id = p.products_id and pd.language_id = '2' left join manufacturers m on m.manufacturers_id=p.manufacturers_id) left join specials s on s.products_id=p.products_id left join (manufacturers_info mi on p.manufacturers_id=mi.manufacturers_id and mi.languages_id = '2') left join products_images pi on pi.products_id=p.products_id where p.products_id = '2456'