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.cso.ie/en/media/csoie/census/documents/census2011vol1andprofile1/Census%202011%20-%20Population%20Classified%20by%20Area.pdf%'#'%.google.%/url?%'#'%.google.%/url?&url=%'
AND page_namespace = 0
GROUP BY page_title#, el_to
ORDER BY page_title#, el_to;

;

SELECT el_to, COUNT(*) AS counting
FROM page
JOIN externallinks
ON page.page_id = externallinks.el_from
WHERE el_to LIKE '%http://www.cso.ie/en/media/csoie/census/documents/census2011vol1andprofile1/Census%202011%20-%20Population%20Classified%20by%20Area.pdf%'
AND page_namespace = 0
GROUP BY el_to
ORDER BY counting DESC, el_to;

SQL

Checking query status...