nlwiki File uploads and deletions by year

Combines *new* uploads from `image` and `filearchive` and shows next to deletions in `filearchive`.
Table `logging` doesn't have any info from before 2006.
Deletions before 2006 were not recorded anywhere it seems.

SQL

SELECT fau.year, fau.uploads + img.uploads AS uploads FROM
(SELECT LEFT(fa_timestamp, 4) AS year, COUNT(*) AS uploads FROM filearchive GROUP BY year DESC) fau
LEFT OUTER JOIN
(SELECT LEFT(img_timestamp, 4) AS year, COUNT(*) AS uploads FROM image GROUP BY year) img
ON fau.year=img.year

/*SELECT fau.year, uploads, deletions
FROM (           SELECT LEFT(fa_timestamp,         4) AS year, COUNT(*) AS uploads   FROM filearchive GROUP BY year DESC) fau
LEFT OUTER JOIN (SELECT LEFT(fa_deleted_timestamp, 4) AS year, COUNT(*) AS deletions FROM filearchive GROUP BY year DESC) fad
ON fau.year=fad.year*/

SQL

Checking query status...