Prova così: (select * from fotografie where album > 0 group by album) UNION (select * from fotografie where album = 0)
Regole del Forum