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 2017-07-21
Hi- I've updated the lead image to a more recent one, with a motion made in Talk weeks ago which no one has objected to. I own the image, it was taken at interview with the writer with permission, and give my consent for anyone to share it. This new on...
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;
.JPG)
.JPG&action=edit){kind=link}
.JPG&action=edit&redlink=1){kind=link}
.JPG&action=history){kind=link}
.JPG&limit=999){kind=link}
.JPG&action=watch){kind=link}
