SQL
x
use hewiki_p;
select * from page as p1 join categorylinks
on page_id = cl_from
where cl_to = "תבניות_עם_ניהול_פרמטרים"
and ((not page_namespace = 10) or
(page_namespace = 10
and not exists
(select * from page
where page_namespace = 14
and page_title = concat("שגיאות_פרמטריות_בתבנית_", p1.page_title))));
use hewiki_p;
select * from page as p1 join categorylinks
on page_id = cl_from
where cl_to = "שגיאות_פרמטריות_לפי_תבנית"
and (not exists
(select * from page
where page_namespace = 10
and p1.page_title = concat("שגיאות_פרמטריות_בתבנית_", page_title)
and exists
(select * from categorylinks
where cl_from = page_id
and cl_to = "שגיאות_פרמטריות_לפי_תבנית"
)))
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.