Untitled query #66404

SQL

select page_id, page_namespace, page_title, links_table
from (
  select page_id, 'page' as links_table
  from page
  where page_namespace = 0 and page_title like 'Module_talk:%'
  union all
  select pl_from, 'pagelinks' as links_table
  from pagelinks
  where pl_namespace = 0 and pl_title like 'Module_talk:%'
  union all
  select tl_from as page_id, 'templatelinks' as links_table
  from linktarget
  join templatelinks on lt_id = tl_target_id
  where lt_namespace = 0 and lt_title like 'Module_talk:%'
  union all
  select rd_from as page_id, 'redirect' as links_table
  from redirect
  where rd_namespace = 0 and rd_title like 'Module_talk:%' and rd_interwiki = ''
) tmp
join page using (page_id);
SQL

Checking query status...
