use hewiki_p;

select concat('# [[תבנית:', replace(page_title, '_', ' ')) as name from page

where page_namespace = 10

and page_is_redirect = 0

#and (page_title like "דרגה/%ורמ%"

#     or replace(page_title, '_', ' ') like "דרגה/%אס %")

and page_title like "דרגה/%"

and not page_title like '%ארה"ב%'

and not page_title like '%ארצות_הברית%'

and not page_title like '%בריטניה%'

and not page_title like '%ישראל%'

and not page_title like '%אצ"ל%'

and (page_title like "דרגה/%אס_%"

or page_title like "דרגה/%ורמ%"

or page_title like "דרגה/%לופט%"

or page_title like "דרגה/%בונד%"

or page_title like "דרגה/%נאצ%" )

​