Two-page transclusion loops in English Wiktionary

SQL

select
	p1.page_namespace, p1.page_title, p2.page_namespace, p2.page_title, linktarget2.lt_namespace, linktarget2.lt_title
from templatelinks as tl1
join page as p1 on p1.page_id = tl1.tl_from
join page as p2 on p2.page_namespace = tl1.tl_namespace and p2.page_title = tl1.tl_title and p1.page_id <> p2.page_id
join templatelinks as tl2 on tl2.tl_from = p2.page_id
join linktarget as linktarget2 on linktarget2.lt_id = tl2.tl_target_id
where linktarget2.lt_namespace = p1.page_namespace and linktarget2.lt_title = p1.page_title
limit 10;

SQL

Checking query status...