CS1 References with Missing Titles

SQL

SELECT
  	page.page_title,
    CAST(page.page_touched AS DATETIME) AS 'last_touched',
  	CONCAT("https://en.wikipedia.org/wiki/",page.page_title) AS 'link'
FROM
  	categorylinks
  	INNER JOIN page ON categorylinks.cl_from = page.page_id
WHERE
	-- Only pages linked in the category page
  	categorylinks.cl_type = 'page'
  	AND categorylinks.cl_to = 'CS1_errors:_missing_title'
  	-- Exclude new pages, they might be in the process of fixing title errors
  	AND page.page_is_new <> 1
  -- AND categorylinks.cl_to = 'Pages_with_citations_lacking_titles' (old category name)

SQL

Checking query status...