Most wanted articles: ns0→ns0 redlinks only - Quarry

Fork of Most wanted articles: ns0→ns0 redlinks only by Netha Hussain

This query is marked as a draft This query has been published by DeemDeem52.

Query to find the 100 most wanted articles in the Main namespace (including links from templates and redirects).

SQL

-- Current code by DeemDeem52
SELECT lt.lt_title AS Target, COUNT(IF(page_title IS NULL, 1, NULL)) AS LinkCount
FROM pagelinks pl
INNER JOIN linktarget lt ON pl.pl_target_id = lt.lt_id
LEFT JOIN page ON page_namespace = 0 AND page_title = lt.lt_title
WHERE pl_from_namespace = 0 AND lt.lt_namespace = 0 AND lt.lt_title >= 'Aathur'
GROUP BY Target
HAVING LinkCount > 500
LIMIT 24;

AخA
 
-- Current code by DeemDeem52SELECT lt.lt_title AS Target, COUNT(IF(page_title IS NULL, 1, NULL)) AS LinkCountFROM pagelinks plINNER JOIN linktarget lt ON pl.pl_target_id = lt.lt_idLEFT JOIN page ON page_namespace = 0 AND page_title = lt.lt_titleWHERE pl_from_namespace = 0 AND lt.lt_namespace = 0 AND lt.lt_title >= 'Aathur'GROUP BY TargetHAVING LinkCount > 500LIMIT 24;

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.

Checking query status...