Untitled query #2806

SQL

set @template = 'מדד_תל_אביב_35';
use hewiki_p;
select pl_title as 'article without template' from page join pagelinks
on page_id = pl_from
where page_namespace = 10
and page_title = @template
and pl_namespace = 0
and exists
(select * from page
 where page_namespace = pl_namespace
 and page_title = pl_title
 and not exists
 (select * from templatelinks
  where tl_from = page_id
  and tl_title = @template));
select page_title as 'article not included in template' from page p join templatelinks
on page_id = tl_from
where tl_title = @template
and page_namespace = 0
and exists
(select * from page
 where page_namespace = 10
 and page_title = @template
 and not exists
 (select * from pagelinks
  where page_id = pl_from
  and pl_namespace = p.page_namespace
  and pl_title = p.page_title))
SQL

Checking query status...
