Untitled query #72043

SQL

select page_id, replace(page_title, '_', ' ') from pagelinks join page
on page_title = pl_title
where pl_from = 10069356
and not pl_namespace
and not page_namespace
and not page_id in
(select page_id from templatelinks join page
on tl_from = page_id
where tl_target_id = 21855
and not page_namespace);
select concat('# ', replace(page_title, '_', ' ')) from templatelinks join page
on tl_from = page_id
where tl_target_id = 21855
and not page_namespace
and not page_id in
(select page_id from pagelinks join page
on page_title = pl_title
where pl_from = 10069356
and not pl_namespace
and not page_namespace)
SQL

Checking query status...
