home page about us site map
view cart check out my account log out
current specials featured products new products customer support
 
Enter your keywords above, or for additional options click the button below

Checkout
 Garage Sale Items - Close Outs (1)

 RCScrewZ FAQ

 Stainless Screw Kits Cars/Trucks  (1174)

 Stainless Screw Kits Heli  (260)

 Stainless Screw Kits Motorcycle  (12)

 Stainless Screw Kits Tanks (2)

 Engine Screw Kits (1)

 Stainless Screw Kits Boats  (2)

 Bulk Screw Kits (20)

 Screw Packs Metric & Standard  (529)

 Bearing Kits - Cars/Trucks  (413)

 Bearing Kits - Helis  (197)

 Bearing Kits Motorcycles  (3)
  Duratrax Cycle Bearing Kits (1)
  Thunder Tiger Cycle Bearing Kits (1)
  Venom Racing Cycle Bearing Kits (1)

 Precision Bearing Packs  (91)

 Bulk Bearing Kits (3)

 Tools & Setup Stations  (18)

 RCScrewZ Shirts & Stickers (4)

 Distributors/Retailers - For RCS

 Hobby / Retail For RCScrewZ 
Bearing Kits Motorcycles Bearing Kits Motorcycles
Duratrax Cycle Bearing Kits
Duratrax Cycle Bearing Kits
Thunder Tiger Cycle Bearing Kits
Thunder Tiger Cycle Bearing Kits
Venom Racing Cycle Bearing Kits
Venom Racing Cycle Bearing Kits
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 = '472' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 6

[TEP STOP]