| Addshore added a comment. |
Here is a list of all pages that will likely be affected already with data being lost in the revisions that have since been restored:
MariaDB [wikidatawiki]> SELECT DISTINCT rev_page, page_title, page_namespace, page_touched
-> FROM revision AS revision
-> INNER JOIN page AS page ON revision.rev_page = page.page_id
-> WHERE rev_id > 745452473 and rev_id < 745468910 and page_touched > 20181010151500
-> ORDER BY page_namespace, page_title;
+----------+---------------------------------------------------------------------------------+----------------+----------------+
| rev_page | page_title | page_namespace | page_touched |
+----------+---------------------------------------------------------------------------------+----------------+----------------+
| 957791 | Q1008351 | 0 | 20181011183506 |
| 972072 | Q1022718 | 0 | 20181011112403 |
| 11573912 | Q10269330 | 0 | 20181011102631 |
| 11618130 | Q10313336 | 0 | 20181011183306 |
| 12075277 | Q10801324 | 0 | 20181011231428 |
| 1037514 | Q1089690 | 0 | 20181011224900 |
| 115186 | Q112562 | 0 | 20181011232641 |
| 1072735 | Q1125675 | 0 | 20181011112401 |
| 1088182 | Q1141499 | 0 | 20181011093245 |
| 1098210 | Q1151801 | 0 | 20181011112357 |
| 1103257 | Q1156971 | 0 | 20181011231351 |
| 1140371 | Q1196895 | 0 | 20181011150707 |
| 130504 | Q128504 | 0 | 20181012061613 |
| 1246692 | Q1306726 | 0 | 20181012061648 |
| 1278081 | Q1338401 | 0 | 20181011010159 |
| 1304828 | Q1365309 | 0 | 20181011112351 |
| 140372 | Q138671 | 0 | 20181012114338 |
| 140517 | Q138820 | 0 | 20181011032316 |
| 1373695 | Q1435223 | 0 | 20181011093244 |
| 1444721 | Q1507379 | 0 | 20181011112349 |
| 17026621 | Q15378860 | 0 | 20181011195823 |
| 1480008 | Q1543446 | 0 | 20181011112346 |
| 17087585 | Q15443105 | 0 | 20181011112023 |
| 17343834 | Q15708744 | 0 | 20181012023419 |
| 17825650 | Q16199113 | 0 | 20181010184808 |
| 17865127 | Q16240975 | 0 | 20181012124819 |
| 1575620 | Q1641483 | 0 | 20181011112343 |
| 1607340 | Q1673849 | 0 | 20181011200423 |
| 168071 | Q167548 | 0 | 20181011112132 |
| 1611743 | Q1678281 | 0 | 20181011112340 |
| 1616952 | Q1683527 | 0 | 20181011102520 |
| 1624134 | Q1690779 | 0 | 20181011112338 |
| 1688234 | Q1755568 | 0 | 20181011093246 |
| 1694424 | Q1762011 | 0 | 20181012035631 |
| 1742299 | Q1811132 | 0 | 20181011112335 |
| 1754506 | Q1823744 | 0 | 20181012013950 |
| 19862904 | Q18333329 | 0 | 20181011215652 |
| 21738062 | Q20068036 | 0 | 20181011193532 |
| 198920 | Q202335 | 0 | 20181010175433 |
| 201044 | Q204673 | 0 | 20181011185857 |
| 1978761 | Q2051265 | 0 | 20181011231931 |
| 1985680 | Q2058295 | 0 | 20181012161641 |
| 203131 | Q206901 | 0 | 20181011112444 |
| 22459166 | Q20713246 | 0 | 20181010204958 |
| 2008976 | Q2081964 | 0 | 20181010212249 |
| 2086134 | Q2160802 | 0 | 20181011112332 |
| 23687338 | Q21646756 | 0 | 20181012000520 |
| 228686 | Q235159 | 0 | 20181011183455 |
| 2309304 | Q2390402 | 0 | 20181011184222 |
| 247770 | Q255314 | 0 | 20181011214756 |
| 260198 | Q268667 | 0 | 20181011112439 |
| 261193 | Q269762 | 0 | 20181011104759 |
| 29148268 | Q27343176 | 0 | 20181010183633 |
| 2787662 | Q2912561 | 0 | 20181011205402 |
| 2874057 | Q3006047 | 0 | 20181012095825 |
| 2878421 | Q3010685 | 0 | 20181010185630 |
| 2985601 | Q3124666 | 0 | 20181011051530 |
| 3004470 | Q3144934 | 0 | 20181011112325 |
| 307820 | Q320431 | 0 | 20181011184537 |
| 3178480 | Q3333971 | 0 | 20181011173248 |
| 35007772 | Q33561533 | 0 | 20181011213159 |
| 35023180 | Q33577088 | 0 | 20181012011441 |
| 35701956 | Q34262237 | 0 | 20181011151904 |
| 35702184 | Q34262466 | 0 | 20181010223222 |
| 35702622 | Q34262904 | 0 | 20181010163705 |
| 35702988 | Q34263275 | 0 | 20181012094550 |
| 35703059 | Q34263346 | 0 | 20181012092118 |
| 35703076 | Q34263363 | 0 | 20181012092012 |
| 35703083 | Q34263370 | 0 | 20181012091926 |
| 3265334 | Q3427374 | 0 | 20181011013745 |
| 3341159 | Q3508800 | 0 | 20181011112321 |
| 38392418 | Q37012398 | 0 | 20181011084656 |
| 3535241 | Q3709312 | 0 | 20181011112318 |
| 38685156 | Q37308652 | 0 | 20181011094801 |
| 39033395 | Q37660398 | 0 | 20181011162706 |
| 39447871 | Q38079893 | 0 | 20181011221000 |
| 39485756 | Q38117928 | 0 | 20181011224245 |
| 3647964 | Q3824771 | 0 | 20181012012959 |
| 39730811 | Q38365229 | 0 | 20181012023936 |
| 40029265 | Q38667098 | 0 | 20181010200901 |
| 369686 | Q388501 | 0 | 20181011021133 |
| 3716366 | Q3894917 | 0 | 20181012020308 |
| 40394048 | Q39035187 | 0 | 20181012085635 |
| 40543701 | Q39186183 | 0 | 20181011183820 |
| 41255425 | Q39907647 | 0 | 20181012080721 |
| 41256342 | Q39908575 | 0 | 20181010175007 |
| 41256501 | Q39908733 | 0 | 20181011060643 |
| 41256513 | Q39908746 | 0 | 20181012093612 |
| 41257665 | Q39909915 | 0 | 20181011060656 |
| 41258848 | Q39911150 | 0 | 20181010235101 |
| 41260860 | Q39913204 | 0 | 20181011060757 |
| 41261082 | Q39913428 | 0 | 20181012102913 |
| 41261094 | Q39913440 | 0 | 20181012102934 |
| 41261858 | Q39914222 | 0 | 20181011224648 |
| 41262356 | Q39914725 | 0 | 20181012085955 |
| 41262787 | Q39915160 | 0 | 20181012080327 |
| 41263307 | Q39915689 | 0 | 20181012084816 |
| 384336 | Q405379 | 0 | 20181011202102 |
| 391982 | Q413914 | 0 | 20181010165906 |
| 43253714 | Q41948972 | 0 | 20181010153910 |
| 43254325 | Q41949634 | 0 | 20181010153550 |
| 43255162 | Q41950534 | 0 | 20181010153134 |
| 43256202 | Q41951622 | 0 | 20181010152708 |
| 43256997 | Q41952471 | 0 | 20181010152137 |
| 43368415 | Q42070996 | 0 | 20181011102602 |
| 43368817 | Q42071422 | 0 | 20181010164110 |
| 43368881 | Q42071490 | 0 | 20181010190808 |
| 43369101 | Q42071724 | 0 | 20181012062007 |
| 4082894 | Q4271978 | 0 | 20181011222138 |
| 4163798 | Q4358039 | 0 | 20181011112310 |
| 4223095 | Q4421817 | 0 | 20181012023856 |
| 422669 | Q447991 | 0 | 20181011013552 |
| 46076673 | Q44893536 | 0 | 20181011140903 |
| 47320704 | Q46181491 | 0 | 20181012054623 |
| 435627 | Q461854 | 0 | 20181011112426 |
| 4447927 | Q4656032 | 0 | 20181012064814 |
| 451387 | Q478944 | 0 | 20181011185815 |
| 49061308 | Q48029208 | 0 | 20181012145415 |
| 49299836 | Q48270808 | 0 | 20181011115725 |
| 50446 | Q48460 | 0 | 20181012133354 |
| 50543043 | Q49540506 | 0 | 20181012010223 |
| 50563374 | Q49560992 | 0 | 20181012010332 |
| 50566855 | Q49564504 | 0 | 20181012014956 |
| 50575127 | Q49572856 | 0 | 20181012010949 |
| 50624954 | Q49623071 | 0 | 20181010213220 |
| 50739022 | Q49737482 | 0 | 20181010163039 |
| 50942082 | Q49942384 | 0 | 20181011061213 |
| 51073050 | Q50075052 | 0 | 20181011152312 |
| 477133 | Q507443 | 0 | 20181011215739 |
| 477184 | Q507495 | 0 | 20181011110342 |
| 4914180 | Q5141749 | 0 | 20181010154817 |
| 52372133 | Q51455231 | 0 | 20181011052134 |
| 4933784 | Q5162259 | 0 | 20181011173232 |
| 52740327 | Q51829353 | 0 | 20181011052204 |
| 5069396 | Q5300847 | 0 | 20181010153853 |
| 53882540 | Q53218157 | 0 | 20181012072049 |
| 53937530 | Q53329314 | 0 | 20181012131354 |
| 54158274 | Q53657221 | 0 | 20181011112928 |
| 54165977 | Q53666308 | 0 | 20181012135045 |
| 54742546 | Q54558402 | 0 | 20181012163918 |
| 514688 | Q546323 | 0 | 20181012171751 |
| 55418980 | Q55391507 | 0 | 20181012043021 |
| 55421379 | Q55393994 | 0 | 20181012045043 |
| 56000140 | Q56051896 | 0 | 20181011174443 |
| 5369329 | Q5608478 | 0 | 20181010165855 |
| 56159982 | Q56217568 | 0 | 20181011055628 |
| 56161030 | Q56218619 | 0 | 20181011055657 |
| 56161856 | Q56219453 | 0 | 20181011055734 |
| 5392274 | Q5631147 | 0 | 20181011102625 |
| 56437871 | Q56499153 | 0 | 20181011001139 |
| 56543532 | Q56604343 | 0 | 20181012050653 |
| 56543610 | Q56604417 | 0 | 20181011181951 |
| 56543615 | Q56604422 | 0 | 20181011181908 |
| 56543617 | Q56604423 | 0 | 20181011215538 |
| 56543619 | Q56604425 | 0 | 20181011181825 |
| 56543623 | Q56604431 | 0 | 20181011175741 |
| 60222 | Q57402 | 0 | 20181012171131 |
| 618860 | Q657516 | 0 | 20181011112421 |
| 636327 | Q675547 | 0 | 20181011081337 |
| 6612593 | Q6766645 | 0 | 20181010153854 |
| 6655901 | Q6805941 | 0 | 20181011083505 |
| 659769 | Q701108 | 0 | 20181011202837 |
| 6919619 | Q7034101 | 0 | 20181012063018 |
| 7226804 | Q7320761 | 0 | 20181011112220 |
| 7232144 | Q7325915 | 0 | 20181010184809 |
| 7494149 | Q7575800 | 0 | 20181010154117 |
| 712640 | Q757749 | 0 | 20181011112409 |
| 7734782 | Q7803282 | 0 | 20181010153855 |
| 7843764 | Q7905827 | 0 | 20181010183135 |
| 743985 | Q790971 | 0 | 20181011112406 |
| 797838 | Q845779 | 0 | 20181011093248 |
| 920104 | Q970408 | 0 | 20181011034629 |
| 947009 | Q997456 | 0 | 20181010165844 |
| 24932878 | Gz260/Roads/E/Wikidata/nl | 2 | 20181012051044 |
| 56496542 | Jacksonj04/Leeds/Prompt/All/comparison | 2 | 20181012090943 |
| 56496550 | Jacksonj04/Leeds/Prompt/All/comparison_csv | 2 | 20181012090944 |
| 48530520 | Jacksonj04/prompts/Kenya/Assembly/comparison | 2 | 20181011090730 |
| 48530527 | Jacksonj04/prompts/Kenya/Assembly/comparison_csv | 2 | 20181011090733 |
| 48530519 | Jacksonj04/prompts/Kenya/Assembly/stats | 2 | 20181011090730 |
| 51458078 | Jacksonj04/prompts/Pakistan/Assembly/Official/comparison | 2 | 20181012090848 |
| 51458087 | Jacksonj04/prompts/Pakistan/Assembly/Official/comparison_csv | 2 | 20181012090851 |
| 51458075 | Jacksonj04/prompts/Pakistan/Assembly/Official/stats | 2 | 20181011090912 |
| 49657071 | Jacksonj04/prompts/South_Africa/Assembly/Official/comparison | 2 | 20181012090817 |
| 49657081 | Jacksonj04/prompts/South_Africa/Assembly/Official/comparison_csv | 2 | 20181012090820 |
| 49657067 | Jacksonj04/prompts/South_Africa/Assembly/Official/stats | 2 | 20181011090801 |
| 56304527 | KaMan/WSJP | 2 | 20181011115159 |
| 55022675 | KaMan/brudnopis | 2 | 20181012055348 |
| 30487411 | Máté/ratings/Academy_Awards | 2 | 20181012154749 |
| 55072711 | Nurni/Painting_candidates | 2 | 20181012154311 |
| 31726906 | Olaf_Kosinsky/Chile | 2 | 20181012160214 |
| 25693096 | Olaf_Kosinsky/Reichstag_Kaiserreich | 2 | 20181011223129 |
| 29058208 | Olaf_Kosinsky/USA_Michigan | 2 | 20181012110330 |
| 25722124 | Olaf_Kosinsky/USA_Repräsentantenhaus_Republikanische_Partei | 2 | 20181012083236 |
| 56425624 | Oravrattas/prompts/8th_European_Parliament/comparison | 2 | 20181012090934 |
| 56425631 | Oravrattas/prompts/8th_European_Parliament/comparison_csv | 2 | 20181012090936 |
| 31749200 | Pawel_Marynowski_(WMIE)/Tables/Cork | 2 | 20181012055504 |
| 25772493 | SR5/P/500 | 2 | 20181011170317 |
| 26230380 | SR5/Test/1 | 2 | 20181012034000 |
| 44150090 | Strakhov/PRUEBA001 | 2 | 20181011232408 |
| 22492864 | Máté | 3 | 20181012043735 |
| 23684710 | Database_reports/Identical_GND_ID | 4 | 20181012171500 |
| 23537613 | Database_reports/Identical_VIAF_ID | 4 | 20181012152525 |
| 23020581 | Database_reports/identical_birth_and_death_dates | 4 | 20181012153356 |
| 23020610 | Database_reports/identical_birth_and_death_dates/1 | 4 | 20181012153356 |
| 29585021 | Flemish_art_collections,_Wikidata_and_Linked_Open_Data/KMSKA/Creators | 4 | 20181011225425 |
| 31621196 | Met_Open_Access_Artworks_Challenge/ES | 4 | 20181012082724 |
| 31591206 | Met_Open_Access_Artworks_Challenge/IT | 4 | 20181012110503 |
| 31591177 | Met_Open_Access_Artworks_Challenge/RU | 4 | 20181012084303 |
| 56400232 | Property_proposal/ArhivX_LOD | 4 | 20181012004639 |
| 56540384 | Property_proposal/Arkivportalen_aktor_ID | 4 | 20181012004639 |
| 56540714 | Property_proposal/Arkivportalen_arkiv_ID | 4 | 20181012004639 |
| 56538430 | Property_proposal/CharacTour_character_ID | 4 | 20181011151733 |
| 56538037 | Property_proposal/Microsoft_Store_app_ID | 4 | 20181012004639 |
| 56525183 | Property_proposal/Model_item_for | 4 | 20181012043735 |
| 56543524 | Property_proposal/Muziekweb_performer_ID | 4 | 20181012004639 |
| 21420181 | Property_proposal/count | 4 | 20181012145129 |
| 56539145 | Property_proposal/re3data_repository_ID | 4 | 20181011005059 |
| 55786984 | Property_proposal/value_is_inherited_from | 4 | 20181011115053 |
| 454 | Requests_for_deletions | 4 | 20181012172057 |
| 48119148 | WikiProject_France/Églises/28 | 4 | 20181011054657 |
| 33246637 | WikiProject_Heads_of_state_and_government/Report:P1313/P1365 | 4 | 20181011102947 |
| 31671457 | WikiProject_Maps/list_of_maps/RDT | 4 | 20181012050334 |
| 23793929 | WikiProject_Movies/Numbers/Most_frequent_P144 | 4 | 20181011161304 |
| 29634655 | WikiProject_Movies/lists/multiple_language_versions/it | 4 | 20181012013210 |
| 29753336 | WikiProject_Names/lists/Arabic_given_names | 4 | 20181012115818 |
| 28114772 | WikiProject_Names/reports/Romans_with_P2358 | 4 | 20181012172236 |
| 27869767 | WikiProject_Q5/lists/people_who_died_on_their_birthday | 4 | 20181012002603 |
| 56302855 | WikiProject_Source_MetaData/Wikidata_lists/Usage_of_Template_Scholia/Cross-wiki | 4 | 20181012171837 |
| 51320106 | WikiProject_every_politician/France/data/Assembly/15th_(bio) | 4 | 20181012051832 |
| 46908531 | WikiProject_every_politician/Italy/Deputies/prompts/OpenPolis/comparison | 4 | 20181012090637 |
| 46908539 | WikiProject_every_politician/Italy/Deputies/prompts/OpenPolis/comparison_csv | 4 | 20181012090640 |
| 28386517 | WikiProject_sum_of_all_paintings/Collections_without_inventory_number | 4 | 20181012033856 |
| 52365903 | WikiProject_sum_of_all_paintings/Location/Armenia/Missing_inventory_number | 4 | 20181012125721 |
| 16175375 | Lexicographical_data | 5 | 20181011184712 |
| 26029028 | Import_NBD_from_enwikisource/lists/people | 12 | 20181012052722 |
| 15088705 | P580 | 120 | 20181011081153 |
| 15088708 | P582 | 120 | 20181011081212 |
| 27795330 | P2963 | 121 | 20181012002041 |
| 27871509 | P2969 | 121 | 20181012002041 |
| 30231096 | P3533 | 121 | 20181012002041 |
| 30487540 | P3685 | 121 | 20181012002041 |
| 31528508 | P3936 | 121 | 20181012002042 |
| 31856026 | P4050 | 121 | 20181012002042 |
| 56058928 | P5633 | 121 | 20181012002042 |
| 56058926 | P5634 | 121 | 20181012002042 |
| 56215320 | P5721 | 121 | 20181012002042 |
| 56218329 | P5724 | 121 | 20181012002042 |
| 56543616 | L20543 | 146 | 20181011163148 |
+----------+---------------------------------------------------------------------------------+----------------+----------------+
248 rows in set (0.05 sec)It looks like in total there were 9681 pages linked to the revisions that had to be restored that could be affected:
MariaDB [wikidatawiki]> select count(DISTINCT rev_page) from revision where rev_id > 745452473 and rev_id < 745468910; +--------------------------+ | count(DISTINCT rev_page) | +--------------------------+ | 9681 | +--------------------------+ 1 row in set (0.02 sec)
TASK DETAIL
EMAIL PREFERENCES
To: Marostegui, Addshore
Cc: Pigsonthewing, Nikerabbit, gerritbot, WMDE-leszek, jcrespo, mark, Stashbot, Nikki, Marostegui, daniel, TerraCodes, Liuxinyu970226, Addshore, Ladsgroup, Lea_Lacroix_WMDE, Lexicographical data, KaMan, CucyNoiD, Nandana, NebulousIris, Banyek, jijiki, Mringgaard, AndyTan, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, Minhnv-2809, Volans, Maathavan, Jonas, Johan, Luke081515, Wikidata-bugs, aude, Lydia_Pintscher, Darkdadaah, TheDJ, Mbch331, Jay8g, Krenair, akosiaris
Cc: Pigsonthewing, Nikerabbit, gerritbot, WMDE-leszek, jcrespo, mark, Stashbot, Nikki, Marostegui, daniel, TerraCodes, Liuxinyu970226, Addshore, Ladsgroup, Lea_Lacroix_WMDE, Lexicographical data, KaMan, CucyNoiD, Nandana, NebulousIris, Banyek, jijiki, Mringgaard, AndyTan, Gaboe420, Versusxo, Majesticalreaper22, Giuliamocci, Adrian1985, Cpaulf30, Lahi, Gq86, Baloch007, Darkminds3113, Bsandipan, Lordiis, GoranSMilovanovic, Adik2382, Th3d3v1ls, Ramalepe, Liugev6, QZanden, LawExplorer, Lewizho99, Minhnv-2809, Volans, Maathavan, Jonas, Johan, Luke081515, Wikidata-bugs, aude, Lydia_Pintscher, Darkdadaah, TheDJ, Mbch331, Jay8g, Krenair, akosiaris
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
