Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Cryptic
.
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.
Toggle Highlighting
SQL
SELECT CAST(MIN(rev_timestamp) AS DATETIME) AS '1st edit', page_title FROM categorylinks JOIN page ON page_id = cl_from JOIN revision ON rev_page = page_id WHERE page_namespace = 0 AND (cl_to LIKE 'Articles\_lacking\_sources\_from\_%\_2023' OR cl_to = 'Articles_lacking_sources') GROUP BY page_title HAVING MIN(rev_timestamp) >= '2023';
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
.
Checking query status...