Query Run
use ukwiki_p; select SUBSTRING_INDEX(page_title, ':', 1) as prefix, --... 7 years ago
use metawiki_p; select SUBSTRING_INDEX(page_title, ':', 1) as prefix, --... 7 years ago