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.icao.int/safety/ism/accident%20incident%20reporting%20guidance/locationindicatorsbystate.pdf%') OR (el_to LIKE 'http://www.unece.org/cefact/locode/%') OR (el_to LIKE 'http://www.itftennis.com/shared/medialibrary/pdf/original/IO_57746_original.PDF%') OR (el_to LIKE 'http://2012.itftennis.com/olympics/history/medallists/paris-1924.aspx%') OR (el_to LIKE 'http://2012.itftennis.com/olympics/news/articles/london-2012-itf-announces-entries-for-olympic-tennis-event.aspx%') OR (el_to LIKE 'http://2012.itftennis.com/olympics/players/qualification.aspx%') OR (el_to LIKE 'http://2012.itftennis.com/olympics/results/mixed-doubles.aspx%') OR (el_to LIKE 'http://www.army.mil.pl/index.php/aktualnosci/3461-kawaleryjskie-wito%') OR (el_to LIKE 'http://www.udskior.gov.pl/Uroczystosc,wreczenia,odznaczen,w,Palacu,na,Wodzie,w,warszawskich,Lazienkach,256.html%') OR (el_to LIKE 'http://futpedia.globo.com/campeonatos/campeonato-brasileiro/1982/02/07/csa-3-x-3-fluminense%') OR (el_to LIKE 'http://www.wzkosz.pl/files/dokumenty_wgid/2014-2015/Dokumenty/Oficjalne_Przepisy_Gry_w_Koszykowke_2014.pdf%') OR (el_to LIKE 'http://www.tuchow.pl/miasto-i-gmina/miejscowosci/%') OR (el_to LIKE 'http://www.mgokis.zagorz.pl/news/view/155%') OR (el_to LIKE 'http://www.mgokis.zagorz.pl/news/view/157%') OR (el_to LIKE 'http://www.si.podkarpackie.pl/Pliki/2008/program_opieki_n_zabytkami_ostateczny.pdf%') OR (el_to LIKE 'http://www.miedzychod.pl/cms_tmp/strategia.pdf%') OR (el_to LIKE 'http://www.plk-sa.pl/fileadmin/PDF/akty_prawne_i_przepisy/instrukcje/wersja_do_wydruku/Id-12.pdf%') OR (el_to LIKE 'http://www.stat.gov.pl/gus/definicje_PLK_HTML.htm?id=POJ-3203.htm%') OR (el_to LIKE 'http://www.topos.com.pl/topos/images/news/2015/01_03_2015/Laureaci-Konkursu_Rilkego.pdf%') OR (el_to LIKE 'http://rilke.pl/aktualnosci/2007/rilkeanski_topos/%') OR (el_to LIKE 'http://www.rugby.com.au/Portals/1/PDFs/Annual%20Reports/ARUwebsite_updated_R1.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.icao.int/safety/ism/accident%20incident%20reporting%20guidance/locationindicatorsbystate.pdf%') OR (el_to LIKE 'http://www.unece.org/cefact/locode/%') OR (el_to LIKE 'http://www.itftennis.com/shared/medialibrary/pdf/original/IO_57746_original.PDF%') OR (el_to LIKE 'http://2012.itftennis.com/olympics/history/medallists/paris-1924.aspx%') OR (el_to LIKE 'http://2012.itftennis.com/olympics/news/articles/london-2012-itf-announces-entries-for-olympic-tennis-event.aspx%') OR (el_to LIKE 'http://2012.itftennis.com/olympics/players/qualification.aspx%') OR (el_to LIKE 'http://2012.itftennis.com/olympics/results/mixed-doubles.aspx%') OR (el_to LIKE 'http://www.army.mil.pl/index.php/aktualnosci/3461-kawaleryjskie-wito%') OR (el_to LIKE 'http://www.udskior.gov.pl/Uroczystosc,wreczenia,odznaczen,w,Palacu,na,Wodzie,w,warszawskich,Lazienkach,256.html%') OR (el_to LIKE 'http://futpedia.globo.com/campeonatos/campeonato-brasileiro/1982/02/07/csa-3-x-3-fluminense%') OR (el_to LIKE 'http://www.wzkosz.pl/files/dokumenty_wgid/2014-2015/Dokumenty/Oficjalne_Przepisy_Gry_w_Koszykowke_2014.pdf%') OR (el_to LIKE 'http://www.tuchow.pl/miasto-i-gmina/miejscowosci/%') OR (el_to LIKE 'http://www.mgokis.zagorz.pl/news/view/155%') OR (el_to LIKE 'http://www.mgokis.zagorz.pl/news/view/157%') OR (el_to LIKE 'http://www.si.podkarpackie.pl/Pliki/2008/program_opieki_n_zabytkami_ostateczny.pdf%') OR (el_to LIKE 'http://www.miedzychod.pl/cms_tmp/strategia.pdf%') OR (el_to LIKE 'http://www.plk-sa.pl/fileadmin/PDF/akty_prawne_i_przepisy/instrukcje/wersja_do_wydruku/Id-12.pdf%') OR (el_to LIKE 'http://www.stat.gov.pl/gus/definicje_PLK_HTML.htm?id=POJ-3203.htm%') OR (el_to LIKE 'http://www.topos.com.pl/topos/images/news/2015/01_03_2015/Laureaci-Konkursu_Rilkego.pdf%') OR (el_to LIKE 'http://rilke.pl/aktualnosci/2007/rilkeanski_topos/%') OR (el_to LIKE 'http://www.rugby.com.au/Portals/1/PDFs/Annual%20Reports/ARUwebsite_updated_R1.pdf%'))

GROUP BY el_to

ORDER BY /*counting DESC,*/ el_to;