Home » Diesel Truck Performance » GMC Duramax » Duramax Intake Kits My Account  |  Cart Contents  |  Checkout   
Manufacturers
Our Products
Diesel Truck Performance
  Dodge Cummins
  Ford PowerStroke
  GMC Duramax
    Duramax Intake Kits
      01-04 LB7
      04.5-06 LLY
      06-07 LLY/LBZ
      07.5-08 LMM
    Duramax Programmer & Boxes
    Fuel Tank Upgrades
    Duramax Exhaust Kits
    Gauges & Mounting Solutions
    Turbo Components & Upgrades
    Fuel System & Injectors
    Clutch Kits & Flywheels
    Automatic Trans & Componets
    Engine Fasteners & Cylinder Head
    Harmonic Balancers
    Propane Injection Kits
    Water Methanol Injection Kits
  Nitrous Systems for Diesel Truck
Dodge & Chrysler
Ford Motor Company
General Motors
Honda & Acura
Mercedes-Benz
Nissan & Infinity
Nitrous Accessories
Scion
Toyota & Lexus
Volkswagen
Gauges & Accessories
Fuel systems & pumps
Nitrous Systems & Accessories
Wheels & Tires
BMW
Universal Exhaust Parts
ATV Parts

View All Products
Store Information
Contact Us
Shipping & Return Policy
Security/Privacy Policy
What We Do
Current Projects
Dyno Rates & Services
Duramax Intake Kits
Duramax Intake Kits

01-04 LB7

04.5-06 LLY

06-07 LLY/LBZ

07.5-08 LMM
1054 - Unknown column 'p.products_id' in 'on clause'

select distinct p.products_id, p.products_image, p.products_tax_class_id, p.products_price from products p, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '113' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 6

[TEP STOP]