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.qarkushkoder.org/dw/Statistikat%20e%20pergjithshme%20Qarku%202008.rar%') OR 

(el_to LIKE 'http://www.stat.gov.pl/broker/access/showTreeDefinition.jspa?gmiId=6448&level=gmi%') OR 

(el_to LIKE 'http://www.stat.gov.pl/broker/access/showTreeDefinition.jspa?gmiId=6450&level=gmi%') OR 

(el_to LIKE 'http://www.stat.gov.pl/broker/access/showTreeDefinition.jspa?gmiId=4372&level=gmi%') OR 

(el_to LIKE 'http://botswana.microdatahub.com/index.php/catalog/5/related_materials%') OR 

(el_to LIKE 'http://www.zaglebie.walbrzych.pl/index.php?option=com_content&task=view&id=637&Itemid=59%') OR 

(el_to LIKE 'http://tkpzl.lviv.ua/pl/pages/21/%') OR 

(el_to LIKE 'http://www.zaglebie.walbrzych.pl/index.php?option=com_content&task=view&id=636&Itemid=59%') OR 

(el_to LIKE 'http://www.vg-goellheim.de/index.php%') OR 

(el_to LIKE 'http://stoczniowiec.gda.pl/index.php?option=com_content&view=article&id=166&Itemid=262%') OR 

(el_to LIKE 'http://fakty.interia.pl/raport/lech-kaczynski-nie-zyje/news/odsloniecie-tablicy-w-urnie-ziemia-ze-smolenska,1518986%') OR 

(el_to LIKE 'http://www.european-athletics.org/externalmodules/AT/pdf/ATM072101_C73M.pdf%') OR 

(el_to LIKE 'http://news.sciencemag.org/scienceinsider/2012/02/breaking-news-error-undoes-faster.html%') OR 

(el_to LIKE 'http://www.eurowizja.org/v10_news.php?id=2967%') OR 

(el_to LIKE 'http://www.trust.org/alertnet/news/al-qaeda-says-responsible-for-car-bomb-in-yemens-south/%') OR 

(el_to LIKE 'http://czerwonegitary.pl/www/wp-content/uploads/2011/05/1_-_plyty_analogowe_-_longplaye.pdf%') OR 

(el_to LIKE 'http://dss.ucsd.edu/~mshugart/semi-presidentialism.pdf%') OR 

(el_to LIKE 'http://www.pzm.pl/pliki/zg/samochody/2014/Regulaminy/rajdy/rsmp_2014_01_15.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.qarkushkoder.org/dw/Statistikat%20e%20pergjithshme%20Qarku%202008.rar%') OR 

(el_to LIKE 'http://www.stat.gov.pl/broker/access/showTreeDefinition.jspa?gmiId=6448&level=gmi%') OR 

(el_to LIKE 'http://www.stat.gov.pl/broker/access/showTreeDefinition.jspa?gmiId=6450&level=gmi%') OR 

(el_to LIKE 'http://www.stat.gov.pl/broker/access/showTreeDefinition.jspa?gmiId=4372&level=gmi%') OR 

(el_to LIKE 'http://botswana.microdatahub.com/index.php/catalog/5/related_materials%') OR 

(el_to LIKE 'http://www.zaglebie.walbrzych.pl/index.php?option=com_content&task=view&id=637&Itemid=59%') OR 

(el_to LIKE 'http://tkpzl.lviv.ua/pl/pages/21/%') OR 

(el_to LIKE 'http://www.zaglebie.walbrzych.pl/index.php?option=com_content&task=view&id=636&Itemid=59%') OR 

(el_to LIKE 'http://www.vg-goellheim.de/index.php%') OR 

(el_to LIKE 'http://stoczniowiec.gda.pl/index.php?option=com_content&view=article&id=166&Itemid=262%') OR 

(el_to LIKE 'http://fakty.interia.pl/raport/lech-kaczynski-nie-zyje/news/odsloniecie-tablicy-w-urnie-ziemia-ze-smolenska,1518986%') OR 

(el_to LIKE 'http://www.european-athletics.org/externalmodules/AT/pdf/ATM072101_C73M.pdf%') OR 

(el_to LIKE 'http://news.sciencemag.org/scienceinsider/2012/02/breaking-news-error-undoes-faster.html%') OR 

(el_to LIKE 'http://www.eurowizja.org/v10_news.php?id=2967%') OR 

(el_to LIKE 'http://www.trust.org/alertnet/news/al-qaeda-says-responsible-for-car-bomb-in-yemens-south/%') OR 

(el_to LIKE 'http://czerwonegitary.pl/www/wp-content/uploads/2011/05/1_-_plyty_analogowe_-_longplaye.pdf%') OR 

(el_to LIKE 'http://dss.ucsd.edu/~mshugart/semi-presidentialism.pdf%') OR 

(el_to LIKE 'http://www.pzm.pl/pliki/zg/samochody/2014/Regulaminy/rajdy/rsmp_2014_01_15.pdf%'))

GROUP BY el_to

ORDER BY /*counting DESC,*/ el_to;