4x4 Proyect
ACESSÓRIOS, PEÇAS DE REPOSIÇAO PARA SEU 4X4
SOBRE NÓS
PEDIDOS Y ATENCION AL CLIENTE
Tel: +34 876 26 14 93 info@4x4proyect.com
English Castellano french portuguese Italian 
Serviço e Ajuda

Envios/Devoluçoes | Privacidade | Condiçoes de uso | Advertência jurídica

ARB | Rubicon Express | Old Man Emu | Jeep



Veja o preço dos transportes em seu carrinho

UPS - 4x4 Proyect Nacex - 4x4 Proyect
Credit Cards acepted

 

0.070189 seg.

select SQL_CACHE distinct p.products_image, p.products_model, m.manufacturers_name, pd.products_name, p.products_id,p.products_master, p.products_master_status, p.manufacturers_id,p.products_msrp, 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 from ((products_description pd, products p) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, cache_products_path cpp) left join specials s on p.products_id = s.products_id left join categories c on c.categories_id = cpp.categories_id where p.products_id in (0,126153,126154,126155,126158,126161,126164,126167,126277,126362,126429,126430,126649,126650,126696,126697,126698,126699,126700,126655,126656,126156,126157,126159,126160,126162,126163,126165,126166,126168,126651,126652,126648,126037,126216,126217,126218,126219,126293,126382,126653,126654,126193,126194,126195,126196,126197,126198,126199,126200,126285,126373,126374,126431,126432,126444,126463,122585,100432,101448,101476,101478,101474,101485,101458,101416,101418,101420,101422,101587,101594,101601,101606,101576,101493,101499,101507,101513,101525,101799,101803,101795,101788,101534,101539,101625,101630,101637,101643,101648,101768,101662,101671,101678,101684,101692,101699,101704,101708,101712,101772,101779,101724,101730,101743,101753,101758,101561,101567,129233,129299,129244,129310,129255,129321,129266,129332,129277,129343,129288,129354,129366,129414,129378,129426,129390,129438,129402,129450,130882,130912,130892,130897,130860,130876,130916,132960,132813,132818,132824,132825,132838,132843,132846,132853,132856,132863,132872,132873,132887,132894,132905,132910,132913,132917,132924,132929,132934,132941,132953,132956,132963,132976,132977,132978,133000,133003,133004,133014,133025,133026,133032,133033,133076,133077,133086,133126,132800,132808,132811,132828,132829,132840,132847,132858,132875,132879,132888,132891,132896,132911,132914,132919,132925,132936,132943,132948,132954,132958,132966,132982,132983,132984,133016,133036,133037,133055,133058,133060,133064,133066,133068,133072,133078,133079,133087,133093,133094,133102,133103,133110,133111,133114,133117,133118,133128,123057,122865,122734,128130,125522,125523,123089,122866,122732,125942,125439,125306,125518,125519,125520,125521,122882,123214,122733,125960,128132,128133,128156,128157) and c.categories_status = '1' and p.products_status = '1' and p.products_master = '0' and p.products_listing_status = '1' and p.products_id = cpp.products_id and pd.products_id = cpp.products_id and pd.language_id = '6' and cpp.categories_id = '7248' order by products_ordered desc , pd.products_name