SQL
AخA
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='מפנה'
)
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.