SELECT a.* from ARTICULOS a, MARCAS m, PROVEEDORES p WHERE m.Codigo=a.Cod_Marca and a.Proveedor=p.Codigo and m.Activo <> 'N' and a.Cod_Familia <> 0 and a.Borrado <> 'S' and p.Activo <> 'N' AND Cod_Subfamilia = 22 AND Cod_Subsubfamilia = 29 order by FIELD(Cod_Marca, 1132) DESC LIMIT 0, 20
SORDINAS
SORDINAS
DENIS WICK
J.MICHAEL
ON STAGE
ORTOLA
SAETA
SMLPARIS
YAMAHA
SORDINA CORNETA SAETA
18,00€
SILENT BRASS YAMAHA PM1X
523,20€
SORDINA TROMPETA ENTRA¯NEMENT SMLPARIS ASMSOURTPE
41,82€
FUNDA SORDINA TROMPA DENIS WICK DW-A105
18,94€
FUNDA SORDINA BOMBARDINO DENIS WICK DW-A100
22,36€
SORDINA TROMPETA PRACTICE 3X STANDARD ORTOLA
23,98€
SORDINA TROMPETA PRACTICE JX STANDARD ORTOLA
34,24€
SORDINA TROMPETA STRAIGHT 1 STANDARD ORTOLA
13,68€
SORDINA TROMBON STRAIGHT 1 STANDARD ORTOLA
41,13€
SORDINA TROMPA BOUCHE 1 STANDARD ORTOLA
68,53€
SORDINA TROMBON DROITE PLASTIQUE SMLPARIS ASMSOURTBP
36,72€
SORDINA TROMPETA WA-WHA SMLPARIS ASMSOURTPW
57,55€
SORDINA TROMPETA ON STAGE TCM7420 WAH WAH MUTE
46,60€
SORDINA YAMAHA PM3X PARA FRENCH HORN
153,60€
SORDINA YAMAHA PM5X PARA TROMBONE
139,20€
SORDINA YAMAHA PM6X PARA FLUGELHORN
139,20€
SORDINA YAMAHA PM7X PARA TROMPETA
90,40€
SILENT BRASS YAMAHA SB1X PARA TUBA
571,20€
SILENT BRASS YAMAHA SB2X PARA EUPHONIUM
285,60€
SILENT BRASS YAMAHA SB3X 02 PARA FRENCH HORN
209,60€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES