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, "" AS VARCHAR(50), 100
  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
  JOIN page_props ON childLinks.cl_from = pp_page
  WHERE (child.page_namespace = 10
   	OR child.page_namespace = 14)
    AND parent.page_namespace = 14
  	AND level < 10
  	AND pp_propname != "hiddencat")
)

SELECT *
FROM elements

SQL

Checking query status...