Links to Draft: from mainspace

Links from mainspace to draft.

This excludes links links that both 1) are to the same title (such as from [[!Kung mythology]] to [[Draft:!Kung mythology]]) and 2) the mainspace page transcludes either {{R with possibilities}} or {{R from upcoming film}}, which always create a link to the page's title in draftspace even though they don't necessarily display it.

SQL

SELECT COUNT(*),
       CONCAT('Draft:', pl_title),
       NOT EXISTS (SELECT 1
                   FROM page
                   WHERE page_namespace = 118
                     AND page_title = pl_title)
         AS redlink
FROM pagelinks
JOIN page ON page_id = pl_from
WHERE pl_from_namespace = 0
  AND pl_namespace = 118
  AND pl_title != page_title
GROUP BY pl_title;

AخA
 
SELECT COUNT(*),       CONCAT('Draft:', pl_title),       NOT EXISTS (SELECT 1                   FROM page                   WHERE page_namespace = 118                     AND page_title = pl_title)         AS redlinkFROM pagelinksJOIN page ON page_id = pl_fromWHERE pl_from_namespace = 0  AND pl_namespace = 118  AND pl_title != page_titleGROUP BY pl_title;

SQL

Checking query status...