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 = 6 AND Cod_Subsubfamilia = 12 order by FIELD(Cod_Marca, 1132) DESC LIMIT 0, 20
BOLSA DE PÚAS PRODIGY NEGRA MINI 2,00 MM - 6 UNIDADES ERNIEBALL PUAS EB9200
PVP: 11,73€
9,38€
PUAS NYLON JAZZ II SEMI ROJA 1\'18 DUNLOP 47-R2S
15,71€
CAJA PUAS NYLON FINS DUNLOP 4440
86,90€
3819 PLEC PÚA DE GUITARRA SET DE 4 UNIDADES
PVP: 3,09€
2,78€
PUAS NYLON JAZZ III SHARP NEGRA 1\'38 DUNLOP 47-R3S
LOGIN
![](Imgs/Art/thumb_Img1_2_2101157.jpg "PUAS NYLON JAZZ II SEMI ROJA 1\")
![](Imgs/Art/thumb_Img1_2_2101158.jpg "PUAS NYLON JAZZ III SHARP NEGRA 1\")
![](Imgs/Art/thumb_Img1_2_2101159.jpg "PUAS NYLON MIDI STANDARD 0\")
![](Imgs/Art/thumb_Img1_2_2101160.jpg "PUAS NYLON MIDI STANDARD 0\")
![](Imgs/Art/thumb_Img1_2_2101161.jpg "PUAS NYLON MIDI STANDARD 0\")
![](Imgs/Art/thumb_Img1_2_2101162.jpg "PUAS NYLON MIDI STANDARD 1\")
![](Imgs/Art/thumb_Img1_2_2101163.jpg "PUAS NYLON MIDI STANDARD 1\")
