select codigo from products where codigo > '125050000' and marca = 'AMPEG' and catalogid = '30' and subcatalogid = '90' and codtitulo = '940' and estado = 0 and publica = 1 order by codigo asc LIMIT 1
codigo: 125.050.000
SKU: 99-015-0907
origen: CHINA
peso bruto: 16.000Kg
volumen bruto: 0.061586m3
BA-108v2 COMBO 20w 1x8" angulado p-uso monitor
Agotado