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 distinct(enel.el_index) FROM externallinks enel where el_to like "http://www.worldcurl.com/%" limit 150; /* P2350 http://eu.speedskatingbase.www./ SpeedSkatingBase.eu ID http://www.speedskatingbase.eu/?section=skaters&subsection=skater&skaterid=$1 \d+ vēl var būt section=main P2459 IBU biathlete ID http://services.biathlonresults.com/athletes.aspx?IbuId=$1 BT([A-Z]{3}\d{9}0[12]|-[A-Z]{3}-[MW]-[A-Z]{6}) P2481 Elite Prospects player ID http://www.eliteprospects.com/player.php?player=$1 [1-9][0-9]{0,5} P2601 http://com.eurohockey.www./player/ Eurohockey.com player ID http://www.eurohockey.com/player/$1.html [1-9][0-9]*-[a-z-]+ P2602 http://.com.hockeydb.www./ HockeyDB.com player ID http://www.hockeydb.com/ihdb/stats/pdisplay.php?pid=$1 [1-9][0-9]* P2694 ISU figure skater ID http://www.isuresults.com/bios/isufs$1.htm \d{8} P2990 http://org.fil-luge.www./ FIL ID http://www.fil-luge.org/en/athletes/$1 [a-z-]+(-[0-9])? P2991 http://org.ibsf.www./en/ IBSF ID http://www.ibsf.org/en/athletes/athlete/$1 [1-9]\d* P3556 World Curling Tour ID http://www.worldcurl.com/player.php?playerid=$1 \d+ P3557 World Curling Federation ID http://results.worldcurling.org/Person/Details/$1 \d+ P3598 Hockey-reference player ID http://www.hockey-reference.com/players/$1.html P3619 ski-db.com skier ID http://www.ski-db.com/db/profiles/$1.php [a-z][a-z\-]{0,20}(_[a-z\-]*){1,4}_[a-z]{3}_(\d{5,7}|[a-z\-]+) P3693 short-track speed skater ISU ID http://www.shorttrackonline.info/skaterbio.php?id=$1 ST[A-Z]{3}\d+ P3694 SpeedSkatingNews.info speed skater ID http://www.speedskatingnews.info/en/data/skater/$1/ [a-z-]+\d? P3695 SpeedSkatingStats speed skater ID http://www.schaatsstatistieken.nl/index.php?file=schaatser&code=$1 \d+ P4314 SpeedskatingResults.com speed skater ID http://speedskatingresults.com./index.php?p=17&s=$1 [1-9]\d+ P4319 Elite Prospects staff ID http://www.eliteprospects.com/staff.php?staff=$1 [1-9]\d* */
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...