Quarry

Query	Run
select regexp_replace(replace(cat_title, '_', ' '), '^.+([Aa]ncient...	5 years ago
select regexp_replace(replace(cat_title, '_', ' '), '^.+([Aa]ncient...	5 years ago
select regexp_replace(cat_title, '^.+([Aa]ncient_[A-Za-z0-9]+).*?$', '\\1')...	5 years ago
select regexp_replace(cat_title, '.+([Aa]ncient_\w+).*?', '\\1') `Category...	5 years ago
select regexp_replace(cat_title, '.+([Aa]ncient_\w+)(.+?)?', '\\1')...	5 years ago
select regexp_replace(cat_title, '.+([Aa]ncient_[\w]+)\b(.+?)?', '\\1')...	5 years ago
select regexp_replace(cat_title, '.+([Aa]ncient_[\B]+)\b(.+?)?', '\\1')...	5 years ago
select regexp_replace(cat_title, '.+([Aa]ncient_[^_]+)(.+?)?', '\\1')...	5 years ago
select regexp_replace(cat_title, '.+([Aa]ncient_.+?)(_.+)?', '\\1')...	5 years ago
select regexp_replace(cat_title, '.+([Aa]ncient_.+)(_.+)?', '\\1') `Category...	5 years ago
select concat('[[:Category:', replace(cat_title, '_', ' '), ']]')...	5 years ago
select concat('[[:Category:', replace(cat_title, '_', ' '), ']]')...	5 years ago