USE plwiki_p;

SELECT CONCAT(page_title) as page_title

FROM page

JOIN externallinks

ON page_id = el_from

WHERE page_namespace = 1

AND ((el_to LIKE 'https://en.asiangames2018.id/athletes/country/') OR (el_to LIKE 'http://www.japannationalfootballteam.com/en/players/arai_kozo.html') OR (el_to LIKE 'http://www.przegubowiec.com/bus/katalog/') OR (el_to LIKE 'http://www.cajt.pwp.blueyonder.co.uk/scotopen.html') OR (el_to LIKE 'http://www.cajt.pwp.blueyonder.co.uk/int.html') OR (el_to LIKE 'http://www.demorgen.be/dm/nl/1005/Meer-Sport/article/detail/1726860/2013/10/21/Snookerpionier-Jackie-Rea-92-overleden.dhtml') OR (el_to LIKE 'http://www.cajt.pwp.blueyonder.co.uk/Players/Rea,Jackie.html') OR (el_to LIKE 'http://www.cajt.pwp.blueyonder.co.uk/PotBlack.html') OR (el_to LIKE 'http://www.cajt.pwp.blueyonder.co.uk/Rankings.html') OR (el_to LIKE 'http://www.cajt.pwp.blueyonder.co.uk/Records.html') OR (el_to LIKE 'http://www.iihf.com/competition/605/') OR (el_to LIKE 'http://www.iihf.com/competition/606/') OR (el_to LIKE 'http://www.cajt.pwp.blueyonder.co.uk/league.html') OR (el_to LIKE 'http://www.jvmv.se/bandelsregister/LOK-reg/Alla/JvgStnK.htm') OR (el_to LIKE 'http://www.region.grodno.by/by/oblast/regions/BolshayaBerestovitsa') OR (el_to LIKE 'http://www.strategicstudiesinstitute.army.mil/pdffiles/PUB585.pdf') OR (el_to LIKE 'http://www.lansstyrelsen.se/orebro/sv/samhallsplanering-och-kulturmiljo/byggnadsvard/kulturmiljo/sevarda-kulturmiljoer/orebro/vattentornet-svampen/Pages/index.aspx') OR (el_to LIKE 'http://www.sportinglife.com/snooker/worldchampionships2012/profiles/story_get.dor?STORY_NAME=snooker/12/03/20/manual_172233.html&BID=25068') OR (el_to LIKE 'http://www.sverigetopplistan.se/netdata/ghl002.mbr/artdata?dfom=20170225&sart=8356584') OR (el_to LIKE 'http://www.lansstyrelsen.se/orebro/SiteCollectionDocuments/Sv/samhallsplanering-och-kulturmiljo/skyddad-bebyggelse/Olaus-petri-kyrka/Olaus%20Petri%20kyrka%20Ingegerd%20Granstr%C3%B6m.pdf') OR (el_to LIKE 'http://www.eurovision.tv/page/history/year/participant-profile/?song=20425') OR (el_to LIKE 'http://www.eurovision.tv/page/history/by-year/contest?event=297') OR (el_to LIKE 'http://www.eurovision.tv/page/history/by-year/contest?event=298') OR (el_to LIKE 'http://download.naturkundemuseum-berlin.de/michael.ohl/Scheel/Debevec%20et%20al%202012%20sistergroup%20bees.pdf') OR (el_to LIKE 'https://eurovision.tv/event/harrogate-1982/final#|') OR (el_to LIKE 'http://www.jernhusen.se/Resenar/Enkopings-Centralstation/') OR (el_to LIKE 'http://www.jernhusen.se/Resenar/Flemingsbergs-Station/') OR (el_to LIKE 'http://www.lansstyrelsen.se/orebro/Sv/samhallsplanering-och-kulturmiljo/byggnadsvard/kulturmiljo/sevarda-kulturmiljoer/hallsberg/hallsbergs-jarnvagsstation/Pages/index.aspx') OR (el_to LIKE 'https://www.flightglobal.com/pdfarchive/view/1989/1989%20-%203603.html') OR (el_to LIKE 'http://www.koscielscy.pl/biogramy_jan_polkowski.php') OR (el_to LIKE 'http://www.environment.gov.au/heritage/places/national/cape-inscription') OR (el_to LIKE 'http://statistik.basketball-bundesliga.de/beko-bbl/statistik/spieler/index.php?spieler_id=2049') OR (el_to LIKE 'http://www.gamecocksonline.com/sports/m-baskbl/mtt/eidson_chuck00.html') OR (el_to LIKE 'http://www.sfuathletics.com/staff.aspx?staff=120') OR (el_to LIKE 'https://ucdavisaggies.com/roster.aspx?rp_id=362') OR (el_to LIKE 'http://www.cyclingnews.com/races/5th-amgen-tour-of-california-2-hc/race-history') OR (el_to LIKE 'http://www.regmurcia.com/servlet/s.Sl?sit=c,722&r=ReP-24475-DETALLE_REPORTAJESPADRE') OR (el_to LIKE 'https://ucdavisaggies.com/coaches.aspx?rc=233') OR (el_to LIKE 'http://sports.yahoo.com/nba/players/3681/') OR (el_to LIKE 'http://www.marina.difesa.it/storiacultura/storia/almanacco/Pagine/') OR (el_to LIKE 'http://www.datosbaloncesto.com/jugadorcomp.php?jugacomp=1490LIGA') OR (el_to LIKE 'http://www.sportando.com/en/europe/turkey/173106/joey-dorsey-inks-a-deal-with-galatasaray.html') OR (el_to LIKE 'http://mks.pl/rozne.php?pd=plk/mecze_gwiazd') OR (el_to LIKE 'http://www.aba-liga.com/League/Player.aspx?id=1168') OR (el_to LIKE 'http://www.cyclones.com/ViewArticle.dbml?DB_OEM_ID=10700&ATCLID=1610576') OR (el_to LIKE 'http://www.cyclones.com/ViewArticle.dbml?DB_OEM_ID=10700&ATCLID=344191') OR (el_to LIKE 'http://www.bz.ru/ru/history-hist_ship.html') OR (el_to LIKE 'http://www.fiba.com/pages/eng/fc/gamecent/p/pid/6006891/playerview.html') OR (el_to LIKE 'http://www.auburntigers.com/sports/c-swim/mtt/peirsol_hayley00.html') OR (el_to LIKE 'http://www.swimmingworldmagazine.com/lane9/news/26856.asp?q=FINA-Announces-Two-Year-Antidoping-Ban-of-Slovakia') OR (el_to LIKE 'http://www.ausport.gov.au/ais/sports/swimming/achievements/hall_of_fame#Edmistone') OR (el_to LIKE 'http://www.europeanjuniors2012.be/070Results/ResultList_10F.pdf') OR (el_to LIKE 'http://www.sportelite.fi/index.php?node_id=18625') OR (el_to LIKE 'http://www.zweminstituutamsterdam.nl/index.php?pid=2&subpid=58') OR (el_to LIKE 'http://www.sportelite.fi/index.php?node_id=17270') OR (el_to LIKE 'http://www.henrikarjalainen.com/henrikarjalainenindex2eng.htm') OR (el_to LIKE 'http://results.wa.swimming.org.au/PersonalBest.aspx?ID=83045') OR (el_to LIKE 'http://www.konami.co.jp/swimming/profile/takayasu.html') OR (el_to LIKE 'http://kazan2013.com/hide/en/-240/Participant/ParticipantInfo/67ae94a8-5205-4c69-bf45-33b329daf102') OR (el_to LIKE 'https://swimhistory.co.za/index.php/champions/empire-and-commonwealth-games/tatjana-schoenmaker') OR (el_to LIKE 'http://www.wpk.katowice.pl'))

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 = 1

AND ((el_to LIKE 'https://en.asiangames2018.id/athletes/country/') OR (el_to LIKE 'http://www.japannationalfootballteam.com/en/players/arai_kozo.html') OR (el_to LIKE 'http://www.przegubowiec.com/bus/katalog/') OR (el_to LIKE 'http://www.cajt.pwp.blueyonder.co.uk/scotopen.html') OR (el_to LIKE 'http://www.cajt.pwp.blueyonder.co.uk/int.html') OR (el_to LIKE 'http://www.demorgen.be/dm/nl/1005/Meer-Sport/article/detail/1726860/2013/10/21/Snookerpionier-Jackie-Rea-92-overleden.dhtml') OR (el_to LIKE 'http://www.cajt.pwp.blueyonder.co.uk/Players/Rea,Jackie.html') OR (el_to LIKE 'http://www.cajt.pwp.blueyonder.co.uk/PotBlack.html') OR (el_to LIKE 'http://www.cajt.pwp.blueyonder.co.uk/Rankings.html') OR (el_to LIKE 'http://www.cajt.pwp.blueyonder.co.uk/Records.html') OR (el_to LIKE 'http://www.iihf.com/competition/605/') OR (el_to LIKE 'http://www.iihf.com/competition/606/') OR (el_to LIKE 'http://www.cajt.pwp.blueyonder.co.uk/league.html') OR (el_to LIKE 'http://www.jvmv.se/bandelsregister/LOK-reg/Alla/JvgStnK.htm') OR (el_to LIKE 'http://www.region.grodno.by/by/oblast/regions/BolshayaBerestovitsa') OR (el_to LIKE 'http://www.strategicstudiesinstitute.army.mil/pdffiles/PUB585.pdf') OR (el_to LIKE 'http://www.lansstyrelsen.se/orebro/sv/samhallsplanering-och-kulturmiljo/byggnadsvard/kulturmiljo/sevarda-kulturmiljoer/orebro/vattentornet-svampen/Pages/index.aspx') OR (el_to LIKE 'http://www.sportinglife.com/snooker/worldchampionships2012/profiles/story_get.dor?STORY_NAME=snooker/12/03/20/manual_172233.html&BID=25068') OR (el_to LIKE 'http://www.sverigetopplistan.se/netdata/ghl002.mbr/artdata?dfom=20170225&sart=8356584') OR (el_to LIKE 'http://www.lansstyrelsen.se/orebro/SiteCollectionDocuments/Sv/samhallsplanering-och-kulturmiljo/skyddad-bebyggelse/Olaus-petri-kyrka/Olaus%20Petri%20kyrka%20Ingegerd%20Granstr%C3%B6m.pdf') OR (el_to LIKE 'http://www.eurovision.tv/page/history/year/participant-profile/?song=20425') OR (el_to LIKE 'http://www.eurovision.tv/page/history/by-year/contest?event=297') OR (el_to LIKE 'http://www.eurovision.tv/page/history/by-year/contest?event=298') OR (el_to LIKE 'http://download.naturkundemuseum-berlin.de/michael.ohl/Scheel/Debevec%20et%20al%202012%20sistergroup%20bees.pdf') OR (el_to LIKE 'https://eurovision.tv/event/harrogate-1982/final#|') OR (el_to LIKE 'http://www.jernhusen.se/Resenar/Enkopings-Centralstation/') OR (el_to LIKE 'http://www.jernhusen.se/Resenar/Flemingsbergs-Station/') OR (el_to LIKE 'http://www.lansstyrelsen.se/orebro/Sv/samhallsplanering-och-kulturmiljo/byggnadsvard/kulturmiljo/sevarda-kulturmiljoer/hallsberg/hallsbergs-jarnvagsstation/Pages/index.aspx') OR (el_to LIKE 'https://www.flightglobal.com/pdfarchive/view/1989/1989%20-%203603.html') OR (el_to LIKE 'http://www.koscielscy.pl/biogramy_jan_polkowski.php') OR (el_to LIKE 'http://www.environment.gov.au/heritage/places/national/cape-inscription') OR (el_to LIKE 'http://statistik.basketball-bundesliga.de/beko-bbl/statistik/spieler/index.php?spieler_id=2049') OR (el_to LIKE 'http://www.gamecocksonline.com/sports/m-baskbl/mtt/eidson_chuck00.html') OR (el_to LIKE 'http://www.sfuathletics.com/staff.aspx?staff=120') OR (el_to LIKE 'https://ucdavisaggies.com/roster.aspx?rp_id=362') OR (el_to LIKE 'http://www.cyclingnews.com/races/5th-amgen-tour-of-california-2-hc/race-history') OR (el_to LIKE 'http://www.regmurcia.com/servlet/s.Sl?sit=c,722&r=ReP-24475-DETALLE_REPORTAJESPADRE') OR (el_to LIKE 'https://ucdavisaggies.com/coaches.aspx?rc=233') OR (el_to LIKE 'http://sports.yahoo.com/nba/players/3681/') OR (el_to LIKE 'http://www.marina.difesa.it/storiacultura/storia/almanacco/Pagine/') OR (el_to LIKE 'http://www.datosbaloncesto.com/jugadorcomp.php?jugacomp=1490LIGA') OR (el_to LIKE 'http://www.sportando.com/en/europe/turkey/173106/joey-dorsey-inks-a-deal-with-galatasaray.html') OR (el_to LIKE 'http://mks.pl/rozne.php?pd=plk/mecze_gwiazd') OR (el_to LIKE 'http://www.aba-liga.com/League/Player.aspx?id=1168') OR (el_to LIKE 'http://www.cyclones.com/ViewArticle.dbml?DB_OEM_ID=10700&ATCLID=1610576') OR (el_to LIKE 'http://www.cyclones.com/ViewArticle.dbml?DB_OEM_ID=10700&ATCLID=344191') OR (el_to LIKE 'http://www.bz.ru/ru/history-hist_ship.html') OR (el_to LIKE 'http://www.fiba.com/pages/eng/fc/gamecent/p/pid/6006891/playerview.html') OR (el_to LIKE 'http://www.auburntigers.com/sports/c-swim/mtt/peirsol_hayley00.html') OR (el_to LIKE 'http://www.swimmingworldmagazine.com/lane9/news/26856.asp?q=FINA-Announces-Two-Year-Antidoping-Ban-of-Slovakia') OR (el_to LIKE 'http://www.ausport.gov.au/ais/sports/swimming/achievements/hall_of_fame#Edmistone') OR (el_to LIKE 'http://www.europeanjuniors2012.be/070Results/ResultList_10F.pdf') OR (el_to LIKE 'http://www.sportelite.fi/index.php?node_id=18625') OR (el_to LIKE 'http://www.zweminstituutamsterdam.nl/index.php?pid=2&subpid=58') OR (el_to LIKE 'http://www.sportelite.fi/index.php?node_id=17270') OR (el_to LIKE 'http://www.henrikarjalainen.com/henrikarjalainenindex2eng.htm') OR (el_to LIKE 'http://results.wa.swimming.org.au/PersonalBest.aspx?ID=83045') OR (el_to LIKE 'http://www.konami.co.jp/swimming/profile/takayasu.html') OR (el_to LIKE 'http://kazan2013.com/hide/en/-240/Participant/ParticipantInfo/67ae94a8-5205-4c69-bf45-33b329daf102') OR (el_to LIKE 'https://swimhistory.co.za/index.php/champions/empire-and-commonwealth-games/tatjana-schoenmaker') OR (el_to LIKE 'http://www.wpk.katowice.pl'))

GROUP BY el_to

ORDER BY /*counting DESC,*/ el_to;