adjacent stations using style templates

SQL

select
    page_id
    page_namespace,
    page_title,
    lt_namespace,
    lt_title
from templatelinks
left join page on page_id = tl_from
left join linktarget lt1 on lt_id = tl_target_id
where lt_namespace = 10 and lt_title like '%_style'
and lt_title not in ( "National_Rail_style" )
  and exists (
    select 1 from templatelinks
    left join linktarget lt2 on lt2.lt_id = tl_target_id
    where tl_from = page_id
      and lt2.lt_namespace = 828
      and lt2.lt_title = 'Adjacent_stations'
  )
  and exists (
    select 1 from categorylinks
    left join page on page_namespace = lt1.lt_namespace and page_title = lt1.lt_title
    where cl_from = page_id
    and cl_to = 'Rail_transport_style_templates'
  )
order by lt_namespace, lt_title, page_namespace, page_title
SQL

Checking query status...
