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 elements AS (
  (SELECT page_title, page_id
  FROM page
   WHERE page_title = "Citation_templates")
  UNION
  (SELECT child.page_title, child.page_id
  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)
)

SELECT DISTINCT(page_title), page_id
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...