MariaDB [translatewiki_net]> select distinct LEFT(page_title,LOCATE('/', page_title) - 1) from bw_page where page_namespace = 8 and page_title LIKE 'Openstackmanager%';
+----------------------------------------------------+
| LEFT(page_title,LOCATE('/', page_title) - 1)       |
+----------------------------------------------------+
| Openstackmanager-action                            |
| Openstackmanager-actions                           |
| Openstackmanager-addadditionaldomain               |
| Openstackmanager-addadditionalkey                  |
| Openstackmanager-addadditionalproject              |
| Openstackmanager-addadditionalsudoer               |
| Openstackmanager-addedhost                         |
| Openstackmanager-addedpuppetclass                  |
| Openstackmanager-addedpuppetvar                    |
| Openstackmanager-addedrule                         |
| Openstackmanager-addedto                           |
| Openstackmanager-addhost                           |
| Openstackmanager-addhostfailed                     |
| Openstackmanager-addkey                            |
| Openstackmanager-addmember                         |
| Openstackmanager-addpuppetclass                    |
| Openstackmanager-addpuppetvar                      |
| Openstackmanager-address                           |
| Openstackmanager-addresslist                       |
| Openstackmanager-addrolemember                     |
| Openstackmanager-addrule-action                    |
| Openstackmanager-addrule                           |
| Openstackmanager-addrulefailed                     |
| Openstackmanager-addservicegroup                   |
| Openstackmanager-addservicegroupmember             |
| Openstackmanager-allmembers                        |
| Openstackmanager-allocateaddress-confirm           |
| Openstackmanager-allocateaddress                   |
| Openstackmanager-allocateaddressfailed             |
| Openstackmanager-allocatedaddress                  |
| Openstackmanager-allocateips                       |
| Openstackmanager-associateaddress                  |
| Openstackmanager-associateaddressfailed            |
| Openstackmanager-associatedaddress                 |
| Openstackmanager-attach                            |
| Openstackmanager-attachedvolume                    |
| Openstackmanager-attachvolume                      |
| Openstackmanager-attachvolumefailed                |
| Openstackmanager-availabilityzone                  |
| Openstackmanager-backaddresslist                   |
| Openstackmanager-backdomainlist                    |
| Openstackmanager-backinstancelist                  |
| Openstackmanager-backkeylist                       |
| Openstackmanager-backprojectlist                   |
| Openstackmanager-backproxylist                     |
| Openstackmanager-backpuppetgrouplist               |
| Openstackmanager-backsecuritygrouplist             |
| Openstackmanager-backservicegrouplist              |
| Openstackmanager-backsudoerlist                    |
| Openstackmanager-backvolumelist                    |
| Openstackmanager-badinstancename                   |
| Openstackmanager-badprojectname                    |
| Openstackmanager-badresourcename                   |
| Openstackmanager-badvolumename                     |
| Openstackmanager-cannotreleaseaddress              |
| Openstackmanager-commadelimiter                    |
| Openstackmanager-configure                         |
| Openstackmanager-configureinstance                 |
| Openstackmanager-configureproject-failed           |
| Openstackmanager-configureproject-servicegroup     |
| Openstackmanager-configureproject-serviceuserhome  |
| Openstackmanager-configureproject-serviceuserinfo  |
| Openstackmanager-configureproject-sharedhomedirs   |
| Openstackmanager-configureproject-sharedstorage    |
| Openstackmanager-configureproject-success          |
| Openstackmanager-configureproject-volume           |
| Openstackmanager-configureproject                  |
| Openstackmanager-configuresecuritygroup            |
| Openstackmanager-consoleoutput                     |
| Openstackmanager-createddomain                     |
| Openstackmanager-createdinstance                   |
| Openstackmanager-createdomain                      |
| Openstackmanager-createdomainfailed                |
| Openstackmanager-createdproject                    |
| Openstackmanager-createdproxy                      |
| Openstackmanager-createdpuppetgroup                |
| Openstackmanager-createdsecuritygroup              |
| Openstackmanager-createdservicegroup               |
| Openstackmanager-createdsudoer                     |
| Openstackmanager-createdvolume                     |
| Openstackmanager-createevolumefailed               |
| Openstackmanager-createfailedldap                  |
| Openstackmanager-createinstance                    |
| Openstackmanager-createinstancefailed              |
| Openstackmanager-createinstancepuppetwarning       |
| Openstackmanager-createnewsecuritygroup            |
| Openstackmanager-createproject                     |
| Openstackmanager-createprojectfailed               |
| Openstackmanager-createproxy                       |
| Openstackmanager-createproxyfailed                 |
| Openstackmanager-createpuppetgroup                 |
| Openstackmanager-createpuppetgroupfailed           |
| Openstackmanager-createsecuritygroup               |
| Openstackmanager-createsecuritygroupfailed         |
| Openstackmanager-createservicegroupfailed          |
| Openstackmanager-createsudoer                      |
| Openstackmanager-createsudoerfailed                |
| Openstackmanager-createvolume                      |
| Openstackmanager-creationdisabled                  |
| Openstackmanager-creator                           |
| Openstackmanager-delete                            |
| Openstackmanager-deleteddomain                     |
| Openstackmanager-deletedinstance-faileddns         |
| Openstackmanager-deletedinstance                   |
| Openstackmanager-deletedkey                        |
| Openstackmanager-deletedkeyfailed                  |
| Openstackmanager-deletedomain-confirm              |
| Openstackmanager-deletedomain                      |
| Openstackmanager-deletedproject                    |
| Openstackmanager-deletedpuppetclass                |
| Openstackmanager-deletedpuppetgroup                |
| Openstackmanager-deletedpuppetvar                  |
| Openstackmanager-deletedsecuritygroup              |
| Openstackmanager-deletedsudoer                     |
| Openstackmanager-deletedvolume                     |
| Openstackmanager-deleteinstance                    |
| Openstackmanager-deleteinstancefailed              |
| Openstackmanager-deleteinstancequestion            |
| Openstackmanager-deleteinstancewithname            |
| Openstackmanager-deletekey                         |
| Openstackmanager-deletekeyconfirm                  |
| Openstackmanager-deleteproject                     |
| Openstackmanager-deleteprojectfailed               |
| Openstackmanager-deleteproxy-confirm               |
| Openstackmanager-deleteproxy                       |
| Openstackmanager-deleteproxyfailed                 |
| Openstackmanager-deleteproxysuccess                |
| Openstackmanager-deletepuppetgroup                 |
| Openstackmanager-deletepuppetgroupfailed           |
| Openstackmanager-deletesecuritygroup-confirm       |
| Openstackmanager-deletesecuritygroup               |
| Openstackmanager-deletesecuritygroupfailed         |
| Openstackmanager-deletesudoer-confirm              |
| Openstackmanager-deletesudoer                      |
| Openstackmanager-deletevolume                      |
| Openstackmanager-deletevolumefailed                |
| Openstackmanager-deletevolumequestion              |
| Openstackmanager-desc                              |
| Openstackmanager-detach                            |
| Openstackmanager-detachedvolume                    |
| Openstackmanager-detachvolume                      |
| Openstackmanager-detachvolumefailed                |
| Openstackmanager-device                            |
| Openstackmanager-disassociateaddress-confirm       |
| Openstackmanager-disassociateaddress               |
| Openstackmanager-disassociateaddressfailed         |
| Openstackmanager-disassociatedaddress              |
| Openstackmanager-displayquotas-action              |
| Openstackmanager-displayquotas-cores               |
| Openstackmanager-displayquotas-floatingips         |
| Openstackmanager-displayquotas-instances           |
| Openstackmanager-displayquotas-ram                 |
| Openstackmanager-displayquotas-securitygroups      |
| Openstackmanager-displayquotas                     |
| Openstackmanager-dnsdomain                         |
| Openstackmanager-domainlist                        |
| Openstackmanager-domainname                        |
| Openstackmanager-email-body                        |
| Openstackmanager-email-subject                     |
| Openstackmanager-failedeletedomain                 |
| Openstackmanager-failedeletedomainduplicates       |
| Openstackmanager-failedeletedomainnotfound         |
| Openstackmanager-failedeletedsudoer                |
| Openstackmanager-failedtoadd                       |
| Openstackmanager-failedtoaddneedsloginright        |
| Openstackmanager-failedtoaddpuppetclass            |
| Openstackmanager-failedtoaddpuppetvar              |
| Openstackmanager-failedtodeletepuppetclass         |
| Openstackmanager-failedtodeletepuppetvar           |
| Openstackmanager-failedtomodifypuppetclass         |
| Openstackmanager-failedtomodifypuppetgroup         |
| Openstackmanager-failedtomodifypuppetvar           |
| Openstackmanager-failedtoremove                    |
| Openstackmanager-failedtosetgroupmembers           |
| Openstackmanager-fingerprint                       |
| Openstackmanager-forcedetachment                   |
| Openstackmanager-forcedetachmenthelp               |
| Openstackmanager-fqdn                              |
| Openstackmanager-getconsoleoutput                  |
| Openstackmanager-getconsoleoutputfailed            |
| Openstackmanager-hiera-disabled                    |
| Openstackmanager-hiera-noadmin                     |
| Openstackmanager-hieraconfig                       |
| Openstackmanager-hostname                          |
| Openstackmanager-hostnames                         |
| Openstackmanager-imageid                           |
| Openstackmanager-imagetype                         |
| Openstackmanager-importkey                         |
| Openstackmanager-instance                          |
| Openstackmanager-instancecreator                   |
| Openstackmanager-instanceid                        |
| Openstackmanager-instanceip                        |
| Openstackmanager-instancelist                      |
| Openstackmanager-instancename                      |
| Openstackmanager-instancepublicip                  |
| Openstackmanager-instancestate                     |
| Openstackmanager-instancetype                      |
| Openstackmanager-instancetypelabel                 |
| Openstackmanager-invalidaddress                    |
| Openstackmanager-invalidaddressforproject          |
| Openstackmanager-invaliddomain                     |
| Openstackmanager-invalidkeypair                    |
| Openstackmanager-keylist                           |
| Openstackmanager-keypairformatconverted            |
| Openstackmanager-keypairformatwrong                |
| Openstackmanager-keypairimported                   |
| Openstackmanager-keypairimportedfingerprint        |
| Openstackmanager-keypairimportfailed               |
| Openstackmanager-keys                              |
| Openstackmanager-launchtime                        |
| Openstackmanager-location-help                     |
| Openstackmanager-location                          |
| Openstackmanager-manageservicegroupmembers-title   |
| Openstackmanager-manageservicegroupmembers         |
| Openstackmanager-member                            |
| Openstackmanager-members                           |
| Openstackmanager-membersofgroup                    |
| Openstackmanager-missingimage                      |
| Openstackmanager-modifiedgroup                     |
| Openstackmanager-modifiedinstance                  |
| Openstackmanager-modifiedpuppetclass               |
| Openstackmanager-modifiedpuppetgroup               |
| Openstackmanager-modifiedpuppetvar                 |
| Openstackmanager-modifiedsudoer                    |
| Openstackmanager-modify                            |
| Openstackmanager-modifygroupfailed                 |
| Openstackmanager-modifyinstancefailed              |
| Openstackmanager-modifypuppetclass                 |
| Openstackmanager-modifypuppetgroup                 |
| Openstackmanager-modifypuppetvar                   |
| Openstackmanager-modifysudoer                      |
| Openstackmanager-modifysudoerfailed                |
| Openstackmanager-mustbeloggedin                    |
| Openstackmanager-name                              |
| Openstackmanager-needcloudadminrole                |
| Openstackmanager-needcloudadminrole2               |
| Openstackmanager-neednetadminrole                  |
| Openstackmanager-neednetadminrole2                 |
| Openstackmanager-needrole                          |
| Openstackmanager-needrole2                         |
| Openstackmanager-needservicegroup                  |
| Openstackmanager-needsysadminrole                  |
| Openstackmanager-needsysadminrole2                 |
| Openstackmanager-noaccount                         |
| Openstackmanager-noaccount2                        |
| Openstackmanager-nomemberstoadd                    |
| Openstackmanager-nomemberstoremove                 |
| Openstackmanager-nonexistantgroup                  |
| Openstackmanager-nonexistanthost                   |
| Openstackmanager-nonexistantsecuritygroup          |
| Openstackmanager-nonexistantsudoer                 |
| Openstackmanager-nonexistenthost                   |
| Openstackmanager-nonexistentresource               |
| Openstackmanager-nonexistentrole                   |
| Openstackmanager-nonexistentservicegroup           |
| Openstackmanager-nonovacred-admincreate            |
| Openstackmanager-nonovacred                        |
| Openstackmanager-noownedinstances                  |
| Openstackmanager-noownedprojects                   |
| Openstackmanager-notinservicegroup                 |
| Openstackmanager-notloggedin                       |
| Openstackmanager-novadomain-domain                 |
| Openstackmanager-novadomain-info                   |
| Openstackmanager-novadomain                        |
| Openstackmanager-novainstance-global               |
| Openstackmanager-novainstance-info                 |
| Openstackmanager-novainstance-instance             |
| Openstackmanager-novainstance-project              |
| Openstackmanager-novainstance-puppetinfo           |
| Openstackmanager-novainstance                      |
| Openstackmanager-novakey-info                      |
| Openstackmanager-novakey-key                       |
| Openstackmanager-novakey                           |
| Openstackmanager-novakeyname                       |
| Openstackmanager-novaproject-info                  |
| Openstackmanager-novaproject-membership            |
| Openstackmanager-novaproject-project               |
| Openstackmanager-novaproject                       |
| Openstackmanager-novaprojectfilter-projectfilter   |
| Openstackmanager-novaproxy-backend                 |
| Openstackmanager-novaproxy-frontend                |
| Openstackmanager-novapublickey                     |
| Openstackmanager-novapuppetgroup                   |
| Openstackmanager-novarole-info                     |
| Openstackmanager-novarole-role                     |
| Openstackmanager-novasecuritygroup-group           |
| Openstackmanager-novasecuritygroup-rule            |
| Openstackmanager-novasecuritygroup-singlerule      |
| Openstackmanager-novasudoer-info                   |
| Openstackmanager-novasudoer-sudoer                 |
| Openstackmanager-novavolume-info                   |
| Openstackmanager-novavolume-volume                 |
| Openstackmanager-ownedinstances                    |
| Openstackmanager-ownedprojects                     |
| Openstackmanager-prefs-novapublickey               |
| Openstackmanager-projectfiltersubmit               |
| Openstackmanager-projectlist                       |
| Openstackmanager-projectname                       |
| Openstackmanager-projects                          |
| Openstackmanager-proxybackend                      |
| Openstackmanager-proxylist                         |
| Openstackmanager-proxyname                         |
| Openstackmanager-proxyport                         |
| Openstackmanager-puppetallprojects                 |
| Openstackmanager-puppetclasses                     |
| Openstackmanager-puppetclassname                   |
| Openstackmanager-puppetclassposition               |
| Openstackmanager-puppetdoclink                     |
| Openstackmanager-puppetgroup                       |
| Openstackmanager-puppetgrouplist                   |
| Openstackmanager-puppetgroupname                   |
| Openstackmanager-puppetgroupposition               |
| Openstackmanager-puppetstatus                      |
| Openstackmanager-puppetvarname                     |
| Openstackmanager-puppetvarposition                 |
| Openstackmanager-puppetvars                        |
| Openstackmanager-reassociateaddress                |
| Openstackmanager-reboot                            |
| Openstackmanager-rebootedinstance                  |
| Openstackmanager-rebootinstance                    |
| Openstackmanager-rebootinstancefailed              |
| Openstackmanager-rebootinstancequestion            |
| Openstackmanager-rebootinstancewithname            |
| Openstackmanager-releaseaddress-confirm            |
| Openstackmanager-releaseaddress                    |
| Openstackmanager-releaseaddressfailed              |
| Openstackmanager-releasedaddress                   |
| Openstackmanager-removedfrom                       |
| Openstackmanager-removedhost                       |
| Openstackmanager-removedrule                       |
| Openstackmanager-removedservicegroup               |
| Openstackmanager-removehost-action                 |
| Openstackmanager-removehost-confirm                |
| Openstackmanager-removehost                        |
| Openstackmanager-removehostfailed                  |
| Openstackmanager-removemember                      |
| Openstackmanager-removeprojectconfirm              |
| Openstackmanager-removepuppetclass                 |
| Openstackmanager-removepuppetclassconfirm          |
| Openstackmanager-removepuppetgroupconfirm          |
| Openstackmanager-removepuppetvar                   |
| Openstackmanager-removepuppetvarconfirm            |
| Openstackmanager-removerolemember                  |
| Openstackmanager-removerule-action                 |
| Openstackmanager-removerule-confirm                |
| Openstackmanager-removerule                        |
| Openstackmanager-removerulefailed                  |
| Openstackmanager-removeservicegroup                |
| Openstackmanager-removeservicegroupconfirm         |
| Openstackmanager-removeservicegroupfailed          |
| Openstackmanager-removeservicegroupmember          |
| Openstackmanager-rename                            |
| Openstackmanager-requirepassword                   |
| Openstackmanager-rolelist                          |
| Openstackmanager-rolename                          |
| Openstackmanager-roles                             |
| Openstackmanager-scratchtokens                     |
| Openstackmanager-securitygroupdescription          |
| Openstackmanager-securitygrouplist                 |
| Openstackmanager-securitygroupname                 |
| Openstackmanager-securitygrouprule-fromport        |
| Openstackmanager-securitygrouprule-group-exclusive |
| Openstackmanager-securitygrouprule-groups-help     |
| Openstackmanager-securitygrouprule-groups          |
| Openstackmanager-securitygrouprule-ipranges        |
| Openstackmanager-securitygrouprule-protocol        |
| Openstackmanager-securitygrouprule-ranges-help     |
| Openstackmanager-securitygrouprule-ranges          |
| Openstackmanager-securitygrouprule-toport          |
| Openstackmanager-securitygrouprule                 |
| Openstackmanager-securitygroups                    |
| Openstackmanager-servicegrouplist                  |
| Openstackmanager-servicegroupname                  |
| Openstackmanager-servicegrouprecursewarning        |
| Openstackmanager-servicegroups                     |
| Openstackmanager-serviceuser                       |
| Openstackmanager-setgroupmembers                   |
| Openstackmanager-setprojectfilter                  |
| Openstackmanager-setprojects                       |
| Openstackmanager-shellaccountexists                |
| Openstackmanager-shellaccountname-pref             |
| Openstackmanager-shellaccountname                  |
| Openstackmanager-shellaccountnamehelp              |
| Openstackmanager-shellaccountvalidationfail        |
| Openstackmanager-sudoercommands                    |
| Openstackmanager-sudoerhosts                       |
| Openstackmanager-sudoerlist                        |
| Openstackmanager-sudoername                        |
| Openstackmanager-sudoeroptions                     |
| Openstackmanager-sudoerrunas                       |
| Openstackmanager-sudoerusers                       |
| Openstackmanager-title                             |
| Openstackmanager-toggle                            |
| Openstackmanager-unknownerror                      |
| Openstackmanager-volumeattachmentdevice            |
| Openstackmanager-volumeattachmentinstance          |
| Openstackmanager-volumeattachmentstatus            |
| Openstackmanager-volumecreationtime                |
| Openstackmanager-volumedeleteonvolumedelete        |
| Openstackmanager-volumedescription                 |
| Openstackmanager-volumeid                          |
| Openstackmanager-volumelist                        |
| Openstackmanager-volumename                        |
| Openstackmanager-volumesize                        |
| Openstackmanager-volumestate                       |
| Openstackmanager                                   |
+----------------------------------------------------+
406 rows in set (0.013 sec)