select pd.products_name, pd.products_name2, p.products_divers, p.products_model, p.products_image, p.products_id, p.products_master, p.products_master_status, p.manufacturers_id, p.products_price, p.design_surface, p.products_price_surface, p.products_remise, p.products_weight, p.products_quantity, p.products_qty_blocks, p.products_tax_class_id, p.adh_cart, p.products_affect, p.group_products, p.name, p.price, p.netWeight, p.status, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, ptdc.discount_categories_id, p.products_mesure_status from h2f_products p left join h2f_specials s on p.products_id = s.products_id left join h2f_products_to_discount_categories ptdc on p.products_id = ptdc.products_id, h2f_products_description pd where p.products_status = '1' and pd.products_id = p.products_id and p.products_id = '502' and pd.language_id = '4' [TEP STOP] |
