Azienda


Nuoviprodotti
Informazioni Condizioni Altri Prodotti Catalogo RSS Scrivimi
banner colonna destra

CCR MEDICAL Srl

CCR MEDICAL Srl
1054 - Unknown column \'p2c.categories_id\' in \'field list\'

select p.products_image, pd.products_name, p.products_id, p.traders_id, p.manufacturers_id, p.products_price, p.products_selling_status, pt.traders_services_id, p.products_tax_class_id, p2c.categories_id, p.products_min_order_qty, pt.traders_shop_name, p.products_set_qty, 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 from (products p, products_description pd, traders pt, manufacturers m) left join specials s on p.products_id = s.products_id where p.products_status = \'1\' and p.products_quantity > 0 and pd.products_id = p.products_id and pd.language_id = \'4\' and p.traders_id = pt.traders_id and pt.traders_ap = 1 and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = \'277\' order by pd.products_name limit 0, 12

[TEP STOP]