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.040099 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 (0,126178,126179,126180,126181,126182,126281,126368,126369,100461,125582,125583,128269,129496,129497,128057,128056,128080,128079,128152,128153,128200,128201,128070,129482,129483,129498,128109,126220,126221,126222,126294,126383,101442,101447,101463,101469,101487,101473,101484,101455,101456,101457,101400,101429,101432,101402,101406,101408,101412,101410,101414,101415,101425,101435,101438,101466,128108,126493,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,131119,131120,126223,126224,126225,126295,126384,126598,123086,123087,122812,122813,123257,123258,123539,123474,123475,124823,125584,125585,125817,123088,122869,123263,124822,125947,125965,125812,125571,125572,125573,125588,125589,125590,125591,125307,125308,125729,125730,128268,129494,129495,128054,128058,128076,128081,128149,128150,128199,128069,129484,126226,126227,126296,126385,126464,125948,125966,125813,125592,125593,125594,125595) 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