User:Fæ/BLP overwrites

From Wikimedia Commons, the free media repository
Jump to navigation Jump to search

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 2018-10-19

# Image Link / Upload comment Timestamp Status Upload history
1 Master Hsin Tao.gif File:Master_Hsin_Tao.gif (edit|talk|history|links|watch|logs)

hsintao_181019_600.gif

2018-10-19 09:07:06 Current 5
0 2018-10-19 Claire1106 600×428K
1 2018-10-19 Claire1106 1040×1040K
2 2018-10-19 Claire1106 500×500K
3 2018-10-19 Claire1106 1040×1040K
4 2009-04-10 LJM093 400×537K
2 Meghan-Trainor2010.jpg File:Meghan-Trainor2010.jpg (edit|talk|history|links|watch|logs)

cropped

2018-10-17 23:48:13 Current 3
0 2018-10-17 T1980 2205×2577K
1 2018-10-17 Embedded Data Bot 4288×3216K
2 2018-10-17 T1980 4288×3216K
3 Rajon Rondo, Kelly Oubre Jr. (38294689275) (cropped).jpg File:Rajon_Rondo,_Kelly_Oubre_Jr._(38294689275)_(cropped).jpg (edit|talk|history|links|watch|logs)

{{Information |Description= Rondo dribbling the ball in 2018 |Source= Bleacher report |Date= October 17, 2018 |Author= Unknown |Permission= Legal |other_versions= }}

2018-10-17 08:08:23 Replaced 2
0 2018-10-17 DaHuzyBru 1433×2314K
1 2018-03-09 H-Hurry 1433×2314K
4 Yante Maten.jpg File:Yante_Maten.jpg (edit|talk|history|links|watch|logs)

Light, contrast

2018-10-16 18:22:18 Current 2
0 2018-10-16 Pacoperez6 651×970K
1 2018-09-09 Editorofthewiki 651×970K
5 20180206 UM-NW Reggie Hearn 7DM27455.jpg File:20180206_UM-NW_Reggie_Hearn_7DM27455.jpg (edit|talk|history|links|watch|logs)

Contrast, saturation

2018-10-16 15:53:53 Current 4
0 2018-10-16 Pacoperez6 3139×4709K
1 2018-04-27 TonyTheTiger 3139×4709K
2 2018-04-27 TonyTheTiger 3139×4709K
3 2018-04-27 TonyTheTiger 3648×5472K
6 FX Hadi Rudyatmo.jpg File:FX_Hadi_Rudyatmo.jpg (edit|talk|history|links|watch|logs)

Source: http://ppid.surakarta.go.id/wp-content/uploads/2017/10/FXrudy-e1494416824468-460x601.jpg

2018-10-16 14:28:06 Replaced 3
0 2018-10-16 640×626K
1 2018-10-16 Imanuel321995 460×601K
2 2013-01-27 Steven Andrew Scarface220995 640×626K
7 Passarella world cup.jpg File:Passarella_world_cup.jpg (edit|talk|history|links|watch|logs)

Cropped 17 % horizontally, 20 % vertically using [[Commons:CropTool|CropTool]] with precise mode.

2018-10-16 05:28:30 Current 2
0 2018-10-16 DIEGO73 976×1250K
1 2015-08-09 Fma12 1180×1565K
8 Fran Villalba.JPG File:Fran_Villalba.JPG (edit|talk|history|links|watch|logs)

updated picture

2018-10-13 15:01:18 Replaced 3
0 2018-10-14 4nn1l2 905×1416K
1 2018-10-13 Gisela Seifart 446×703K
2 2016-02-28 Gisela Seifart Coscia 905×1416K
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;