Uncited articles

SQL

WITH RECURSIVE elements (page_title, page_id, page_namespace, level, parent_title, parent_namespace) AS (
  (SELECT page_title, page_id, page_namespace, 1 level, page_title, page_namespace
  FROM page
   WHERE page_title = "Citation_templates"
   AND page_namespace = 14)
  UNION
  (
    SELECT child.page_title, child.page_id, child.page_namespace, level + 1, parent.page_title as parent_title, parent.page_namespace as parent_namespace
  FROM page AS child
  JOIN categorylinks as childLinks ON child.page_id = childLinks.cl_from
  JOIN elements AS parent ON childLinks.cl_to = parent.page_title
  LEFT JOIN page_props ON childLinks.cl_from = pp_page AND pp_propname = "hiddencat"
  WHERE (child.page_namespace = 10
   	OR child.page_namespace = 14)
    AND parent.page_namespace = 14
  	AND level < 10
  	AND pp_propname IS NULL)
), 

citation_templates AS (
  SELECT DISTINCT(page_id), page_title
  FROM elements
  WHERE page_namespace = 10
),

used_templates AS (SELECT page_title as tl_title, tl_from
  FROM citation_templates
  JOIN templatelinks ON tl_title = page_title
  	AND tl_namespace = 10
    AND tl_from_namespace = 0
)

SELECT page_title, page_len, SUBSTRING(rev_timestamp, 1, 8)
FROM page
JOIN revision ON page_id = rev_page and rev_parent_id = 0
WHERE page_id NOT IN used_templates.tl_from
AND page_is_redirect = 0
AND tl_title IS NULL
SQL

Checking query status...
