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.svatojanskavez.cz/stala-expozice/pohledy-do-dejin-farnosti-frydek/frydecka-farnost-v-kontextu-cirkevne-spravniho-vyvoje-slezska/%') OR (el_to LIKE 'http://www.aena.es/csee/ccurl/483/1011/Copia%20de%2012.Estadisticas_Diciembre_2015.pdf%') OR (el_to LIKE 'http://www.plantes-botanique.org/espece_aristolochia_acutifolia%') OR (el_to LIKE 'http://www.mapywig.org/m/WIG_maps/series/100K/P30_S40_WILNO_1935_600dpi.jpg%') OR (el_to LIKE 'http://discover-saint-vincent.com/Map%20showing%20Saint%20Vincent%20and%20the%20Grenadines.jpg%') OR (el_to LIKE 'http://www.battleships-cruisers.co.uk/d+eclass.htm#E%201%') OR (el_to LIKE 'http://www.rnsubs.co.uk/Boats/BoatDB2/index.php?BoatID=92%') OR (el_to LIKE 'http://pravo.gov.ru:8080/page.aspx?23732%') OR (el_to LIKE 'http://www.battleships-cruisers.co.uk/c_class1.htm#C_25%') OR (el_to LIKE 'http://www.bsp.guam.gov/GU%20Statistical%20Yearbook_2010.pdf%') OR (el_to LIKE 'http://www.katedrapolowa.pl/files/Lista%20osob%20zamordowanych%20w%20Katyniu,%20Miednoje%20i%20w%20Charkowie%20mianowanych%20posmiertnie%20na%20kolejne%20stopnie,%20odczytana%20w%20trakcie%20uroczystych%20obchodow%20w%20dniach%209-10%20listopada%202007%20r.%20v3.pdf%') OR (el_to LIKE 'http://www.sikhhockeyolympians.com/Countries/Hong%20Kong%201964%20Tokyo.pdf%') OR (el_to LIKE 'http://www.mdcr.cz/NR/rdonlyres/AA1BA8C3-2CF4-4466-B3B5-8EA68538FB0B/0/Nove_pojeti_mapa.pdf%') OR (el_to LIKE 'https://secure.ausport.gov.au/__data/assets/pdf_file/0005/86945/Australian_Rugby_Union_2005.pdf%') OR (el_to LIKE 'http://www.singapore2010.sg/public/sg2010/en/en_news/en_media_releases/en_2010814_list_of_noc_flag_bearers_for_opening_ceremony/MainPar/0/text_files/file0/RP%20-%20NOC%20Flag%20Bearers.pdf %') OR (el_to LIKE 'http://www.aiba.org/documents/site1/Events/2014%20Youth%20World/C32A__ALL.pdf%') OR (el_to LIKE 'http://www.crisisgroup.org/~/media/Files/CrisisWatch/2014/cw128.pdf%') OR (el_to LIKE 'http://www.crisisgroup.org/~/media/Files/CrisisWatch/2014/cw130.pdf%') OR (el_to LIKE 'http://timesofindia.indiatimes.com/world/rest-of-world/Fighting-rages-in-South-Sudan-as-UN-moves-to-boost-force/articleshow/27919541.cms%') OR (el_to LIKE 'http://www.european-arachnology.org/proceedings/21th/319_332_Tuneva.pdf%'))

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.svatojanskavez.cz/stala-expozice/pohledy-do-dejin-farnosti-frydek/frydecka-farnost-v-kontextu-cirkevne-spravniho-vyvoje-slezska/%') OR (el_to LIKE 'http://www.aena.es/csee/ccurl/483/1011/Copia%20de%2012.Estadisticas_Diciembre_2015.pdf%') OR (el_to LIKE 'http://www.plantes-botanique.org/espece_aristolochia_acutifolia%') OR (el_to LIKE 'http://www.mapywig.org/m/WIG_maps/series/100K/P30_S40_WILNO_1935_600dpi.jpg%') OR (el_to LIKE 'http://discover-saint-vincent.com/Map%20showing%20Saint%20Vincent%20and%20the%20Grenadines.jpg%') OR (el_to LIKE 'http://www.battleships-cruisers.co.uk/d+eclass.htm#E%201%') OR (el_to LIKE 'http://www.rnsubs.co.uk/Boats/BoatDB2/index.php?BoatID=92%') OR (el_to LIKE 'http://pravo.gov.ru:8080/page.aspx?23732%') OR (el_to LIKE 'http://www.battleships-cruisers.co.uk/c_class1.htm#C_25%') OR (el_to LIKE 'http://www.bsp.guam.gov/GU%20Statistical%20Yearbook_2010.pdf%') OR (el_to LIKE 'http://www.katedrapolowa.pl/files/Lista%20osob%20zamordowanych%20w%20Katyniu,%20Miednoje%20i%20w%20Charkowie%20mianowanych%20posmiertnie%20na%20kolejne%20stopnie,%20odczytana%20w%20trakcie%20uroczystych%20obchodow%20w%20dniach%209-10%20listopada%202007%20r.%20v3.pdf%') OR (el_to LIKE 'http://www.sikhhockeyolympians.com/Countries/Hong%20Kong%201964%20Tokyo.pdf%') OR (el_to LIKE 'http://www.mdcr.cz/NR/rdonlyres/AA1BA8C3-2CF4-4466-B3B5-8EA68538FB0B/0/Nove_pojeti_mapa.pdf%') OR (el_to LIKE 'https://secure.ausport.gov.au/__data/assets/pdf_file/0005/86945/Australian_Rugby_Union_2005.pdf%') OR (el_to LIKE 'http://www.singapore2010.sg/public/sg2010/en/en_news/en_media_releases/en_2010814_list_of_noc_flag_bearers_for_opening_ceremony/MainPar/0/text_files/file0/RP%20-%20NOC%20Flag%20Bearers.pdf %') OR (el_to LIKE 'http://www.aiba.org/documents/site1/Events/2014%20Youth%20World/C32A__ALL.pdf%') OR (el_to LIKE 'http://www.crisisgroup.org/~/media/Files/CrisisWatch/2014/cw128.pdf%') OR (el_to LIKE 'http://www.crisisgroup.org/~/media/Files/CrisisWatch/2014/cw130.pdf%') OR (el_to LIKE 'http://timesofindia.indiatimes.com/world/rest-of-world/Fighting-rages-in-South-Sudan-as-UN-moves-to-boost-force/articleshow/27919541.cms%') OR (el_to LIKE 'http://www.european-arachnology.org/proceedings/21th/319_332_Tuneva.pdf%'))

GROUP BY el_to

ORDER BY /*counting DESC,*/ el_to;