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 COUNT(*) AS uploads FROM filearchive DESC;
SELECT COUNT(*) AS deletions FROM filearchive DESC;
SELECT SUM(log_type='upload' AND log_action='upload') AS uploads FROM logging WHERE log_namespace=6;/*
SELECT fa.year, uploads, deletions
FROM (
    SELECT
        LEFT(fa_deleted_timestamp, 4) AS year,
        COUNT(*) AS deletions
    FROM filearchive
  	GROUP BY year DESC) fa
LEFT OUTER JOIN (
    SELECT 
        LEFT(log_timestamp, 4) AS year,
        SUM(log_type='upload' AND log_action='upload') AS uploads
    FROM logging
    WHERE log_namespace=6
  	GROUP BY year DESC) log
ON fa.year=log.year*/

SQL

Checking query status...