Wikipédia:Legtöbbször hivatkozott lapok

5000 most-time linked red link (not existing article) on huwiki
Az 5000 legtöbbet hivatkozott piros link (nem létező cikk) a magyar Wikipédián

SQL

USE huwiki_p;
SELECT /*pl_title AS title, COUNT(pl_from) AS requests,*/
	concat('[[', replace(pl_title, '_', ' '), ']]') AS 'Cím',
    concat('[[Speciális:Mi hivatkozik erre/', replace(pl_title, '_', ' '), '|', COUNT(pl_from), ']]') AS 'Hivatkozások'
	FROM page p JOIN pagelinks ON p.page_id = pl_from LEFT JOIN page x ON pl_title = x.page_title AND x.page_namespace=0
	WHERE p.page_namespace = 0 AND pl_namespace = 0 AND x.page_title IS NULL
	GROUP BY pl_title
	ORDER BY COUNT(pl_from) DESC
	LIMIT 5000;

SQL

Checking query status...