Most linked redirects in articles on plwiki

SQL

USE plwiki_p;
SELECT externallinks.el_to
FROM (SELECT el_to
FROM page
JOIN externallinks
ON page.page_id = externallinks.el_from
WHERE el_to NOT LIKE 'http://www.tilastopaja.%'
AND page_title IN (
	SELECT page_title
	FROM categorylinks
	JOIN page ON cl_from=page_id
	WHERE cl_to LIKE 'Niezweryfikowane_martwe_linki_zarchiwizowane_przez_Internet_Archive'
)
AND page_namespace = 2
AND page_id = el_from
GROUP BY el_to) tmp, page
JOIN externallinks
ON page.page_id = externallinks.el_from
WHERE page_namespace = 0
AND tmp.el_to = externallinks.el_to
GROUP BY externallinks.el_to
ORDER BY el_to;

SQL

Checking query status...