Untitled query #24448

SQL

use enwiki_p;
SELECT distinct(enel.el_index)
FROM externallinks enel
where el_to like "http://results.worldcurling.org/%"
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	http://com.worldcurl.www./	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*
*/
SQL

Checking query status...
