SQL
AخA
select distinct user_name, user_registration, user_editcount from page
join templatelinks on page_id = tl_from and tl_from_namespace = 2 and tl_target_id in (
select lt_id from linktarget where lt_namespace = 10 and lt_title in (
select page_title from categorylinks join page on cl_from = page_id and page_namespace = 10
where cl_to = 'Association_football_flag_templates' and cl_type = 'page'
)
)
join user on user_name = REPLACE(SUBSTRING_INDEX(page_title, '/', 1), '_', ' ') and user_registration > 20230500000000
order by user_registration desc
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.