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 = 23 order by FIELD(Cod_Marca, 1132) DESC LIMIT 0, 20

PIANO DIGITAL
PIANOS DIGITALES
ALESIS
ARTESIA
CASIO
KORG
MEDELI
ORLA
RINGWAY
ROLAND
VOX
YAMAHA
PIANO DIGITAL MEDELI DP650K
1.045,20€
PIANO DIGITAL MEDELI GRAND510
2.465,47€
PIANO DIGITAL YAMAHA CLP-695GP POLISHED BLACK
6.186,00€
PIANO DIGITAL YAMAHA CLP-685PWH POLISHED WHITE
4.368,00€
PIANO DIGITAL YAMAHA CLP-685PE POLISHED BLACK
4.064,25€
PIANO DIGITAL YAMAHA CLP-695GPWH POLISHED WHITE
6.811,50€
PIANO DIGITAL CASIO CELVIANO GP-300 BK NEGRO
3.159,00€
PIANO DIGITAL YAMAHA CLP-685B BLACK
3.684,75€
PIANO DIGITAL CASIO CELVIANO GP-300 WE
3.295,00€
PIANO DIGITAL YAMAHA YDP-S34WH WHITE
793,00€
PIANO DIGITAL YAMAHA CVP-709B BLACK
7.128,00€
PIANO DIGITAL YAMAHA CVP-709PWH WHITE POLISHED
8.009,25€
PIANO DIGITAL YAMAHA CSP-150PE POLISHED BLACK
2.639,00€
PIANO DIGITAL YAMAHA YDP-143R
699,00€
PIANO DIGITAL YAMAHA P-515WH WHITE
1.381,50€
PIANO DIGITAL YAMAHA YDP-143WH
745,00€
PIANO DIGITAL YAMAHA P-121B BLACK
555,00€
PIANO DIGITAL YAMAHA YDP-163B
940,00€
PIANO DIGITAL ROLAND RP-102-BK
650,00€
PIANO DIGITAL YAMAHA P-121WH WHITE
555,00€
SUSCRÍBETE A NUESTRO BOLETÍN Y RECIBE EN TU MAIL OFERTAS Y NOVEDADES