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€
SORDINA TROMBON ALUMINIO TUBO EXTENSIBLE DENIS WICK DW5507 WAH-WAH
59,41€
SORDINA TROMBON ALUMINIO NEGRO DENIS WICK DW5527 PRACTICE
48,60€
SORDINA TROMBON ALUMINIO DENIS WICK DW5529 CUP
69,30€
SORDINA TROMBON FIBRA RECTA DENIS WICK DW5572 STRAIG
23,40€
SORDINA TROMBON ALUMINIO ROJA DENIS WICK DW5582 TRAVEL MUTE
63,90€
SORDINA TROMBON BAJO ALUMINIO TUBO EXTENSIBLE DENIS WICK DW5508 WAH-WAH
67,50€
SORDINA TROMBON BAJO ALUMINIO NEGRO DENIS WICK DW5528 PRACTICE
54,00€
SORDINA TROMBON BAJO ALUMINIO DENIS WICK DW5533 CUP
77,39€
SORDINA TROMBON BAJO MADERA RECTA DENIS WICK DW5553 STRAIGH
72,90€
SORDINA TROMBON BAJO ALUMINO RECTA DENIS WICK DW5509 STRAIGH
54,00€
SORDINA BOMBARDINO ALUMINIO RECTA DENIS WICK DW5513 STRAIGH
123,30€
SORDINA BOMBARDINO ALUMINIO NEGRO DENIS WICK DW5512 PRACTICE
123,30€
SORDINA BOMBARDINO MADERA RECTA DENIS WICK DW5562 STRAIGH
174,60€
SORDINA BOMBARDINO ALUMINIO STEVEN MEAD ROJA DENIS WICK DW5587 TRAVEL MUTE
123,30€
SORDINA TUBA ALUMINIO RECTA DENIS WICK DW5518 STRAIGH
244,80€
SORDINA TUBA ALUMINIO NEGRO DENIS WICK DW5519 PRACTICE
244,80€
SORDINA TROMPETA PICCOLO ALUMINIO RECTA DENIS WICK DW5521 STRAIGH
35,10€
SORDINA TROMPETA PICCOLO ALUMINIO NEGRO DENIS WICK DW5532 PRACTICE
34,19€
SORDINA FLISCORNO ALUMINIO NEGRO DENIS WICK DW5535 PRACTICE
63,00€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES