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
BilledMammal
.
Looks for Stub-Class biography articles sourced solely to various statistical sources, creating in February 2015.
Toggle Highlighting
SQL
SET STATEMENT max_statement_time = 3600 FOR WITH Olympedia AS (SELECT el_from, page_title FROM externallinks JOIN page ON Article.page_id = el_from AS Article JOIN page ON Article.page_title = Talk.page_title AND Talk.page_namespace = 1 AS Talk JOIN revision ON rev_parent_id = 0 AND rev_page = el_from JOIN categorylinks ON Talk.page_id = cl_from AND cl_to = 'Stub-Class_biography_articles' WHERE rev_timestamp > 20150200000000 AND Article.page_namespace = 0 AND rev_timestamp < 20150300000000 AND (el_index LIKE 'https://org.olympedia%' OR el_index LIKE 'http://org.olympedia%' OR el_index LIKE 'https://com.olympics%' OR el_index LIKE 'http://com.olympics%' OR el_index LIKE 'https://org.archive.web./%/https://www.sports-reference.com%' OR el_index LIKE 'http://org.archive.web./%/https://www.sports-reference.com%' OR el_index LIKE 'https://org.archive.web./%/http://www.sports-reference.com%' OR el_index LIKE 'http://org.archive.web./%/http://www.sports-reference.com%' OR el_index LIKE 'http://com.soccerway%' OR el_index LIKE 'https://com.soccerway%' OR el_index LIKE 'http://net.worldfootball%' OR el_index LIKE 'https://net.worldfootball%' OR el_index LIKE 'http://org.fina.www./athletes/%' OR el_index LIKE 'http://de.uni-leipzig.iat.www./datenbanken/%' OR el_index LIKE 'http://au.org.swimming.www./athletes/%' OR el_index LIKE 'http://net.swimrankings%' OR el_index LIKE 'http://hu.waterpolo./jatekos/%' OR el_index LIKE 'http://org.ishof.www./honoree/%' OR el_index LIKE 'http://org.usawaterpolo%' OR el_index LIKE 'http://org.worldarchery%' OR el_index LIKE 'http://org.worldathletics.www./athletes/%' OR el_index LIKE 'http://org.mementoweb.timetravel./memento/%/http://www.european-athletics.org/athletes/%' OR el_index LIKE 'http://org.d-u-v.statistik%' OR el_index LIKE 'http://it.fidal.www./atleta_one.php%' OR el_index LIKE 'http://fr.athle.bases./asp.net/athletes.aspx%' OR el_index LIKE 'http://de.leichtathletik.www./nationalmannschaft/%' OR el_index LIKE 'http://com.possumbility.athletics./athletes/%' OR el_index LIKE 'http://org.usatf.legacy%' OR el_index LIKE 'http://nl.atletiek.www./atleet/%' OR el_index LIKE 'http://jp.or.jaaf.www./athletes/%' OR el_index LIKE 'http://info.thepowerof10.www./athletes/%' OR el_index LIKE 'http://com.diamondleague.www./athletes/%' OR el_index LIKE 'http://org.tfrrs.www./athletes/%' OR el_index LIKE 'http://com.sports-reference%' OR el_index LIKE 'http://com.pro-football-reference.www./players/%' OR el_index LIKE 'http://com.justsportsstats%' OR el_index LIKE 'http://org.archive.www./web/%/http://static.fifa.com/fifa-tournaments/%' OR el_index LIKE 'http://com.uefa.www./uefachampionsleague/clubs/players/%' OR el_index LIKE 'http://be.belgianfootball.static./project/%' OR el_index LIKE 'http://hr.hns-cff%' OR el_index LIKE 'http://cz.fotbal.nv./reprezentace/%' OR el_index LIKE 'http://ee.jalgpall./voistlused/player/%' OR el_index LIKE 'http://il.org.football.www./en/players/%' OR el_index LIKE 'http://no.fotball.www./fotballdata/person/%' OR el_index LIKE 'http://uk,co.scottishfa.www./players/%' OR el_index LIKE 'http://org.tff%' OR el_index LIKE 'http://ua.uaf.db./player/%' OR el_index LIKE 'http://jp.or.j-league.data%' OR el_index LIKE 'http://com.kleague.www./record/%' OR el_index LIKE 'http://fr.lfp.www./joueur/%' OR el_index LIKE 'http://com.mlssoccer.www./players/%' OR el_index LIKE 'http://mx.ligafemenil./cancha/jugador/%' OR el_index LIKE 'http://com.espn.global/football/player/%' OR el_index LIKE 'http://eu.footballdatabase.www./fr/joueur/%' OR el_index LIKE 'http://de.fussballdaten.www./spieler/%' OR el_index LIKE 'http://fr.lequipe.www./Football/%' OR el_index LIKE 'http://com.national-football-teams.www./player/%' OR el_index LIKE 'http://com.soccerbase%' OR el_index LIKE 'http://pt.zerozero.www./player.php%' OR el_index LIKE 'http://net.worldfootball.www./player_summary/%' OR el_index LIKE 'https://org.fina.www./athletes/%' OR el_index LIKE 'https://de.uni-leipzig.iat.www./datenbanken/%' OR el_index LIKE 'https://au.org.swimming.www./athletes/%' OR el_index LIKE 'https://net.swimrankings%' OR el_index LIKE 'https://hu.waterpolo./jatekos/%' OR el_index LIKE 'https://org.ishof.www./honoree/%' OR el_index LIKE 'https://org.usawaterpolo%' OR el_index LIKE 'https://org.worldarchery%' OR el_index LIKE 'https://org.worldathletics.www./athletes/%' OR el_index LIKE 'https://org.mementoweb.timetravel./memento/%/https://www.european-athletics.org/athletes/%' OR el_index LIKE 'https://org.d-u-v.statistik%' OR el_index LIKE 'https://it.fidal.www./atleta_one.php%' OR el_index LIKE 'https://fr.athle.bases./asp.net/athletes.aspx%' OR el_index LIKE 'https://de.leichtathletik.www./nationalmannschaft/%' OR el_index LIKE 'https://com.possumbility.athletics./athletes/%' OR el_index LIKE 'https://org.usatf.legacy%' OR el_index LIKE 'https://nl.atletiek.www./atleet/%' OR el_index LIKE 'https://jp.or.jaaf.www./athletes/%' OR el_index LIKE 'https://info.thepowerof10.www./athletes/%' OR el_index LIKE 'https://com.diamondleague.www./athletes/%' OR el_index LIKE 'https://org.tfrrs.www./athletes/%' OR el_index LIKE 'https://com.sports-reference%' OR el_index LIKE 'https://com.pro-football-reference.www./players/%' OR el_index LIKE 'https://com.justsportsstats%' OR el_index LIKE 'https://org.archive.www./web/%/https://static.fifa.com/fifa-tournaments/%' OR el_index LIKE 'https://com.uefa.www./uefachampionsleague/clubs/players/%' OR el_index LIKE 'https://be.belgianfootball.static./project/%' OR el_index LIKE 'https://hr.hns-cff%' OR el_index LIKE 'https://cz.fotbal.nv./reprezentace/%' OR el_index LIKE 'https://ee.jalgpall./voistlused/player/%' OR el_index LIKE 'https://il.org.football.www./en/players/%' OR el_index LIKE 'https://no.fotball.www./fotballdata/person/%' OR el_index LIKE 'https://uk,co.scottishfa.www./players/%' OR el_index LIKE 'https://org.tff%' OR el_index LIKE 'https://ua.uaf.db./player/%' OR el_index LIKE 'https://jp.or.j-league.data%' OR el_index LIKE 'https://com.kleague.www./record/%' OR el_index LIKE 'https://fr.lfp.www./joueur/%' OR el_index LIKE 'https://com.mlssoccer.www./players/%' OR el_index LIKE 'https://mx.ligafemenil./cancha/jugador/%' OR el_index LIKE 'https://com.espn.global/football/player/%' OR el_index LIKE 'https://eu.footballdatabase.www./fr/joueur/%' OR el_index LIKE 'https://de.fussballdaten.www./spieler/%' OR el_index LIKE 'https://fr.lequipe.www./Football/%' OR el_index LIKE 'https://com.national-football-teams.www./player/%' OR el_index LIKE 'https://com.soccerbase%' OR el_index LIKE 'https://pt.zerozero.www./player.php%' OR el_index LIKE 'https://net.worldfootball.www./player_summary/%' ) GROUP BY el_from) SELECT Olympedia.page_title, actor_name, rev_timestamp FROM Olympedia LEFT JOIN (SELECT Olympedia.el_from, Olympedia.page_title FROM externallinks JOIN Olympedia ON Olympedia.el_from = externallinks.el_from WHERE el_index NOT LIKE 'https://org.olympedia%' AND el_index NOT LIKE 'http://org.olympedia%' AND el_index NOT LIKE 'https://com.olympics%' AND el_index NOT LIKE 'http://com.olympics%' AND el_index NOT LIKE 'https://org.archive.web./%/https://www.sports-reference.com%' AND el_index NOT LIKE 'http://org.archive.web./%/https://www.sports-reference.com%' AND el_index NOT LIKE 'https://org.archive.web./%/http://www.sports-reference.com%' AND el_index NOT LIKE 'http://org.archive.web./%/http://www.sports-reference.com%' AND el_index NOT LIKE 'http://com.soccerway%' AND el_index NOT LIKE 'https://com.soccerway%' AND el_index NOT LIKE 'http://net.worldfootball%' AND el_index NOT LIKE 'https://net.worldfootball%' AND el_index NOT LIKE 'http://org.fina.www./athletes/%' AND el_index NOT LIKE 'http://de.uni-leipzig.iat.www./datenbanken/%' AND el_index NOT LIKE 'http://au.org.swimming.www./athletes/%' AND el_index NOT LIKE 'http://net.swimrankings%' AND el_index NOT LIKE 'http://hu.waterpolo./jatekos/%' AND el_index NOT LIKE 'http://org.ishof.www./honoree/%' AND el_index NOT LIKE 'http://org.usawaterpolo%' AND el_index NOT LIKE 'http://org.worldarchery%' AND el_index NOT LIKE 'http://org.worldathletics.www./athletes/%' AND el_index NOT LIKE 'http://org.mementoweb.timetravel./memento/%/http://www.european-athletics.org/athletes/%' AND el_index NOT LIKE 'http://org.d-u-v.statistik%' AND el_index NOT LIKE 'http://it.fidal.www./atleta_one.php%' AND el_index NOT LIKE 'http://fr.athle.bases./asp.net/athletes.aspx%' AND el_index NOT LIKE 'http://de.leichtathletik.www./nationalmannschaft/%' AND el_index NOT LIKE 'http://com.possumbility.athletics./athletes/%' AND el_index NOT LIKE 'http://org.usatf.legacy%' AND el_index NOT LIKE 'http://nl.atletiek.www./atleet/%' AND el_index NOT LIKE 'http://jp.or.jaaf.www./athletes/%' AND el_index NOT LIKE 'http://info.thepowerof10.www./athletes/%' AND el_index NOT LIKE 'http://com.diamondleague.www./athletes/%' AND el_index NOT LIKE 'http://org.tfrrs.www./athletes/%' AND el_index NOT LIKE 'http://com.sports-reference%' AND el_index NOT LIKE 'http://com.pro-football-reference.www./players/%' AND el_index NOT LIKE 'http://com.justsportsstats%' AND el_index NOT LIKE 'http://org.archive.www./web/%/http://static.fifa.com/fifa-tournaments/%' AND el_index NOT LIKE 'http://com.uefa.www./uefachampionsleague/clubs/players/%' AND el_index NOT LIKE 'http://be.belgianfootball.static./project/%' AND el_index NOT LIKE 'http://hr.hns-cff%' AND el_index NOT LIKE 'http://cz.fotbal.nv./reprezentace/%' AND el_index NOT LIKE 'http://ee.jalgpall./voistlused/player/%' AND el_index NOT LIKE 'http://il.org.football.www./en/players/%' AND el_index NOT LIKE 'http://no.fotball.www./fotballdata/person/%' AND el_index NOT LIKE 'http://uk,co.scottishfa.www./players/%' AND el_index NOT LIKE 'http://org.tff%' AND el_index NOT LIKE 'http://ua.uaf.db./player/%' AND el_index NOT LIKE 'http://jp.or.j-league.data%' AND el_index NOT LIKE 'http://com.kleague.www./record/%' AND el_index NOT LIKE 'http://fr.lfp.www./joueur/%' AND el_index NOT LIKE 'http://com.mlssoccer.www./players/%' AND el_index NOT LIKE 'http://mx.ligafemenil./cancha/jugador/%' AND el_index NOT LIKE 'http://com.espn.global/football/player/%' AND el_index NOT LIKE 'http://eu.footballdatabase.www./fr/joueur/%' AND el_index NOT LIKE 'http://de.fussballdaten.www./spieler/%' AND el_index NOT LIKE 'http://fr.lequipe.www./Football/%' AND el_index NOT LIKE 'http://com.national-football-teams.www./player/%' AND el_index NOT LIKE 'http://com.soccerbase%' AND el_index NOT LIKE 'http://pt.zerozero.www./player.php%' AND el_index NOT LIKE 'http://net.worldfootball.www./player_summary/%' AND el_index NOT LIKE 'https://org.fina.www./athletes/%' AND el_index NOT LIKE 'https://de.uni-leipzig.iat.www./datenbanken/%' AND el_index NOT LIKE 'https://au.org.swimming.www./athletes/%' AND el_index NOT LIKE 'https://net.swimrankings%' AND el_index NOT LIKE 'https://hu.waterpolo./jatekos/%' AND el_index NOT LIKE 'https://org.ishof.www./honoree/%' AND el_index NOT LIKE 'https://org.usawaterpolo%' AND el_index NOT LIKE 'https://org.worldarchery%' AND el_index NOT LIKE 'https://org.worldathletics.www./athletes/%' AND el_index NOT LIKE 'https://org.mementoweb.timetravel./memento/%/https://www.european-athletics.org/athletes/%' AND el_index NOT LIKE 'https://org.d-u-v.statistik%' AND el_index NOT LIKE 'https://it.fidal.www./atleta_one.php%' AND el_index NOT LIKE 'https://fr.athle.bases./asp.net/athletes.aspx%' AND el_index NOT LIKE 'https://de.leichtathletik.www./nationalmannschaft/%' AND el_index NOT LIKE 'https://com.possumbility.athletics./athletes/%' AND el_index NOT LIKE 'https://org.usatf.legacy%' AND el_index NOT LIKE 'https://nl.atletiek.www./atleet/%' AND el_index NOT LIKE 'https://jp.or.jaaf.www./athletes/%' AND el_index NOT LIKE 'https://info.thepowerof10.www./athletes/%' AND el_index NOT LIKE 'https://com.diamondleague.www./athletes/%' AND el_index NOT LIKE 'https://org.tfrrs.www./athletes/%' AND el_index NOT LIKE 'https://com.sports-reference%' AND el_index NOT LIKE 'https://com.pro-football-reference.www./players/%' AND el_index NOT LIKE 'https://com.justsportsstats%' AND el_index NOT LIKE 'https://org.archive.www./web/%/https://static.fifa.com/fifa-tournaments/%' AND el_index NOT LIKE 'https://com.uefa.www./uefachampionsleague/clubs/players/%' AND el_index NOT LIKE 'https://be.belgianfootball.static./project/%' AND el_index NOT LIKE 'https://hr.hns-cff%' AND el_index NOT LIKE 'https://cz.fotbal.nv./reprezentace/%' AND el_index NOT LIKE 'https://ee.jalgpall./voistlused/player/%' AND el_index NOT LIKE 'https://il.org.football.www./en/players/%' AND el_index NOT LIKE 'https://no.fotball.www./fotballdata/person/%' AND el_index NOT LIKE 'https://uk,co.scottishfa.www./players/%' AND el_index NOT LIKE 'https://org.tff%' AND el_index NOT LIKE 'https://ua.uaf.db./player/%' AND el_index NOT LIKE 'https://jp.or.j-league.data%' AND el_index NOT LIKE 'https://com.kleague.www./record/%' AND el_index NOT LIKE 'https://fr.lfp.www./joueur/%' AND el_index NOT LIKE 'https://com.mlssoccer.www./players/%' AND el_index NOT LIKE 'https://mx.ligafemenil./cancha/jugador/%' AND el_index NOT LIKE 'https://com.espn.global/football/player/%' AND el_index NOT LIKE 'https://eu.footballdatabase.www./fr/joueur/%' AND el_index NOT LIKE 'https://de.fussballdaten.www./spieler/%' AND el_index NOT LIKE 'https://fr.lequipe.www./Football/%' AND el_index NOT LIKE 'https://com.national-football-teams.www./player/%' AND el_index NOT LIKE 'https://com.soccerbase%' AND el_index NOT LIKE 'https://pt.zerozero.www./player.php%' AND el_index NOT LIKE 'https://net.worldfootball.www./player_summary/%' GROUP BY Olympedia.el_from) AS NotOlympedia ON Olympedia.el_from = NotOlympedia.el_from LEFT JOIN revision ON rev_page = Olympedia.el_from AND rev_parent_id = 0 LEFT JOIN actor_revision ON actor_id = rev_actor WHERE NotOlympedia.el_from IS NULL
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...