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 year, SUM(uploads) AS uploads FROM (
  SELECT LEFT(fa_timestamp, 4) AS year, COUNT(*) AS uploads FROM filearchive GROUP BY year DESC
	UNION
  SELECT LEFT(img_timestamp, 4) AS year, COUNT(*) AS uploads FROM image GROUP BY year DESC) t
GROUP BY year DESC

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