Shopping cart is empty
 
Cart Contents Shopping Cart 0 item(s) in your cart
    
Vehicles - Start Here
Acura
Alfa Romeo
Aston Martin
Audi
Bentley
BMW
Buick
Cadillac
Chevrolet
Chrysler
Citroen
Daewoo
Dodge
Eagle
Ferrari
Fiat
Ford
Geo
GMC
Honda
Hummer
Hyundai
Infiniti
Isuzu
Jaguar
Jeep
Kia
Lamborghini
Land Rover
Lexus
Lincoln
Lotus
Maserati
Mazda
Mercedes Benz
Mercury
Mini
Mitsubishi
New Products
Nissan
Oldsmobile
Opel
Peugeot
Plymouth
Pontiac
Porsche
Saab
Saturn
Scion
Smart Car
Subaru
Suzuki
Toyota
Universal Parts
Volkswagen
Volvo
  Top » Catalog » Advanced Search's » Search Results

Products meeting the search criteria Products meeting the search criteria
 
Displaying 1 to 64 (of 64 products) Result Pages:  1 
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'limit 0, 100' at line 39

select distinct p.products_image, p.products_model, m.manufacturers_id, p.products_id, pd.products_name, p.products_price, p.products_price1, p.products_price2, p.products_price3, p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price9, p.products_price10, p.products_price11, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_price9_qty, p.products_price10_qty, p.products_price11_qty, p.products_qty_blocks, 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 p left join specials s on(s.products_id = p.products_id and s.status = 1) ) left join manufacturers m on p.manufacturers_id = m.manufacturers_id ) , products_description pd, categories c, products_to_categories p2c where p.products_status = 1 and p.products_id = pd.products_id and pd.language_id = 1 and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%rx-8%' or p.products_model like '%rx-8%' or pd.products_name like '%rx-8%' or m.manufacturers_name like '%rx-8%') and (pd.products_name like '%body%' or p.products_model like '%body%' or pd.products_name like '%body%' or m.manufacturers_name like '%body%') and (pd.products_name like '%kit%' or p.products_model like '%kit%' or pd.products_name like '%kit%' or m.manufacturers_name like '%kit%') ) order by limit 0, 100

[TEP STOP]