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://botswana.microdatahub.com/index.php/catalog/15/related_materials') OR (el_to LIKE 'http://www.environmentcalifornia.org/uploads/at/56/at563bKwmfrtJI6fKl9U_w/Solar-Water-Heating.pdf') OR (el_to LIKE 'http://www.ncdc.noaa.gov:80/oa/climate/globalextremes.html') OR (el_to LIKE 'http://ed.sjtu.edu.cn/rank/2006/ARWU2006_Top100.htm') OR (el_to LIKE 'http://ed.sjtu.edu.cn/rank/2006/ARWU2006TOP500list.htm') OR (el_to LIKE 'http://www.fmep.org/settlement_info/settlement-info-and-tables/stats-data/settlements-in-the-gaza-strip-1') OR (el_to LIKE 'http://www.european-athletics.org/news/latest-news/496-general/10589-turkeys-avan-and-bulgarias-lalova-are-the-2011-balkan-athletes-of-the-year.html') OR (el_to LIKE 'http://www.plantes-botanique.org/genre_isolona'))

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://botswana.microdatahub.com/index.php/catalog/15/related_materials') OR (el_to LIKE 'http://www.environmentcalifornia.org/uploads/at/56/at563bKwmfrtJI6fKl9U_w/Solar-Water-Heating.pdf') OR (el_to LIKE 'http://www.ncdc.noaa.gov:80/oa/climate/globalextremes.html') OR (el_to LIKE 'http://ed.sjtu.edu.cn/rank/2006/ARWU2006_Top100.htm') OR (el_to LIKE 'http://ed.sjtu.edu.cn/rank/2006/ARWU2006TOP500list.htm') OR (el_to LIKE 'http://www.fmep.org/settlement_info/settlement-info-and-tables/stats-data/settlements-in-the-gaza-strip-1') OR (el_to LIKE 'http://www.european-athletics.org/news/latest-news/496-general/10589-turkeys-avan-and-bulgarias-lalova-are-the-2011-balkan-athletes-of-the-year.html') OR (el_to LIKE 'http://www.plantes-botanique.org/genre_isolona'))

GROUP BY el_to

ORDER BY /*counting DESC,*/ el_to;