30%-OFF  Hand Crafted FINGER BUTTONS
code CLASSYTOUCH   SEE BUTTONS

AND FREE SHIPPING $89+   ENDS 12-noon Dec 3  
SEE BUTTONS
   SHIPPING DETAILS

Schilke Piccolo Trumpet Mouthpieces

Products

Schilke Piccolo Trumpet Mouthpieces are available in cornet shank only. While they may successfully be used on any piccolo trumpet that uses a cornet shank mouthpiece, they are optimized for Schilke piccolo trumpets.

Displaying 1 to 8 (of 8 products)
Result Pages:  1 
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 '' at line 1

select pd.products_name, p.products_model, p.products_quantity, p.products_id, p.products_type, p.manufacturers_id, p.products_price, p.products_tax_class_id, p.products_so_level, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (( products_description pd, products p ) left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c ) left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '363' order by

[TEP STOP]