select codigo from products where codigo > '153650000' and marca = 'BLACKSTAR Carry-On' and catalogid = '25' and subcatalogid = '140' and codtitulo = '1505' and estado = 0 and publica = 1 order by codigo asc LIMIT 1
Productos Vientos Electronicos Blackstar Carry-on
Link del articulo (Click para copiar)
Intrumento DIGITAL de Viento 10Son,MIDI BLU,Dig FLAUTA
Black
White
CARRY-ON-DWI Intrumento DIGITAL de Viento 10Son,MIDI BLU,Dig FLAUTA