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_id
#  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 category_links ON page_id = cl_from
    WHERE page_title = "Citation_templates"
    AND page_namespace = 14

SQL

Checking query status...