pagelinks test

SQL

  SELECT pl_title AS `Draft`,
         COUNT(*) AS `#`,
         GROUP_CONCAT(CASE WHEN page_is_redirect = 1
                        THEN CONCAT(CHR(14853303), '{', '{!r', CHR(124), page_title, '}', '}')
                        ELSE CONCAT('[', '[', page_title, ']', ']')
                      END SEPARATOR ', ') AS `Articles`
  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;
SQL

Checking query status...
