Uncited articles

This query is marked as a draft This query has been published by BilledMammal.

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 page_title, page_id
  FROM page AS child
  JOIN categorylinks as childLinks ON page_id = cl_from
  JOIN elements AS parent ON childLinks.cl_to = parent.page_id
#)

#SELECT DISTINCT(page_title), page_id
#FROM elements

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...