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
Edgars2007
.
Toggle Highlighting
SQL
use enwiki_p; select concat(p.page_id,',') from page p where page_title in ("Anaheim_Ducks_roster", "Arizona_Coyotes_roster", "Boston_Bruins_roster", "Buffalo_Sabres_roster", "Calgary_Flames_roster", "Carolina_Hurricanes_roster", "Chicago_Blackhawks_roster", "Colorado_Avalanche_roster", "Columbus_Blue_Jackets_roster", "Dallas_Stars_roster", "Detroit_Red_Wings_roster", "Edmonton_Oilers_roster", "Florida_Panthers_roster", "Los_Angeles_Kings_roster", "Minnesota_Wild_roster", "Montreal_Canadiens_roster", "Nashville_Predators_roster", "New_Jersey_Devils_roster", "New_York_Islanders_roster", "New_York_Rangers_roster", "Ottawa_Senators_roster", "Philadelphia_Flyers_roster", "Pittsburgh_Penguins_roster", "San_Jose_Sharks_roster", "St._Louis_Blues_roster", "Tampa_Bay_Lightning_roster", "Toronto_Maple_Leafs_roster", "Vancouver_Canucks_roster", "Washington_Capitals_roster", "Winnipeg_Jets_roster") and page_is_redirect=0 and page_namespace=10
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...