Languages

English

Currencies

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...
$249.99
$139.99
IMAGE_BUTTON_DETAILS 
Product Information

Arbor AS300 Electric Guitar
[AS300]

$229.95

Double cutaway body, sleek solid poplar wood with quilted Maple top finish. This vintage style guitar is equipped with a Nato neck, Rosewood fingerboard, and a 3-ply pearloid pick guard. The 25-1/2 scale model comes with 21 frets, gold die cast tuners, and classic 3 single-coil pickups with gold fulcrum tremolo. Players will appreciate the 1 volume, 2 tone, and 5-way switching controls. Available in Natural Honey (NH), Transparent Black (TBK), Transparent Blue (TBL), Transparent Purple (TPU) and Transparent Red (TR). Limited Lifetime Warranty.

Reviews
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 = '138' and opa.orders_id = opb.orders_id and opb.products_id != '138' 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]