Templatelinks - Quarry

SQL

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

AخA
 
select distinct user_name, user_registration, user_editcount from pagejoin 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 > 20230500000000order by user_registration desc

SQL

Checking query status...