use hewiki_p;

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

where page_namespace = 10

and page_is_redirect = 0

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

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

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

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

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

#and page_title like "%טננ%"

​