Eldad draft - Quarry

SQL

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 not page_title like "דרגה/%אס_%"#
and not page_title like "דרגה/%ורמ%"#
and not page_title like "דרגה/%לופט%"#
and not page_title like "דרגה/%בונד%"#
SQL

Checking query status...
