SQL
AخA
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.
All SQL code is licensed under CC0 License.