Uncited articles

SQL

WITH RECURSIVE elements (page_title, page_id, page_namespace) AS (
  (SELECT page_title, page_id, page_namespace
  FROM page
   WHERE page_title = "Citation_templates"
   AND page_namespace = 14)
  UNION
  (SELECT child.page_title, child.page_id, child.page_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 pp_propname IS NULL)
), 

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

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

disambiguation_pages AS (SELECT cl_from
  FROM categorylinks
  WHERE cl_to = "All_disambiguation_pages"
),

links_from AS (
  (
    SELECT cl_from as merged_from
	FROM disambiguation_pages
  )
  UNION
  (
    SELECT tl_from as merged_from
    FROM used_templates
  )
)
	
SELECT page_title, 
	page_len, 
    SUBSTRING(rev_timestamp, 1, 8) as date, 
    CASE WHEN tl_title IS NULL THEN "Untagged" ELSE "Tagged" END as "Tagged as unreferenced"
FROM page
JOIN revision ON page_id = rev_page and rev_parent_id = 0
LEFT JOIN templateLinks ON page_id = tl_from 
	AND tl_from_namespace = 0 
    AND tl_namespace = 10
    AND tl_title = "Unreferenced"
LEFT JOIN links_from ON page_id = merged_from
WHERE merged_from IS NULL
AND page_is_redirect = 0
SQL

Checking query status...
