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-08-15

# Image Link / Upload comment Timestamp Status Upload history
1 Akeem Balogun of Gombe United fc challenges Emeka Umeh of Plateau United fc-15596-350-300-100-c.jpg File:Akeem_Balogun_of_Gombe_United_fc_challenges_Emeka_Umeh_of_Plateau_United_fc-15596-350-300-100-c.jpg (edit|talk|history|links|watch|logs)

Reverted to version as of 13:39, 4 August 2018 (UTC)

2018-08-13 20:11:54 Replaced 5
0 2018-08-15 4nn1l2 350×300K
1 2018-08-13 Gurugenius10 720×709K
2 2018-08-05 4nn1l2 350×300K
3 2018-08-04 Gurugenius10 720×709K
4 2017-06-22 Gurugenius10 350×300K
2 Ahmed Hussen.jpg File:Ahmed_Hussen.jpg (edit|talk|history|links|watch|logs)

sharpen

2018-08-13 15:05:53 Current 2
0 2018-08-13 Cth103 t 205×292K
1 2017-03-15 MB298 205×292K
3 Nic Robertson, Tony Maddox, Arwa Damon, Ivan Watson, and Anderson Cooper, May 2012.jpg File:Nic_Robertson,_Tony_Maddox,_Arwa_Damon,_Ivan_Watson,_and_Anderson_Cooper,_May_2012.jpg (edit|talk|history|links|watch|logs)

cropped for more detail

2018-08-13 12:55:30 Current 2
0 2018-08-13 Tlwm 3020×2232K
1 2016-11-18 Kaiketsu 4256×2832K
4 JaredBorgetti.jpg File:JaredBorgetti.jpg (edit|talk|history|links|watch|logs)

Jared Borgetti celebrando gol con Santos Laguna.

2018-08-13 02:04:39 Replaced 2
0 2018-08-13 2122×3185K
1 2008-08-28 Wolfernt 2122×3185K
5 FWC 2018 - Round of 16 - COL v ENG - Photo 092.jpg File:FWC_2018_-_Round_of_16_-_COL_v_ENG_-_Photo_092.jpg (edit|talk|history|links|watch|logs)

Reverted to version as of 22:21, 12 August 2018 (UTC)

2018-08-12 22:29:57 Current 8
0 2018-08-12 Jesusmmacias0320 2056×3456K
1 2018-08-12 Jesusmmacias0320 4608×3456K
2 2018-08-12 Jesusmmacias0320 2056×3456K
3 2018-08-12 Jesusmmacias0320 4608×3456K
4 2018-08-12 Jesusmmacias0320 2056×3456K
5 2018-08-12 Jesusmmacias0320 4608×3456K
6 2018-08-12 Jesusmmacias0320 2056×3456K
Truncated
6 Norodom Ranariddh2.jpg File:Norodom_Ranariddh2.jpg (edit|talk|history|links|watch|logs)

retouched

2018-08-12 14:42:22 Current 2
0 2018-08-12 Peteremueller 1024×571K
1 2014-03-30 SovanDara18 1024×571K
7 Stefanidou.jpg File:Stefanidou.jpg (edit|talk|history|links|watch|logs)

Quality and Size

2018-08-11 13:03:24 Current 3
0 2018-08-11 EurovisionGR 946×1876K
1 2018-07-10 EurovisionGR 600×804K
2 2009-01-12 Kostisl 232×311K
8 Prime Minister Tony Abbott.jpg File:Prime_Minister_Tony_Abbott.jpg (edit|talk|history|links|watch|logs)

crop

2018-08-11 09:09:25 Current 4
0 2018-08-11 Thescrubbythug 472×652K
1 2018-08-11 Thescrubbythug 445×653K
2 2018-08-11 Thescrubbythug 394×623K
3 2013-09-20 Cropbot 548×653K
9 Sketch of Breivik.png File:Sketch_of_Breivik.png (edit|talk|history|links|watch|logs)

Cropping

2018-08-10 20:17:59 Current 3
0 2018-08-10 Mayimbú 453×613K
1 2017-06-27 Kigsz 628×628K
2 2016-07-28 Lukepryke 628×628K
10 Visita del Vicecanciller de Sudáfrica (9682283362).jpg File:Visita_del_Vicecanciller_de_Sudáfrica_(9682283362).jpg (edit|talk|history|links|watch|logs)

Cropped the picture.

2018-08-10 16:32:03 Current 2
0 2018-08-10 Lefcentreright 1507×1981K
1 2013-12-11 File Upload Bot (Magnus Manske) 4985×3323K
11 Jon Jones - Supporting Brain Health Study.jpg File:Jon_Jones_-_Supporting_Brain_Health_Study.jpg (edit|talk|history|links|watch|logs)

2018-08-10 00:43:40 Current 8
0 2018-08-10 グレイル 466×599K
1 2017-10-05 Alexander Gustafsson 660×1028K
2 2017-10-01 グレイル 957×1230K
3 2014-07-08 Phospheros 660×1028K
4 2014-06-03 WWE Batman131 833×1345K
5 2014-06-01 WWE Batman131 827×1287K
6 2014-02-07 Akira Kouchiyama 957×1230K
Truncated
12 WFGalvin Official Portrait.png File:WFGalvin_Official_Portrait.png (edit|talk|history|links|watch|logs)

Brightened image

2018-08-08 17:38:09 Current 2
0 2018-08-08 Jp16103 283×383K
1 2016-06-07 Simtropolitan 283×383K
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;