Most transcluded infoboxes without TemplateData

SQL

select lt_title as "template", count(tl_from) as "count"
from templatelinks
inner join linktarget on tl_target_id = lt_id
inner join page on lt_title = page_title
inner join categorylinks on cl_from = page_id
where tl_namespace = 10
and page_namespace = 10
and lt_namespace = 10
and cl_to = "Infobox_templates"
and not exists (select * from page_props where pp_page = page_id and pp_propname = "templatedata")
group by lt_title
order by count(tl_from) desc

AخA
 
select lt_title as "template", count(tl_from) as "count"from templatelinksinner join linktarget on tl_target_id = lt_idinner join page on lt_title = page_titleinner join categorylinks on cl_from = page_idwhere tl_namespace = 10and page_namespace = 10and lt_namespace = 10and cl_to = "Infobox_templates"and not exists (select * from page_props where pp_page = page_id and pp_propname = "templatedata")group by lt_titleorder by count(tl_from) desc

SQL

Checking query status...