select albumid from albums where album_name LIKE '%Favorite Worst Nightmare%' and bandid='1847' Limit 1
IndieClick Music Network