use hewiki_p;

select page_namespace, page_title, cl_sortkey_prefix from page join categorylinks

on page_id = cl_from

where page_title regexp '[0-9]'

and page_namespace in (0, 14)

and not cl_sortkey_prefix in (replace(page_title, '_', ' '), "", '*')

and page_is_redirect = 0

and not (page_title regexp concat('^[0-9][0-9][0-9][0-9]_ב', cl_sortkey_prefix))

​