Articles sourced solely to statistical sources

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.

SQL

SET STATEMENT max_statement_time = 3600 FOR
WITH Olympedia AS (SELECT el_from, Article.page_title
  FROM externallinks
  JOIN page AS Article ON Article.page_id = el_from AND Article.page_namespace = 0 
  JOIN page AS Talk ON Article.page_title = Talk.page_title AND Talk.page_namespace = 1
  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 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.

SQL

Checking query status...