select codigo from products where codigo > '150456000' and marca = 'BLACKSTAR' and catalogid = '30' and subcatalogid = '60' and codtitulo = '1476' and estado = 0 and publica = 1 order by codigo asc LIMIT 1

codigo: 150.456.000
SKU: BA180020
origen: CHINA
peso bruto: 15.000Kg
volumen bruto: 0.081908m3


ST. JAMES 212VOC BAFLE 2x12" Vertical Ultra LIVIANO

Productos Amplificadores Para Guitarra Electrica Blackstar