select albumid from albums where album_name LIKE '%the new one%' and bandid='11983' Limit 1
IndieClick Music Network