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.afryka24.pl/tekst-16459/Ruandyjskie-wojska-wkroczyly-na-terytorium-Kongo%') OR (el_to LIKE 'http://www.un.org/Docs/sc/committees/DRC/1533_list.htm%') OR (el_to LIKE 'http://www.pzhl.org.pl/index.php?option=com_content&view=article&id=659:znamy-zwyciezcow-hokejowych-orlow&catid=7&Itemid=186&lang=pl%') OR (el_to LIKE 'http://www.pzhl.org.pl/index.php?option=com_content&view=article&id=723:hokej-tvp-kolejne-trzy-sezony&catid=7&Itemid=186&lang=pl%') OR (el_to LIKE 'http://www.pzhl.org.pl/index.php?option=com_content&view=article&id=700:19-wydanych-licencji&catid=7&Itemid=186&lang=pl%') OR (el_to LIKE 'http://www.pzhl.org.pl/index.php?option=com_content&view=article&id=254:nesta-karawela-wycofala-plh&catid=7:template&Itemid=186&lang=pl%') OR (el_to LIKE 'http://pzhl.org.pl/index.php?option=com_content&view=article&id=992:plachta-selekcjonerem-reprezentacji&catid=7&Itemid=186&lang=pl%') OR (el_to LIKE 'http://www.pzpn.pl/index.php/pol/archiwum/bilski-i-kaliszan-zakonczyli-kariery%') OR (el_to LIKE 'http://www.sportowefakty.pl/zuzel/373649/z-kartek-kalendarza-bajerski-i-rempala-numerem-jeden-wsrod-juniorow%') OR (el_to LIKE 'http://web1.sportowefakty.pl/index.php?dysc_id=5&k1_id=36&k2_id=87&dzial_id=297&news_id=204413&kom=1%') OR (el_to LIKE 'http://www.ibspan.waw.pl/stzm/do-pobrania/Pasmo%20Grodziskie%20-%20rozwiazania%20transportowe.pdf%') OR (el_to LIKE 'http://www.ibspan.waw.pl/stzm/do-pobrania/Pasmo Grodziskie - rozwiazania transportowe.pdf%') OR (el_to LIKE 'http://www.sport.pl/pilka/1,65050,4193720.html%') OR (el_to LIKE 'http://web1.sportowefakty.pl/index.php?dysc_id=5&k1_id=36&k2_id=87&dzial_id=297&news_id=7836%') OR (el_to LIKE 'http://www.kurierlubelski.pl/index.php?module=dzial&func=viewpub&tid=9&pid=29421%') OR (el_to LIKE 'http://sports.pl/index.php?show=1&s=14&ns=84244%') OR (el_to LIKE 'http://www.trybuna.com.pl/n_show.php?code=2006082803%') OR (el_to LIKE 'http://www.onivins.fr/pdfs/454.pdf%') OR (el_to LIKE 'http://www.nass.usda.gov/Statistics_by_State/California/Publications/Grape_Acreage/200804gabtb00.pdf%') OR (el_to LIKE 'http://bip.wasosz.dolnyslask.pl/files/statut-ujednolicony.pdf%') OR (el_to LIKE 'http://www2.cultura.gov.br/site/acesso-a-informacao/programas-e-acoes/ordem-do-merito-cultural/ordem-do-merito-cultural-2004/%') OR (el_to LIKE 'http://www.arttechcinema.pl/images/przewodnik.pdf%') OR (el_to LIKE 'http://kp.rkc.si/dokumenti/zupnije/seznam.pdf%') OR (el_to LIKE 'https://library.la84.org/6oic/OfficialReports/1992/orw1992.pdf%') OR (el_to LIKE 'http://www.city.yokote.lg.jp/files/000073708.pdf%') OR (el_to LIKE 'http://archiwumcaw.wp.mil.pl/biuletyn/b27/b27_5.pdf%') OR (el_to LIKE 'http://www.dacia.org/mag-2008-52.pdf%') OR (el_to LIKE 'http://shtetiweb.org/wp-content/uploads/2012/09/fier.jpeg%') OR (el_to LIKE 'http://www.itftennis.com/shared/medialibrary/pdf/original/IO_3821_original.PDF%') OR (el_to LIKE 'http://markgtelfer.co.uk/files/2012/04/CantharidaeKeys_v3.pdf%') OR (el_to LIKE 'http://markgtelfer.co.uk/files/2011/10/A-field-key-to-Soldier-Beetles.pdf%') OR (el_to LIKE 'http://worcestershire.whub.org.uk/home/cs-research-census-populationreport.pdf%') OR (el_to LIKE 'http://www.iwf.net/goyang/doc/Entry_List_10.11.2009_Women.pdf%') OR (el_to LIKE 'http://www.poznan.pios.gov.pl/publikacje/raport2001/Raport2001-R4_2-Monitoring%20jezior.pdf%') OR (el_to LIKE 'http://www.yadvashem.org/yv/en/righteous/statistics/poland.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.afryka24.pl/tekst-16459/Ruandyjskie-wojska-wkroczyly-na-terytorium-Kongo%') OR (el_to LIKE 'http://www.un.org/Docs/sc/committees/DRC/1533_list.htm%') OR (el_to LIKE 'http://www.pzhl.org.pl/index.php?option=com_content&view=article&id=659:znamy-zwyciezcow-hokejowych-orlow&catid=7&Itemid=186&lang=pl%') OR (el_to LIKE 'http://www.pzhl.org.pl/index.php?option=com_content&view=article&id=723:hokej-tvp-kolejne-trzy-sezony&catid=7&Itemid=186&lang=pl%') OR (el_to LIKE 'http://www.pzhl.org.pl/index.php?option=com_content&view=article&id=700:19-wydanych-licencji&catid=7&Itemid=186&lang=pl%') OR (el_to LIKE 'http://www.pzhl.org.pl/index.php?option=com_content&view=article&id=254:nesta-karawela-wycofala-plh&catid=7:template&Itemid=186&lang=pl%') OR (el_to LIKE 'http://pzhl.org.pl/index.php?option=com_content&view=article&id=992:plachta-selekcjonerem-reprezentacji&catid=7&Itemid=186&lang=pl%') OR (el_to LIKE 'http://www.pzpn.pl/index.php/pol/archiwum/bilski-i-kaliszan-zakonczyli-kariery%') OR (el_to LIKE 'http://www.sportowefakty.pl/zuzel/373649/z-kartek-kalendarza-bajerski-i-rempala-numerem-jeden-wsrod-juniorow%') OR (el_to LIKE 'http://web1.sportowefakty.pl/index.php?dysc_id=5&k1_id=36&k2_id=87&dzial_id=297&news_id=204413&kom=1%') OR (el_to LIKE 'http://www.ibspan.waw.pl/stzm/do-pobrania/Pasmo%20Grodziskie%20-%20rozwiazania%20transportowe.pdf%') OR (el_to LIKE 'http://www.ibspan.waw.pl/stzm/do-pobrania/Pasmo Grodziskie - rozwiazania transportowe.pdf%') OR (el_to LIKE 'http://www.sport.pl/pilka/1,65050,4193720.html%') OR (el_to LIKE 'http://web1.sportowefakty.pl/index.php?dysc_id=5&k1_id=36&k2_id=87&dzial_id=297&news_id=7836%') OR (el_to LIKE 'http://www.kurierlubelski.pl/index.php?module=dzial&func=viewpub&tid=9&pid=29421%') OR (el_to LIKE 'http://sports.pl/index.php?show=1&s=14&ns=84244%') OR (el_to LIKE 'http://www.trybuna.com.pl/n_show.php?code=2006082803%') OR (el_to LIKE 'http://www.onivins.fr/pdfs/454.pdf%') OR (el_to LIKE 'http://www.nass.usda.gov/Statistics_by_State/California/Publications/Grape_Acreage/200804gabtb00.pdf%') OR (el_to LIKE 'http://bip.wasosz.dolnyslask.pl/files/statut-ujednolicony.pdf%') OR (el_to LIKE 'http://www2.cultura.gov.br/site/acesso-a-informacao/programas-e-acoes/ordem-do-merito-cultural/ordem-do-merito-cultural-2004/%') OR (el_to LIKE 'http://www.arttechcinema.pl/images/przewodnik.pdf%') OR (el_to LIKE 'http://kp.rkc.si/dokumenti/zupnije/seznam.pdf%') OR (el_to LIKE 'https://library.la84.org/6oic/OfficialReports/1992/orw1992.pdf%') OR (el_to LIKE 'http://www.city.yokote.lg.jp/files/000073708.pdf%') OR (el_to LIKE 'http://archiwumcaw.wp.mil.pl/biuletyn/b27/b27_5.pdf%') OR (el_to LIKE 'http://www.dacia.org/mag-2008-52.pdf%') OR (el_to LIKE 'http://shtetiweb.org/wp-content/uploads/2012/09/fier.jpeg%') OR (el_to LIKE 'http://www.itftennis.com/shared/medialibrary/pdf/original/IO_3821_original.PDF%') OR (el_to LIKE 'http://markgtelfer.co.uk/files/2012/04/CantharidaeKeys_v3.pdf%') OR (el_to LIKE 'http://markgtelfer.co.uk/files/2011/10/A-field-key-to-Soldier-Beetles.pdf%') OR (el_to LIKE 'http://worcestershire.whub.org.uk/home/cs-research-census-populationreport.pdf%') OR (el_to LIKE 'http://www.iwf.net/goyang/doc/Entry_List_10.11.2009_Women.pdf%') OR (el_to LIKE 'http://www.poznan.pios.gov.pl/publikacje/raport2001/Raport2001-R4_2-Monitoring%20jezior.pdf%') OR (el_to LIKE 'http://www.yadvashem.org/yv/en/righteous/statistics/poland.pdf%'))

GROUP BY el_to

ORDER BY /*counting DESC,*/ el_to;