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
Productos Amplificadores Para Bajo Ampeg
Link del articulo (Click para copiar)
Agotado Agotado
COMBO 20w 1x8" angulado p-uso monitor
BA-108v2 COMBO 20w 1x8" angulado p-uso monitor