select codigo from products where codigo > '385150000' 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

codigo: 385.150.000
SKU: ECI-SPG10ML-HM
origen: CHINA
peso bruto: 0.000Kg
volumen bruto: 0.000807m3


SPG10ML Cable Mic 3mts XLR Macho-Hembra, Std

Productos Cables Para Microfonos Stagepro Cables