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 = 32 AND Cod_Subsubfamilia = 93 order by FIELD(Cod_Marca, 1132) DESC LIMIT 0, 20
CAJAS DE BATERIA/TOMS/BOMBOS
ACCESORIOS BATERIA
BATERIA
BOMBOS
CAJA DE BATERIA
CAJAS
CAJAS DE BATERIA
PERCUSI
TOMS
ADAMS
DIXON
HONSUY
JINBAO
LUDWIG
MAPEX
MEINL
ORTOLA
PREMIER
SANTAFE DRUMS
SONOR
TAMA
VIC FIRTH
YAMAHA
TIMBAL BASE 14"x14" (35,5x35,5cm.) HONSUY
233,68€
BOMBO OAK CUSTOM 22X20" REF.SO0530 ORTOLA
975,60€
TIMBAL BASE 14"x14" (35,5x35,5cm.) HONSUY
263,59€
BOMBO OAK CUSTOM 24X18" REF.SO0540 ORTOLA
1.062,90€
TIMBAL BASE 14"x14" (35,5x35,5cm.) HONSUY
257,98€
BOMBO OAK CUSTOM 24X20" REF.SO0550 ORTOLA
1.062,90€
MT1415BN TIMBA14" & 15" NEGRO LES, BLACK NICKEL FINISH MEINL
409,50€
TIMBAL BASE 14"x14" (35,5x35,5cm.) HONSUY
257,98€
BOMBO TRANSPORTER ABEDUL 16X21" SPARKLE ST0047 ORTOLA
761,08€
MT1415RR-M TIMBAL 14"&15" ANT.BALES, ANTIQUE FINISH, MATTE MEINL
409,50€
TIMBAL BASE 16"x16" (40,7x40,7cm.) HONSUY
261,72€
BOMBO TRANSPORTER ABEDUL 18X21" SPARKLE ST0048 ORTOLA
762,97€
TI1BK 13" & 14" STEEL TIMBALES, BLACK MEINL
409,50€
TIMBAL BASE 16"x16" (40,7x40,7cm.) HONSUY
291,63€
BOMBO CHARANGA JINBAO 50X20 CM
105,00€
TOM TRANSPORTER ABEDUL 10X7" SPARKLE ST0057 ORTOLA
255,10€
AV1BK 14" & 15" STEEL TIMBALES, BLACK MEINL
445,50€
TIMBAL BASE 16"x16" (40,7x40,7cm.) HONSUY
286,03€
BOMBO CHARANGA JINBAO 55X20 CM
109,00€
TOM TRANSPORTER ABEDUL 13X8" SPARKLE ST0058 ORTOLA
255,51€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES