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 = 90 AND Cod_Subsubfamilia = 79 LIMIT 0, 20

CABLES DE INSTRUMENTOS
CABLE DE INSTRUMENTO
CABLES
CABLES DE INSTRUMENTOS
CABLES EFECTOS
CABLES JACK
ADAM HALL CABLES
FENDER ACCESORIOS
IBANEZ
LD SYSTEMS
MARKBASS
MOOER EFFECTS
ON STAGE STANDS
OQAN
PLANETWAVES
PROEL
ROLAND
SABIAN
CABLE J/J 90CM ON STAGE IC-3
4,90€
CABLE J/J 3M ON STAGE IC-10
6,60€
CABLE J/J 4,5M ON STAGE IC-15
7,70€
CABLE J/J 6M ON STAGE IC-20
9,00€
CABLE J/J 7,5M ON STAGE IC-25
10,00€
CABLE PEDALES J/J 15CM NEGRO ON STAGE PC306B
9,20€
CABLE PEDALES J/J 30CM NEGRO ON STAGE PC312B
9,70€
CABLE PEDALES J/J 30CM TWEED ON STAGE PC312T
9,70€
CABLE PEDALES J/J 15CM TWEED ON STAGE PC306T
9,70€
ON STAGE IC-20R CABLE RECTO-CODO J/J 6M
9,70€
ON STAGE PC18-17QTR-R CABLE PEDALES J/J 45CM PACK 8
20,30€
ON STAGE IC-6 CABLE INSTRUMENTO J/J 2M
6,20€
CABLE ROLAND JACK BIC-10
20,24€
CABLE ROLAND JACK BIC-10A
20,24€
CABLE ROLAND JACK BIC-15
22,88€
CABLE ROLAND JACK BIC-15A
22,88€
CABLE ROLAND JACK BIC-1AA
10,56€
CABLE ROLAND JACK BIC-20
25,52€
CABLE ROLAND JACK BIC-3AA
13,20€
CABLE ROLAND JACK BIC-5
17,60€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES