get posts list by template name

SQL

/*
select DISTINCT pp_propname from page_props;
select page.page_id ,page.page_title,page_props.* from page_props 
INNER JOIN page
on page.page_id =  page_props.pp_page
where pp_propname = "disambiguation"
limit 10;
*/

select revision.rev_page, revision.rev_timestamp from revision 
inner join change_tag 
on revision.rev_id in (
select ct_rev_id from change_tag 
where ct_tag_id in (select  ctd_id from change_tag_def where ctd_name = "newcomer task add link") 
)
where revision.rev_timestamp BETWEEN 20210601000000 and 20210601235959
;

SQL

Checking query status...