0 then sys_system_type."keyword" || '_' || usr_institution."keyword" || '_' ||tm_system."keyword_suffix" else sys_system_type."keyword" || '_' || usr_institution."keyword" end AS tm_system_keyword, tm_testing_type."keyword" AS tm_testing_type_keyword FROM "public"."tm_system_actor_profiles" tm_system_actor_profiles INNER JOIN "public"."tm_system" tm_system ON tm_system_actor_profiles."system_id" = tm_system."id" INNER JOIN "public"."tm_system_in_session" tm_system_in_session ON tm_system."id" = tm_system_in_session."system_id" INNER JOIN "public"."tm_institution_system" tm_institution_system ON tm_system."id" = tm_institution_system."system_id" INNER JOIN "public"."usr_institution" usr_institution ON tm_institution_system."institution_id" = usr_institution."id" INNER JOIN "public"."tm_testing_session" tm_testing_session ON tm_system_in_session."testing_session_id" = tm_testing_session."id" INNER JOIN "public"."sys_system_type" sys_system_type ON tm_system."system_type_id" = sys_system_type."id" INNER JOIN "public"."tm_testing_type" tm_testing_type ON tm_system_actor_profiles."testing_type_id" = tm_testing_type."id" INNER JOIN "public"."tf_actor_integration_profile_option" tf_actor_integration_profile_option ON tm_system_actor_profiles."actor_integration_profile_option_id" = tf_actor_integration_profile_option."id" INNER JOIN "public"."tf_actor_integration_profile" tf_actor_integration_profile ON tf_actor_integration_profile_option."actor_integration_profile_id" = tf_actor_integration_profile.id WHERE tf_actor_integration_profile."actor_id" = $P{actorId} AND tf_actor_integration_profile."integration_profile_id" = $P{integrationProfileId} AND tm_testing_session."active" = 't']]>