Links to sandbox modules in entries in English Wiktionary

SQL

select lt_title as "module name", page_namespace as namespace_number, count(tl_from) as transclusions
from templatelinks
left join linktarget on lt_id = tl_target_id
left join page on page_id = tl_from

# links to module page
where lt_namespace = 828

# module page ends in /sandbox
and instr(lt_title, "/sandbox") <> 0 and instr(lt_title, "/sandbox") + length("/sandbox") = length(lt_title) + 1

# links from main and Reconstruction namespace
and (page_namespace = 0 or page_namespace = 114)

group by lt_title, page_namespace
order by transclusions desc

SQL

Checking query status...