Untitled query #6354

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 in ('PD-old-90', 'PD-old-90-1923') and 
    t2.tl_namespace = 10
where 
  file.page_namespace = 6 and
  creator.page_namespace = 100 and
  t1.tl_from = file.page_id 

group by creator.page_id
order by tot desc, creator.page_title;
SQL

Checking query status...
