[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 >
- Shiny Garage
Shiny Garage Shiny Garage - Kosmetyki samochodowe do detailingu
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 (4271,4259,4257,4264,1329672,4256,4250,4272,1330498,4623,4718,6063,1190099,1283959,4285,5711,4262,1330409,1330410,1190100,6239,5709,4263,1190110,4258,5622,1190108,1329771,5713,6240,5705,1329964,5694,1329673,1329855,4267,1283962,5683,5710,1330194,5625,5623,1283980,5035,1190107,6262,1329770,4315,1283981,4254,1330123,4269,5707,4647,5696,5714,1190102,1330120,5708,1330496,1329680,6263,1330205,1329691,1330499,1329657,4268,1330497,1330121,1329654,1190105,1190111,1329694,1330124,1330327,4266,1330411,1190109,5693,1330674,4249,1283960,6264,1330669,1330666,1329895,1329963,6266,1190104,1329893,1190103,5692,1329768,1329656,5716,1330491,1330001,1329765,1283961,1329766,1330346,4261,1329767,4270,1329854,1329892,1329852,1329769,5715,5717,1330671,1329965,1283973,1329845,5695,1330488,1329851,1329835,1329891,1329853,1329982,1330490,1329772,1330464,1330667,1330408,1330673,5626,1330493,4260,1330002,1329700,1330668,1190106,1330675,1330463,1330003,1331404,1331253,1330672,1330670,1331402,1330458,1331406,6265,1330466,1331405,1330462,1331401,1283971,1331403,1283969,1283967,1283966,1283963,1330465,1330505,1283965,1283964,1330456) and pd.language_id = '4' order by p.products_available desc, m.manufacturers_name asc limit 0, 75
[TEP STOP]