select albumid from albums where album_name LIKE '%Confessions on a Dance Floor%' and bandid='806' Limit 1
IndieClick Music Network