Untitled query #11083

SQL

USE commonswiki_p;
select concat("Institution:",ins2.page_title),  ins2.tot, concat("File:",file.page_title)
	from page ins1
    from page file
	join categorylinks c1 on ins1.page_id = c1.cl_from  and c1.cl_to='Institution_templates_without_Wikidata_link'
	join categorylinks c2 on ins1.page_id = c2.cl_from  and c2.cl_to='Institution_template_stubs'
	join templatelinks t2 on ins1.page_title = t2.tl_title and file.page_id = t2.tl_from
	where  ins1.page_namespace = 106 
    and file.page_namespace = 6 
	group by ins1.page_id
	order by tot asc, ins1.page_title
	LIMIT 60
SQL

Checking query status...
