4x4 Proyect
RECHANGES ET PIÈCES DETACHÉES POUR VOTRE 4X4
ABOUT US
ATENTION EN FRANÇAIS DE 16H A 21H
Telephone : +34 876 26 14 93 info@4x4proyect.com
English Castellano french portuguese Italian 
Contacter nous

Shipping policies | Privacy | Conditions of Service | Legal notice

ARB | Rubicon Express | Old Man Emu | Jeep



Voir le prix du transport dans votre panier

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

 

0.082629 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 (122555,123009,124503,124504,124505,124506,123464,122713,122783,122954,123543,122960,122779,130890,101442,101447,101463,101469,101487,101473,101484,101455,101456,101457,101400,101429,101432,101402,101406,101408,101412,101410,101414,101415,101425,101435,101438,101466,101564,101750,101733,101716,101774,101686,101669,101659,101645,101542,101530,101523,101510,101490,101559,101727,101701,101664,101640,101785,101505,101746,101782,101681,101767,101537,101519,101571,101552,101719,101690,101544,101627,101528,101492,101557,101723,101695,101550,101633,101792,101501,130914,101569,101739,101777,101674,101650,101532,101515,130874,130866,101764,130883,130886,130908,129198,129213,129203,129218,129208,129223,129231,129297,129242,129308,129253,129319,129264,129330,129275,129341,129286,129352,129364,129412,129376,129424,129388,129436,129400,129448,101575,101612,101581,101597,101604,101621,101590,101615,101584,131219,131220,131367,131368,131369,131370,131396,131397,131398,131399,131401,131402,131530,131531,131532,131533,131534,131535,130901,130904,130906,130888,130894,130898,130862,130858,130877,130880,130864,130870,130918,130910,101496,132797,132819,132821,132823,132834,132835,132842,132845,132850,132852,132855,132861,132864,132899,132902,132908,132916,132921,132927,132932,132938,132959,132961,132962,132964,132965,132968,132969,132970,132974,132990,132991,132992,132996,132997,133001,133002,133008,133009,133019,133028,133029,133042,133043,133050,133054,133057,133062,133063,133065,133071,133075,133082,133083,133091,133092,133100,133101,133108,133109,133123,133125,132814,132816,132866,132869,131490,100505,123374,128895,129037,128479,128894,128669,128670,128671,128672,129075,129076,129077,129074,129078,129079,129080,129081,128783,128766,128460,128599,128593,128602,128525,129082,129085,129086,129087,129088,129089,129011,128945,128746,128722,122549,123010,122959,124507,123285,122536,100508,124493,124494,124497,124498,124485,124486,124489,124490,122559,123286,124501,124502,123312,122785,122943,122944,122743,130995,130996,132014,132138,132174,132180,132053,132095,132186,132193,132217,132233,131959,132192,131135,131136,131137,100445,128833,128491,128587,128588,128589,128590,128591,128592,122565,124495,124496,124499,124500,124487,124488,124491,124492,123011,100511,131138,131139,122564,122830,122840,122855,122890,122891,122924,122936,122992,122993,123289,123290,123291,123292,123298,123358,123359,124477,124478,124479,124480,124481,124482,124483,124484,124465,124474,124475,124476,124466,124467,124468,124469,124470,124471,124472,124473,128925,129017,128721,128915,128779,128996,128885,132124,132040,132240,131942,128936,129026,100515,131013,131014,131015,131016,131017,131018,131140,131141,131252,132140,132183,132054,131962,132197) 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 = '5' and p2c.categories_id = '7256' order by products_ordered desc , pd.products_name