Prova così:

(select * from fotografie
where album > 0
group by album)

UNION
(select * from fotografie
where album = 0)