[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 >
- Motul
Motul - oleje silnikowe, przekładniowe i płyny eksploatacyjne
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 (3033,4203,3032,4205,3034,3026,4202,4204,3031,1330082,3027,3029,4209,3025,3030,4210,4208,1330901,1330085,1330086,3028,4213,1330906,1330084,4214,4207,1330823,1330904,4206,1330830,1330831,1330083,1330836,1330088,1330087,1330900,1330864,1330862,1330863,1330909,1330899,1330861,1330907,1330902,635969,635970,635971,635972,635973,635941,635940,635939,635937,635936,635935,635934,635968,635967,635938,1330910,635956,635957,635958,635959,635960,635961,635962,635963,635964,635966) and pd.language_id = '4' order by p.products_available desc, m.manufacturers_name desc limit 0, 75
[TEP STOP]