My Account  Cart Contents  Checkout  
  Top » Catalog » Buick » Performance » Exhaust My Account  |  Cart Contents  |  Checkout   
Your TOW Vehicle
Cars For Sale
Turbo Riviera
    Alcohol Injection
    Cooling/Rad Pipes
    Engine Electrical
    Engine Mechanical
    Fuel Injectors
    Fuel Pumps/Wiring & Tanks
    Grease, Additives & Oil
    Heat / AC
    Oil & Fuel Treatments
    Rear Ends
    Turbo TA Entry Level 2 Turbos
    Turbo TA Entry Level 3 Turbos
    Turbo TA Entry Level Turbos
    Weight Saving
  Literature, Display & Apparel
Genuine GM Parts
Used Parts
What's New? more Hat Hat
Quick Find

Advanced Search
Contact UsContact Us
Photo & Video GalleryPhoto & Video Gallery
Interior ColorsInterior Colors
Upcoming ProductsUpcoming Products
The ShopThe Shop
Leather/Vinyl Seat ColorsLeather/Vinyl Seat Colors
Vehicle RegistriesVehicle Registries
Employment OpportunitiesEmployment Opportunities
What is GBP coming out with next?What is GBP coming out with next?
Terms and ConditionsTerms and Conditions
Wholesale AccountsWholesale Accounts
Shipping & ReturnsShipping & Returns
Privacy NoticePrivacy Notice
Conditions of UseConditions of Use
Join Our Mailing List
Category Listing
Category Listing
Displaying 1 to 20 (of 29 products) Result Pages:  1  2  [Next >>] 
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, 20' at line 1

select p.products_image, p.products_model, pd.products_name, p.products_weight, p.products_id, p.manufacturers_id, 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 p left join products_description pd on pd.products_id = p.products_id left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_to_categories p2c on p2c.products_id = p.products_id left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '33' order by limit 0, 20