Articles linking to a given external link 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.ulc.gov.pl/pl/?option=com_content&task=view&id=42&Itemid=147'
AND page_namespace = 0
GROUP BY page_title#, el_to
ORDER BY page_title#, el_to;

SELECT el_to, COUNT(el_to), page_title
FROM page
JOIN externallinks
ON page.page_id = externallinks.el_from
WHERE el_to LIKE 'http://www.ulc.gov.pl/pl/?option=com_content&task=view&id=42&Itemid=147%'
AND page_namespace = 0
GROUP BY el_to
ORDER BY /*counting, */el_to;

SQL

Checking query status...