User:Fæ/BLP overwrites

Userlist BLP Overwrites Significant Reverts Flickrstreams of concern

This table shows images used in biographies of living people on the English Wikipedia overwritten in the last week, by an account other than the original uploader, who has fewer than 1000 edits on Commons and fewer than 2000 on the English Wikipedia. This report is checked for updates at least hourly for the benefit of new image patrol.
Report last updated on 2019-04-16

SQL used to generate this table

SELECT log_title AS image, DATE_FORMAT(log_timestamp, "%Y-%m-%dT%H:%i:%s" ) AS timestamp, COUNT(*) AS "numb BLPs", IF( abs( img_timestamp - log_timestamp ) < 8, "Current", "Replaced" ) AS top, log_comment, oi_timestamp FROM commonswiki_p.logging_logindex INNER JOIN commonswiki_p.globalimagelinks ON log_title = gil_to AND gil_wiki = 'enwiki' LEFT OUTER JOIN commonswiki_p.image ON img_name = log_title INNER JOIN enwiki_p.categorylinks ON gil_page = cl_from AND enwiki_p.categorylinks.cl_to IN ('Living_people', 'Possibly_living_people', '2016_deaths', '2015_deaths', '2014_deaths') INNER JOIN commonswiki_p.user ON log_user = user_id AND user_editcount < 1000 LEFT OUTER JOIN enwiki_p.user u2 ON log_user_text = u2.user_name LEFT OUTER JOIN commonswiki_p.oldimage ON img_name = oi_name WHERE log_type = 'upload' AND log_timestamp > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -8 DAY), "%Y%m%d%H%i%s") AND log_action = 'overwrite' AND oi_user != img_user AND (u2.user_editcount < 2000 OR u2.user_editcount IS NULL) AND NOT img_minor_mime = "svg xml" GROUP BY log_timestamp, log_title HAVING oi_timestamp = MIN(oi_timestamp) ORDER BY log_timestamp DESC, oi_timestamp DESC LIMIT 1000;