select codigo from products where codigo > '385160000' and marca = 'StagePRO Cables' and catalogid = '46' and subcatalogid = '116' and codtitulo = '1422' and estado = 0 and publica = 1 order by codigo asc LIMIT 1
articulo previo
SPG20ML
articulo siguiente
SPG20HZ
Productos Cables Para Microfonos Stagepro Cables
Link del articulo (Click para copiar)
Cable Mic 9mts XLR Macho-Hembra, Std
SPG30ML Cable Mic 9mts XLR Macho-Hembra, Std