SQL
AخA
SELECT log_id, log_timestamp, actor_name, log_title, CONCAT("https://en.wikipedia.org/wiki/User:", log_title)
FROM logging
JOIN actor ON log_actor = actor_id
WHERE log_type = "create"
AND log_namespace = 2
AND log_title NOT LIKE "%/%"
AND REPLACE(log_title, "_", " ") != actor_name
AND log_timestamp LIKE "20210101%"
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.