Most wanted articles: ns0→ns0 redlinks only

Fork of Most wanted articles: ns0→ns0 redlinks only by Certes

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

SQL

SELECT * -- linktarget.lt_title, count(distinct spage.page_id) as LinkCount-- pagelinks.pl_target_id AS Target, SUM(pagelinks.page_title IS NULL) AS LinkCount
FROM pagelinks
left join linktarget on pagelinks.pl_target_id = linktarget.lt_id
left join page as spage on pagelinks.pl_from = spage.page_id
Left join page as tpage on pagelinks.lt_title = tpage.page_name_title
where ( pagelinks.pl_from = 64386913 or pagelinks.pl_from = 44476398 ) AND linktarget.lt_namespace = 0

Group by lt_title
ORDER BY LinkCount DESC
LIMIT 1000

SQL

Checking query status...