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 LEFT(log_timestamp, 4) AS `year`, COUNT(*) AS `uploads`, NULL AS `deletions`
FROM logging
WHERE log_namespace=6 AND log_type='upload' AND log_action='upload'
GROUP BY `year`
UNION
SELECT LEFT(log_timestamp, 4) AS `year`,  NULL AS `uploads`, COUNT(*) AS `deletions`
FROM logging
WHERE log_namespace=6 AND log_type='delete' AND log_action='delete'
GROUP BY `year`*/

SELECT LEFT(log_timestamp, 4) AS `year`, log_type
FROM logging
WHERE log_namespace=6 AND ((log_type='upload' AND log_action='upload') OR (log_type='delete' AND log_action='delete'))
GROUP BY `year`
LIMIT 10

/*SELECT
	LEFT(log_timestamp, 4) AS `year`,
    (SELECT COUNT(*) FROM logging WHERE LEFT(log_timestamp, 4)=`year` AND log_namespace=6 AND log_type='upload' AND log_action='upload') AS `uploads`,
    (SELECT COUNT(*) FROM logging WHERE LEFT(log_timestamp, 4)=`year` AND log_namespace=6 AND log_type='delete' AND log_action='delete') AS `deletions`
FROM logging*/

SQL

Checking query status...