select codigo from products where codigo > '125114000' and marca = 'AMPEG' and catalogid = '30' and subcatalogid = '90' and codtitulo = '941' and estado = 0 and publica = 1 order by codigo asc LIMIT 1
codigo: 125.114.000
SKU: 99-030-2601
origen: CHINA
peso bruto: 24.000Kg
volumen bruto: 0.184197m3
PF-115HE BAFLE 1x15" 450W Eminence+Driver 1" TAPA REMOVIBLE
Agotado