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.191109 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,133161,132781,132784,132775,132776,132774,132777,132778,132779,132780,120218,116927,120220,120223,119875,119873,119610,121065,117056,116916,117058,120576,120841,121031,119757,121302,121329,119968,119886,120015,124254,117059,117060,117057,120740,120760,118869,118870,119846,120182,117970,119936,120769,117983,121236,118857,118865,117287,117290,120193,120197,120198,121208,117963,117299,117301,117302,120160,120562,118365,118397,118403,118338,118339,120243,121257,121259,117999,119750,119798,118862,118858,118866,118855,118852,119918,119935,120190,120191,119697,120204,117425,126127,126129,126131,126133,116864,116978,121076,118984,119564,121253,121241,119939,117498,119507,120030,117064,118867,118868,118863,118864,121285,118859,119974,120684,120247,120246,121288,121289,121290,121291,121292,121293,120840,119575,119563,118399,118405,118002,119509,119492,119494,119495,119566,119562,119505,119565,120751,117268,117269,117285,117286,117300,117295,117294,121332,119892,117274,117275,117276,119937,119976,119973,119933,121248,119834,121207,121249,120685,120687,99401,117528,118937,118936,99493,99578,116832,116980,117976,118150,118151,118330,119993,121046,118994,119642,119638,121052,117281,117282,119871,121047,74343,99247,124260,126497,126498,101444,101443,101461,101467,101471,101481,101453,101451,101403,101428,101431,101399,101404,101411,101433,101464,121276,121272,121275,121228,120361,120362,116977,120353,120185,116828,117752,116923,120099,120180,119833,120225,120215,120217,120211,120207,120169,119139,117786,121227,120365,117400,120581,117432,116831,120360,121233,121244,121269,121268,121234,121213,121266,121237,121246,121247,121242,119123,117272,117273,120359,119124,117758,120750,119796,119673,117879,121062,121056,121074,120172,121077,121079,121081,121085,118376,119145,117479,117777,117778,120174,119132,119131,119285,119320,120368,117473,117062,117530,117531,120357,120351,117491,117527,117529,118427,118426,119907,117291,120358,117767,117762,120348,120352,121254,117510,117742,117745,119321,119295,119311,119316,119317,119319,119318,119313,117871,117872,120183,120123,120363,117532,119314,119894,118070,117458,119794,121277,121260,120364,119972,119322,117883,117884,117781,117885,117880,117874,117876,117875,117873,117877,117878,117819,117870,117799,121028,117483,117497,117482,117496,117464,117969,117297,117298,120231,119312,121238,120370,120350,120349,118377,117971,121270,117467,117989,117536,118072,117918,121274,119180,117916,119089,119090,118363,118368,120244,118423,120794,118402,119327,120553,118421,118420,118362,118408,118411,118175,118170,118168,118422,119323,119286,119328,119315,119326,119179,119324,119325,119195,119196,119200,119199,120239,120240,120377,119724,119641,119637,118418,118409,118412,118407,118414,118329,118425,120378,120375,120376,117470,117471,121240,118938,119592,118249,118226,118251,118240,118424,118248,118417,118000,118179,118241,118250,118419,118269,118009,117998,118005,118001,118006,118008,121067,121068,121043,121033,121034,121035,121037,121036,121038,121032,121040,121039,121041,121042,121061,121070,117764,117783,117770,117754,117492,119115,117441,117442,117446,119120,119118,119119,119122,120177,121024,119756,118921,121267,120354,119701,120345,120369,120366,120367,120682,117816,120355,119881,119882,120226,120373,120374,120209,120210,119801,120235,120176,119728,120216,122181,119687,116933,116934,116935,120347,120346,120227,120097,120213,120371,120356,120775,118849,118850,117055,117279,117280,117270,117271,118873,118874,118993,118992,117266,117267,118843,118851,118943,119971,119843,117277,117278,117293,117292,121327,119874,119856,118854,118861,120181,117787,117788,117789,117410,117696,121222,116842,120904,120573,117438,117439,117459,117472,117765,120202,120203,121072,121029,121027,121030,121086,120001,119151,121273,117753,117751,117779,117639,117697,121069,117768,117443,117444,121256,121271,121262,117743,121263,119877,117651,117763,121087,121044,121063,121055,121053,121048,121084,121075,121082,121054,121083,121059,121049,121060,121050,121057,121058,121064,121080,121071,121073,120201,120372,119891,116994,121090,121091,118267,118428,117981,116845,116846,116847,116991,116854,118990,118991,118264,118263,118266,118265,117426,117421,117405,120116,120115,120120,120125,120126,120143,120147,120148,120139,120140,120179,120138,117979,119172,120110,120142,118152,117398,117695,120572,120112,118215,122762,122763,123304,123305,123308,123313,123316,124321,124322,124323,124324,123386,101580,101583,101593,101600,101608,101618,101579,101502,101520,101547,101666,101667,101687,101715,101718,101720,101728,101735,101742,101553,99394,99245,99246,99248,99489,99313,99319,99320,99321,99337,99277,74225,124130,124131,74226,124132,124133,74227,124134,124135,74228,74224,124136,124137,124138,99333,99334,99335,99221,124165,99222,124166,124244,99181,99185,99188,99202,99234,99203,100488,126036,126201,126202,126203,126204,126287,126288,126324,126360,126376,126377,126424,126425,126434,126588,126589,126590,126591,126592,126593,126607,126608,126609,126610,126758,126759,126761,126762,126764,126765,126767,126768,126770,126771,126773,126774,126776,126777,126779,126780,126782,126783,126785,126786,126788,126789,127040,127041,127042,127043,127044,127045,127046,127047,127048,127049,127050,127051,127052,127053,127054,127055,127056,127057,127058,127059,126757,126760,126763,126766,126769,126772,126775,126778,126781,126784,126787,126790,99239,99403,99406,99407,99409,99410,99411,99412,99417,99484,99485,99947,99948,99949,99422,99424,99425,99452,99429,99430,99329,99274,99270,99391,99390,99389,123986,99271,99310,99326,99327,99275,99339,99340,99276,99278,99341,99345,99346,99347,99348,99349,99358,99359,99360,99279,99350,99351,99356,99357,99291,99292,99293,124171,124175,124179,124181,124024,124025,124028,124032,133152,133150,84651,84652,84653,84654,89024,89162,89163,99342,116900,116925,116928,116979,117420,117465,117466,117474,117501,117784,117804,117972,117993,117994,119056,119057,119091,119117,119133,119181,119329,128328,128329,100390,122524,100388,122525,122526,122527,126491,126495,126496,99655,128373,128374,128375,128376,128386,128428,128450,116893,129184,129186,129187,129188,129189,129194,129209,129199,129214,129204,129219,129224,129290,129235,129301,129246,129312,129257,129323,129268,129334,129279,129345,129356,129404,129368,129416,129380,129428,129392,129440,128299,128288,128145,128142,128177,129461,128147,128144,128178,128231,128141,129472,128139,128250,128221,129480,128075,128135,129473,128137,128246,128176,129474,128248,122528,75039,130968,130969,130970,130971,130975,130976,132104,132110,132111,123987,132227,131925,131926,131915,131186,131331,131332,131333,131334,124146,124147,124148,124149,124153,99328,99280,99294,99295,124170,124174,124178,131928,132113,117402,133070,133135,129515,84661,84659,84660,133158,133160,120017,120577,120842,118010,118342,118406,119969,119883,117882,122048,121066,120655,121252,117506,117507,117508,117509,120683,121251,119726,120224,120219,120221,118367,121314,119876,119898,119201,116910,116833,116834,117881,132507,132508,132509,132510,132511,132512,132513,120741,120761,119147,117063,117061,118398,118871,118872,126121,126122,126123,126124,126125,126274,126357,126618,126619,126620,126621,126622,126682,126683,126684,119795,120742,119635,119639,118401,118004,118007,120817,118404,119919,121258,121235,121255,117964,120192,120194,120195,118860,119681,119680,117997,117848,120564,120563,119727,118416,118429,118415,118003,120579,119760,119765,120214,119755,119799,120145,120168,120753,120186,118413,119797,118400,118856,118853,117303,117304,120020,121261,120196,99577,116866,99402,118845,119950,119908,118210,117494,85777,120636,120187,116904,124261,119952,119975,119779,118211,118219,119674,120743,119737,119636,119640,120843,119514,120831,119516,119766,118410,119493,117170,117288,117289,117296,117283,117284,119970,119947,119954,120686,120688,99492,117995,100382,85561,117975,119787,117974,120248,119632,119634,119951,119900,120009,119920,119880,119879,117909) 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