טוסברהינדי

SQL

use hewiki_p;
select p1.page_title from page p1 
where 
	p1.page_namespace=0 and 
    p1.page_title like '%)' and 
    p1.page_is_redirect=0  and 
    not exists (
      select * from pagelinks
      inner join page p2
      on
      	p2.page_id=pl_from
      where 
      	pl_title=p1.page_title and 
      	pl_namespace=0 and p2.page_namespace=0 and 
      (locate(p2.page_title, p1.page_title)=1 or p2.page_title=concat(left(p1.page_title, locate('_(', page_title)), '(פירושונים)'))
    )
	and not exists (
		select * from pagelinks
		inner join templatelinks
		on pl_from=tl_from
		where  pl_namespace=0 and pl_title=p1.page_title and tl_title = 'מפנה'
	)
SQL

Checking query status...
