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.146059 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,128848,128845,124792,124793,124794,124795,124796,124797,128726,128696,128733,128858,129036,128923,128953,129108,128778,129021,129022,128929,128824,128546,128604,128555,128651,128391,128392,128393,128394,128395,128396,128397,128398,128399,128400,128401,128402,128932,128822,128702,128684,128542,122566,128998,128874,128879,128495,124787,124788,124789,100435,123022,123023,123027,123055,123056,123526,122809,122814,122915,123530,123533,123378,122708,123440,128997,122827,122799,122801,122914,122916,122917,123238,123252,123253,123254,123255,123534,123537,100453,123028,123029,123030,123033,122773,122966,123428,123435,124783,124784,124785,124786,124771,124780,124781,124782,124772,124773,124774,124775,124776,124777,124778,124779,128318,100532,100534,100535,131065,101569,101501,101750,101716,101686,101659,101542,101523,101490,101559,101557,101552,101727,101723,101719,101701,101695,101690,101664,101550,101544,101640,101633,101627,101785,101792,101528,101492,101739,101777,101674,101650,101532,101515,130914,101564,101733,101774,101669,101645,101530,101510,101505,101746,101782,101681,101767,101537,101519,101571,130890,101581,101575,130874,101442,101447,101463,101469,101487,101473,101484,101455,101456,101457,101400,101429,101432,101402,101406,101408,101412,101410,101414,101415,101425,101435,101438,101466,101597,101764,130883,130886,130866,126493,130908,129169,129170,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,101615,132119,132175,132183,101604,132098,132038,132093,101590,101612,101621,132385,132386,132387,101584,132218,132214,130898,130894,130888,132197,132861,130906,132224,132211,132198,132023,132188,131935,131064,131335,131336,131337,132352,132353,132518,132519,132855,132852,132850,132845,132842,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,132814,132816,132819,132821,132823,132834,132835,130901,130904,132864,132866,132869,130862,130858,130877,130880,130864,130870,132899,132902,132908,132916,132921,132927,132932,132938,132959,130918,130910,133159,133269,128699,128724,128700,128725,128793,128792,129029,129096,129097,129098,129099,129100,129101,129102,129103,129104,129105,129106,129091,129094,129093,128710,128704,128498,129092,100460,122574,123509,123510,123511,128304,128305,128306,128307,128308,128309,128310,128311,128312,128313,128314,128315,128316,128317,129014,100454,123048,123050,123051,123097,123098,122868,122884,123237,123239,123546,123414,123418,123445,123446,123470,123471,123472,123387,124757,124766,124767,124768,124769,124770,124758,124759,124760,124761,124762,124763,124764,124765,124743,124752,124753,124754,124755,124756,124744,124745,124746,124747,124748,124749,124750,124751,122722,131554,131555,131014,131013,130985,130984,130983,130982,131562,131563,132334,132335,128301,128818,128743,128847,124739,124740,124741,124742,131066,131067,131068,131069,131070) 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 = '7249' order by products_ordered desc , pd.products_name