Phone: 630-237-4997
2000 Bloomingdale Rd #110
Naperville, Illinois 60139
Steve's Cell: 630-865-6849 Phone: 212-730-8138
242 W. 30th St
New York, NY 10001
  Top » Catalog » Specials Log In |  Cart Contents  |  Checkout | 
Search
 
Use keywords to find the product you are looking for.
Advanced Search
Follow Us
Twitter Facebook InstagramYouTube
Categories
1. J JRUMS custom snares now at Fork's

Cymbal Lathing at Maxwell's

Steve's Travel Schedule

Steve's Website Updates

Craviotto ->

Drum Sets ->

Snare Drums ->

Special Collections ->

Cowbird Music - Illinois Recording Studio

Maxwell Newsletter

Steve's Tuning Tips and Weblog

Steve's Videos: Craviotto

Steve's Video Media Classroom

NYC MUSEUM

About Our Sound Files

Ebay Auctions In Progress

!NEW! STEVE'S CELEB AND ULTRA RARE DRUM GALLERY

Maxwell Announcements ->

Steve's Drum Facts ->

Museum Archives ->
Information
Maxwell Drums Philosophy
Shipping and returns
Privacy
Store Hours
International
Links
Contact Us
Your Account
Your Email Address
Your Password
Manufactures
Payment Methods We Accept
BOX_INFORMATION_CARDMODULE_PAYMENT_PAYPAL_ID
BOX_INFORMATION_CARDMODULE_PAYMENT_PAYPAL_ID
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 '-10, 10' at line 1

select p.products_id, pd.products_name, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' order by s.specials_date_added DESC limit -10, 10

[TEP STOP]