4x4 Proyect
ACCESSORIES AND SPARE PARTS FOR YOUR 4X4
ABOUT US
CUSTOMER SERVICE
Phone : +34 876 26 14 93 info@4x4proyect.com
Sales Manager
nicovogel@4x4proyect.com
English Castellano french portuguese Italian 
Contact Us

Shipping policies | Privacy | Conditions of Service | Legal notice

ARB | Rubicon Express | Old Man Emu | Jeep



See the price of transport in your cart

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

 

0.319366 seg.

select SQL_CACHE 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, products_to_categories p2c) left join specials s on p.products_id = s.products_id left join categories c on c.categories_id = p2c.categories_id where p.products_id in (84526,84527,84662,0,119940,117402,120086,120087,120159,126607,119061,120128,120101,119888,119169,119836,118912,119886,118081,117398,123049,123075,123076,122756,122757,123538,124394,124395,123459,123473,123386,119171,126566,130931,130932,130850,116940,119698,120121,121513,121129,121122,121135,121113,121117,121115,121150,121137,121108,120002,120144,119178,117755,117469,117468,119140,121016,121014,121018,121020,121013,121011,121021,119511,121008,121010,121006,121005,121007,121004,121009,121017,121019,121012,121015,121022,121023,116997,120096,119116,117413,124255,117780,116896,116992,117452,117456,119051,119054,119056,119057,119060,119134,119137,120792,120151,120098,120099,120129,120095,116923,120727,118084,120272,120718,120251,120119,120117,119864,119885,117756,120123,118646,120289,116930,118167,118169,120295,120244,118171,118174,118176,120160,118165,116954,118160,120777,118158,120158,120604,120615,119590,119587,120827,119893,120730,120104,120728,120560,120625,119506,120725,120723,119463,120000,119503,120826,120828,119870,120165,120199,120145,120780,120960,116918,117006,117130,117131,117011,116938,120266,120111,119890,120113,120114,117982,120767,120089,119884,119672,120796,120797,120795,120608,120609,120724,120720,119834,120164,120745,117741,119860,120161,120781,120116,120115,120152,120120,120135,120125,120150,120126,120127,120133,120134,120143,120130,120147,120148,120103,120136,120139,120140,120118,120154,120088,120109,119748,120132,120149,120131,120252,120138,120092,120271,120273,120156,120279,120259,120142,120106,120108,120153,120090,120146,120124,120112,117003,119867,120102,120105,117425,119747,119749,119930,120631,120627,124256,124257,125194,125195,125196,125197,116899,119008,119168,120620,120709,119845,120559,119500,119934,119917,120256,125153,125159,125906,125907,125242,125862,125863,125864,125867,119106,120613,120602,120561,120607,119510,117005,120262,119875,119873,120093,120184,117154,117125,117136,119998,117012,120268,121097,121100,121133,121248,117792,120254,121096,121249,117137,124923,118937,117122,117134,117169,117009,124156,123996,127734,121146,121148,121140,121141,121149,121155,121153,121228,116974,118923,120626,119833,120275,120217,120205,120211,120207,120278,120283,119139,121227,119993,119153,118205,118578,117793,121269,121268,121253,121279,121266,121237,121246,121247,121241,119126,116953,121062,121056,121074,118186,120261,117490,121277,121028,117969,120055,118574,120068,117153,118641,121274,118630,119175,118173,118178,118203,118204,118182,120798,118195,116857,118180,118187,118192,120794,118652,118193,118207,118148,118146,120612,118194,118635,118181,120799,120800,118154,118153,120611,119589,118200,118188,118185,118190,118183,118201,118184,118202,116968,116969,118189,121240,118065,120729,121067,121068,121043,121025,121033,121034,121035,121037,121036,121038,121032,121040,121039,121041,121042,121061,121088,121070,120243,121024,118164,119756,118921,118063,121267,120286,120253,120209,120210,119801,116858,116972,116914,118614,118619,118620,118650,119022,119020,118911,119023,119024,119021,119017,119025,117149,117148,117145,117147,117146,118615,118616,117144,118573,119016,118628,118655,117143,119011,119012,118629,118597,118598,118645,118644,118924,117128,118925,118940,118926,118596,118594,118595,119018,118633,119009,119010,118642,118643,118653,118656,118919,118920,118634,118621,118632,120004,120028,117119,117117,117116,117126,116875,117013,117008,117127,117121,117120,119999,120005,121305,118617,118618,118565,116878,118657,118929,118932,118931,118934,118930,118933,117787,117788,117789,117696,118113,118114,121222,118636,117151,120573,120264,120190,120191,121105,121072,121029,121027,121030,121102,121099,121118,121127,121126,121128,121110,121124,121112,121125,121086,121119,121121,120001,117135,119697,117977,119125,121104,121111,121107,118067,118197,118199,117990,118196,118198,117689,121120,121069,118068,119142,121139,118654,117699,119877,120260,121134,121138,121093,121095,121094,121087,121044,121063,121055,121053,121048,121084,121075,121082,121054,121083,121059,121049,121060,121050,121057,121064,121080,121071,121073,117798,118191,118115,116994,121092,118908,118910,117981,117750,116991,117124,118623,117138,118624,120063,118625,119107,119576,120269,119735,120877,120878,120274,120284,120277,120276,120292,120287,120281,118206,119172,118627,120110,118118,118143,118121,118590,120162,118152,117695,120572,117795,117688,121207,118155,124001,124011,124017,124019,124023,124044,124045,124046,124047,124048,124049,124154,124157,124244,124167,124169,124172,124173,124176,124177,124182,124183,124964,125452,125453,125454,125455,125366,125368,125369,125370,125371,125372,125373,125608,125976,125977,125978,125979,125984,125985,125986,125987,125988,125989,125990,125991,125190,125191,125192,125193,125992,125993,125994,125995,124909,125996,125311,125312,125313,125314,125315,125316,125317,125318,125236,124914,124915,124916,124917,124919,124920,124924,124925,124933,124934,125998,125999,126000,126001,126002,124935,124936,124938,125244,125245,125246,124941,124942,124943,124944,124946,124949,125611,125613,125615,125745,125753,125617,125671,125672,125673,125674,125618,125619,124968,125620,125622,125675,125625,125676,125627,125766,125767,125768,125769,125780,125781,124956,124957,126003,126004,126005,126006,125148,125374,124958,124960,125848,125849,125850,125851,125852,125853,125854,125855,125856,125218,125219,125220,125221,125222,125223,125083,125915,125916,125917,125679,125680,125681,125682,125683,125684,125685,125686,125687,125688,125689,125690,125702,125547,125548,125549,99225,99193,99226,99194,99227,99195,125386,125387,126034,126036,126126,126128,126130,126132,126134,126201,126202,126203,126204,126275,126287,126288,126324,126376,126377,126424,126425,126433,126434,126588,126589,126590,126591,126592,126593,126623,126624,126625,126626,126627,126628,126629,126630,126631,126632,126684,116951,116952,117769,124259,124260,120290,84520,84524,84525,84651,84652,84653,84654,84655,84669,116855,116944,116946,117087,117096,117099,117106,117107,117118,117152,117418,117419,117420,117437,117474,117476,117603,117605,117607,117614,117749,117804,118116,118147,118150,118151,118566,118575,118580,118581,118593,118599,118600,118601,118605,118613,118626,118631,118637,118640,118913,118917,119013,119014,119091,119133,119173,119181,120047,120081,127140,128428,133288,133289,99239,99240,99385,99384,99383,99378,99376,99388,99379,99377,99375,99387,99693,101444,101443,101461,101467,101471,101481,101453,101451,101403,101428,101431,101399,101404,101411,101433,101464,116828,117752,117785,116924,117786,117400,117432,116831,117449,119123,119124,119150,117451,119064,119130,119141,119145,117479,117777,117778,119132,119131,117473,119082,117767,117761,117762,117435,117742,117745,119146,117458,117781,117799,117461,117462,117464,117467,119180,118208,119089,119090,119127,119065,119066,119059,119129,118936,119155,119156,119160,119165,119162,119154,119166,119163,119128,119157,119158,119161,119167,119164,117460,117764,117783,117770,117754,117492,119115,117441,117442,117446,117453,117447,119120,119144,119149,119152,117457,117477,119118,119119,119122,116891,119138,119135,116892,119136,118064,119835,117816,118648,118649,117115,117410,116842,117140,117142,117139,117141,119143,117440,117478,117433,117445,117438,117439,117454,117459,117472,117847,117765,121147,121144,121142,121152,119151,119045,117790,117436,117759,117771,117772,117766,117753,117751,117791,117779,117637,117639,117693,117700,117697,117450,117768,117443,117444,117455,117743,117748,119058,117448,117747,117651,117796,117797,117763,117691,117794,117740,117434,121143,119148,117694,117409,116844,116846,116847,116853,117426,117421,117405,117108,117123,117475,101580,101583,101593,101600,101608,101618,101579,101502,101520,101547,101666,101667,101687,101715,101718,101720,101728,101735,101742,101553,99398,99399,99400,99404,99413,99414,99415,99416,99418,99494,99361,99362,99365,99373,99374,99368,99369,99386,99669,99670,99671,99672,99420,99318,99691,99692,99336,99660,74338,74341,74344,99677,99678,99679,99685,99686,74221,74219,74220,74218,99204,99205,99208,99209,99210,99177,99179,99182,99183,99186,99187,99189,99190,125668,125704,125705,125706,126358,126497,126498,126605,126606,126884,126885,126886,126887,126888,126889,126890,126891,126892,126893,126894,126895,126896,126897,126898,126899,126900,126901,126902,126903,126904,126905,126906,126907,126908,126909,126910,126911,126912,126913,126914,126915,126916,126917,126918,126919,126920,126921,126922,126923,126924,126925,127139,127141,127142,127143,127144,127145,127146,127147,127148,127149,127150,127151,127152,127153,127154,127155,127156,127157,127158,127159,127160,127161,127162,127163,127164,127165,127166,127167,127168,127169,127170,127171,127172,127173,127174,127175,127176,127177,127178,126839,126840,126841,126842,126843,126844,126845,126846,126847,126848,126849,126850,126851,126852,126853,126854,126855,126856,126857,126858,126859,126860,126861,126862,126863,126864,126865,126866,126867,126868,126869,126870,126871,126872,126873,126874,126875,126876,126877,126878,126879,126880,126881,126882,126883,126926,126927,126928,126929,126930,126931,126932,126933,126934,126935,126936,126937,126938,126939,126940,126941,126942,126943,126944,126945,126946,126947,126948,126949,126950,126951,126952,126953,126954,126955,126956,126957,126958,126959,126960,126961,126962,126963,126964,126965,126966,126967,126968,126969,126970,126971,126972,126973,126974,126975,126976,126977,126978,126979,89163,117501,120782,126491,126495,126496,99653,99654,128341,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,132104,132025,132228,131915,131185,131331,131332,99578,132496,132497,132498,132499,132535,132536,132537,132538,133070,121131,120122,120167,121045,121076,121047,121058,121078,121145,121103,121031,121052,120213,121123,121109,121136,121114,121116,121132,121051,121090,116996,84522,121130,121151,119512,120003,121091,121306,117773,117774,120097,120178,120171,120230,120234,120245,120200,119938,120181,121278,120218,120220,120247,120246,119177,119179,121288,121289,121290,121291,121292,121293,121303,117760,120185,120180,120215,120169,120193,120197,120198,120231,120177,120202,120203,120204,120179,116883,116884,117784,119117,116893,117470,117471,116901,124252,116911,119931,120605,120616,117775,117776,116927,120223,120747,121280,119752,117248,120721,118577,120628,120629,120632,119751,119750,117007,120182,119019,120280,121244,117758,117757,119939,119673,116902,119468,117983,116916,117692,119794,120726,119591,118162,116956,119588,118172,118166,116958,116931,120610,118161,118159,118163,120829,121257,119872,118156,120746,119508,119757,119753,120285,120751,121302,117014,118651,119846,119170,119871,118927,118928,120267,119891,119889,117686,125186,125187,125188,125189,100476,120172,116932,120235,120227,120201,120801,116925,117465,117466,120225,117463,119894,120553,118175,118170,118168,119566,119701,119505,119892,117132,117133,124253,116912,119936,118935,121046,121077,121079,121081,121085,119507,120257,120293,118939,119918,119935,125154,125155,125160,125161,125230,125908,125909,125910,125243,125874,125875,125876,125877,125878,125879,120174,119509,125344,119513,116913,124254,121101,121098,120606,120617,120603,120614,120562,119932,119933,120216,116934,116832,118938,116933,116935,121066,121287,117975,117744,117746,117010,120255,117974,121251,119159,120722,118157,119575,119467,120748,118177,120006,119937,119876,119869,124258,116910,120219,120221,119564,120769,120768,119563,119469,119562,119565,120224,119874,119878,119898,120630,120633,119147,119754,119755,120183) 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 = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '7255' order by products_ordered desc , pd.products_name