Yona draft - Quarry

SQL

use hewiki_p;
select replace(page_title, "_", " ") as name_of_the_template_with_flag from page
where page_namespace = 10
and page_title like "דגל/%"
and page_is_redirect = 0
and not exists
(select * from categorylinks
 where cl_from = page_id
 and replace(cl_to, "_", " ") in ("תבניות - דגלים של מדינות", "תבניות - מחתרות וארגונים צבאיים למחצה"));
select page_title, count(tl_from) from page inner join templatelinks
on page_title = tl_title
and page_namespace = tl_namespace
where page_namespace = 10
and page_title like "דגל/%"
and tl_from_namespace in (0, 10)
group by page_title
SQL

Checking query status...
