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 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...