Template reference lists included in article namespace

SQL

/*
select lt_title, page_title from linktarget
join templatelinks on tl_target_id = lt_id
join page on page_id = tl_from and page_namespace = 0
where lt_namespace = 10 and lt_title in (
  select page_title from page
  where page_namespace = 10 and page_id in (
    select tl_from from templatelinks where tl_target_id in (
      select lt_id from linktarget
      where lt_title = 'Template_reference_list' and lt_namespace = 10
    )
  )
)
and page_id in (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget
    where lt_title = 'Template_reference_list' and lt_namespace = 10
  )
)
*/

/*
select page_title from page
where page_namespace = 0 and page_id in (
  select tl_from from templatelinks where tl_target_id in (
    select lt_id from linktarget
    where lt_title = 'Template_reference_list' and lt_namespace = 10
  )
)
*/

with recursive transclusion as (
  select page_namespace, page_title, lt_namespace, lt_title from page
  join templatelinks on tl_from = page_id
  join linktarget on lt_id = tl_target_id
),
search (page_namespace, page_title, path) as (
  select page_namespace, page_title, page_title from transclusion
  where page_namespace = 0 and lt_title = 'Template_reference_list' and lt_namespace = 10
  union
  select t.lt_namespace, t.lt_title, concat(path, ',', t.lt_title) from search
  join transclusion t on t.page_namespace = search.page_namespace and t.page_title = search.page_title
  where t.lt_namespace in (10, 828) and t.lt_title != 'Template_reference_list' and t.lt_title in (
    select page_title from transclusion
    where page_namespace = t.lt_namespace and lt_title = 'Template_reference_list' and lt_namespace = 10
  )
)

select * from search limit 100
SQL

Checking query status...
