Uncited articles

Produces a list of articles that do not use citation templates, are expected to have citations, and are not currently tagged as unreferenced

It may be useful to exclude articles with external links but no citation templates.

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
)

SELECT page_title, CASE WHEN tl_namespace IS NULL THEN 0 ELSE COUNT(*) END
FROM citation_templates
LEFT JOIN templatelinks ON tl_title = page_title
	AND tl_namespace = 10
    AND tl_from_namespace = 0
GROUP BY tl_title

SQL

Checking query status...