|
|
select p.products_id, p.products_model, p.products_capacity, p.products_weight_netto, p.products_capsule_quantity, s.specials_new_products_price as final_price, p.products_price, s.status, p.products_tax_class_id, pd.products_name, m.manufacturers_name from products3 p left join manufacturers m using(manufacturers_id) left join specials s on s.products_id = p.products_id, products_description pd where p.products_status = 1 and s.status = 1 and pd.products_id = p.products_id and pd.language_id = '4' and pd.products_name != '' order by rand() limit 4 [TEP STOP] | |||||||||||||||||||||||||||||||||
609-662-642
