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
Szoltys
.
Toggle Highlighting
SQL
USE plwiki_p; SELECT CONCAT(page_title) as page_title FROM page JOIN externallinks ON page_id = el_from WHERE page_namespace = 0 AND (((el_to LIKE 'http://www.hoo.hr/en/o_igra.aspx?id=14%') OR (el_to LIKE 'http://www.hoo.hr/en/o_igra.aspx?id=16%') OR (el_to LIKE 'http://www.hoo.hr/en/1914-v-xxi-zoi-vancouver-2010vancouver-kanada-12--28-2-2010.aspx%') OR (el_to LIKE 'http://www.hoo.hr/en/o_igra.aspx?id=83%') OR (el_to LIKE 'http://biathlon.pl/index.php?url=news&id=1779%') OR (el_to LIKE 'http://biathlon.pl/index.php?url=news&id=1794%') OR (el_to LIKE 'http://www.jamnica.hr/sponzorstva-i-donacije/jamnica-dd-–-zlatni-sponzor-hrvatskog-olimpijskog-odbora/38-9-35/?lang=%') OR (el_to LIKE 'http://pzls.pl/aktualnosci/aktualnosci-glowna/byly-to-historyczne-igrzyska.html%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/16034%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/16033%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/16031%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/16030%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/16029%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/16027%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/16026%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/16025%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/16021%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/16028%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/16019%') OR (el_to LIKE 'http://www.pkol.pl/pl/pages/display/16037%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/15916%') OR (el_to LIKE 'http://ww.mvguam.com/opinion/25030-all-eyes-on-guam.html%') OR (el_to LIKE 'http://mitchalbom.com/d/journalism/128/shot-dark-guam-biathlete-its-lone-olympian%') OR (el_to LIKE 'http://wiadomosci.onet.pl/wiadomosci/turyn-podium-dla-niemek-udany-finisz-polki,1,3423059,wiadomosc.html%') OR (el_to LIKE 'http://www.sport.pl/sport/2029020,65026,3178054.html%') OR (el_to LIKE 'http://www.przegladsportowy.pl/Igrzyska-olimpijskie/Skreslali-bez-klucza,artykul,3533,1,464.html%') OR (el_to LIKE 'http://www.przegladsportowy.pl/Igrzyska-olimpijskie/Orzel-z-pazurkami,artykul,3703,1,464.html%') OR (el_to LIKE 'http://www.przegladsportowy.pl/Igrzyska-olimpijskie/0-01-do-szczescia,artykul,3753,1,464.html%') OR (el_to LIKE 'http://pzls.pl/aktualnosci/aktualnosci-glowna/konkurs-rozstrzygniety.html%') OR (el_to LIKE 'http://pzls.pl/aktualnosci/aktualnosci-glowna/oficjalne-pozegnanie-naszej-ekipy.html%') OR (el_to LIKE 'http://pzls.pl/aktualnosci/aktualnosci-glowna/ostatni-medal-byl-koloru-zlotego.html%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/15899%') OR (el_to LIKE 'http://www.olimpijski.pl/pl/pages/display/15973%') OR (el_to LIKE 'http://www.dzienniklodzki.pl/sport/vancouver/227046,koniec-igrzysk-teraz-trzeba-zaplacic-rachunki,id,t.html?cookie=1#material_1%') OR (el_to LIKE 'http://www.radiozet.pl/Wiadomosci/Sport/Tylko-113-dni-do-igrzysk-w-Vancouver%') OR (el_to LIKE 'http://www.radiozet.pl/Wiadomosci/Sport/XXI-Zimowe-Igrzyska-Olimpijskie-otwarte%') OR (el_to LIKE 'http://fibt.com/fileadmin/Newsletter_PDFs/Olympic%20Quotas_Final%') OR (el_to LIKE 'http://www2.polskieradio.pl/sport/vancouver/wiadomosci/artykul142943.html%') OR (el_to LIKE 'http://www2.polskieradio.pl/sport/vancouver/wiadomosci/artykul142819.html%') OR (el_to LIKE 'http://www.paralympic.org.au/games-amp-events/paralympic-games-history-winter/paralympic-games-history-winter%') OR (el_to LIKE 'http://corporate.olympics.com.au/files/96/ISU_speedskating_sum_January08.pdf%') OR (el_to LIKE 'http://corporate.olympics.com.au/files/93/FIL_Qualification_System_Vancouver_2010__JANUARY08_eng.pdf%') OR (el_to LIKE 'http://www.biathlonworld.com/en/press_releases.html/do/detail?presse=861%') OR (el_to LIKE 'http://www.biathlonworld.com/en/press_releases.html/do/detail?presse=860%') OR (el_to LIKE 'http://olympichostcity.vancouver.ca/cityhighlights/aboutvancouver/2010hostcity/olympic-torch-relay.htm%') OR (el_to LIKE 'http://www.theaustralian.com.au/news/sport/anastasiya-kuzmina-wins-slovakia-first-winter-crown/story-e6frg7mf-1225830166112%') OR (el_to LIKE 'http://www.biathlonworld.com/en/press_releases.html/do/detail?presse=848%') OR (el_to LIKE 'http://www.biathlonworld.com/en/press_releases.html/do/detail?presse=857%') OR (el_to LIKE 'http://www.biathlonworld.com/en/press_releases.html/do/detail?presse=856%') OR (el_to LIKE 'http://www.biathlonworld.com/en/press_releases.html/do/detail?presse=853%') OR (el_to LIKE 'http://www.biathlonworld.com/en/press_releases.html/do/detail?presse=844%') OR (el_to LIKE 'http://www.biathlonworld.com/en/press_releases.html/do/detail?presse=850%') OR (el_to LIKE 'http://www.biathlonworld.com/en/press_releases.html/do/detail?presse=865%') OR (el_to LIKE 'http://www.biathlonworld.com/en/press_releases.html/do/detail?presse=868%') OR (el_to LIKE 'http://www.miningjournal.net/page/content.detail/id/1264963/The-Latest--Croatian-brothers-strike-gold.html?isap=1&nav=5019%') OR (el_to LIKE 'http://biathlon.pl/index.php?url=news&id=%') OR (el_to LIKE 'http://www.v8supercars.com.au/championship/2014-v8-supercars-championship/2014-formula-1-rolex-australian-grand-prix/sessions/v8-supercars-championship/race-3%') OR (el_to LIKE 'http://www.v8supercars.com.au/championship/2014-v8-supercars-championship/2014-formula-1-rolex-australian-grand-prix/sessions/v8-supercars-championship/race-1%') OR (el_to LIKE 'http://www.v8supercars.com.au/championship/2014-v8-supercars-championship/2014-formula-1-rolex-australian-grand-prix/sessions/v8-supercars-championship/race-2%') OR (el_to LIKE 'http://www.v8supercars.com.au/championship/2014-v8-supercars-championship/2014-formula-1-rolex-australian-grand-prix/sessions/v8-supercars-championship/race-4%'))) GROUP BY page_title ORDER BY page_title; SELECT CONCAT('# ',el_to) as el_to#, COUNT(*) AS counting FROM page JOIN externallinks ON page_id = el_from WHERE page_namespace = 0 AND (((el_to LIKE 'http://www.hoo.hr/en/o_igra.aspx?id=14%') OR (el_to LIKE 'http://www.hoo.hr/en/o_igra.aspx?id=16%') OR (el_to LIKE 'http://www.hoo.hr/en/1914-v-xxi-zoi-vancouver-2010vancouver-kanada-12--28-2-2010.aspx%') OR (el_to LIKE 'http://www.hoo.hr/en/o_igra.aspx?id=83%') OR (el_to LIKE 'http://biathlon.pl/index.php?url=news&id=1779%') OR (el_to LIKE 'http://biathlon.pl/index.php?url=news&id=1794%') OR (el_to LIKE 'http://www.jamnica.hr/sponzorstva-i-donacije/jamnica-dd-–-zlatni-sponzor-hrvatskog-olimpijskog-odbora/38-9-35/?lang=%') OR (el_to LIKE 'http://pzls.pl/aktualnosci/aktualnosci-glowna/byly-to-historyczne-igrzyska.html%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/16034%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/16033%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/16031%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/16030%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/16029%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/16027%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/16026%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/16025%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/16021%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/16028%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/16019%') OR (el_to LIKE 'http://www.pkol.pl/pl/pages/display/16037%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/15916%') OR (el_to LIKE 'http://ww.mvguam.com/opinion/25030-all-eyes-on-guam.html%') OR (el_to LIKE 'http://mitchalbom.com/d/journalism/128/shot-dark-guam-biathlete-its-lone-olympian%') OR (el_to LIKE 'http://wiadomosci.onet.pl/wiadomosci/turyn-podium-dla-niemek-udany-finisz-polki,1,3423059,wiadomosc.html%') OR (el_to LIKE 'http://www.sport.pl/sport/2029020,65026,3178054.html%') OR (el_to LIKE 'http://www.przegladsportowy.pl/Igrzyska-olimpijskie/Skreslali-bez-klucza,artykul,3533,1,464.html%') OR (el_to LIKE 'http://www.przegladsportowy.pl/Igrzyska-olimpijskie/Orzel-z-pazurkami,artykul,3703,1,464.html%') OR (el_to LIKE 'http://www.przegladsportowy.pl/Igrzyska-olimpijskie/0-01-do-szczescia,artykul,3753,1,464.html%') OR (el_to LIKE 'http://pzls.pl/aktualnosci/aktualnosci-glowna/konkurs-rozstrzygniety.html%') OR (el_to LIKE 'http://pzls.pl/aktualnosci/aktualnosci-glowna/oficjalne-pozegnanie-naszej-ekipy.html%') OR (el_to LIKE 'http://pzls.pl/aktualnosci/aktualnosci-glowna/ostatni-medal-byl-koloru-zlotego.html%') OR (el_to LIKE 'http://olimpijski.pl/pl/pages/display/15899%') OR (el_to LIKE 'http://www.olimpijski.pl/pl/pages/display/15973%') OR (el_to LIKE 'http://www.dzienniklodzki.pl/sport/vancouver/227046,koniec-igrzysk-teraz-trzeba-zaplacic-rachunki,id,t.html?cookie=1#material_1%') OR (el_to LIKE 'http://www.radiozet.pl/Wiadomosci/Sport/Tylko-113-dni-do-igrzysk-w-Vancouver%') OR (el_to LIKE 'http://www.radiozet.pl/Wiadomosci/Sport/XXI-Zimowe-Igrzyska-Olimpijskie-otwarte%') OR (el_to LIKE 'http://fibt.com/fileadmin/Newsletter_PDFs/Olympic%20Quotas_Final%') OR (el_to LIKE 'http://www2.polskieradio.pl/sport/vancouver/wiadomosci/artykul142943.html%') OR (el_to LIKE 'http://www2.polskieradio.pl/sport/vancouver/wiadomosci/artykul142819.html%') OR (el_to LIKE 'http://www.paralympic.org.au/games-amp-events/paralympic-games-history-winter/paralympic-games-history-winter%') OR (el_to LIKE 'http://corporate.olympics.com.au/files/96/ISU_speedskating_sum_January08.pdf%') OR (el_to LIKE 'http://corporate.olympics.com.au/files/93/FIL_Qualification_System_Vancouver_2010__JANUARY08_eng.pdf%') OR (el_to LIKE 'http://www.biathlonworld.com/en/press_releases.html/do/detail?presse=861%') OR (el_to LIKE 'http://www.biathlonworld.com/en/press_releases.html/do/detail?presse=860%') OR (el_to LIKE 'http://olympichostcity.vancouver.ca/cityhighlights/aboutvancouver/2010hostcity/olympic-torch-relay.htm%') OR (el_to LIKE 'http://www.theaustralian.com.au/news/sport/anastasiya-kuzmina-wins-slovakia-first-winter-crown/story-e6frg7mf-1225830166112%') OR (el_to LIKE 'http://www.biathlonworld.com/en/press_releases.html/do/detail?presse=848%') OR (el_to LIKE 'http://www.biathlonworld.com/en/press_releases.html/do/detail?presse=857%') OR (el_to LIKE 'http://www.biathlonworld.com/en/press_releases.html/do/detail?presse=856%') OR (el_to LIKE 'http://www.biathlonworld.com/en/press_releases.html/do/detail?presse=853%') OR (el_to LIKE 'http://www.biathlonworld.com/en/press_releases.html/do/detail?presse=844%') OR (el_to LIKE 'http://www.biathlonworld.com/en/press_releases.html/do/detail?presse=850%') OR (el_to LIKE 'http://www.biathlonworld.com/en/press_releases.html/do/detail?presse=865%') OR (el_to LIKE 'http://www.biathlonworld.com/en/press_releases.html/do/detail?presse=868%') OR (el_to LIKE 'http://www.miningjournal.net/page/content.detail/id/1264963/The-Latest--Croatian-brothers-strike-gold.html?isap=1&nav=5019%') OR (el_to LIKE 'http://biathlon.pl/index.php?url=news&id=%') OR (el_to LIKE 'http://www.v8supercars.com.au/championship/2014-v8-supercars-championship/2014-formula-1-rolex-australian-grand-prix/sessions/v8-supercars-championship/race-3%') OR (el_to LIKE 'http://www.v8supercars.com.au/championship/2014-v8-supercars-championship/2014-formula-1-rolex-australian-grand-prix/sessions/v8-supercars-championship/race-1%') OR (el_to LIKE 'http://www.v8supercars.com.au/championship/2014-v8-supercars-championship/2014-formula-1-rolex-australian-grand-prix/sessions/v8-supercars-championship/race-2%') OR (el_to LIKE 'http://www.v8supercars.com.au/championship/2014-v8-supercars-championship/2014-formula-1-rolex-australian-grand-prix/sessions/v8-supercars-championship/race-4%'))) GROUP BY el_to ORDER BY /*counting DESC,*/ el_to;
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...