Overwrites by Jan Arkesteijn filtered by metadata

Fork of Overwrites by Jan Arkesteijn by Fæ

This query is marked as a draft This query has been published by Fæ.

Analysis of overwrites by Jan Arkesteijn, account #3601. Metadata filter may be slow to run, but handy for limiting to specific guessed sources.

Tweaking rather than forking for 2018 analysis.

SQL

USE commonswiki_p;
SELECT
	DISTINCT log_title AS File,
	LEFT(log_timestamp, 8) AS Date,
	log_comment AS Comment
FROM logging_userindex
JOIN image ON log_title=img_name AND img_user = log_user
JOIN oldimage ON oi_name = img_name
JOIN categorylinks ON log_page=cl_from
WHERE log_action = "overwrite" 
	AND log_user = '3601' 
	AND oi_user!=log_user
    AND (cl_to = "Image_overwrites_by_Jan_Arkesteijn_for_independent_review" OR log_timestamp>20160301000000)
    AND img_metadata REGEXP "Rijks"
GROUP BY oi_name
ORDER BY log_timestamp DESC;

SQL

Checking query status...