4x4 Proyect
ACCESORIOS, RECAMBIOS Y REPUESTOS PARA TU 4X4
SOBRE NOSOTROS
PEDIDOS Y ATENCION AL CLIENTE
Movil 699 938 332
Oficina 876 26 14 93 (gratuito)
info@4x4proyect.com
English Castellano french portuguese Italian 
Servicio & Ayuda

Envios/Devoluciones | Confidencialidad | Condiciones del servicio | Aviso legal

ARB | Rubicon Express | Old Man Emu | Jeep



Consulte el precio del transporte en su cesta

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

 

0.130016 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 (0,122807,122812,122813,122932,122933,122991,123257,123258,123259,123267,123268,123269,124720,124729,124730,124731,124721,124722,124723,124724,124725,124726,124727,124728,128942,128943,128944,129141,128601,128770,129029,129096,129097,129098,129099,129100,129101,129102,129103,129104,129105,129106,128623,128543,128536,128894,128499,128500,128501,128502,128503,128504,128505,128506,128507,128508,128509,128510,128918,128878,128269,128080,128079,132390,124308,101552,101739,101719,101777,101690,101674,101544,101650,101627,101532,101528,101515,101492,101559,101727,101701,101664,101640,101785,101505,101564,101733,101774,101669,101645,101530,101510,101746,101782,101681,101767,101537,101519,101571,130914,130908,130890,101581,101597,126183,126185,126282,126370,101442,101447,101463,101469,101487,101473,101484,101455,101456,101457,101400,101429,101432,101402,101406,101408,101412,101410,101414,101415,101425,101435,101438,101466,126473,126474,126475,126476,126477,126478,126479,126480,126481,126482,126483,126484,126485,126486,126487,130883,101764,122539,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,130847,130986,130987,130988,130989,131014,131013,132183,101604,101615,132098,132093,101590,101612,101621,101584,130898,130894,130888,132197,132861,130906,123553,132188,131108,131109,131110,131214,131238,131558,131559,131560,131561,132523,132524,132525,132855,132852,132850,132845,132842,101501,101496,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,132797,130886,130866,130874,132814,132816,101575,132819,132821,132823,132834,132835,130901,130904,101490,132864,132866,132869,101523,130862,130858,130877,130880,130864,130870,132899,132902,101792,132908,101542,101633,132916,101659,132921,132927,132932,132938,101550,101686,101695,101716,101723,101750,101557,101569,132959,130918,130910,100502) 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 = '3' and cpp.categories_id = '7248' order by products_ordered desc , pd.products_name