MariaDB [mediawikiwiki_p]> select page_namespace as ns, page_title, count(*) from page join revision on rev_page = page_id where rev_user_text = 'MZMcBride' and page_title like 'Requests_for_comment%' group by page_id order by count(*) desc; +----+----------------------------------------------------------------------+----------+ | ns | page_title | count(*) | +----+----------------------------------------------------------------------+----------+ | 0 | Requests_for_comment | 28 | | 0 | Requests_for_comment/Reimplement_info_action | 19 | | 0 | Requests_for_comment/URL_shortener | 13 | | 0 | Requests_for_comment/Add_developer_link_to_footer_of_Wikimedia_wikis | 11 | | 0 | Requests_for_comment/Core_user_preferences | 10 | | 1 | Requests_for_comment/Reimplement_info_action | 9 | | 0 | Requests_for_comment/Global_scripts | 8 | | 0 | Requests_for_comment/Retained_account_data_self-discovery | 5 | | 0 | Requests_for_comment/Password_requirements | 4 | | 0 | Requests_for_comment/Regex-based_blacklist | 4 | | 0 | Requests_for_comment/Scripting | 3 | | 1 | Requests_for_comment/MediaWiki.org_Main_Page_tweaks | 3 | | 0 | Requests_for_comment/Nasty_templates | 3 | | 0 | Requests_for_comment/Disable_raw_HTML_on_wikimediafoundation.org | 2 | | 0 | Requests_for_comment/Bugzilla_taxonomy | 2 | | 0 | Requests_for_comment/Overthrow_Bugzilla | 2 | | 0 | Requests_for_comment/Custom_inter-namespace_tabs | 2 | | 1 | Requests_for_comment/Tickets | 2 | | 1 | Requests_for_comment/Deprecating_inline_styles | 2 | | 1 | Requests_for_comment/MediaWiki_Foundation | 2 | | 0 | Requests_for_comment/Clickable_section_anchors | 2 | | 1 | Requests_for_comment/Clean_up_URLs | 2 | | 1 | Requests_for_comment/Regex-based_blacklist | 1 | | 0 | Requests_for_comment/Account_creation | 1 | | 1 | Requests_for_comment/Custom_inter-namespace_tabs | 1 | | 0 | Requests_for_comment/Simplify_thumbnail_cache | 1 | | 0 | Requests_for_comment/Configuration_database | 1 | | 1 | Requests_for_comment/Disable_raw_HTML_on_wikimediafoundation.org | 1 | | 0 | Requests_for_comment/API_roadmap | 1 | | 0 | Requests_for_comment/URL_shortener_service_for_Wikimedia | 1 | | 1 | Requests_for_comment/Configuration_database | 1 | | 1 | Requests_for_comment/Core_user_preferences | 1 | | 1 | Requests_for_comment/Simplify_thumbnail_cache | 1 | | 1 | Requests_for_comment/Overthrow_Bugzilla | 1 | | 0 | Requests_for_comment/Simplify_Thumbnail_Cache | 1 | | 0 | Requests_for_comment/Extensionless_files | 1 | | 0 | Requests_for_comment/Dismissable_notices | 1 | | 0 | Requests_for_comment/Support_for_user-specific_page_lists_in_core | 1 | | 1 | Requests_for_comment/Simplify_Thumbnail_Cache | 1 | | 1 | Requests_for_comment/Extensionless_files | 1 | | 0 | Requests_for_comment/Deprecating_inline_styles | 1 | | 0 | Requests_for_comment/Tarball_maintenance | 1 | | 1 | Requests_for_comment/Clickable_section_anchors | 1 | | 1 | Requests_for_comment/URL_shortener | 1 | | 1 | Requests_for_comment/LESS | 1 | | 0 | Requests_for_comment/Page_deletion | 1 | | 0 | Requests_for_comment/Page_protection_as_a_component | 1 | +----+----------------------------------------------------------------------+----------+ 47 rows in set (0.10 sec)