Untitled query #19783

This query is marked as a draft This query has been published by Fabian.braesemann.
SQL

USE enwiki_p;
SELECT rev_user_text AS IP, rev_timestamp AS Datetime, page_title
FROM page JOIN categorylinks ON cl_from = page_id
JOIN revision ON page_id = rev_page 
WHERE 
(cl_to =  "American_football_by_city" OR cl_to =  "American_football_by_continent" )#OR cl_to =  "American_football_by_country" OR cl_to =  "American_football-related_lists" OR cl_to =  "American_football_competitions" OR cl_to =  "American_football_culture" OR cl_to =  "American_football_equipment" OR cl_to =  "History_of_American_football" OR cl_to =  "American_football_incidents" OR cl_to =  "American_football_media" OR cl_to =  "American_football_occupations" OR cl_to =  "American_football_organisations" OR cl_to =  "American_football_people" OR cl_to =  "American_football_plays" OR cl_to =  "American_football_positions" OR cl_to =  "American_football_records_and_statistics" OR cl_to =  "Seasons_in_American_football" OR cl_to =  "Semi-professional_American_football" OR cl_to =  "American_football_strategy" OR cl_to =  "American_football_teams" OR cl_to =  "American_football_terminology" OR cl_to =  "American_football_trophies_and_awards" OR cl_to =  "Variations_of_American_football" OR cl_to =  "American_football_venues" OR cl_to =  "Women%27s_American_football" OR cl_to =  "American_football_logos" OR cl_to =  "American_football_stubs" OR cl_to =  "American_football_teams_by_city" OR cl_to =  "American_football_in_the_United_States_by_city" OR cl_to =  "American_football_in_London" OR cl_to =  "American_football_in_Toronto" OR cl_to =  "American_football_in_Africa" OR cl_to =  "American_football_in_Asia" OR cl_to =  "American_football_in_Europe" OR cl_to =  "American_football_in_North_America" OR cl_to =  "American_football_in_Oceania" OR cl_to =  "American_football_in_South_America" OR cl_to =  "Players_of_American_football_by_nationality" OR cl_to =  "American_football_in_American_Samoa" OR cl_to =  "American_football_in_Australia" OR cl_to =  "American_football_in_Austria" OR cl_to =  "American_football_in_the_Bahamas" OR cl_to =  "American_football_in_Belgium" OR cl_to =  "American_football_in_Brazil" OR cl_to =  "American_football_in_Canada" OR cl_to =  "American_football_in_China" OR cl_to =  "American_football_in_Cuba" OR cl_to =  "American_football_in_Denmark" OR cl_to =  "American_football_in_Egypt" OR cl_to =  "American_football_in_Finland" OR cl_to =  "American_football_in_France" OR cl_to =  "American_football_in_Germany" OR cl_to =  "American_football_in_Iceland" OR cl_to =  "American_football_in_India" OR cl_to =  "American_football_in_Ireland" OR cl_to =  "American_football_in_Israel" OR cl_to =  "American_football_in_Italy" OR cl_to =  "American_football_in_Japan" OR cl_to =  "American_football_in_South_Korea" OR cl_to =  "American_football_in_Mexico" OR cl_to =  "American_football_in_the_Netherlands" OR cl_to =  "American_football_in_New_Zealand" OR cl_to =  "American_football_in_Norway" OR cl_to =  "American_football_in_Pakistan" OR cl_to =  "American_football_in_the_Philippines" OR cl_to =  "American_football_in_Poland" OR cl_to =  "American_football_in_Portugal" OR cl_to =  "American_football_in_Romania" OR cl_to =  "American_football_in_Russia" OR cl_to =  "American_football_in_Serbia" OR cl_to =  "American_football_in_Slovakia" OR cl_to =  "American_football_in_Slovenia" OR cl_to =  "American_football_in_Spain" OR cl_to =  "American_football_in_Sri_Lanka" OR cl_to =  "American_football_in_Sweden" OR cl_to =  "American_football_in_Switzerland" OR cl_to =  "American_football_in_Turkey" OR cl_to =  "American_football_in_the_United_Kingdom" OR cl_to =  "American_football_in_the_United_States" OR cl_to =  "Arena_Football_League_lists" OR cl_to =  "Career_achievements_of_American_football_players" OR cl_to =  "College_football-related_lists" OR cl_to =  "National_Football_League_lists" OR cl_to =  "Lists_of_American_football_players" OR cl_to =  "American_football_games" OR cl_to =  "American_football_leagues" OR cl_to =  "ArenaCup" OR cl_to =  "American_football_bowls" OR cl_to =  "Defunct_American_football_competitions" OR cl_to =  "American_football_competitions_in_Europe" OR cl_to =  "IFAF_competitions" OR cl_to =  "Indoor_American_football_competitions" OR cl_to =  "National_Football_League_competitions" OR cl_to =  "NFL_Global_Junior_Championship" OR cl_to =  "American_football_competitions_in_the_United_States" OR cl_to =  "World_Bowl" OR cl_to =  "American_football_comics" OR cl_to =  "American_football-related_curses" OR cl_to =  "American_football_uniforms" OR cl_to =  "American_football_controversies" OR cl_to =  "History_of_the_Arena_Football_League" OR cl_to =  "History_of_college_football_by_team" OR cl_to =  "American_football_museums_and_halls_of_fame" OR cl_to =  "History_of_the_National_Football_League" OR cl_to =  "American_football_rivalries" OR cl_to =  "Years_in_American_football" OR cl_to =  "American_football_animation" OR cl_to =  "American_football_announcers" OR cl_to =  "American_football_websites" OR cl_to =  "Arena_football_media" OR cl_to =  "American_football_books" OR cl_to =  "College_football_media" OR cl_to =  "American_football_video_games" OR cl_to =  "American_football_films" OR cl_to =  "Football_music" OR cl_to =  "Gridiron_football_on_television" OR cl_to =  "Indoor_American_football_media" OR cl_to =  "National_Football_League_media" OR cl_to =  "United_States_Football_League_media" OR cl_to =  "Works_about_high_school_football_in_the_United_States" OR cl_to =  "American_football_governing_bodies" OR cl_to =  "Arena_Football_Hall_of_Fame_inductees" OR cl_to =  "Coaches_of_American_football" OR cl_to =  "Colquitt_football_family" OR cl_to =  "American_football_executives" OR cl_to =  "National_Football_League_families" OR cl_to =  "Matthews_football_family" OR cl_to =  "National_Football_League_people" OR cl_to =  "American_football_officials" OR cl_to =  "Players_of_American_football" OR cl_to =  "Pro_Football_Hall_of_Fame_inductees" OR cl_to =  "World_Football_League_people" OR cl_to =  "American_football_biography_stubs" OR cl_to =  "Wikipedia_categories_named_after_American_football_people" OR cl_to =  "Super_Bowl_plays" OR cl_to =  "Players_of_American_football_by_position" OR cl_to =  "American_football_team_records_and_statistics" OR cl_to =  "Lists_of_college_football_records" OR cl_to =  "National_Football_League_records_and_achievements" OR cl_to =  "Current_American_football_seasons" OR cl_to =  "All-America_Football_Conference_seasons" OR cl_to =  "American_Football_League_seasons" OR cl_to =  "College_football_seasons" OR cl_to =  "Continental_Football_League_seasons" OR cl_to =  "Fall_Experimental_Football_League_seasons" OR cl_to =  "Indoor_American_football_seasons" OR cl_to =  "National_Football_League_seasons" OR cl_to =  "NFL_Europe_(WLAF)_seasons" OR cl_to =  "Polish_American_Football_League_seasons" OR cl_to =  "Puerto_Rico_American_Football_League_seasons" OR cl_to =  "United_Football_League_(2009%E2%80%9312)_seasons" OR cl_to =  "United_States_Football_League_seasons" OR cl_to =  "World_Football_League_(2008%E2%80%9310)" OR cl_to =  "American_football_formations" OR cl_to =  "Defunct_American_football_teams" OR cl_to =  "American_football_teams_by_country" OR cl_to =  "College_football_teams" OR cl_to =  "Early_professional_American_football_clubs" OR cl_to =  "American_football_teams_in_Europe" OR cl_to =  "Indoor_American_football_teams" OR cl_to =  "National_American_football_teams" OR cl_to =  "Women%27s_American_football_teams" OR cl_to =  "American_football_team_stubs" OR cl_to =  "Wikipedia_categories_named_after_American_football_teams" OR cl_to =  "Arena_Football_League_terminology" OR cl_to =  "American_Football_League_Most_Valuable_Players" OR cl_to =  "Arena_Football_League_trophies_and_awards" OR cl_to =  "College_football_awards" OR cl_to =  "High_school_football_trophies_and_awards_in_the_United_States" OR cl_to =  "National_Football_League_trophies_and_awards" OR cl_to =  "American_football_players_with_retired_numbers" OR cl_to =  "World_Bowl_MVPs" OR cl_to =  "Eight-man_football" OR cl_to =  "Flag_football" OR cl_to =  "Indoor_American_football" OR cl_to =  "Sprint_football" OR cl_to =  "American_football_venues_by_country" OR cl_to =  "Defunct_American_football_venues" OR cl_to =  "IFAF_Women%27s_World_Championship" OR cl_to =  "Women%27s_American_football_leagues" OR cl_to =  "Women%27s_American_football_logos" OR cl_to =  "Female_players_of_American_football" OR cl_to =  "American_Football_League_logos" OR cl_to =  "American_football_logos_in_Germany" OR cl_to =  "College_football_logos" OR cl_to =  "Fall_Experimental_Football_League_logos" OR cl_to =  "Indoor_American_football_logos" OR cl_to =  "National_Football_League_logos" OR cl_to =  "United_Football_League_(2009%E2%80%9312)_logos" OR cl_to =  "United_States_Football_League_logos" OR cl_to =  "World_Football_League_logos" OR cl_to =  "XFL_logos" OR cl_to =  "Arena_Football_League_stubs" OR cl_to =  "College_football_stubs" OR cl_to =  "American_football_season_stubs" OR cl_to =  "American_football_video_game_stubs")
AND page_namespace = "0"
AND rev_user = 0
GROUP BY IP, Datetime
ORDER BY Datetime DESC
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...
