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.131368 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,119831,119523,120560,121106,120735,120653,120569,118343,120179,117035,119993,119465,120561,119552,119604,117755,120551,119570,120557,119841,118334,117951,119934,119917,119526,119713,120648,117958,120554,120159,119554,120288,120258,119613,119616,120834,119498,118772,119015,119667,119845,121224,121223,121221,121225,121226,117524,118780,118782,117525,117849,121129,121122,121135,121113,121117,121115,121150,121137,120002,119178,118391,118358,119116,117413,120832,116896,117452,117456,119052,119054,119056,119057,119060,119061,120272,120251,119887,119698,119885,118356,118357,118167,118169,118352,118354,118351,120295,118355,120244,118366,119506,119503,120199,117208,117207,117210,117209,117246,117247,117212,117211,121320,120266,120745,118789,120252,120271,120273,120279,120102,119747,119884,117003,119867,119169,121229,121230,121231,120960,121212,121218,121232,121209,121211,121216,121217,121215,121210,121220,121219,121214,120559,116918,120013,120256,120146,120290,119961,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,119284,119864,120098,120262,117756,118208,119571,118333,118822,118374,119488,120145,121319,119998,118081,120268,121100,121133,120254,117448,121096,118361,117526,117418,117419,117476,118328,118325,119609,118840,120004,120005,118327,118819,117963,120243,120028,120264,120190,120191,120162,121207,120718,118984,119682,117240,117239,118793,118795,118796,118792,118826,118834,118809,118810,118837,118838,118805,118806,119611,118372,118164,118921,121302,118976,118978,118762,118763,118764,118765,118766,118767,118768,118769,118770,118771,119039,119040,119041,118827,118811,118812,118824,117254,117255,117256,117257,117258,117259,117251,117260,117261,118980,118982,118823,118746,118747,87865,119036,119037,118839,117045,117222,117221,117232,117231,117244,117234,117233,117245,117224,117223,117028,117046,118988,118987,118756,118757,118750,118751,116877,117250,120811,119697,120650,117768,121139,117238,117237,118986,118985,121138,118989,120292,118602,99579,125974,120812,118818,119576,99401,116856,116863,116899,117976,118150,118151,118330,118331,119034,119035,119572,121315,99403,99493,99578,119612,117119,117117,117116,132500,132501,132502,132503,132504,132505,132506,118251,119043,120793,121142,121152,116844,126034,126126,126128,126130,126132,126134,126275,126623,126624,126625,126626,126627,126628,126629,126630,126631,116924,119591,117968,119876,120152,120281,119302,121227,121213,121222,99664,99665,99666,99667,99668,99674,99687,99688,99689,99675,99676,101444,101443,101461,101467,101471,101481,101453,101451,101403,101428,101431,101399,101404,101411,101433,101464,116828,117681,117752,117785,116923,120275,120217,120278,120283,119139,117855,117786,117400,117432,116831,117853,117449,119190,119123,119124,119150,117451,119063,119064,119130,119289,118376,120261,119145,117479,117777,117778,119132,119131,117473,117490,117857,119082,117767,117761,117762,117435,117742,117745,119291,119295,117866,118070,117458,117781,117856,119292,117480,117461,117462,117496,117464,117969,117867,118380,118381,116947,118387,118377,117971,117467,117549,117523,117809,117852,117493,117481,117800,119297,118375,118389,118390,118388,118396,118332,118382,118383,119089,119090,118378,118369,118370,118363,118379,119127,118368,118242,119065,119066,119059,120574,119129,120160,118936,119303,118384,119304,119128,119298,119323,119299,119300,119301,119305,119195,119196,118329,117470,117471,117860,117859,118240,118269,117865,119306,119307,119308,117460,117764,117783,117770,117754,117492,119115,117441,117442,117446,117453,117447,119120,119293,119294,119296,119152,119191,117457,117477,119118,119119,119122,116891,119138,119135,116892,119136,117850,117780,117469,117468,117953,117960,117961,117954,117955,117956,117816,117858,117851,120286,120253,120209,120210,118367,117230,117128,118788,118774,118394,117787,117788,117789,117410,117696,116842,120573,119143,117440,117478,117433,117445,117438,117439,117454,117459,117472,117847,117765,120113,120114,121072,121029,121027,121030,121102,121099,121118,121127,121148,121126,121128,119151,118386,119045,117790,119287,117436,117759,117771,117772,117766,117753,117751,117791,117779,121120,121069,117450,117443,117455,117743,117748,119058,120260,117747,117651,117808,117763,117740,117434,119148,117409,118115,118267,118428,117981,116846,116847,117124,117426,117421,117405,120116,120115,120269,120125,120126,120143,120147,120139,120140,120274,120284,120277,120276,120138,120287,117108,117979,119172,120110,120142,118152,117398,117695,120572,120112,117123,118246,118395,118215,123071,123072,123073,123074,122758,122759,122955,123520,122956,123521,123304,124332,124341,124342,124343,124333,124334,124335,124336,124337,124338,124339,124340,123386,122723,101580,101583,101593,101600,101608,101618,101579,101502,101520,101547,101666,101667,101687,101715,101718,101720,101728,101735,101742,101553,99241,99242,99380,99381,99382,99370,99371,99372,99322,99277,74238,74233,74236,74235,124052,124053,124054,124055,124056,124057,124058,124059,124060,124061,74234,124062,124063,124064,124065,74232,124066,124067,124068,74231,124069,124070,74230,124071,124072,124073,124074,99285,99286,99332,99419,124141,99208,99209,99212,99213,124244,99177,99179,99182,99186,99189,125629,125630,125641,125642,125763,125764,125765,125545,125546,99196,124184,99197,99228,99198,99229,126036,126201,126202,126203,126204,126287,126288,126324,126358,126376,126377,126424,126425,126434,126497,126498,126588,126589,126590,126591,126592,126593,126605,126606,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,127100,127101,127102,127103,127104,127105,127106,127107,127108,127109,127110,127111,127112,127113,127114,127115,127116,127117,127118,127119,127120,127121,127122,127123,127124,127125,127126,127127,127128,127129,127130,127131,127132,127133,127134,127135,127136,127137,127138,126757,126760,126763,126766,126769,126772,126775,126778,126781,126784,126787,126790,118848,121146,121105,121110,121124,121112,121125,121140,121119,121121,121104,121111,121141,121149,121134,121093,121095,121094,121155,121092,121153,121228,99247,99321,99337,99320,99389,99390,99391,99270,99274,74343,99271,133150,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,84520,84655,89024,89162,89163,117118,117420,117501,117804,117993,117994,119091,119133,119181,122524,100390,122526,122527,122528,122529,100394,126491,126495,126496,99642,99643,129173,129184,129186,129187,129188,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,121551,133158,133160,128299,129460,128288,128145,128142,128177,129461,128147,128144,128178,128289,128290,128179,100388,75039,123987,123986,131567,131568,99406,99407,99409,99410,99411,99412,99417,99484,99485,99947,99948,99949,99422,99424,99425,99452,99429,99430,99329,99310,99326,99327,74338,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,124146,124147,124148,124149,124153,124158,124159,124161,123996,124001,124156,124167,124169,124172,124176,124182,99239,99240,99387,99388,99375,99376,99377,99378,99379,99383,99384,99385,99691,99692,99693,99660,99342,117402,132781,132775,132774,132777,132778,122716,133070,133135,129515,84661,84659,84660,133161,133290,133291,133292,133278,133293,133294,133295,133296,131184,119904,100484,119711,118344,119524,120736,121108,120570,120565,119051,119134,119137,120259,119888,120767,119168,120101,117026,118371,119175,119125,117690,117689,117699,117798,117688,117686,117970,119940,120810,119886,117437,126032,126033,126116,126117,126118,126119,126120,126272,126355,126420,126421,126422,126423,126461,126577,126578,121107,117972,130848,120833,118349,118337,121016,121014,121018,121020,121013,121011,121021,119511,118341,121008,121010,121006,121005,121007,121004,121009,121017,121019,121012,121015,121022,121023,116997,124255,120122,120228,120178,119964,120093,119965,120171,120289,120558,118340,118345,119605,119614,119893,119852,119775,120756,119850,119486,120000,120184,118335,120230,120234,119870,118781,117144,117143,120111,119890,117982,117637,117639,117693,117700,117697,120758,120757,120773,119834,117741,117796,117797,117691,117794,120245,119860,117694,116853,120552,121239,120200,119930,120656,120662,124256,124257,117032,118828,118829,117043,117036,84523,116915,117603,117605,117607,117614,119780,119500,119962,120165,119785,117037,120164,120090,116926,119510,120555,118937,116976,120218,116927,120220,120223,119875,119873,117793,117959,117952,117031,120721,117792,121243,119739,117011,118844,121088,121089,119522,116903,120193,120197,120198,121208,119757,118068,120204,117965,117425,121253,121241,119714,119835,118778,118773,117760,121248,120015,117029,121307,119963,117200,120205,120211,120207,121062,121056,121074,120123,121028,120794,121067,121068,121026,121043,121033,121034,121035,121037,121036,121038,121032,121040,121039,121041,121042,121061,121070,121024,124259,124260,121086,120001,121144,119877,121143,121087,121044,121063,121055,121053,121048,121084,121075,121082,121054,121083,121059,121049,121060,121050,121057,121064,121080,121071,121073,116994,121276,121272,121275,116974,120180,119833,120225,120215,120169,119153,121233,121244,121269,121268,121234,121279,121266,121237,121246,121247,117962,121258,121277,121260,121238,121270,121274,118385,119702,119617,120158,121240,118179,119756,120649,121267,119801,120097,118777,120904,120202,120203,121147,121273,117444,121256,121271,121262,121263,120120,120148,121249,118775,118776,116925,116966,117474,117967,121131,118783,121045,116996,121076,121047,121058,121078,121145,120213,121031,121136,121052,121051,121109,121151,121090,121130,121103,121123,121114,121116,121132,117465,117466,119512,120003,121091,117957,121257,121259,117775,117776,117773,117774,120566,121278,118359,117795,118360,121288,121289,121290,121291,121292,121293,119179,119117,116893,119126,117758,119177,118392,116884,117784,130968,130969,130970,130971,132104,132031,132228,131915,131928,132113,116901,124252,116911,119931,118784,117216,117215,120747,121280,120104,119753,117007,120657,120658,120663,118787,116916,120182,119288,122048,120768,117983,117040,118157,118338,119751,119781,119782,119750,117038,120746,116835,119925,119939,116902,119487,118347,118342,117044,117039,117033,118218,118346,119508,120751,118786,117214,117213,117129,117248,118797,118798,118790,121321,119310,119741,119853,118846,116865,116874,121323,120769,119606,119892,119871,120172,119894,119846,118938,120231,119505,120235,119673,119794,120553,119575,119701,119891,117869,120280,117868,121242,120750,118393,118175,118170,118168,118229,118148,118228,118353,116957,120237,119615,118350,118365,116959,118397,118226,116960,120177,119872,120227,120285,120181,120201,120267,119889,118264,118263,118266,118265,117658,117684,124253,116912,119937,119936,120014,119927,119918,119935,121046,121077,121079,121081,121085,119509,119507,120174,120293,120257,120226,117170,116832,119513,116913,124254,120567,120562,120247,120246,117218,117217,118785,119932,120216,120099,118339,116933,116934,116935,121101,121098,116928,120006,120556,120748,117528,119610,117034,120722,119477,119480,117042,117243,119854,120659,120664,119481,117041,117027,118799,118800,119869,121066,119469,119874,124258,116910,116977,121287,119898,120185,119564,117498,120655,121254,85777,121252,120652,121251,118373,119563,119562,119565,120224,120219,120183,120017,118326,118841,119290,119778,119147,119703,119607,100486,120563,118336,119919,119754,120753,121261,119777,117769,118059,117984,118051,121235,121255,117964,120265,120263,120192,120194,120195,119681,119680,117966,117848,120835,118217,119766,119752,119783,120214,120176,120168,120186,119784,119765,120196,99492,99577,119950,124261,120248,119764,120660,120665,119482,119959,119514,117757,121282,120564,119942,120009,119776,118216,100382,118210,117494,121312,121324,121281,121283,120636,120187,120754,116904,117024,119952,120016,118211,118234,118219,117242,117241,116917,120737,118362,120291,119715,120294,119737,118348,116909,119515,119474,120270,120651,117030,117220,117219,117226,117225,117236,117235,118791,117228,117249,117229,118842,121314,117252,117253,117262,117263,117264,117265,118977,118979,118981,118983,118807,118808,118816,118815,118779,118843,120010,120007,118748,118749,119947,119954,119837,118801,118803,118802,118804,118830,118832,118831,118825,118794,117977,121286,125975,117020,120809,117015,118845,118813,118814,118752,118753,118754,118755,118758,118759,118760,118761,118817,118820,118821,116879,116880,116900,117106,119042,119081,119173,128490,128489,121284,120770,120221,119920,119478,119879,119880,119900,119608,120771,119779,119787,119951,120173,119921,120666,120661,116894,119180,120206,120208,120212,120222,126121,126122,126123,126124,126125,126274,126357,126618,126619,126620,126621,126622,126682,126683,126684,132547,132548,132549,132550,132551,132552,132553,85561,120236,119946,121169,116905,120175,120229,119182,119203,119204,118241,120803,119516,119479,120232,120233,119676,119960,119901,118904,116845,120667,119483,117806,117975,117974,119206,120282) 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 = '7288' order by products_ordered desc , pd.products_name