Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Stefterv
.
Toggle Highlighting
SQL
SELECT '2015/7' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Speciaal:Aanmelden','Template:GeoTemplate','Special:Search','Vulkaan-Eifel','Speciaal:Volglijst','Speciaal:Boek','Speciaal:RecenteWijzigingen','Ronde_van_Frankrijk','User:Basvb/Nuweg') UNION SELECT '2015/8' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Speciaal:Aanmelden','Template:GeoTemplate','Special:Search','Speciaal:Volglijst','Speciaal:Boek','User:Basvb/Nuweg','Speciaal:RecenteWijzigingen','Tabel_van_Belgische_gemeenten','Penoza') UNION SELECT '2015/9' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Speciaal:Aanmelden','Joost_Zwagerman','Template:GeoTemplate','Pablo_Escobar','Special:Search','Speciaal:Volglijst','Speciaal:Boek','Speciaal:RecenteWijzigingen','User:Basvb/Nuweg') UNION SELECT '2015/10' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Template:GeoTemplate','Special:Search','Speciaal:Aanmelden','James_Bond','Halloween','Speciaal:Volglijst','Pablo_Escobar','Nederland','User:Basvb/Nuweg') UNION SELECT '2015/11' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Special:MyPage/zeusmodepreferences.js','Special:Search','Islamitische_Staat_(in_Irak_en_de_Levant)','K3_(muziekgroep)','Speciaal:Aanmelden','James_Bond','Speciaal:Volglijst','Template:GeoTemplate','Sinterklaas') UNION SELECT '2015/12' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Special:MyPage/zeusmodepreferences.js','Star_Wars','Special:Search','3FM_Serious_Request','Speciaal:Aanmelden','Speciaal:Volglijst','Sinterklaas','Adele','Star_Wars:_Episode_VII:_The_Force_Awakens') UNION SELECT '2016/1' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','David_Bowie','Special:MyPage/zeusmodepreferences.js','Special:Search','Speciaal:Aanmelden','Speciaal:Volglijst','Alan_Rickman','Speciaal:Boek','Nederland','Pablo_Escobar') UNION SELECT '2016/2' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Special:MyPage/zeusmodepreferences.js','Speciaal:Aanmelden','De_blikken_trommel','Special:Search','Speciaal:Volglijst','Nederland','Conjunctuur','Carnaval','Jheronimus_Bosch') UNION SELECT '2016/3' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Johan_Cruijff','Special:MyPage/zeusmodepreferences.js','Kwatta_(merk)','Special:Search','Pasen','Speciaal:Aanmelden','Speciaal:Volglijst','Goede_Vrijdag','Waterstofperoxide') UNION SELECT '2016/4' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Prince','Special:MyPage/zeusmodepreferences.js','Speciaal:Aanmelden','Special:Search','Speciaal:Volglijst','Willem-Alexander_der_Nederlanden','Johan_Cruijff','Nederland','User:Basvb/Nuweg') UNION SELECT '2016/5' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Eurovisiesongfestival_2016','Special:MyPage/zeusmodepreferences.js','Special:Search','Pinksteren','Douwe_Bob','Max_Verstappen_(coureur)','Speciaal:Volglijst','Speciaal:Aanmelden','Eurovisiesongfestival') UNION SELECT '2016/6' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Special:Search','Special:MyPage/zeusmodepreferences.js','Europees_kampioenschap_voetbal_2016','Muhammad_Ali','Zlatan_Ibrahimović','IJsland','Speciaal:Volglijst','Belgisch_voetbalelftal','Daniël_de_Ridder') UNION SELECT '2016/7' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Special:MyPage/zeusmodepreferences.js','Special:Search','Speciaal:AllePaginas','Speciaal:Volglijst','Fethullah_Gülen','Staatsgreep','Pokémon','Antoine_Griezmann','Pokémon_GO') UNION SELECT '2016/8' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Special:MyPage/zeusmodepreferences.js','Olympische_Zomerspelen_2016','Medaillespiegel_van_de_Olympische_Zomerspelen_2016','Speciaal:Volglijst','Special:Search','Medaillespiegel_van_de_Olympische_Zomerspelen_2012','Olympische_Spelen','Hockey','User:Basvb/Nuweg') UNION SELECT '2016/9' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Special:MyPage/zeusmodepreferences.js','Pablo_Escobar','xss','Special:Search','Speciaal:Volglijst','Aanslagen_op_11_september_2001','Hoornaar_(insect)','Speciaal:Aanmelden','Speciaal:Boek') UNION SELECT '2016/10' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Special:MyPage/zeusmodepreferences.js','Halloween','Speciaal:Boek','Special:Search','Speciaal:Volglijst','Speciaal:Aanmelden','Dries_Riphagen','Amerikaanse_presidentsverkiezingen_2016','Donald_Trump') UNION SELECT '2016/11' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Donald_Trump','Special:MyPage/zeusmodepreferences.js','Amerikaanse_presidentsverkiezingen_2016','Special:Search','Sinterklaas','Elizabeth_II_van_het_Verenigd_Koninkrijk','Melania_Trump','Pieter_Menten','Speciaal:Aanmelden') UNION SELECT '2016/12' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Special:MyPage/zeusmodepreferences.js','Epilepsie','Special:Search','George_Michael','3FM_Serious_Request','Tabel_van_Belgische_gemeenten','Lijst_van_personen_overleden_in_2016','Rico_Verhoeven','Michiel_de_Ruyter') UNION SELECT '2017/1' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Special:MyPage/zeusmodepreferences.js','Donald_Trump','Tabel_van_Belgische_gemeenten','Special:Search','Victoria_van_het_Verenigd_Koninkrijk','Dries_Riphagen','O.J._Simpson','Speciaal:Volglijst','Speciaal:Aanmelden') UNION SELECT '2017/2' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Special:MyPage/zeusmodepreferences.js','Lijst_van_landcodes_voor_voertuigen','Special:Search','Speciaal:Aanmelden','Patricia_Paay','Speciaal:Volglijst','Speciaal:Boek','Speciaal:GebruikerAanmaken','Jesse_Klaver') UNION SELECT '2017/3' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Jesse_Klaver','Special:MyPage/zeusmodepreferences.js','Thierry_Baudet','Geert_Wilders','Special:Search','Mark_Rutte','Speciaal:Volglijst','Tweede_Kamerverkiezingen_2017','Ancilla_van_de_Leest') UNION SELECT '2017/4' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Special:MyPage/zeusmodepreferences.js','Speciaal:Aanmelden','Speciaal:GebruikerAanmaken','Pasen','Speciaal:Boek','Special:Search','Speciaal:Volglijst','13_Reasons_Why','Noord-Korea') UNION SELECT '2017/5' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Eurovisiesongfestival_2017','Special:MyPage/zeusmodepreferences.js','OG3NE','John_Wijdenbosch','Special:Search','Dirk_Kuijt','Speciaal:Volglijst','Feyenoord','Inge_de_Bruijn') UNION SELECT '2017/6' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Speciaal:Aanmelden','Special:MyPage/zeusmodepreferences.js','Speciaal:GebruikerAanmaken','Speciaal:Boek','Pinksteren','Ariana_Grande','Speciaal:Citeren','Special:Search','FIFA_Confederations_Cup_2017') UNION SELECT '2017/7' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Special:MyPage/zeusmodepreferences.js','Abdelhak_Nouri','Speciaal:RecenteWijzigingen','Special:Search','Speciaal:Volglijst','Speciaal:Aanmelden','Speciaal:GebruikerAanmaken','Chester_Bennington','Roger_Federer') UNION SELECT '2017/8' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Speciaal:Boek','Special:MyPage/zeusmodepreferences.js','Lieke_Martens','Diana_Spencer','Speciaal:Volglijst','Special:Search','Fipronil','Elvis_Presley','Michiel_de_Ruyter') UNION SELECT '2017/9' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Johannes_Kepler','Speciaal:VerwijzingenNaarHier','Special:MyPage/zeusmodepreferences.js','Sint_Maarten_(eiland)','Eberhard_van_der_Laan','Special:Search','Speciaal:Volglijst','Calikartel','Nederland') UNION SELECT '2017/10' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Special:MyPage/zeusmodepreferences.js','Catalonië','Halloween','Eberhard_van_der_Laan','Bende_van_Nijvel','Special:Search','Speciaal:Volglijst','Max_Verstappen_(coureur)','Speciaal:Aanmelden') UNION SELECT '2017/11' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Special:MyPage/zeusmodepreferences.js','Sinterklaas','Special:Search','Black_Friday','Speciaal:Volglijst','Sint-Maarten_(feest)','Meghan_Markle','Charles_Manson','Thanksgiving_Day') UNION SELECT '2017/12' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Special:MyPage/zeusmodepreferences.js','Margaret_Windsor','Elizabeth_II_van_het_Verenigd_Koninkrijk','Speciaal:Aanmelden','Speciaal:GebruikerAanmaken','Special:Search','Speciaal:Volglijst','3FM_Serious_Request','Joost_Karhof') UNION SELECT '2018/1' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Special:MyPage/zeusmodepreferences.js','Special:Search','Speciaal:Volglijst','Elizabeth_II_van_het_Verenigd_Koninkrijk','Speciaal:Aanmelden','Margaret_Windsor','Victoria_van_het_Verenigd_Koninkrijk','Blue_Monday_(dag)','Wie_is_de_Mol?') UNION SELECT '2018/2' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Medaillespiegel_van_de_Olympische_Winterspelen_2018','Special:MyPage/zeusmodepreferences.js','Olympische_Winterspelen_2018','Sven_Kramer','Nederland_op_de_Olympische_Winterspelen_2018','Ted-Jan_Bloemen','Massastart_(schaatsen)','Medaillespiegel_van_de_Olympische_Winterspelen_2014','Special:Search') UNION SELECT '2018/3' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Special:MyPage/zeusmodepreferences.js','Stephen_Hawking','Google_Inc.','Special:Search','Speciaal:Volglijst','Pasen','Speciaal:Aanmelden','Wie_is_de_Mol?','Goede_Vrijdag') UNION SELECT '2018/4' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Surinaamse_indianen','Avicii','Special:MyPage/zeusmodepreferences.js','Google_Inc.','Nikki_Sexx','Special:Search','Speciaal:Volglijst','.bf','La_casa_de_papel') UNION SELECT '2018/5' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Meghan_Markle','Special:MyPage/zeusmodepreferences.js','Eurovisiesongfestival_2018','Pinksteren','Google_Inc.','Waylon_(zanger)','Special:Search','Harry_van_Wales','Speciaal:Volglijst') UNION SELECT '2018/6' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Special:MyPage/zeusmodepreferences.js','Wereldkampioenschap_voetbal_2018','Getronics','Google_Inc.','Nikki_Sexx','Wereldkampioenschap_voetbal','Special:Search','XXXTentacion','Speciaal:Volglijst') UNION SELECT '2018/7' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Special:MyPage/zeusmodepreferences.js','Kroatië','Wereldkampioenschap_voetbal','Google_Inc.','Eden_Hazard','Special:Search','Europees_kampioenschap_voetbal_2020','Wereldkampioenschap_voetbal_2018','Speciaal:Volglijst') UNION SELECT '2018/8' as date, page_title, page_id, (SELECT COUNT(*) FROM revision WHERE rev_page=page_id) as revisions, (SELECT COUNT(DISTINCT(rev_user_text)) FROM revision WHERE rev_page=page_id) as unique_users FROM page WHERE page_namespace = 0 AND page_title IN ('Hoofdpagina','Speciaal:Zoeken','Special:MyPage/zeusmodepreferences.js','Speciaal:Volglijst','Moord_op_Nicky_Verstappen','Special:Search','Hoornaar_(insect)','Aretha_Franklin','Maarten_van_der_Weijden','Speciaal:Aanmelden','Speciaal:RecenteWijzigingen')
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...