Запрос который выбирает типы Customer Request Type для Jira Service Desk

1.sql

select vp.KEY as project_key, vpf.NAME as Request_type_Name, vpf.KEY AS request_type from AO_54307E_VIEWPORT vp join AO_54307E_VIEWPORTFORM vpf on vpf.VIEWPORT_ID = vp.ID;
+-------------+------------------------------------+--------------------------------------+
| project_key | Request_type_Name                  | request_type                         |
+-------------+------------------------------------+--------------------------------------+
| a1sd        | Get IT help                        | getithelp                            |
| a1sd        | Fix an account problem             | accountproblem                       |
| a1sd        | Get a guest wifi account           | guestwifi                            |
| a1sd        | Request admin access               | adminaccess                          |
| a1sd        | Request a new account              | newaccount                           |
| a1sd        | Onboard new employees              | newhires                             |
| a1sd        | Desktop/Laptop support             | compsupport                          |
| a1sd        | Set up a phone line redirect       | phoneredirect                        |
| a1sd        | Request new software               | newsoftware                          |
| a1sd        | New mobile device                  | newmobiledevice                      |
| a1sd        | Report a system problem            | systemproblem                        |
| a1sd        | Upgrade or change a server         | upgradeserver                        |
| a1sd        | Upgrade or change a managed system | upgradesystem                        |

.....

+-------------+------------------------------------+--------------------------------------+