SELECT a.* from ARTICULOS a, MARCAS m WHERE m.Codigo=a.Cod_Marca and m.Activo <> 'N' and a.Cod_Familia <> 0 and a.Borrado <> 'S' AND Cod_Subfamilia = 34 AND Cod_Subsubfamilia = 55 LIMIT 0, 20
MEINL
SABIAN
TURKISH
ZILDJIAN
PLATOS SABIAN 21823 18" AA Suspended
265,50€
PLATOS SABIAN 11824 18" HH Germanic
717,30€
PLATOS SABIAN 12220 22" HH Viennese
834,30€
PLATOS SABIAN 12120B 21" HH Viennese
773,10€
PLATOS SABIAN 11994XBH 19" HHX Synergy Heavy
710,10€
PLATOS SABIAN 31422B 14" B8 Pro Marching Band
194,40€
PLATOS SABIAN 31622B 16" B8 Pro Marching Band
267,30€
PLATOS SABIAN 31822B 18" B8 Pro Marching Band
302,40€
PLATOS SABIAN 41622X 16" B8X Band
169,20€
PLATOS SABIAN XSR1421B 14" XSR Concert Band
251,10€
PLATOS SABIAN XSR1621B 16" XSR Concert Band
341,10€
PLATOS SABIAN XSR1821B 18" XSR Concert Band
388,80€
PLATOS SABIAN XSR1623B 16" XSR Suspended
170,10€
PLATOS SABIAN XSR1823B 18" XSR Suspended
194,40€
PLATOS SABIAN XSR2023B 20" XSR Suspended
233,10€
PLATOS SABIAN 41822X 18" B8X Band
251,10€
PLATOS SABIAN XSR2021B 20" XSR Concert Band
503,10€
PLATOS TURKISH SET MODERATE XS (14-16) C/FUNDA
256,00€
MA-BO-14M PLATOS DE CHOQUE 14", SERIE BRONZE, PESO MEDIUM MEINL
116,10€
MA-BO-16M PLATOS DE CHOQUE 16", SERIE BRONZE, PESO MEDIUM MEINL
152,09€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES