SQL
AخA
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 száma'*/
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 title
ORDER BY requests DESC
LIMIT 5000;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.