[x]
Skontaktujemy się z Tobą najszybciej jak to będzie możliwe. Staramy się aby ten czas nie był dłuższy niż 24h.
(X)
Szukaj pojazdu
Masz problem ze znalezieniem swojego samochodu???
Zapytaj konsultanta: 512 802 277 lub napisz [email protected]
Infolinia czynna:
pon-pt: 9.00 - 17.00
Jesteś tutaj:
- Strona główna >
- Producenci >
- Boll
Boll - profesjonalna chemia samochodowa
select pd.products_name, p.td, p.products_image, p.products_id, p.shipping_methods, cd.categories_id, cd.categories_name, pd.products_shortdescription, p.manufacturers_id, p.products_price, p.products_tax_class_id, 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, p.products_quantity, p.products_image_description, p.products_image_description_2, p.buy_in_pairs, p.withdrawn, p.withdrawn_substitute, p.shipping_methods from products p LEFT JOIN products_to_categories p2c on p.products_id = p2c.products_id LEFT JOIN categories_description cd on p2c.categories_id = cd.categories_id LEFT JOIN categories c on cd.categories_id = c.categories_id left join specials s on p.products_id = s.products_id LEFT JOIN products_description pd ON pd.products_id = p.products_id where p.products_id IN (3894,3900,4786,4742,3897,3905,4741,3899,3907,4738,4803,3906,3915,4729,4745,1288,4793,4792,4737,4771,4763,4739,4779,4725,3902,1330486,3896,4801,5172,3917,3909,3914,1330853,4727,4733,4778,4802,3903,3904,3898,4783,4757,4750,4787,3911,1330845,4775,4788,4770,4776,3893,4755,4747,4795,1330846,4726,3901,1330844,4746,4774,3910,4740,1329907,4772,4743,4732,4765,4744,3908,4761,4768,3918,4780,3895,4781,4753,3919,1329882,4764,4766,4789,4782,4751,1329909,4798,4796,4735,4773,1330851,1330855,1330852,4749,1330847,1330017,4759,1330832,1330841,4752,1330849,1330856,4756,4785,1330843,1330809,4754,4769,1330420,4797,1330839,1330810,1329905,4730,4767,1329908,1330859,1330842,1330850,1330824,4762,1330840,4777,1330812,4728,1330837,1330838,1329904,1330829,1330825,4791,1330817,1330801,1330814,1330816,4760,4731,1330848,4734,1330803,1330804,1330860,1330827,1330800,1329903,1330815,1330818,1330813,1330811,1330828,1330826,1330802,1330857) and pd.language_id = '4' order by p.products_available desc, m.manufacturers_name desc limit 0, 75
[TEP STOP]