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
 RCScrewZ FAQ

 Stainless Screw Kits Cars/Trucks  (1896)

 Stainless Screw Kits Drones  (24)

 Stainless Screw Kits Helicopters  (339)

 Stainless Screw Kits Motorcycle  (12)

 Stainless Screw Kits Tanks (2)

 Stainless Screws Tractor/Trailer  (19)

 Engine Screw Kits (1)

 Stainless Screw Kits Boats  (2)

 Bulk Screw Kits (32)

 Screw Packs Metric & Standard  (547)

 Bearing Kits - Cars/Trucks  (1559)

 Bearing Kits - Helicopters  (260)

 Bearing Kits Motorcycles  (3)

 Precision Bearing Packs  (131)

 Bulk Bearing Kits (3)

 Tools & Setup Stations  (16)

 RCScrewZ Shirts & Stickers (1)

 Distributors | Worldwide 

 Hobby Shops | Retail USA 
RCScrewZ Team Shirt - X-Large
[rcteexlg]
  PRICE: $15.95

Team RCScrewZ T-Shirt - NEW 2013 Design. Accepting Pre-Orders NOW! Shirts Start Shipping 4/30/13

This product was added to our catalog on Monday May 15, 2006.
Reviews
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'rcscrewz_rcdata.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select p.products_id, p.products_image from orders_products opa, orders_products opb, orders o, products p, categories c, products_to_categories p2c where c.categories_status='1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and opa.products_id = '1508' and opa.orders_id = opb.orders_id and opb.products_id != '1508' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = '1' group by p.products_id order by o.date_purchased desc limit 6

[TEP STOP]