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
.
Toggle Highlighting
SQL
WITH ids AS (SELECT cl_from FROM categorylinks WHERE cl_to IN ('WikiProject_Sports_articles')#, 'WikiProject_Women\'s_sport_articles', 'WikiProject_Athletics_articles', 'WikiProject_Backpacking_articles', 'WikiProject_Bodybuilding_articles', 'WikiProject_Bowling_articles', 'WikiProject_Boxing_articles', 'WikiProject_Caving_articles', 'WikiProject_Climbing_articles', 'WikiProject_Cricket_articles', 'WikiProject_Cycling_articles', 'WikiProject_Extreme_sports_articles', 'WikiProject_Fencing_articles', 'WikiProject_Floorball_articles', 'WikiProject_Geocaching_articles', 'WikiProject_Golf_articles', 'WikiProject_Gymnastics_articles', 'WikiProject_Handball_articles', 'WikiProject_Hiking_Trails_articles', 'WikiProject_Lacrosse_articles', 'WikiProject_Motorcycling_articles', 'WikiProject_Multi-sport_events_articles', 'WikiProject_Netball_articles', 'WikiProject_Olympics_articles', 'WikiProject_Paintball_articles', 'WikiProject_Running_articles', 'WikiProject_Skateboarding_articles', 'WikiProject_Softball_articles', 'WikiProject_Sports_listing_articles', 'WikiProject_Sports_Results_articles', 'WikiProject_Sports_team_listing_articles', 'WikiProject_Triathlon_articles', 'WikiProject_Volleyball_articles', 'WikiProject_American_football_articles', 'WikiProject_American_football_articles', 'WikiProject_American_Football_League_articles', 'WikiProject_Arena_Football_League_articles', 'WikiProject_Chicago_Bears_articles', 'WikiProject_College_football_articles', 'WikiProject_European_League_of_Football_articles', 'WikiProject_Green_Bay_Packers_articles', 'WikiProject_Indianapolis_Colts_articles', 'WikiProject_National_Football_League_articles', 'WikiProject_Los_Angeles_Rams_articles', 'WikiProject_Australian_sports_articles', 'WikiProject_Australian_sports_articles', 'WikiProject_Australian_rules_football_articles', 'WikiProject_Australian_Baseball_articles', 'WikiProject_Australian_basketball_articles', 'WikiProject_Football_(soccer)_in_Australia_articles', 'WikiProject_Gridiron_in_Australia_articles', 'WikiProject_Australian_motorsport_articles', 'WikiProject_Baseball_articles', 'WikiProject_Baseball_articles', 'WikiProject_College_baseball_articles', 'WikiProject_Boston_Red_Sox_articles', 'WikiProject_Chicago_Cubs_articles', 'WikiProject_Cincinnati_Reds_articles', 'WikiProject_Los_Angeles_Angels_of_Anaheim_articles', 'WikiProject_Los_Angeles_Dodgers_articles', 'WikiProject_Minnesota_Twins_articles', 'WikiProject_New_York_Yankees_articles', 'WikiProject_Seattle_Mariners_articles', 'WikiProject_St._Louis_Cardinals_articles', 'WikiProject_Philadelphia_Phillies_articles', 'WikiProject_Toronto_Blue_Jays_articles', 'WikiProject_Basketball_articles', 'WikiProject_Basketball_articles', 'WikiProject_College_Basketball_articles', 'WikiProject_National_Basketball_Association_articles', 'WikiProject_NBL_articles', 'WikiProject_National_Basketball_League_of_Canada_articles', 'WikiProject_Bull_Riding_articles', 'WikiProject_Bull_Riding_articles', 'WikiProject_Canadian_football_articles', 'WikiProject_Canadian_football_articles', 'WikiProject_College_sports_articles', 'WikiProject_Atlantic_Coast_Conference_articles', 'WikiProject_Big_12_Conference_articles', 'WikiProject_Big_Ten_articles', 'WikiProject_College_Baseball_articles', 'WikiProject_Cue_sports_articles', 'WikiProject_Cue_sports_articles', 'WikiProject_Snooker_articles', 'WikiProject_Ditto_the_above,_re:_assessments._articles', 'WikiProject_Carrom_articles', 'WikiProject_Association_football_articles', 'WikiProject_Football_articles', 'WikiProject_Football_World_Cup_finals_articles', 'WikiProject_The_Football_League:_Season-By-Season_articles', 'WikiProject_UEFA_Champions_League_finals_articles', 'WikiProject_Horse_racing_articles', 'WikiProject_Horse_racing_articles', 'WikiProject_Indian_sports_articles', 'WikiProject_Indian_sports_articles', 'WikiProject_Football_in_India_articles', 'WikiProject_Indian_Premier_League_articles', 'WikiProject_Martial_arts_articles', 'WikiProject_Martial_arts_articles', 'WikiProject_Mixed_martial_arts_articles', 'WikiProject_Sumo_articles', 'WikiProject_Motorsport_articles', 'WikiProject_Motorsport_articles', 'WikiProject_American_Open_Wheel_Racing_articles', 'WikiProject_British_Motorsport_articles', 'WikiProject_Formula_One_articles', 'WikiProject_Motorcycle_racing_articles', 'WikiProject_IROC_articles', 'WikiProject_NASCAR_articles', 'WikiProject_Sports_Car_Racing_articles', 'WikiProject_World_Rally_articles', 'WikiProject_Racquet_Sports_articles', 'WikiProject_Badminton_articles', 'WikiProject_Racquetball_articles', 'WikiProject_Squash_articles', 'WikiProject_Table_tennis_articles', 'WikiProject_Tennis_articles', 'WikiProject_Rugby_league_articles', 'WikiProject_Rugby_union_articles', 'WikiProject_Target_sports_articles', 'WikiProject_Darts_articles', 'WikiProject_Water_sports_articles', 'WikiProject_Water_sports_articles', 'WikiProject_Fisheries_and_Fishing_articles', 'WikiProject_Canoeing_and_Kayaking_articles', 'WikiProject_Rowing_articles', 'WikiProject_Sailing_articles', 'WikiProject_Underwater_diving_articles', 'WikiProject_Swimming_articles', 'WikiProject_Winter_sports_articles', 'WikiProject_Winter_sports_articles', 'WikiProject_Biathlon_articles', 'WikiProject_Curling_articles', 'WikiProject_Figure_Skating_articles', 'WikiProject_Ice_Hockey_articles', 'WikiProject_Skiing_and_Snowboarding_articles', 'WikiProject_Speed_skating') ), title AS (SELECT page_title FROM ids JOIN page ON page_id = cl_from), article AS (SELECT page_id FROM page WHERE page_namespace = 0 AND page_title IN (SELECT * FROM title)) SELECT actor_name, creations FROM (SELECT rev_actor, COUNT(*) as creations FROM revision JOIN article on page_id = rev_page WHERE rev_parent_id = 0 GROUP BY rev_actor) as creation_count JOIN actor ON rev_actor = actor_id #WHERE creations > 5
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...