select codigo from products where codigo > '385195000' and marca = 'StagePRO Cables' and catalogid = '46' and subcatalogid = '116' and codtitulo = '1423' and estado = 0 and publica = 1 order by codigo asc LIMIT 1
articulo previo
SPGP10ML
articulo siguiente
SPGP30ML
Productos Cables Para Microfonos Stagepro Cables
Link del articulo (Click para copiar)
Stock HOY: 3 Stock HOY: 3
Cable Mic 6mts XLR Macho-Hembra, Pro
SPGP20ML Cable Mic 6mts XLR Macho-Hembra, Pro