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.032239 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 (123565,123566,123567,123568,123569,123570,123571,123572,123573,123649,123574,123575,123576,123577,123578,123579,123580,123581,123582,123583,123584,123585,123586,123587,123588,123589,123590,123591,123592,123593,123594,123650,123651,123652,123653,123654,123595,123596,123597,123598,123599,123600,123601,123602,123603,123604,123605,123606,123607,123608,123609,123610,123611,123612,123613,123614,123615,123616,123617,123618,123619,123655,123656,123657,123658,123659,123660,123661,123662,123663,123664,123665,123666,123667,123668,123702,123703,123704,123705,123706,123707,123708,123620,123621,123622,123623,123624,123625,123626,123627,123628,123629,123630,123631,123632,123633,123634,123635,123636,123669,123670,123671,123672,123673,123674,123675,123676,123677,123678,123679,123680,123681,123709,123710,123711,123712,123637,123638,123639,123640,123641,123642,123643,123644,123645,123646,123647,123648,123682,123683,123684,123685,123686,123687,123688,123689,123690,123691,123692,123693,123694,123695,123696,123697,123698,123699,123700,123701,123713,123714,123715,123716,123717,123718,123719,123720,123721,123722,123723,123724,123725,123726,123727,123728,123729,123730,123731,123732,123733,123734,123735,123736,123737,123738,123739,123740,123741,124188,122626,122627,122622,122623,122634,122635,122630,122628,122629,122620,122632,122633,122621,122624,122625,122631,92353,92352,92354,92359,92355,92358,92357,92356,92360,92364,92363,92361,92362,123984,124004,124005,124999,125025,125000,125026,125001,125027,125002,125028,125003,125029,124981,124982,125162,124966,125004,125005,124967,124973,124974,125030,124983,124984,125427,125345,125428,124985,125429,125052,124986,124987,125031,125032,125033,125382,125383,124988,125365,125377,124977,125430,124978,124979,124980,125346,124989,125431,124990,125043,125389,125390,125391,125392,125393,125394,125053,125054,124993,124994,124995,124996,125347,125348,125349,125350,125351,125352,125353,125354,125356,125357,125358,125006,125034,132358,125035,125359,125360,125361,125362,125363,125396,125397,125055,125056,125057,125058,125059,125060,125061,125062,125063,125064,125609,125395,125610,125065,125066,125067,125068,125069,125070,125071,125078,125079,125072,125073,125080,125081,125082,125920,125074,125075,125319,125320,125321,125322,125323,125332,125234,125235,125666,125667,125076,124997,125008,125009,125010,125012,125013,125014,125015,125016,125017,125018,125019,125020,125021,125273,125022,124965,125274,125275,125276,125277,125278,125279,125280,125281,125282,125283,125284,125285,125286,125287,125288,125289,125290,125291,125292,125293,125023,125024,125364,125432,125433,125434,125435,125402,125403,125424,125404,125405,125406,125407,125408,125398,125399,125425,125400,125401,125426,125409,125410,125411,125412,125413,125414,125415,125416,125417,125418,125419,125420,125421,125422,125423,125036,125086,125087,125088,125089,125090,125037,125038,125039,125040,125041,125042,125091,125092,125093,125094,125095,125096,125097,125098,125099,125100,125101,125102,125103,125104,125105,125107,125108,125109,125110,125111,125112,125113,125114,125115,125116,125117,125118,125119,125120,125121,125122,125123,125124,125125,125128,125129,125130,125131,125132,125133,125134,125135,125136,125137,125138,125139,125140,125141,125142,125143,125144,125145,125146,125147,125044,125045,125046,125047,125048,125049,125050,125568,125051,125578,125579,100547,100548,122614,122615,122616,122617,122618,122619,92838,92836,92837,127735,0,127875,127876,127877,127878,128102,128103,128104,128105,128106,128107,128110,128111,84526,84527,84662,84921,84922,84957,84958,84959,84960,123921,123922,132695,127179,127180,127181,92825,122603,122602,92827,100361,92787,92788,92789,92790,122604,122607,100362,100363,100364,100365,100366,92798,100367,122610,122605,122606,122608,122609,122611,122613,100368,100369,100370,92812,92813,122612,100372,100373,100374,100375,100376,100377,100378,100379,100380,101396,101395,92832,84887,92833,101393,101394,101397,101398,92830,92831,132699,132700,132701,132696,132697,132698,132678,132679,132680,132681,132682,132683,132684,132685,132686,132687,132688,132689,132690,132691,132692,132693,132694,132677,132676,132675,132674,132671,132672,132673,132669,132670,132668,132667,132666,132665,132664,132662,132663,132661,125997,129459,127736,127737,127738,127739,127740,127741,127742,127743,127744,127745,127746,127747,127748,127749,127750,127751,127752,127753,127754,127755,127756,127757,127758,127759,127760,127761,127762,127763,127764,127765,127766,127767,127768,127769,127770,127771,127772,127773,127774,127775,127776,127777,127778,127779,127780,127781,127782,127783,127784,127785,127786,127787,127788,127789,127790,127791,127792,127793,127794,127795,127796,127797,127798,127799,127800,127801,127802,127803,127804,127805,127806,127807,127808,127809,127810,127811,127812,127813,127814,127815,127816,127817,127818,127819,127820,127821,127822,127823,127824,127825,127826,127827,127828,127829,127830,127831,127832,127833,127834,127835,127836,127837,127838,127839,127840,127841,127842,127843,127844,127845,127846,127847,127848,127849,127850,127851,127852,127853,127854,127855,127856,127857,127858,127859,127860,127861,127862,127863,127864,127865,127866,127867,127868,127869,127870,127871,127872,127873,127874,127879,127880,127881,127882,127883,127884,127885,127886,127887,127888,127889,127890,127891,127892,127893,127894,127895,127896,127897,127898,127899,127900,127901,127902,127903,127904,127905,127906,127907,127908,127909,127910,127911,127912,127913,127914,127915,127916,127917,127918,127919,127920,127921,127922,127923,127924,127925,127926,127927,127928,127929,127930,127931,127932,127933,127934,127935,127936,127937,127938,127939,127940,127941,127942,127943,127944,127945,127946,127947,127948,127949,127950,127951,127952,127953,127954,127955,127956,127957,127958,127959,127960,127961,127962,127963,127964,127965,127966,127967,127968,127969,127970,127971,127972,127973,127974,127975,127976,127977,127978,127979,127980,127981,127982,127983,127984,127985,127986,128088,128089,128090,128091,128092,128093,128094,128095,128096,128097,128098,128099,128100,128101,128112,128113,128114,128115,128116,128117,128118,128119,128120,128121,128122,128123,128124,128125,128126,128127,128128,128129,132702,132703,132704,132705,123,1,132806,132807,132812,132885,132886,132893,132906,132923,132928,132940,132946,133012,133013,133021,133031,133046,133047,133096,133097) 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 = '1' and cpp.categories_id = '6894' order by products_ordered desc , pd.products_name