(SELECT DISTINCT(album), postdate, COUNT(photoid) AS photos FROM photos GROUP BY(album) ORDER BY photoid DESC)