Untitled query #36735

This query is marked as a draft This query has been published by Palotabarát.

SQL

USE huwiki_p;
SELECT pl title as title, count(pl from) as requests
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.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...