Commons files using PD-old-100 for authors_who_died_less_than_100_years_ago

SQL

USE commonswiki_p;
select concat("Creator:",creator.page_title), count(*) as tot
from 
  page creator
  join categorylinks on 
    creator.page_id = cl_from and 
    cl_to='Creator_templates'
  join templatelinks as t1 on 
    t1.tl_title = creator.page_title  and 
    t1.tl_namespace = 100,

  page file  
  INNER JOIN templatelinks as t2 ON 
    t2.tl_from = file.page_id and 
    t2.tl_title = 'Works_of_authors_who_died_more_than_70_years_ago' and 
    t2.tl_namespace = 10
  INNER JOIN templatelinks as t3 ON 
    t3.tl_from = file.page_id and 
    t3.tl_title = 'PD-old-100' and 
    t3.tl_namespace = 10
where 
  file.page_namespace = 6 and
  creator.page_namespace = 100 and
  t1.tl_from = file.page_id and 
  not exists (
    select * 
    from templatelinks t4
    where 
      t4.tl_from=file.page_id and 
      t4.tl_namespace=10 and 
      t4.tl_title = "Works_of_authors_who_died_more_than_100_years_ago"
    limit 1 
  )  
group by creator.page_id
order by tot desc, creator.page_title;
SQL

Checking query status...
