Untitled query #6780

SQL

USE lvwiki_p;
SELECT externallinks.el_to, COUNT(*) AS counting
FROM (SELECT el_to, COUNT(*) AS counting
	FROM page
	JOIN externallinks
	ON page.page_id = externallinks.el_from
	WHERE el_to NOT LIKE 'http://web.archive.org/%'
	AND el_to NOT LIKE 'http://toolserver.org/%'
    AND page_title LIKE 'MastiBot/Statystyka_martwych_linków'
    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
HAVING counting >= 2
ORDER BY counting DESC, el_to;
SQL

Checking query status...
