Your Monster Truck Source
Accepted Payments: | Ordering Info | Product Questions | International Orders
  Home » Catalog » Nitro Gear My Account  |  Cart Contents  |  Checkout   
Categories
Air Planes->
Apparel->
Boats->
Bodies/Shells->
Cars/Buggies->
Close Outs->
Decal Sets->
E/S/T-Maxx Parts->
Electrical->
Gears
HPI Savage 25/21/SS Parts->
MGT Stock/Option Parts->
Misc. Gear->
Nitro Engines->
Nitro Gear->
  Air Filter Adaptors
  Battery Monitors
  Boost Bottles
  Boost Collars for .15 TRX
  Clutch Nuts
  Engine Bearings
  Exhaust Couplers
  Exhaust Deflectors
  Fail Safes
  Fuel Bottles
  Fuel Filters
  Fuel Line
  Gear Caddy
  Glow Plug Igniters
  Glow Plugs
  Linkage Rod Adjusters
  Nitro Fuel
  Nitro Wash/Cleaners
  Oils
  Pull Start Assemblies
  Speedometers
  Starters
  Temp Guns/Monitors
  Tuned Pipes
Parts Misc.->
R/C Toys
REVO Parts->
Special Buys
Wheels/Tires->
Trucks->
Shop By Price more
Under $50
From $50 to $100
From $100 to $250
$250 and above
Manufacturers
Quick Find
 
Use keywords to find the product you are looking for.
Super Search
Newsletter Center
Subscribe
Unsubscribe
Support Ticket
Open Support Ticket
View Ticket
Information
F.A.Q.
Shipping-Return
Privacy Notice
Conditions of Use
Contact Us
Currencies
Categories

Air Filter Adaptors

Battery Monitors

Boost Bottles

Boost Collars for .15 TRX

Clutch Nuts

Engine Bearings

Exhaust Couplers

Exhaust Deflectors

Fail Safes

Fuel Bottles

Fuel Filters

Fuel Line

Gear Caddy

Glow Plug Igniters

Glow Plugs

Linkage Rod Adjusters

Nitro Fuel

Nitro Wash/Cleaners

Oils

Pull Start Assemblies

Speedometers

Starters

Temp Guns/Monitors

Tuned Pipes

1054 - Unknown column 'p.products_id' in 'on clause'

select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, 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 = '6' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 12

[TEP STOP]