select codigo from products where codigo > '153010000' and marca = 'BLACKSTAR Carry-On' and catalogid = '15' and subcatalogid = '370' and codtitulo = '1425' and estado = 0 and publica = 1 order by codigo asc LIMIT 1
articulo siguiente
CARRY-ON-FP88
Productos Pianos Digitales Blackstar Carry-on
Link del articulo (Click para copiar)
Piano PLEGABLE 49teclas, 128sonid,Parlant,USB,MIDI
CARRY-ON-FP49 Piano PLEGABLE 49teclas, 128sonid,Parlant,USB,MIDI