Page MenuHomePhabricator
Paste P17044

Very active items (≥100 edits in the past 30 days)
ActivePublic

Authored by Lucas_Werkmeister_WMDE on Aug 18 2021, 12:51 PM.
rc_title wbx_text count
Q100333768 2021 Vuelta a España 592
Q101075855 Scott C. Holstad 114
Q101478196 2021 Clásica de San Sebastián 407
Q101550854 2021 Tour de Pologne 721
Q103097200 2021 Danmark Rundt 461
Q103100834 1st stage of the 2021 Danmark Rundt 122
Q103101733 2nd stage of the 2021 Danmark Rundt 123
Q103102557 3rd stage of the 2021 Danmark Rundt 150
Q104176880 2021 Ladies Tour of Norway 545
Q104183710 2021 Arctic Race of Norway 425
Q104211520 2021 Vuelta a Burgos 399
Q104392654 2021 Tour de l'Ain 631
Q104392919 2021 Tour de l'Ain, stage 1 132
Q104393010 2021 Tour de l'Ain, stage 2 101
Q105429923 Special:RecentChanges 716
Q106178442 Exotec 152
Q106189016 Das Fotoalbum für Weierstraß 307
Q106690059 Hydra 160
Q106876320 Geological Survey Bulletin 114
Q107018514 Quarterly Journal of Current Acquisitions 164
Q1071096 2001 Vuelta a España 139
Q107171731 NasserTone 106
Q107363105 Benkhalifa 136
Q107377361 NULL 289
Q107461898 2021 Taliban offensive 125
Q107566844 Anne Marie of Nassau-Siegen 202
Q107566920 John Albert of Nassau-Siegen 208
Q107567077 2021 Volta a Portugal 103
Q107574938 Josef Aichinger 104
Q107596384 2021 Henan floods 101
Q107596985 2021 12 Hours of Estoril Qualification Practice 701
Q107607609 Tracey Nicholls 124
Q107612969 Adriaan de Winter 111
Q107613033 Thomas W. Benson 167
Q107625868 Eurythenes atacamensis sp. nov. (Crustacea: Amphipoda) exhibits ontogenetic vertical stratification across abyssal and hadal depths in the Atacama Trench, eastern South Pacific Ocean 119
Q107629220 Professional Paper 119
Q107636701 NULL 134
Q107637510 Omid Rahimi 248
Q107641660 King Rodolinos 109
Q107642118 Maryland Medicine 102
Q107643395 Cornelis Apeus 103
Q107643443 Michael Espinoza Coila 115
Q107644012 Amelia Brodka 103
Q107644144 Arella Devorah 156
Q107645285 Momiji Nishiya 132
Q107645569 Stoephasius 121
Q107650388 MK Czerwiec 162
Q107652700 Ian Williams 109
Q107654158 DC Glenn 261
Q107658488 Susan Merrill Squier 172
Q107664976 David Lingelbach 127
Q107688076 Kimberly R. Myers 107
Q107689773 NULL 142
Q107693631 Spot News 18 134
Q107704708 Scott Thompson Smith 133
Q107724210 Civilization 116
Q107737285 Nightcore by baby angel's 177
Q107740769 Jacob van Rijndorp 126
Q107741164 Platonov 102
Q107742130 Jacob Zeeus 138
Q107744444 Donna al caffè - Compenetrazioni di luci e piani 103
Q107745202 Jacobus Baptist 105
Q107745865 Shahjahan Shamim 124
Q107746645 Diego Durán Solís 128
Q107778411 Hayden Bridge 108
Q107787116 Paleomagnetism and tectonic significance of Albian and Cenomanian turbidites, Ochoco Basin, Mitchell Inlier, central Oregon 154
Q107804099 Vital Shyshou 112
Q107952426 2021 Greek wildfires 109
Q107965926 Ali Nasser (Bu Mayed) 164
Q107972848 Mohammed Shanooj 115
Q107998963 Shape of the World 107
Q107999611 Simon de Vries 144
Q108039337 Yhojan Díaz 100
Q108046546 Jan Pook 114
Q108056923 Boni Faas 102
Q108063587 Frans Rijk 100
Q108087527 Einvestment 224
Q108091634 2021 Haiti earthquake 121
Q108102163 Eric Jan Sluijter 113
Q108102583 Fall of Kabul 140
Q108124453 Willem den Elger 118
Q108127606 Jordan Bear 111
Q108127909 Julia Isabel Miller 115
Q109987 Christian Bernhard Albinus 114
Q11201 Supreme Court of the United States 107
Q11241025 RLogin 275
Q113464 Chatham-Kent 101
Q1148422 United States Board on Geographic Names 118
Q11707166 Czech Property Investments 109
Q11967152 Elisabeth Reiss 125
Q13406268 Wikidata Sandbox 2 132
Q134430 Snow White and the Seven Dwarfs 102
Q13531686 Paris-Saclay University 134
Q1390714 Johann Jakob Egli 107
Q14077855 Jan Peters 102
Q14565069 An update of the Angiosperm Phylogeny Group classification for the orders and families of flowering plants: APG II 106
Q15397819 Wikidata Sandbox 3 137
Q1543 A.C. Milan 113
Q15545507 Prunus amygdalus 158
Q1579670 United States Supreme Court Building 167
Q15847453 Siduction 120
Q161819 Julie Andrews 188
Q16943273 Earth 270
Q17339402 NULL 124
Q17346683 Jin Ping Mei, chapter 77 101
Q17346684 Jin Ping Mei, chapter 78 130
Q17346685 Jin Ping Mei, chapter 79 106
Q174009 Hermione Granger 273
Q1774229 Ministry of Finance 117
Q179444 Potomac River 132
Q181278 2020 Summer Olympics 155
Q18165115 Siobhan Bernadette Haughey 106
Q18233 ABBA 298
Q18418922 Jossimar Pemberton 128
Q18558884 Firman Abdul Kholik 260
Q18684456 LoliRock 101
Q19096339 Republic Act No. 8293 315
Q193755 United States Geological Survey 187
Q20107972 Elizabeth of Nassau-Siegen 243
Q214204 Eden Hazard 183
Q22110911 Kenneth W. Cooper 144
Q2294962 Arsène Lupin III 130
Q229669 Malin Åkerman 131
Q23061366 Jan van Leeuwen 145
Q239766 Redakai: Conquer the Kairu 111
Q24034587 Batgirl and the Birds of Prey 333
Q2458031 Jean Jacobs 136
Q25114039 Hábito 195
Q2513804 Peter de Wit 102
Q25366209 Marcell Jacobs 119
Q2542307 The Cowardly Lion 143
Q2583524 Dorothy Gale 213
Q25835388 NULL 101
Q2612011 Ministry of Justice 198
Q2624248 Ministry of Healthcare of the Russian Federation 117
Q26712439 Xian-Zhang Liu 174
Q26838166 Theodor van Kessel 157
Q27715421 The Quarterly Journal of the Library of Congress 130
Q28197149 Risako 140
Q2822443 National Academy of Television Arts and Sciences 126
Q28667972 One Piece 140
Q28717743 Christian Sørum 230
Q2887250 Baskup 208
Q29098215 Dorothy and The Wizard of Oz 109
Q30747910 Islamic Republic of Afghanistan 183
Q31030630 Krystsina Tsimanouskaya 146
Q324829 William of Nassau-Siegen 249
Q3259444 Adolf of Nassau-Siegen 151
Q32649933 NULL 131
Q338430 Wonder Woman 139
Q360084 Juri Lotman 134
Q3696178 Coupe du Monde Cycliste Féminine de Montréal 2009 184
Q37092731 Kiyuna 296
Q3768819 2009 Tour of Flanders for Women 159
Q3790214 Sidekick 121
Q3816206 Kokoa Shuzen 153
Q38685497 Free Guy 123
Q3930104 John Ernest van Nassau-Siegen 184
Q39918 Prunus dulcis 148
Q403869 Aidamir Mugu 121
Q4115189 Wikidata Sandbox 1601
Q41242 Opera 129
Q41832532 Michael J. Green 164
Q42418 Taliban 105
Q427941 Islamic Emirate of Afghanistan 160
Q43744 Gerd Müller 106
Q448124 Countess Juliane of Nassau-Siegen 233
Q46480955 Hans Rem 108
Q47011266 Total DramaRama 127
Q47789432 Anders Mol 222
Q48256 Dnipro 102
Q5153902 Rzeczpospolita 171
Q52154105 Simon Schijnvoet 226
Q532062 Magdalena of Waldeck-Wildungen 151
Q532907 Langenbach 102
Q533619 Netherlandish Proverbs 117
Q53579434 Ministry of Science and Higher Education 934
Q53953275 Open-File Report 121
Q54357938 Tom Grennan 116
Q56617465 People's Artist of the Chechen Republic 172
Q570307 2000 Vuelta a España 610
Q57083851 badminton at the 2020 Summer Olympics – men's singles 142
Q57083852 badminton at the 2020 Summer Olympics – women's singles 143
Q57083855 badminton at the 2020 Summer Olympics – men's doubles 123
Q57083856 badminton at the 2020 Summer Olympics – women's doubles 107
Q57083858 badminton at the 2020 Summer Olympics – mixed doubles 111
Q57137425 Tomoru 101
Q59354527 NULL 136
Q61749128 Geological Survey Professional Paper 139
Q61881665 Rohrlach 145
Q62400 Heinrich von Treitschke 131
Q63035145 Karel Sichem 111
Q63339904 Planet Zoo 113
Q637413 United States Census Bureau 113
Q65153800 Mari Kraimbrery 103
Q65242227 cycling at the 2020 Summer Olympics – men's individual time trial 380
Q65242242 cycling at the 2020 Summer Olympics – women's individual road race 615
Q65242249 cycling at the 2020 Summer Olympics – men's individual road race 645
Q65956705 Donostia San Sebastian Klasikoa Women 2021 582
Q6905671 Montgomery College 120
Q69270696 July 6, 1934 134
Q710324 One Piece 168
Q720005 Jahn Teigen 193
Q726264 Israel Finkelstein 100
Q7355119 Rocket Monkeys 131
Q738909 Gothic 3 121
Q769344 1998 Vuelta a España 578
Q77143 Thomas Anders 106
Q79874 flag of Afghanistan 161
Q819521 John VII, Count of Nassau-Siegen 194
Q829662 Craterellus sinuosus 113
Q83872271 COVID-19 pandemic in mainland China 217
Q83872291 COVID-19 pandemic in Japan 225
Q83872398 COVID-19 pandemic in South Korea 229
Q83873057 COVID-19 pandemic in Vietnam 217
Q83873387 COVID-19 pandemic in Singapore 322
Q83873548 COVID-19 pandemic in Australia 216
Q83873556 COVID-19 pandemic in Malaysia 225
Q83873566 COVID-19 pandemic in Thailand 211
Q83873573 COVID-19 pandemic in Nepal 224
Q83873577 COVID-19 pandemic in the United States 216
Q83873580 COVID-19 pandemic in Canada 211
Q83873593 COVID-19 pandemic in France 227
Q83888864 COVID-19 pandemic in Cambodia 232
Q83889114 COVID-19 pandemic in Sri Lanka 213
Q83889294 COVID-19 pandemic in Germany 225
Q84030045 COVID-19 pandemic in the United Arab Emirates 216
Q84055415 COVID-19 pandemic in Finland 226
Q84055514 COVID-19 pandemic in India 104
Q84055544 COVID-19 pandemic in the Philippines 225
Q84081576 COVID-19 pandemic in Sweden 216
Q84098939 COVID-19 pandemic in Russia 211
Q84104992 COVID-19 pandemic in Italy 227
Q84166704 COVID-19 pandemic in Spain 217
Q84167106 COVID-19 pandemic in the United Kingdom 985
Q84446340 COVID-19 pandemic in Belgium 232
Q844857 Pacific Islands 108
Q85627863 Mohammad Mohammadian 127
Q85876114 COVID-19 pandemic in Iran 226
Q861473 Union Station 134
Q86597685 COVID-19 pandemic in Denmark 228
Q86597695 COVID-19 pandemic in Brazil 875
Q86606 Albrecht von Stosch 135
Q86628344 COVID-19 pandemic in Mexico 224
Q86717788 COVID-19 pandemic in Switzerland 212
Q86733728 COVID-19 pandemic in Iraq 225
Q86756826 2020 COVID-19 pandemic in the Netherlands 225
Q86886544 COVID-19 pandemic in Norway 224
Q86913546 COVID-19 pandemic in Indonesia 126
Q86919406 COVID-19 pandemic in the Czech Republic 224
Q86948603 2020 COVID-19 pandemic in Portugal 217
Q87058723 COVID-19 pandemic in Morocco 227
Q87066621 COVID-19 pandemic in Latvia 225
Q87068864 COVID-19 pandemic in Greece 225
Q87070975 COVID-19 pandemic in Israel 224
Q87070999 2020 COVID-19 pandemic in Bahrain 234
Q87116829 COVID-19 pandemic in Egypt 224
Q87119811 COVID-19 pandemic in Hungary 192
Q87121993 COVID-19 pandemic in Iceland 224
Q87123561 2020 COVID-19 pandemic in San Marino 213
Q87186117 COVID-19 pandemic in Saudi Arabia 216
Q87186365 COVID-19 pandemic in the Republic of Ireland 225
Q87191204 COVID-19 pandemic in Chile 241
Q87193778 2020 COVID-19 pandemic in Serbia 208
Q87200954 COVID-19 pandemic in Slovakia 208
Q87202921 2020 COVID-19 pandemic in Algeria 232
Q87204911 COVID-19 pandemic in Estonia 225
Q87235137 COVID-19 pandemic in Argentina 232
Q87235177 COVID-19 pandemic in Ukraine 217
Q87243915 2020 COVID-19 pandemic in South Africa 212
Q87245450 2020 COVID-19 pandemic in Lebanon 224
Q87250691 2020 COVID-19 pandemic in Kuwait 224
Q87250695 COVID-19 pandemic in Poland 218
Q87250713 COVID-19 pandemic in Ecuador 224
Q87250732 COVID-19 pandemic in Croatia 224
Q87250752 COVID-19 pandemic in Romania 216
Q87250770 2020 COVID-19 pandemic in Bosnia and Herzegovina 233
Q87250788 2020 COVID-19 pandemic in Belarus 232
Q87250803 COVID-19 pandemic in New Zealand 225
Q87250819 2020 COVID-19 pandemic in Liechtenstein 225
Q87250838 2020 COVID-19 pandemic in Lithuania 225
Q87250877 2020 COVID-19 pandemic in Monaco 225
Q87250897 2020 COVID-19 pandemic in North Macedonia 224
Q87250913 2020 COVID-19 pandemic in Georgia 225
Q87250930 2020 COVID-19 pandemic in Cameroon 229
Q87250948 COVID-19 pandemic in Slovenia 213
Q87343682 COVID-19 pandemic in Tunisia 216
Q87412028 2020 COVID-19 pandemic in Brunei 230
Q87450756 COVID-19 pandemic in Albania 224
Q87454162 COVID-19 pandemic in Oman 225
Q87473205 COVID-19 pandemic in Turkey 216
Q87477462 COVID-19 pandemic in Costa Rica 224
Q87477841 COVID-19 pandemic in Panama 224
Q87480220 COVID-19 pandemic in Bolivia 232
Q87486535 COVID-19 pandemic in Bulgaria 232
Q87540454 COVID-19 pandemic in Bangladesh 232
Q87563855 2020 COVID-19 pandemic in the Dominican Republic 224
Q87580938 2020 COVID-19 pandemic in Cyprus 224
Q87587760 2020 COVID-19 pandemic in Malta 224
Q87587763 COVID-19 pandemic in Peru 224
Q87589123 2020 COVID-19 pandemic in Paraguay 224
Q87589148 2020 COVID-19 pandemic in Jordan 224
Q87589392 COVID-19 pandemic in Honduras 224
Q87590993 2020 COVID-19 pandemic in Cuba 224
Q87592982 COVID-19 pandemic in Moldova 224
Q87610822 2020 COVID-19 pandemic in Jamaica 224
Q87648634 COVID-19 pandemic in Armenia 232
Q87651970 2020 COVID-19 pandemic in Guinea 216
Q87651995 COVID-19 pandemic in Kazakhstan 224
Q87652000 COVID-19 pandemic in Pakistan 224
Q87652010 2020 COVID-19 pandemic in Venezuela 217
Q87655119 COVID-19 pandemic in Kosovo 225
Q87657486 2020 COVID-19 pandemic in Sudan 228
Q87659698 2020 COVID-19 pandemic in Guyana 217
Q87660365 2020 COVID-19 pandemic in Uruguay 209
Q87662819 2020 COVID-19 pandemic in Togo 217
Q87662895 COVID-19 pandemic in the Maldives 225
Q87664046 2020 COVID-19 pandemic in Suriname 217
Q87665038 2020 COVID-19 pandemic in Ethiopia 224
Q87665364 COVID-19 pandemic in Burkina Faso 232
Q87666042 2020 COVID-19 pandemic in Gabon 225
Q87666247 COVID-19 pandemic in Ghana 220
Q87669612 COVID-19 pandemic in Guatemala 222
Q87687648 2020 COVID-19 pandemic in Saint Vincent and the Grenadines 217
Q87694131 2020 COVID-19 pandemic in Trinidad and Tobago 217
Q87704267 2020 COVID-19 pandemic in Ivory Coast 226
Q87705884 COVID-19 pandemic in Kenya 225
Q87706558 COVID-19 pandemic in the Democratic Republic of the Congo 224
Q87707727 2020 COVID-19 pandemic in Saint Lucia 209
Q87708331 2020 COVID-19 pandemic in Antigua and Barbuda 232
Q87708832 2020 COVID-19 pandemic in Mongolia 226
Q87709900 COVID-19 pandemic in Mauritania 222
Q87709973 2020 COVID-19 pandemic in Eswatini 224
Q87714704 2020 COVID-19 pandemic in Rwanda 209
Q87715166 COVID-19 pandemic in Bhutan 234
Q87715843 2020 COVID-19 pandemic in Andorra 234
Q87718451 COVID-19 pandemic in Nigeria 224
Q87722485 2020 COVID-19 pandemic in Azerbaijan 232
Q87729500 2020 COVID-19 pandemic in Seychelles 192
Q87729501 2020 COVID-19 pandemic in Namibia 224
Q87733671 2020 COVID-19 pandemic in Qatar 216
Q87742064 2020 COVID-19 pandemic in Equatorial Guinea 224
Q87742085 2020 COVID-19 pandemic in the Central African Republic 232
Q87742114 2020 COVID-19 pandemic in the Republic of the Congo 231
Q87745903 COVID-19 pandemic in Senegal 217
Q87755488 2020 COVID-19 pandemic in the Bahamas 233
Q87755912 2020 COVID-19 pandemic in Uzbekistan 209
Q87766242 2020 COVID-19 pandemic in Liberia 224
Q87768605 COVID-19 pandemic in Afghanistan 232
Q87770645 2020 COVID-19 pandemic in Somalia 210
Q87770827 2020 COVID-19 pandemic in Tanzania 217
Q87781572 2020 COVID-19 pandemic in Benin 233
Q87814953 2020 COVID-19 pandemic in Syria 216
Q87836826 COVID-19 pandemic in East Timor 201
Q87887813 2020 COVID-19 pandemic in Montenegro 224
Q87899016 2020 COVID-19 pandemic in the Gambia 226
Q87899022 2020 COVID-19 pandemic in Djibouti 221
Q87902902 2020 COVID-19 pandemic in Barbados 233
Q87902950 COVID-19 pandemic in Kyrgyzstan 224
Q87936974 COVID-19 pandemic in El Salvador 225
Q87975745 2020 COVID-19 pandemic in Fiji 226
Q87976629 2020 COVID-19 pandemic in Zambia 202
Q87976701 COVID-19 pandemic in Nicaragua 224
Q87979033 2020 COVID-19 pandemic in Mauritius 225
Q88082534 2020 COVID-19 pandemia em Angola 233
Q88082639 COVID-19 pandemic in Cape Verde 233
Q88082670 2020 COVID-19 pandemic in Chad 232
Q88082693 COVID-19 pandemic in Haiti 216
Q88082809 2020 COVID-19 pandemic in Niger 227
Q88137634 2020 COVID-19 pandemic in Papua New Guinea 224
Q88164033 2020 COVID-19 pandemic in Zimbabwe 217
Q88225303 2020 COVID-19 pandemic in Madagascar 225
Q88263719 2020 COVID-19 pandemic in Uganda 217
Q88335426 2020 COVID-19 pandemic in Mozambique 224
Q88356648 COVID-19 pandemic in Dominica 224
Q88371105 2020 COVID-19 pandemic in Eritrea 224
Q88460663 2020 COVID-19 pandemic in Myanmar 233
Q88521330 2020 COVID-19 pandemic in Laos 224
Q88556836 COVID-19 pandemic in Mali 226
Q88561418 2020 COVID-19 pandemic in Belize 233
Q88568089 2020 COVID-19 pandemic in Libya 224
Q88617000 2020 COVID-19 pandemic in Guinea-Bissau 216
Q88713785 2020 COVID-19 pandemic in Grenada 224
Q88864139 COVID-19 pandemic in Saint Kitts and Nevis 210
Q889 Afghanistan 135
Q89127366 2020 COVID-19 pandemic in Sierra Leone 184
Q89164046 2020 COVID-19 pandemic in Botswana 228
Q89193856 2020 COVID-19 pandemic in Burundi 232
Q89276897 COVID-19 pandemic in the Marshall Islands 224
Q89277028 2020 COVID-19 pandemic in Kiribati 224
Q89277147 2020 COVID-19 pandemic in Samoa 217
Q89277187 2020 COVID-19 pandemic in the Solomon Islands 214
Q89277287 COVID-19 pandemic in Palau 224
Q89285378 2020 COVID-19 pandemic in Malawi 224
Q89560617 2020 COVID-19 pandemic in South Sudan 217
Q89598747 2020 COVID-19 pandemic in São Tomé and Príncipe 211
Q89695985 2020 COVID-19 pandemic in Yemen 208
Q89990513 COVID-19 pandemic in Tajikistan 217
Q9081459 Tag Team 140
Q91024607 COVID-19 pandemic in Lesotho 224
Q91988138 Peter A. McCullough 100
Q92619508 COVID-19 pandemic in the Comoros 233
Q93222996 Bettina Bergo 174
Q93372338 Rebecca Stefoff 115
Q9338576 Slugterra 174
Q950363 1999 Vuelta a España 220
Q95276888 Arie Schippers 108
Q96417649 Among Us 380
Q96888686 Strange Energies 116
Q97672275 Christakis 496
Q982531 Luigi Giussani 155
Q98277271 Album amicorum of Albertus van Loo 100
Q9952505 NULL 128

Event Timeline

Query:

SELECT rc_title, wbx_text, count FROM (SELECT rc_title, COUNT(*) AS count FROM recentchanges WHERE rc_namespace = 0 GROUP BY rc_title HAVING COUNT(*) >= 100) AS items LEFT JOIN wbt_item_terms ON SUBSTRING(rc_title, 2) = wbit_item_id LEFT JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id LEFT JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id LEFT JOIN wbt_text ON wbxl_text_id = wbx_id WHERE (wbtl_type_id = (SELECT wby_id FROM wbt_type WHERE wby_name = 'label') AND wbxl_language = 'en') OR wbtl_id IS NULL;

Formatted:

SELECT rc_title, wbx_text, count
FROM (
  SELECT rc_title, COUNT(*) AS count
  FROM recentchanges
  WHERE rc_namespace = 0
  GROUP BY rc_title
  HAVING COUNT(*) >= 100
) AS items
LEFT JOIN wbt_item_terms ON SUBSTRING(rc_title, 2) = wbit_item_id
LEFT JOIN wbt_term_in_lang ON wbit_term_in_lang_id = wbtl_id
LEFT JOIN wbt_text_in_lang ON wbtl_text_in_lang_id = wbxl_id
LEFT JOIN wbt_text ON wbxl_text_id = wbx_id 
WHERE (
  wbtl_type_id = (
    SELECT wby_id
    FROM wbt_type
    WHERE wby_name = 'label'
  )
  AND wbxl_language = 'en'
)
OR wbtl_id IS NULL;