Articles created in 2023 tagged unsourced

Main-namespace pages in either [[Category:Articles lacking sources]] or any category starting [[Category:Articles lacking sources ]] and ending with "2023" whose first non-deleted edit is in 2023.

This won't find pages created in 2023 but in a dated Articles-lacking-sources subcategory from earlier than 2023; such articles are occasionally cut-and-pasted in from earlier deleted versions.  That's not worth fixing, for current purposes; it increases the number of pages to check from 4011 to 119096, and the number of revisions - the really slow part - by a significantly greater ratio.  This would make the query much, much slower, and be unlikely to find more than a handful more pages.

It also won't find pages that were previously redirects, but became non-redirects only in 2023.  That's technically more difficult to fix - without access to page text, we can only see whether the current revision of a page is a redirect, and the tags attached to each revision.  We could, I suppose, look for pages with a creation timestamp before 2023 and a revision with a 'Removed redirect' tag later than 2023; but that, and similar schemes, would also find pages that have been changed back and forth between being redirects and articles multiple times.  (We can't look for pages that have *no* revisions tagged 'Removed redirect' before 2023 and get fully correct results, since the tag hasn't always existed.)  Again, probably not worth fixing for current purposes.

Also doesn't consider pages created in another namespace - particularly Draft: - before 2023 and moved into the main namespace in 2023 as having been created in 2023.  Tracing moves from the database side is even more awkward than doing it from the wiki interface.

For [[WP:VPI#Unreferenced articles]] circa 25 September 2023.
SQL

Checking query status...
