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.fifa.com/worldcup/archive/%') OR (el_to LIKE 'http://www.fifa.com/tournaments/archive/%') OR (el_to LIKE 'http://www.lokalbanen.dk/media/%') OR (el_to LIKE 'http://www.athletics.ca/admin/%') OR (el_to LIKE 'http://gowyld.net/wyoming/%') OR (el_to LIKE 'http://gornoslaskie-dziedzictwo.com/katowicki-rynek-nie-bojmy-sie-historii-i-zabytkow-katowic/'))

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.fifa.com/worldcup/archive/%') OR (el_to LIKE 'http://www.fifa.com/tournaments/archive/%') OR (el_to LIKE 'http://www.lokalbanen.dk/media/%') OR (el_to LIKE 'http://www.athletics.ca/admin/%') OR (el_to LIKE 'http://gowyld.net/wyoming/%') OR (el_to LIKE 'http://gornoslaskie-dziedzictwo.com/katowicki-rynek-nie-bojmy-sie-historii-i-zabytkow-katowic/'))

GROUP BY el_to

ORDER BY /*counting DESC,*/ el_to;