Untitled query #16133

SQL

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;
SQL

Checking query status...
