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;

select page_title, 0 from page

where page_namespace = 10

and page_is_redirect = 0

and page_title like "דגל/%"

and not exists

(select * from templatelinks

 where page_title = tl_title

and page_namespace = tl_namespace

and tl_from_namespace in (0, 10)

and not

(tl_from_namespace = 10

 and tl_from = page_id))

​