Untitled query #16130

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://www.cbssports.com/collegebasketball/story/10096527%') OR (el_to LIKE 'http://www.hickoksports.com/history/wamboxingwomen.shtml%') OR (el_to LIKE 'http://www.sports.uz/ru/blogs/emansipatsiya_futbola/372/%') OR (el_to LIKE 'http://www.sports.pl/Lekkoatletyka/Igrzyska-Wspolnoty-Brytyjskiej-Oludamola-pozbawiona-medalu,artykul,89203,1,287.html%') OR (el_to LIKE 'http://www.hickoksports.com/history/wmenshotgun.shtml%') OR (el_to LIKE 'http://sports.pl/index.php?show=1&s=14&ns=85357%') OR (el_to LIKE 'http://sports.pl/index.php?show=1&s=14&ns=85274%') OR (el_to LIKE 'http://sports.pl/index.php?show=1&s=14&ns=85418%') OR (el_to LIKE 'https://www.rio2016.com/en/%'))
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.cbssports.com/collegebasketball/story/10096527%') OR (el_to LIKE 'http://www.hickoksports.com/history/wamboxingwomen.shtml%') OR (el_to LIKE 'http://www.sports.uz/ru/blogs/emansipatsiya_futbola/372/%') OR (el_to LIKE 'http://www.sports.pl/Lekkoatletyka/Igrzyska-Wspolnoty-Brytyjskiej-Oludamola-pozbawiona-medalu,artykul,89203,1,287.html%') OR (el_to LIKE 'http://www.hickoksports.com/history/wmenshotgun.shtml%') OR (el_to LIKE 'http://sports.pl/index.php?show=1&s=14&ns=85357%') OR (el_to LIKE 'http://sports.pl/index.php?show=1&s=14&ns=85274%') OR (el_to LIKE 'http://sports.pl/index.php?show=1&s=14&ns=85418%') OR (el_to LIKE 'https://www.rio2016.com/en/%'))
GROUP BY el_to
ORDER BY /*counting DESC,*/ el_to;
SQL

Checking query status...
