Overwrites by Jan Arkesteijn

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

Analysis of overwrites by Jan Arkesteijn, account #3601. Files that are separated into new uploads or otherwise overwritten will drop from these results. Restricted to members of Category:Image_overwrites_by_Jan_Arkesteijn_for_independent_review or new overwrites from March 2016 onwards.

SQL

USE commonswiki_p;
SELECT
	log_title AS File,
    COUNT(*) AS No,
	GROUP_CONCAT(LEFT(log_timestamp, 8)) AS Date,
	GROUP_CONCAT(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
WHERE log_action = "overwrite" 
	AND log_user = '3601' 
	AND oi_user!=log_user
GROUP BY log_title
ORDER BY log_timestamp DESC;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...