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
  )
)
*/
SQL

Checking query status...
