select codigo from products where codigo > '385155000' 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
SPG10ML
articulo siguiente
SPG30ML
Productos Cables Para Microfonos Stagepro Cables
Link del articulo (Click para copiar)
Cable Mic 6mts XLR Macho-Hembra, Std
SPG20ML Cable Mic 6mts XLR Macho-Hembra, Std