What's New?
Gold Plated Flute With Hard Case and FREE Extras
Gold Plated Flute With Hard Case and FREE Extras
This colorful gold plated flute is ideal for the student to in...
Product Information

Black Upright Double Bass

$1,200.00 $649.99

Black Upright Double Bass outfit with bow and soft case.

Product Features:

. Maple back and sides
. Select spruce top
. Arched back construction
. 24:1 ratio Tyrolean_style machine heads
. Arched back construction
. Rosewood frog bow with genuine horsehair
. Padded nylon bag
. Extra set of strings (While supplies last)

Product Tags: double bass, upright bass, string bass, bass fiddle, bass violin, doghouse bass, contrabass, bass viola, stand-up bass, bull fiddle.

Available Options:
1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'musicalw_musicalmart.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 where opa.products_id = '140' and opa.orders_id = opb.orders_id and opb.products_id != '140' 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