Fork of
Overwrites by Jan Arkesteijn
by Fæ
This query is marked as a draft
This query has been published
by Fæ.
SQL
AخA
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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.