Articles linking to a given multiple external links on plwiki

SQL

USE plwiki_p;
SELECT page_title#, el_to
FROM page
JOIN externallinks
ON page.page_id = externallinks.el_from
WHERE el_to LIKE 'http://www.hbw.com/species/%' OR el_to LIKE 'https://www.hbw.com/species/%'
AND page_namespace = 0
GROUP BY page_title
ORDER BY page_title;
SELECT el_to, COUNT(*) AS counting
FROM page
JOIN externallinks
ON page.page_id = externallinks.el_from
WHERE el_to LIKE 'http://www.hbw.com/species/%' OR el_to LIKE 'https://www.hbw.com/species/%'
AND page_namespace = 0
GROUP BY el_to
ORDER BY counting DESC, el_to;

SQL

Checking query status...