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.213932 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 (84526,84527,84662,0,125608,124914,124941,116986,125860,89024,89162,89163,125983,118574,116948,116949,116950,118573,117113,117109,117110,118570,118571,118623,118572,118624,118625,118602,118562,118561,118564,118563,74339,74342,74222,124947,100390,126305,100423,116936,116937,84521,116983,116985,116990,117104,117105,117106,117107,117599,118589,118600,118611,120620,118601,119106,120081,128428,101441,101445,101462,101468,101472,101482,101454,101452,101401,101430,101405,101407,101409,101423,101434,101437,101465,120055,122764,122803,101582,101585,101591,101598,101605,101616,101622,101572,101497,101516,101783,101538,101628,101634,101766,101545,101665,101675,101696,101702,101710,101775,101717,101734,101740,101747,101751,101756,101565,101765,124918,124919,124921,126003,126004,126005,126006,125218,117099,117395,117972,118567,100388,99644,129197,129212,129202,129217,129207,129222,129228,129294,129239,129305,129250,129316,129261,129327,129272,129338,129283,129349,129359,129407,129371,129419,129383,129431,129395,129443,132804,132805,132836,132837,132862,132883,132884,132892,132900,132922,132933,132939,132945,132947,132993,133010,133011,133020,133030,133044,133045,133084,133085,132870,132952,84528,84529,119818,117079,117081,117076,117077,117111,117112,117115,117097,117108,117100,117101,117098,117102,117103,122529,100394,120710,119553,120307,120301,116922,120335,120334,118921,120327,120113,120114,120159,120115,120329,120342,120318,120332,120304,120100,120309,119868,120325,120344,120305,120143,120313,120312,120110,120311,120308,120319,120328,120326,120330,122524,117078,117087,118559,118569,118584,119078,118104,120155,120588,118044,100424,117084,117086,120296,120094,119538,119537,119075,119073,120297,119699,120299,120091,126624,126625,126626,126627,116961,116963,118099,118097,119542,119545,120898,120117,120875,120874,120123,120777,118073,116962,120713,118576,121181,118081,118078,121192,116938,119829,119830,118043,121196,121195,121197,116965,120573,120089,120161,117083,117085,118079,118077,116967,121204,121206,116989,121199,119549,121191,121189,120776,121200,121202,121187,121182,120717,121194,121193,120116,121201,120310,117862,117861,120152,120120,120125,120315,120150,120126,120133,120134,120148,120298,120715,120339,120088,120109,120129,120149,121179,120092,120156,120096,117411,119558,121180,120142,120338,118076,120106,120108,117430,120153,117423,120572,117407,121186,121188,121184,121205,121183,121185,120112,121198,118106,121190,120781,125311,125313,125314,125315,125316,125679,125680,125681,125682,125683,125684,116964,117431,118916,120107,130850,120321,120127,120130,120324,120166,120320,118116,119112,116975,116982,119579,120589,119583,120337,119501,118093,119069,118113,118114,118095,118191,118101,118096,118117,118121,119695,119578,120306,120323,120619,120137,120559,120145,120322,120151,120316,120341,120340,120090,120300,116921,117501,119113,119084,120926,120941,120946,120936,120923,120924,120931,120938,120929,117629,120947,120927,120942,120932,120935,120939,120953,120952,118090,118086,119913,120933,120943,120945,120937,120940,120922,120925,120950,120951,120949,120948,117670,120930,120928,120954,120955,120957,120956,116999,118137,117090,117091,117406,118143,117088,117089,117427,118909,119671,120302,118131,126599,126600,126685,126687,117665,117627,117666,117080,117096,117412,117414,117424,118575,118579,118580,118581,118586,118588,118599,118605,118606,118607,118608,118613,118637,118913,118917,119006,119008,119015,119091,119099,120036,116920,124922,126623,122594,122593,99239,117642,117643,117678,117663,116827,117634,117660,117681,117640,120343,117652,116829,119546,118923,116830,117400,117432,116831,117636,116953,119063,119064,119082,117969,120068,118587,119089,119090,119065,119066,119059,119062,118202,116969,119575,118112,118074,118136,119555,119548,118128,118127,118082,118083,116895,116970,118122,116971,116973,119559,119539,118110,119048,119541,119533,121340,119817,119819,116859,116860,119820,118912,119007,118925,118926,118596,119009,119010,118919,118920,120028,119824,118585,119825,116919,122431,119827,119108,118133,117410,117696,119828,116837,116838,117647,116839,117655,118109,122520,117645,117675,117630,116840,116841,120934,119083,118130,118132,119045,119697,117650,117637,117639,117693,117697,119058,117691,119071,117409,116843,116898,117662,118908,117981,116844,116853,117631,117426,117405,117396,119107,117676,117680,117653,119547,120103,118609,118610,117635,118918,119989,118111,118108,118590,118135,118107,118120,119068,118124,118123,120162,118591,117677,118119,118125,118126,118140,118139,118582,118583,117682,117656,117429,120944,117413,117404,117398,117401,117399,117403,117695,117005,117082,119070,118592,118134,117644,118129,119077,117648,118145,99366,99367,99423,124018,99661,99662,99663,99681,99682,99683,99684,124050,124051,124151,99208,124155,99209,99177,99179,99182,99186,99189,125152,125158,125368,125369,125370,125371,125372,125373,125984,125985,125986,125987,125988,125989,125990,125991,125194,125195,125196,125197,125992,125993,125994,125995,125996,125236,125242,124915,124916,124917,124920,124923,124934,125998,125999,126000,126001,126002,124936,124942,124943,124944,124946,125770,125771,125772,125782,125783,124957,125148,124958,124960,125219,125220,125221,125222,125223,125083,125861,125542,125543,125544,99223,99191,99224,99192,125607,126358,127734,120780,125312,125317,125318,123996,124156,99240,99387,99388,99375,99376,99377,99378,99379,99383,99384,99385,99693,116855,116876,117002,117004,117402,117408,117418,117419,117420,117683,117684,117698,117863,118075,118324,118603,118604,118914,118915,119101,120782,124011,99398,99399,99400,99413,99414,99415,99416,99418,99685,120784,119086,120825,117415,119885,118085,119072,117006,119998,118105,120163,120136,119109,119067,117616,120157,126306,117397,120709,120621,119102,119104,119046,120624,119044,119049,119050,119053,119055,119061,119821,119822,119823,116862,120786,120787,119860,117422,119087,119867,119085,118032,118028,118033,119092,120591,119915,119094,120336,118141,118614,116861,118102,120333,120314,120331,120823,118142,120105,126030,126101,126102,126103,126104,126105,126106,126268,126351,126459,126567,126568,126569,126570,126571,126572,118034,118027,118091,118089,120897,120889,120895,120904,118029,118031,118036,118087,120901,120911,120860,120859,120915,120886,120913,120856,120887,120908,120910,120912,120914,120916,120917,120905,120906,120903,120907,120909,120902,120919,120920,120918,120921,120622,119498,119551,119504,119577,119580,120708,119556,116923,120879,119993,120960,120991,119536,118138,118080,119826,120969,120971,120970,120965,120999,121003,120988,121001,120995,121000,120974,120986,119554,120139,120140,120118,120154,120876,119534,119991,119914,120998,120992,120967,120983,120958,120973,120972,120976,120978,120979,120981,120980,120975,120982,120961,120962,120963,120964,120966,120996,120990,120968,120997,120977,121002,120873,120989,120959,120993,117000,120984,120987,120985,125190,125191,125192,125193,116992,119088,119845,120135,120131,120128,118040,120586,119745,119744,119746,117093,118035,118593,119079,119100,100438,120098,120099,119698,118578,119074,116914,119114,118092,118594,118595,117094,117095,116939,116940,116941,117977,120086,118568,119735,120141,119748,119105,120132,120095,120144,120716,119076,118041,118038,118039,118577,120087,120124,120102,117425,117092,118566,119047,119093,119103,119667,119996,119693,118030,119095,119013,119014,119051,119054,119056,119057,119060,119081,120861,120900,117628,119463,118088,119098,120896,120857,120890,120881,120883,120851,120888,120891,120872,120852,120855,118910,120867,116998,120121,120899,120877,120878,119466,117669,120868,120850,120869,117003,117667,117668,120849,117638,120854,120858,120862,120848,120847,117782,120846,120870,120853,120871,119992,120882,120880,120885,118098,117417,117416,118100,120864,120865,120866,117001,120893,120894,126127,126129,126131,126133,126601,126628,126629,126630,126631,126686,126688,116896,119052,119080,119096,119097,119111,120790,116924,120179,120262,118084,120272,120275,120217,120251,120278,120283,120093,119887,119864,120261,119465,120244,119552,119503,120286,120253,120209,120210,120199,120266,120264,120268,120190,120191,119884,120254,120256,120260,119576,120269,120147,120274,120284,120252,120277,120276,120138,120271,120273,120287,120279,120281,120288,119581,120821,120590,119997,120146,120258,119747,120623,120295,120243,118094,120863,120292,116918,120101,117692,119110,117690,117689,117421,120259,117685,117688,117686,117600,125976,125977,125978,125979,126035,126135,126136,126138,126140,126141,126146,126147,126150,126152,126276,126359,126426,126427,126428,126579,126580,126581,126582,126583,126584,126585,126602,126603,126604,126632,126633,126634,126635,126636,126637,126638,126639,126640,126641,126642,126643,126644,126645,126646,126647,126689,126690,126691,126692,126693,126694,126695,117603,117605,117607,117614,117687,120568,128460,128461,128462) 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