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 2019-01-17

# Image Link / Upload comment Timestamp Status Upload history
1 JamesHetfield2012.jpg File:JamesHetfield2012.jpg (edit|talk|history|links|watch|logs)

2019-01-17 18:39:31 Current 2
0 2019-01-17 Choirek 681×942K
1 2012-05-29 Pingaiadadocrack 681×942K
2 COEN Brothers (cannesPH).jpg File:COEN_Brothers_(cannesPH).jpg (edit|talk|history|links|watch|logs)

2019-01-17 18:17:42 Current 3
0 2019-01-17 Choirek 482×361K
1 2017-05-17 WikiPedant 482×361K
2 2005-10-31 Nikita~commonswiki 482×361K
3 Wendy Newman 121 First Dates 2016.jpeg File:Wendy_Newman_121_First_Dates_2016.jpeg (edit|talk|history|links|watch|logs)

2019-01-17 16:29:00 Current 2
0 2019-01-17 Wendynewmansanfrancisco 480×521K
1 2016-04-10 009o9 700×998K
4 Tessa Violet by Gage Skidmore.jpg File:Tessa_Violet_by_Gage_Skidmore.jpg (edit|talk|history|links|watch|logs)

2019-01-16 21:02:07 Current 2
0 2019-01-16 FF-11 2528×2975K
1 2014-07-06 Gage 2528×3288K
5 Msc 2006-Saturday, 16.00 - 18.00-Grytsenko.jpg File:Msc_2006-Saturday,_16.00_-_18.00-Grytsenko.jpg (edit|talk|history|links|watch|logs)

2019-01-16 17:34:23 Current 2
0 2019-01-16 Cheep 1141×1297K
1 2009-04-08 BotMultichillT 1932×1996K
6 Ya'akov Eilon at i24 News studio 2.jpg File:Ya'akov_Eilon_at_i24_News_studio_2.jpg (edit|talk|history|links|watch|logs)

2019-01-16 05:15:53 Current 4
0 2019-01-16 אלי גודין 595×396K
1 2019-01-16 אלי גודין 4694×3130K
2 2019-01-16 אלי גודין 595×396K
3 2014-02-26 Wembli 4694×3130K
7 ZazieConcertBruxelles09-06-07.JPG File:ZazieConcertBruxelles09-06-07.JPG (edit|talk|history|links|watch|logs)

2019-01-16 01:03:38 Current 2
0 2019-01-16 EhOuiH 1267×1838K
1 2007-12-29 Kevin.Ryckaert 1584×2816K
8 Flag of DKBA-5 (Buddhist).png File:Flag_of_DKBA-5_(Buddhist).png (edit|talk|history|links|watch|logs)

2019-01-16 00:31:00 Current 3
0 2019-01-16 Xophe84 450×300K
1 2018-04-20 CentreLeftRight 1280×853K
2 2015-11-08 CentreLeftRight 450×300K
9 Buddy Murphy 2018.jpg File:Buddy_Murphy_2018.jpg (edit|talk|history|links|watch|logs)

2019-01-15 19:56:21 Current 3
0 2019-01-15 Kingofcruiserweight 527×1066K
1 2019-01-06 Ducktech89 525×1224K
2 2019-01-06 Ducktech89 3054×3905K
10 Kode57 front 20160819 162707.jpg File:Kode57_front_20160819_162707.jpg (edit|talk|history|links|watch|logs)

2019-01-13 15:05:53 Current 2
0 2019-01-13 Rundvald 2089×1420K
1 2016-09-07 M5man 2526×1421K
11 Hoover-JEdgar-LOC.jpg File:Hoover-JEdgar-LOC.jpg (edit|talk|history|links|watch|logs)

2019-01-12 08:09:18 Current 5
0 2019-01-12 Kesäperuna 2406×3036K
1 2012-12-19 CherryX 2406×3036K
2 2006-06-29 Tom 2406×3036K
3 2005-09-27 Slarre~commonswiki 387×582K
4 2005-02-21 Jengod 430×640K
12 Jon Jones, Lorenzo Fertitta, and Dana White in 2014.jpg File:Jon_Jones,_Lorenzo_Fertitta,_and_Dana_White_in_2014.jpg (edit|talk|history|links|watch|logs)

2019-01-11 13:35:08 Current 2
0 2019-01-11 グレイル 595×923K
1 2018-11-27 Arbor to SJ 4928×3280K
13 Richard Matthew Stallman.jpeg File:Richard_Matthew_Stallman.jpeg (edit|talk|history|links|watch|logs)

2019-01-10 20:56:02 Current 2
0 2019-01-10 Kesäperuna 1627×1218K
1 2005-07-02 Sj 393×298K
14 Trisha at World Children's Day Press Meet.png File:Trisha_at_World_Children's_Day_Press_Meet.png (edit|talk|history|links|watch|logs)

2019-01-10 09:50:06 Current 3
0 2019-01-10 Stringy Acid 600×600K
1 2018-11-23 VenkateshMgna 531×700K
2 2018-10-16 VenkateshMgna 635×572K
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;