Untitled query #74464

SQL

# Mobile: 10069356
# Template: 7216752

/*
select * from pagelinks
where pl_from = 10069356;

select * from templatelinks join page
on tl_from = page_id
where tl_target_id = 21855

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

Checking query status...
