Submitted drafts with 0 or 1 external links

Fork of Submitted drafts with 0, 1, or 2 external links by Novem Linguae

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

These are often easy declines, because you usually need around 3 sources to pass GNG. Help thin out the queue a bit. Still needs manual review though, because 1) some drafts qualify for an SNG, and 2) some drafts have citations such as books that don't include an external link.

The lowest # of external links a draft can have from a database perspective is 24, because the database logs all the transcluded external links from the AFC template, which contains a ton in the "Editor resources" section of the template.

SQL

SELECT page_namespace,
	page_title,
    ( SELECT COUNT(*) FROM externallinks WHERE el_from = page_id ) AS externallinks_count
FROM categorylinks
JOIN page ON page_id = cl_from
WHERE cl_to = 'Pending_AfC_submissions'
	AND page_namespace = 118
    AND ( SELECT COUNT(*) FROM externallinks WHERE el_from = page_id ) < 26 /* 24 = 0, 25 = 1, 26 = 2, 27 = 3. So drafts with 0-2 external links. Unlikely to pass GNG. */
ORDER BY externallinks_count ASC

SQL

Checking query status...