SELECT COUNT(*),

       CONCAT('Draft:', pl_title) AS title,

       NOT EXISTS (SELECT 1

                   FROM page

                   WHERE page_namespace = 118

                     AND page_title = pl_title)

         AS 'Draft is redlink',

       GROUP_CONCAT(page_title SEPARATOR ' | ') AS 'from'

FROM pagelinks

JOIN page ON page_id = pl_from

WHERE pl_from_namespace = 0

  AND pl_namespace = 118

  AND (NOT EXISTS (SELECT 1

                   FROM templatelinks

                   JOIN linktarget ON lt_id = tl_target_id

                   WHERE tl_from = pl_from

                     AND lt_namespace = 10

                     AND lt_title IN ('R_with_possibilities', 'R_from_upcoming_film'))

       OR pl_title != page_title)

GROUP BY pl_title;