DYKs of Nintendo taskforce

SQL

WITH pages_vg AS (
  WITH pages_vg_talk AS (
    SELECT
      page.page_namespace,
      page.page_title
    FROM
      page
      JOIN categorylinks AS cat1 ON cat1.cl_to = '推薦的新條目'
      AND cat1.cl_type = 'page'
      AND cat1.cl_from = page.page_id
    JOIN categorylinks AS cat2 ON cat2.cl_to = '任天堂工作组条目'
  )
  SELECT
    page.page_id,
    page.page_title
  FROM
    page
    JOIN pages_vg_talk ON page.page_title = pages_vg_talk.page_title
    AND page.page_namespace + 1 = pages_vg_talk.page_namespace
),
transclusion_count AS (
  SELECT
    pages_vg.page_title,
    COUNT(*) AS cot
  FROM
    pages_vg
    JOIN templatelinks ON tl_from = pages_vg.page_id
  GROUP BY
    pages_vg.page_title
)
SELECT
  CONCAT(
    '* {{icon|DYK}} [[:Template:',
    REPLACE(page_title, '_', ' '),
    ']]'
  ) AS result
FROM
  transclusion_count
ORDER BY
  cot DESC,
  page_title ASC;
SQL

Checking query status...
