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, page_id from page where 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
    )
  )
),
search as (
  select * as path from transclusion where page_namespace = 0
  union distinct
  select lt_title, page_title from linktarget
  join templatelinks on tl_target_id = lt_id
  join search on page_id = tl_from
  where lt_namespace = 10 and lt_title != 'Template_reference_list'
  and lt_title in (
    select page_title from transclusion where page_namespace = 10
  )
)

select * from search limit 10
SQL

Checking query status...
