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) AS (
  (SELECT page_title, page_id, page_namespace, 1 level
  FROM page
   WHERE page_title = "Citation_templates")
  UNION
  (
    SELECT child.page_title, child.page_id, child.page_namespace, level + 1
  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
  WHERE (child.page_namespace = 10
   	OR child.page_namespace = 14)
  	AND level < 3)
)

SELECT *
FROM elements

#SELECT page_title, page_id
#	FROM page
#    JOIN categorylinks ON page_id = cl_from
#    WHERE cl_to = "Citation_templates"
#    AND (page_namespace = 14
#         OR page_namespace = 10)

SQL

Checking query status...