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.107218 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,119283,119667,119831,119572,120560,119552,120551,120557,118343,120554,119554,120002,119051,118357,118169,118354,119884,117003,120559,120290,121062,121056,121074,121028,118396,121067,121068,121026,121043,121033,121034,121035,121037,121036,121038,121032,121040,121039,121041,121042,121061,121088,121070,121024,118372,118367,121072,121086,120001,121087,121044,121063,121055,121053,121048,121084,121075,121082,121054,121083,121059,121049,121060,121050,121057,121058,121064,121080,121071,121073,116994,118267,118152,118246,118081,118361,126036,126201,126202,126203,126204,126287,126288,126324,126376,126377,126434,126588,126589,126590,126591,126592,126593,126607,126608,126609,126610,118164,116856,119171,119173,120573,120572,119904,119613,119616,120834,119498,120736,120159,120288,120258,119845,117524,117525,117849,121129,121122,121135,121113,121117,121115,121150,121137,121108,119178,120832,119116,117413,117452,117456,119052,119054,119056,119057,119060,120272,120251,120295,120244,120199,120266,120767,120252,120271,120273,120279,120259,120102,119888,120101,120256,120146,119961,121228,116923,120098,120262,120275,120217,120278,120283,119139,121227,121266,121237,121246,121247,120261,117473,117490,121277,118377,121274,119571,120160,120243,120286,120253,120209,120210,120212,120145,117258,117259,117251,117787,117788,117789,121222,117250,120264,120268,120190,120191,120113,120114,121105,121029,121027,121030,121102,121099,121097,121118,121127,121126,121128,121110,121124,121112,121125,121119,121121,121100,121142,121152,120650,119125,121104,121111,121107,121120,121069,121133,121139,120254,120260,121134,121138,121093,121096,121095,121094,117798,121092,117426,117421,117405,120116,119576,120115,120269,120152,120125,120126,120143,120147,120139,120140,120274,120284,120277,120276,120138,120292,120287,120281,117108,117979,119172,120110,120162,120142,117398,120112,117123,117526,119711,118215,124075,119284,128428,101444,101443,101461,101467,101471,101481,101453,101451,101403,101428,101431,101399,101404,101411,101433,101464,116924,119176,118269,119886,117410,117779,117637,117639,117693,117700,117697,117443,117444,117448,117796,117797,117691,117794,117694,117409,116853,101580,101583,101593,101600,101608,101618,101579,101502,101520,101547,101666,101667,101687,101715,101718,101720,101728,101735,101742,101553,126035,126135,126136,126138,126140,126141,126146,126147,126150,126152,126276,126359,126426,126427,126428,126497,126498,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,117472,123987,117437,117476,117501,117599,117603,117607,117614,117804,118150,118151,118330,118331,119081,119091,119181,121315,100388,126491,126495,126496,99642,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,128288,128145,128142,128177,129461,128147,128144,128178,99342,133070,120833,121016,121014,121018,121020,121013,121011,121021,118341,121008,121010,121006,121005,121007,121004,121009,121017,121019,121012,121015,121022,121023,116997,124255,119134,119137,100394,122529,120122,120228,120178,119964,120093,120171,117032,120289,120000,120184,118335,120230,120234,119870,120960,117144,117143,117043,117036,120111,119890,120653,117982,119834,120245,120200,124256,124257,119168,119169,120165,120181,120164,120090,120180,120218,120220,120215,120205,120211,120207,119873,120169,119153,117793,121253,121279,121241,120193,120197,120198,120123,121089,120097,120202,120203,121147,121144,121248,120204,117792,121143,120555,119522,120120,120148,121207,121249,117425,120225,116927,120223,119739,120794,117011,119877,124259,124260,116925,118327,118068,121131,121045,121076,121103,121031,121052,120213,121145,121123,121109,121136,121114,121116,121151,121132,121051,121047,121078,121090,116996,117465,117466,121130,119512,121091,119126,121288,121289,121290,121291,121292,121293,117795,121278,119177,119179,117684,117784,119117,116893,124252,116911,119925,120280,121244,120172,117983,119741,118148,118228,120237,118397,120177,120104,121257,120235,120227,120285,117248,119853,120201,120267,118264,118263,118266,118265,120182,120750,122048,121280,119871,119288,118157,120746,120185,121065,121046,121077,121079,121081,121085,119507,120257,124253,116912,117170,116832,116933,116935,116913,124254,116974,121269,121268,121267,121307,120651) 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