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 categorylinks on cl_from = page_id
inner join page on lt_title = page_title
where tl_namespace = 10
and page_namespace = 10
 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
limit 100

​x
 
select lt_title as "template", count(tl_from) as "count"from templatelinksinner join linktarget on tl_target_id = lt_idinner join categorylinks on cl_from = page_idinner join page on lt_title = page_titlewhere tl_namespace = 10and page_namespace = 10 and not exists(select * from page_props where pp_page = page_id and pp_propname = "templatedata")group by lt_titleorder by count(tl_from) desclimit 100​

SQL

Checking query status...