t Transfer: 1220 :     11|09:14:22.1625|EKtOFe||OAuth: /api/logout?_dc=1688717661011
t Transfer: 1220 :     11|09:14:22.1635|EKtOFe||GetCurrentUser..
t Transfer: 1220 :     11|09:14:22.1635|EKtOFe||  OAuth authenticated
t Verbose: 1220 :      11|09:14:22.1635|EKtOFe||    uid claim is missing..
t Information: 1220 :  11|09:14:22.1635|EKtOFe||OAuth. AutoLogin no Windows identity  type WindowsIdentity
t Transfer: 1220 :     11|09:14:22.3645|elkTWh||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey
t Verbose: 1220 :      11|09:14:22.7665|ZgN6_f||imfx v3 API took 0.174s '/api/v3/visual-asset/group/PnqJC_/2/image'
t Verbose: 1220 :      11|09:14:24.1745|LTqpax||Oauth validating..
t Verbose: 1220 :      11|09:14:24.1745|LTqpax||GrantResourceOwnerCredentials.
t Verbose: 1220 :      11|09:14:24.1745|LTqpax||LoginUser. cjpowercast, login type OAuth, encrypt password True
t Information: 1220 :  11|09:14:24.1745|LTqpax||TryLoginUser. cjpowercast, login type OAuth, check password True, check hash False, encrypt password True, load user data False
t Information: 1220 :  11|09:14:24.5765|LTqpax||  oauth token 00000000-0000-0000-0000-000000000000
t Information: 1220 :  11|09:14:24.5765|LTqpax||TryLoginUser. Logged in..
t Information: 1220 :  11|09:14:24.5765|LTqpax||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled.
t Verbose: 1220 :      11|09:14:24.5765|LTqpax||LoginUser. Adding history. User Id 1165, result CJPOWERCAST, host 192.168.127.6
t Verbose: 1220 :      11|09:14:24.5765|LTqpax||GrantResourceOwnerCredentials. Try login finished. Logged: True
t Transfer: 1220 :     11|09:14:24.9785|JxgLJV|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=defaultSearchColumnsMedia,defaultSearchColumnsVersion,defaultSearchColumnsSimple,defaultSearchColumnsTitle,defaultSearchMisrDetailsMediaColumns,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,supplier_portal.version_complete.setups,logoImage,uploadSettings,helpdeskUrl,customLabels,googleMapsApiSettings&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,helpdeskUrl,customLabels&_dc=1688717663997
t Transfer: 1220 :     11|09:14:24.9785|JxgLJV|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:24.9785|JxgLJV|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:24.9785|JxgLJV|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:24.9785|JxgLJV|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:24.9795|JxgLJV|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:24.9795|JxgLJV|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:24.9795|JxgLJV|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:25.1805|JxgLJV|CJPOWERCAST|imfx v3 API took 0.045s '/api/user-group-preferences?keys=defaultSearchColumnsMedia,defaultSearchColumnsVersion,defaultSearchColumnsSimple,defaultSearchColumnsTitle,defaultSearchMisrDetailsMediaColumns,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,supplier_portal.version_complete.setups,logoImage,uploadSettings,helpdeskUrl,customLabels,googleMapsApiSettings&globals=isDebugMode,htmlplayerhotkeys,versionCreationSettings,associate.advanced_search.version.setups,associate.advanced_search.media.setups,associate.wfrise.setups,supplier_portal.advanced_search.version.setups,media_portal.del_history.advanced.search_criteria,helpdeskUrl,customLabels&_dc=1688717663997'
t Transfer: 1220 :     11|09:14:25.3815|iJ00wd|CJPOWERCAST|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1688717664341
t Transfer: 1220 :     11|09:14:25.3815|iJ00wd|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:25.3815|iJ00wd|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:25.3815|iJ00wd|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:25.3815|iJ00wd|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|09:14:25.3815|iJ00wd|CJPOWERCAST|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings
t Transfer: 1220 :     11|09:14:25.3815|iJ00wd|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:25.3815|iJ00wd|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:25.3825|iJ00wd|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:25.3825|iJ00wd|CJPOWERCAST|imfx v3 API took 0.046s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1688717664341'
t Information: 1220 :  11|09:14:25.7845|Vh6wGA|CJPOWERCAST|GetUserProfile. Id: 0
t Transfer: 1220 :     11|09:14:25.7845|Vh6wGA|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:25.7845|Vh6wGA|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:25.7845|Vh6wGA|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:26.1865|TWuPep|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1688717665060
t Transfer: 1220 :     11|09:14:26.1865|TWuPep|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:26.1865|TWuPep|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:26.1865|TWuPep|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:26.1865|TWuPep|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:26.1865|cIcSZK|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1688717665061
t Transfer: 1220 :     11|09:14:26.1865|cIcSZK|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:26.1865|cIcSZK|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:26.1875|cIcSZK|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:26.1875|cIcSZK|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:26.1875|cIcSZK|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:26.1875|cIcSZK|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:26.1875|cIcSZK|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:26.1875|tPjx5J|CJPOWERCAST|OAuth: /api/settings/user/uploadSettings?_dc=1688717665063
t Transfer: 1220 :     11|09:14:26.1875|tPjx5J|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:26.1875|tPjx5J|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:26.1875|tPjx5J|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:26.1875|tPjx5J|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|09:14:26.1885|cIcSZK|CJPOWERCAST|imfx v3 API took 0.007s '/api/settings/user/mainMenuSettings?_dc=1688717665061'
t Transfer: 1220 :     11|09:14:26.1885|tPjx5J|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:26.1885|tPjx5J|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:26.1885|tPjx5J|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:26.1885|tPjx5J|CJPOWERCAST|imfx v3 API took 0.009s '/api/settings/user/uploadSettings?_dc=1688717665063'
t Transfer: 1220 :     11|09:14:26.3895|zKTGlD|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1688717665069
t Transfer: 1220 :     11|09:14:26.3895|zKTGlD|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:26.3895|zKTGlD|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:26.3895|zKTGlD|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:26.3895|zKTGlD|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|09:14:26.3895|TWuPep|CJPOWERCAST|imfx v3 API took 0.323s '/api/settings/group/0?_dc=1688717665060'
t Transfer: 1220 :     11|09:14:26.3905|hZljbt|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1688717665070
t Transfer: 1220 :     11|09:14:26.3905|hZljbt|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:26.3905|hZljbt|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:26.3905|hZljbt|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:26.3905|hZljbt|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:26.5915|hZljbt|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:26.5915|hZljbt|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:26.5915|hZljbt|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:26.5915|zKTGlD|CJPOWERCAST|imfx v3 API took 0.090s '/api/settings/group/0?_dc=1688717665069'
t Verbose: 1220 :      11|09:14:26.5915|hZljbt|CJPOWERCAST|imfx v3 API took 0.002s '/api/settings/user/mainMenuSettings?_dc=1688717665070'
t Verbose: 1220 :      11|09:14:26.5915|_PDgN5||imfx v3 API took 0.003s '/api/v3/visual-asset/group/Any_gO/0/image'
t Transfer: 1220 :     11|09:14:26.5915|2uIri1|CJPOWERCAST|OAuth: /api/lookups/MediaStatus?_dc=1688717665074
t Transfer: 1220 :     11|09:14:26.5925|2uIri1|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:26.5925|2uIri1|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:26.5925|2uIri1|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:26.5925|2uIri1|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:26.5925|tGkg8Y|CJPOWERCAST|OAuth: /api/lookups/PgmStatus?_dc=1688717665074
t Transfer: 1220 :     11|09:14:26.5925|tGkg8Y|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:26.5925|tGkg8Y|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:26.5935|tGkg8Y|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:26.5935|tGkg8Y|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|09:14:26.7945|2uIri1|CJPOWERCAST|imfx v3 API took 0.031s '/api/lookups/MediaStatus?_dc=1688717665074'
t Verbose: 1220 :      11|09:14:26.7945|tGkg8Y|CJPOWERCAST|imfx v3 API took 0.026s '/api/lookups/PgmStatus?_dc=1688717665074'
t Transfer: 1220 :     11|09:14:26.7945|uZcnyx|CJPOWERCAST|OAuth: /api/lookup/CustomMediaStatusTypes?_dc=1688717665075
t Transfer: 1220 :     11|09:14:26.7945|uZcnyx|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:26.7945|uZcnyx|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:26.7945|uZcnyx|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:26.7945|uZcnyx|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:26.7945|iDlhi6|CJPOWERCAST|OAuth: /api/lookup/CustomVersionStatusTypes?_dc=1688717665075
t Transfer: 1220 :     11|09:14:26.7955|iDlhi6|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:26.7955|iDlhi6|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:26.7955|iDlhi6|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:26.7955|iDlhi6|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|09:14:26.7955|iDlhi6|CJPOWERCAST|imfx v3 API took 0.023s '/api/lookup/CustomVersionStatusTypes?_dc=1688717665075'
t Verbose: 1220 :      11|09:14:26.7955|uZcnyx|CJPOWERCAST|imfx v3 API took 0.072s '/api/lookup/CustomMediaStatusTypes?_dc=1688717665075'
t Transfer: 1220 :     11|09:14:26.9965|4tgkt9|CJPOWERCAST|OAuth: /api/lookup/CustomTitleStatusTypes?_dc=1688717665075
t Transfer: 1220 :     11|09:14:26.9965|4tgkt9|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:26.9965|4tgkt9|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:26.9965|4tgkt9|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:26.9965|4tgkt9|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|09:14:26.9965|4tgkt9|CJPOWERCAST|imfx v3 API took 0.011s '/api/lookup/CustomTitleStatusTypes?_dc=1688717665075'
t Transfer: 1220 :     11|09:14:26.9965|7D2evB|CJPOWERCAST|OAuth: /api/settings/user/defaultHomePage?_dc=1688717665076
t Transfer: 1220 :     11|09:14:26.9975|7D2evB|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:26.9975|7D2evB|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:26.9975|7D2evB|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:26.9975|7D2evB|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:26.9975|7D2evB|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:26.9975|7D2evB|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:26.9975|7D2evB|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:26.9975|07bSNW||imfx v3 API took 0.002s '/api/v3/visual-asset/group/Any_gO/1/image'
t Verbose: 1220 :      11|09:14:26.9975|7D2evB|CJPOWERCAST|imfx v3 API took 0.008s '/api/settings/user/defaultHomePage?_dc=1688717665076'
t Transfer: 1220 :     11|09:14:27.3995|T0RDq3|CJPOWERCAST|OAuth: /api/settings/user/startSearch?_dc=1688717666319
t Transfer: 1220 :     11|09:14:27.3995|T0RDq3|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:27.3995|T0RDq3|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:27.3995|T0RDq3|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:27.3995|T0RDq3|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:27.3995|T0RDq3|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:27.3995|T0RDq3|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:27.4005|T0RDq3|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:27.4005|GmRGz9|CJPOWERCAST|OAuth: /api/settings/user/defaultSearch?_dc=1688717666318
t Transfer: 1220 :     11|09:14:27.4005|GmRGz9|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:27.4005|GmRGz9|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:27.4005|GmRGz9|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:27.4005|GmRGz9|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:27.4005|GmRGz9|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:27.4005|GmRGz9|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:27.4005|GmRGz9|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:27.4005|T0RDq3|CJPOWERCAST|imfx v3 API took 0.008s '/api/settings/user/startSearch?_dc=1688717666319'
t Verbose: 1220 :      11|09:14:27.4015|GmRGz9|CJPOWERCAST|imfx v3 API took 0.009s '/api/settings/user/defaultSearch?_dc=1688717666318'
t Verbose: 1220 :      11|09:14:27.6025|KMCCnp||imfx v3 API took 0.003s '/api/v3/visual-asset/group/Any_gO/3/image'
t Transfer: 1220 :     11|09:14:27.6025|L9Na_v|CJPOWERCAST|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1688717666619
t Transfer: 1220 :     11|09:14:27.6025|L9Na_v|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:27.6025|L9Na_v|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:27.6025|L9Na_v|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:27.6025|L9Na_v|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:27.6025|VFdRnr|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1688717666621
t Transfer: 1220 :     11|09:14:27.6025|VFdRnr|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:27.6035|VFdRnr|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:27.6035|VFdRnr|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:27.6035|VFdRnr|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|09:14:27.6035|L9Na_v|CJPOWERCAST|GetUserDataByKeys: consumer.recent.data
t Transfer: 1220 :     11|09:14:27.6035|L9Na_v|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:27.6035|L9Na_v|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:27.6035|L9Na_v|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|09:14:27.6035|VFdRnr|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.consumer
t Transfer: 1220 :     11|09:14:27.6045|VFdRnr|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:27.6045|VFdRnr|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:27.6045|VFdRnr|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:27.6045|L9Na_v|CJPOWERCAST|imfx v3 API took 0.005s '/api/user-preferences?keys=consumer.recent.data&_dc=1688717666619'
t Verbose: 1220 :      11|09:14:27.6045|VFdRnr|CJPOWERCAST|imfx v3 API took 0.006s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1688717666621'
t Transfer: 1220 :     11|09:14:31.0215|LHqGEh|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1688717669887
t Transfer: 1220 :     11|09:14:31.0215|LHqGEh|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:31.0215|LHqGEh|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:31.0215|LHqGEh|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:31.0215|LHqGEh|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:31.0215|gr3cU7|CJPOWERCAST|OAuth: /api/lookups/SearchSupportedOperators?_dc=1688717669886
t Transfer: 1220 :     11|09:14:31.0215|gr3cU7|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:31.0215|gr3cU7|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:31.0225|gr3cU7|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:31.0225|gr3cU7|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|09:14:31.0225|LHqGEh|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.titles
t Transfer: 1220 :     11|09:14:31.0225|LHqGEh|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:31.0225|LHqGEh|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:31.0225|LHqGEh|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:31.0225|jrFtK_|CJPOWERCAST|OAuth: /api/view/searchinfo/TitleSearch?_dc=1688717669886
t Transfer: 1220 :     11|09:14:31.0225|jrFtK_|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:31.0225|jrFtK_|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:31.0225|jrFtK_|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:31.0235|jrFtK_|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|09:14:31.0235|gr3cU7|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1688717669886'
t Verbose: 1220 :      11|09:14:31.0235|LHqGEh|CJPOWERCAST|imfx v3 API took 0.005s '/api/user-preferences?keys=adv.recent.searches.titles&_dc=1688717669887'
t Transfer: 1220 :     11|09:14:31.0235|~oLm6E|CJPOWERCAST|OAuth: /api/view/searches/TitleSearch?_dc=1688717669904
t Transfer: 1220 :     11|09:14:31.0235|~oLm6E|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:31.0235|~oLm6E|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:31.0235|~oLm6E|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:31.0235|~oLm6E|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:31.0235|8sRWja|CJPOWERCAST|OAuth: /api/view/info/VersionGrid?lang=en-GB&_dc=1688717669909
t Transfer: 1220 :     11|09:14:31.0235|8sRWja|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:31.0245|8sRWja|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:31.0245|8sRWja|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:31.0245|8sRWja|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:31.0245|Qqzawh|CJPOWERCAST|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1688717669930
t Transfer: 1220 :     11|09:14:31.0245|Qqzawh|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:31.0245|Qqzawh|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:31.0245|Qqzawh|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:31.0245|Qqzawh|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|09:14:31.0245|8sRWja|CJPOWERCAST|GetGridViewBuilder. builder type VersionGrid.
t Information: 1220 :  11|09:14:31.0245|jrFtK_|CJPOWERCAST|GetAdvSearchColumns. search type TitleSearch grid .
t Verbose: 1220 :      11|09:14:31.0255|jrFtK_|CJPOWERCAST|imfx v3 API took 0.001s '/api/view/searchinfo/TitleSearch?_dc=1688717669886'
t Information: 1220 :  11|09:14:31.0255|~oLm6E|CJPOWERCAST|GetSavedSearchNames. search type TitleSearch.
t Transfer: 1220 :     11|09:14:31.0255|~oLm6E|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:31.0255|~oLm6E|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:31.0255|~oLm6E|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:31.0255|8sRWja|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:31.0255|8sRWja|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:31.0255|8sRWja|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|09:14:31.0255|Qqzawh|CJPOWERCAST|GetGridViewBuilder. builder type MediaGrid.
t Transfer: 1220 :     11|09:14:31.0255|Qqzawh|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:31.0265|Qqzawh|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:31.0265|Qqzawh|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:31.2275|~oLm6E|CJPOWERCAST|imfx v3 API took 0.113s '/api/view/searches/TitleSearch?_dc=1688717669904'
t Information: 1220 :  11|09:14:31.2275|8sRWja|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default.
t Information: 1220 :  11|09:14:31.2275|Qqzawh|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default.
t Transfer: 1220 :     11|09:14:31.2275|8sRWja|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:31.2275|8sRWja|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:31.2275|8sRWja|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:31.2275|Qqzawh|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:31.2275|Qqzawh|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:31.2275|Qqzawh|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:31.2285|8sRWja|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:31.2285|8sRWja|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:31.2285|8sRWja|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:31.2285|Qqzawh|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:31.2285|Qqzawh|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:31.2285|Qqzawh|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:31.2285|K47VXw|CJPOWERCAST|OAuth: /api/view/info/DigitalCarriers?lang=en-GB&_dc=1688717669940
t Transfer: 1220 :     11|09:14:31.2285|K47VXw|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:31.2285|K47VXw|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:31.2285|K47VXw|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:31.2285|K47VXw|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|09:14:31.2295|K47VXw|CJPOWERCAST|GetGridViewBuilder. builder type DigitalCarriers.
t Transfer: 1220 :     11|09:14:31.2295|K47VXw|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:31.2295|K47VXw|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:31.2295|K47VXw|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:31.2295|migGsj|CJPOWERCAST|OAuth: /api/view/info/TitleTree?lang=en-GB&_dc=1688717669950
t Transfer: 1220 :     11|09:14:31.2295|migGsj|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:31.2295|migGsj|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:31.2295|migGsj|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:31.2295|migGsj|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|09:14:31.2295|K47VXw|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default.
t Transfer: 1220 :     11|09:14:31.2305|K47VXw|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:31.2305|K47VXw|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:31.2305|K47VXw|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|09:14:31.2305|migGsj|CJPOWERCAST|GetGridViewBuilder. builder type TitleTree.
t Transfer: 1220 :     11|09:14:31.2305|migGsj|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:31.2305|migGsj|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:31.2305|migGsj|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:31.2305|K47VXw|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:31.2305|K47VXw|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:31.2315|K47VXw|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:31.2315|8sRWja|CJPOWERCAST|imfx v3 API took 0.210s '/api/view/info/VersionGrid?lang=en-GB&_dc=1688717669909'
t Verbose: 1220 :      11|09:14:31.2315|Qqzawh|CJPOWERCAST|imfx v3 API took 0.129s '/api/view/info/MediaGrid?lang=en-GB&_dc=1688717669930'
t Information: 1220 :  11|09:14:31.2315|migGsj|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default.
t Transfer: 1220 :     11|09:14:31.2315|migGsj|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:31.2315|migGsj|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:31.2315|migGsj|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:31.2315|K47VXw|CJPOWERCAST|imfx v3 API took 0.009s '/api/view/info/DigitalCarriers?lang=en-GB&_dc=1688717669940'
t Transfer: 1220 :     11|09:14:31.2315|migGsj|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:31.2315|migGsj|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:31.2325|migGsj|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:31.2325|migGsj|CJPOWERCAST|imfx v3 API took 0.008s '/api/view/info/TitleTree?lang=en-GB&_dc=1688717669950'
t Transfer: 1220 :     11|09:14:34.2455|fbv4Rz|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1688717673159
t Transfer: 1220 :     11|09:14:34.2455|fbv4Rz|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:34.2455|fbv4Rz|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:34.2455|fbv4Rz|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:34.2455|fbv4Rz|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:34.2455|X_Ac7M|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1688717673237
t Transfer: 1220 :     11|09:14:34.2455|X_Ac7M|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:34.2455|X_Ac7M|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:34.2465|X_Ac7M|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:34.2465|X_Ac7M|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:34.2465|X_Ac7M|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:34.2465|X_Ac7M|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:34.2465|X_Ac7M|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:34.2465|fbv4Rz|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:34.2465|fbv4Rz|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:34.2465|fbv4Rz|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:35.0515|X_Ac7M|CJPOWERCAST|imfx v3 API took 0.814s '/api/v3/search-suggestion/?_dc=1688717673237'
t Verbose: 1220 :      11|09:14:35.0515|fbv4Rz|CJPOWERCAST|imfx v3 API took 0.814s '/api/v3/search-suggestion/?_dc=1688717673159'
t Transfer: 1220 :     11|09:14:36.4585|HA8UCd|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1688717675357
t Transfer: 1220 :     11|09:14:36.4585|HA8UCd|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:36.4585|HA8UCd|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:36.4585|HA8UCd|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:36.4585|HA8UCd|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|09:14:36.4585|HA8UCd|CJPOWERCAST|V3Api.SearchTitles
t Information: 1220 :  11|09:14:36.4585|HA8UCd|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|09:14:36.4595|HA8UCd|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:36.4595|HA8UCd|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:36.4595|HA8UCd|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|09:14:36.4595|HA8UCd|CJPOWERCAST|SearchTitle SQL:
with 
 v as (
    SELECT 
        abs.*
       ,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = abs.net_grp_id) CHANNEL_GROUP
       ,decode(ITEM_TYPE,
                 1010,SER_ABS_ID,
                 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END
              ) xparent_id
     FROM TMDDBA.TM_PG_ABS abs
     WHERE abs.id in (
          select a.id
          FROM TMDDBA.TM_PG_ABS a
          where ABS_DELETED = 0  AND (INSTR(OWNERS,'|SFP2|')>0  OR INSTR(OWNERS,'|PSP|')>0  OR INSTR(OWNERS,'|PMS|')>0  OR INSTR(OWNERS,'|SFP1|')>0  OR INSTR(OWNERS,'|PMH|')>0  OR INSTR(OWNERS,'|PPL|')>0 ) AND   a.ser_abs_id=:param_0    AND ROWNUM < 25000   )
      
 )
,v_missing_parent_ids as (
    select xparent_id from v
    minus
    select id from v
 )
,v_missing_parents as (
    SELECT 
        distinct a.*
       ,(select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = a.net_grp_id) CHANNEL_GROUP
       ,decode(ITEM_TYPE,
                 1010,SER_ABS_ID,
                 1020,CASE WHEN SER_ABS2_ID > 0 THEN SER_ABS2_ID ELSE SER_ABS_ID END
              ) xparent_id
      FROM TMDDBA.TM_PG_ABS a
    START WITH ID IN (select xparent_id from v_missing_parent_ids)
    CONNECT BY
           CASE PRIOR ITEM_TYPE
             WHEN 1010 THEN PRIOR SER_ABS_ID
             WHEN 1020 THEN 
               CASE WHEN NVL(PRIOR SER_ABS2_ID, 0) > 0 THEN PRIOR SER_ABS2_ID ELSE PRIOR SER_ABS_ID END
             END = ID
 )
,v_all as (
   select x.*, count(*) over() RowCount
   from (
     select * from v_missing_parents
     union 
     select * from v
   ) x
 )
,v_top as (
   select id
   from (select id, row_number()over(order by upper(ser_title),upper(title),ser_num,ser_ep_num, SER_EP_SQ_NUM ) rnk -- sort roots
         from v_all 
         where  xparent_id is null)
   where rnk between (:page_number-1)*50+1 and :page_number*50
)
,v_tree as (
   select level "TreeLevel", a.*from v_all a
   start with id in (select id from v_top)
   connect by xparent_id = prior ID
   order siblings by upper(ser_title),ser_num,ser_ep_num, SER_EP_SQ_NUM,upper(title) -- sort children
 )
select *
from v_tree 
--where rnk <= 50
t Verbose: 1220 :      11|09:14:36.6605|HA8UCd|CJPOWERCAST|imfx v3 API took 0.250s '/api/v3/search/title?_dc=1688717675357'
t Transfer: 1220 :     11|09:14:37.0625|88wY_G|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1688717676059
t Transfer: 1220 :     11|09:14:37.0625|88wY_G|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:37.0625|88wY_G|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:37.0625|88wY_G|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:37.0635|88wY_G|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:37.0635|SWIP0O|CJPOWERCAST|OAuth: /api/v3/title/299390/versions?_dc=1688717676058
t Transfer: 1220 :     11|09:14:37.0635|SWIP0O|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:37.0635|SWIP0O|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:37.0635|SWIP0O|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:37.0635|SWIP0O|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|09:14:37.0645|88wY_G|CJPOWERCAST|StoreUserDataByKeys..
t Transfer: 1220 :     11|09:14:37.0645|88wY_G|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:37.0645|88wY_G|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:37.0645|88wY_G|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|09:14:37.0645|SWIP0O|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|09:14:37.0655|SWIP0O|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:37.0655|SWIP0O|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:37.0655|SWIP0O|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:37.0655|SWIP0O|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:37.0655|SWIP0O|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:37.0665|SWIP0O|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:37.0665|SWIP0O|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:37.0665|SWIP0O|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:37.0665|SWIP0O|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:37.0665|88wY_G|CJPOWERCAST|imfx v3 API took 0.035s '/api/user-preferences?_dc=1688717676059'
t Information: 1220 :  11|09:14:37.0675|SWIP0O|CJPOWERCAST|SearchVersion SQL:
 select  v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name)
    from TM_CFG_AUDIO_CONTENT_MS_TYPES audio
    where v.audio_type = audio.id   
    ) SOUND  ,(select min(from_date_time)
  from TM_PG_RL_PROD_DATE prodDate
 where prodDate.Tm_Pg_Rl_Id = v.id 
   ) PROD_FROM_DATE  ,(select min(to_date_time)
  from TM_PG_RL_PROD_DATE prodDate
 where prodDate.Tm_Pg_Rl_Id = v.id 
    ) PROD_TO_DATE  ,(select min(full_name)
  from tm_lang_data lang, TM_PG_RL_LANG_LNX link
 where lang.id = link.lang_id
   and link.tm_pg_rl_id = v.id) PROD_LANGUAGE  ,(SELECT min(COLOUR_NAME)
  FROM tm_cfg_colour_list list, tm_pg_rl ver
 where ver.col_mono = list.id
   and ver.id = v.id) PROD_COLOUR_TEXT  ,(SELECT min(cfg.prod_date_type_name)
 FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg
where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE  ,(select min(status.description)
  from TM_CFG_PGM_STATUS status
 where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name
  from TM_CFG_SUB_MEDIUM submed
 where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID 
    from TM_PORTAL_VERSION_CONFIG cvt
    where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL
    ) MP_CONFIG_ID     from 

  (select v.*,
  coalesce(v.primary_thumb_id,
          (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id)
) primary_thumb_id2
  from tmddba.tm_pg_rl v
 where v.item_type > 0
   and v.rl_deleted = 0) v

                    left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2
                    --sqlIdSearchJoin
                    where 1=1
                     AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0)
                    and v.id in
                    (select x.id from tmddba.tm_pg_rl x
                    start with x.id in (
                     select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m 
 where item_type>0 and rl_deleted=0  and m.PGM_ABS_ID=:param_0   AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0)
) A WHERE rnum>=1 and rnum <= 9999
                    ) connect by nocycle prior x.parent_id=x.id)
t Transfer: 1220 :     11|09:14:37.0675|SWIP0O|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:37.0675|SWIP0O|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:37.0675|SWIP0O|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|09:14:37.2685|SWIP0O|CJPOWERCAST|Running version search. User: 1165    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 40ms.  Returned lines: 0

t Verbose: 1220 :      11|09:14:37.2685|SWIP0O|CJPOWERCAST|imfx v3 API took 0.077s '/api/v3/title/299390/versions?_dc=1688717676058'
t Transfer: 1220 :     11|09:14:38.2735|Ys0iq7|CJPOWERCAST|OAuth: /api/v3/title/299544/versions?_dc=1688717677294
t Transfer: 1220 :     11|09:14:38.2735|Ys0iq7|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:38.2735|Ys0iq7|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:38.2735|Ys0iq7|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:38.2735|Ys0iq7|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|09:14:38.2735|Ys0iq7|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|09:14:38.2735|Ys0iq7|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:38.2735|Ys0iq7|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:38.2745|Ys0iq7|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:38.2745|Ys0iq7|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:38.2745|Ys0iq7|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:38.2745|Ys0iq7|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:38.2745|Ys0iq7|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:38.2745|Ys0iq7|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:38.2745|Ys0iq7|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|09:14:38.2745|Ys0iq7|CJPOWERCAST|SearchVersion SQL:
 select  v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name)
    from TM_CFG_AUDIO_CONTENT_MS_TYPES audio
    where v.audio_type = audio.id   
    ) SOUND  ,(select min(from_date_time)
  from TM_PG_RL_PROD_DATE prodDate
 where prodDate.Tm_Pg_Rl_Id = v.id 
   ) PROD_FROM_DATE  ,(select min(to_date_time)
  from TM_PG_RL_PROD_DATE prodDate
 where prodDate.Tm_Pg_Rl_Id = v.id 
    ) PROD_TO_DATE  ,(select min(full_name)
  from tm_lang_data lang, TM_PG_RL_LANG_LNX link
 where lang.id = link.lang_id
   and link.tm_pg_rl_id = v.id) PROD_LANGUAGE  ,(SELECT min(COLOUR_NAME)
  FROM tm_cfg_colour_list list, tm_pg_rl ver
 where ver.col_mono = list.id
   and ver.id = v.id) PROD_COLOUR_TEXT  ,(SELECT min(cfg.prod_date_type_name)
 FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg
where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE  ,(select min(status.description)
  from TM_CFG_PGM_STATUS status
 where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name
  from TM_CFG_SUB_MEDIUM submed
 where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID 
    from TM_PORTAL_VERSION_CONFIG cvt
    where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL
    ) MP_CONFIG_ID     from 

  (select v.*,
  coalesce(v.primary_thumb_id,
          (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id)
) primary_thumb_id2
  from tmddba.tm_pg_rl v
 where v.item_type > 0
   and v.rl_deleted = 0) v

                    left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2
                    --sqlIdSearchJoin
                    where 1=1
                     AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0)
                    and v.id in
                    (select x.id from tmddba.tm_pg_rl x
                    start with x.id in (
                     select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m 
 where item_type>0 and rl_deleted=0  and m.PGM_ABS_ID=:param_0   AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0)
) A WHERE rnum>=1 and rnum <= 9999
                    ) connect by nocycle prior x.parent_id=x.id)
t Transfer: 1220 :     11|09:14:38.2745|Ys0iq7|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:38.2755|Ys0iq7|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:38.2755|Ys0iq7|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|09:14:39.0795|Ys0iq7|CJPOWERCAST|Running version search. User: 1165    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 5ms.  Returned lines: 1
Oracle version search timing: 760ms.
SQL run:
 select  v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name)
    from TM_CFG_AUDIO_CONTENT_MS_TYPES audio
    where v.audio_type = audio.id   
    ) SOUND  ,(select min(from_date_time)
  from TM_PG_RL_PROD_DATE prodDate
 where prodDate.Tm_Pg_Rl_Id = v.id 
   ) PROD_FROM_DATE  ,(select min(to_date_time)
  from TM_PG_RL_PROD_DATE prodDate
 where prodDate.Tm_Pg_Rl_Id = v.id 
    ) PROD_TO_DATE  ,(select min(full_name)
  from tm_lang_data lang, TM_PG_RL_LANG_LNX link
 where lang.id = link.lang_id
   and link.tm_pg_rl_id = v.id) PROD_LANGUAGE  ,(SELECT min(COLOUR_NAME)
  FROM tm_cfg_colour_list list, tm_pg_rl ver
 where ver.col_mono = list.id
   and ver.id = v.id) PROD_COLOUR_TEXT  ,(SELECT min(cfg.prod_date_type_name)
 FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg
where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE  ,(select min(status.description)
  from TM_CFG_PGM_STATUS status
 where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name
  from TM_CFG_SUB_MEDIUM submed
 where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID 
    from TM_PORTAL_VERSION_CONFIG cvt
    where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL
    ) MP_CONFIG_ID     from 

  (select v.*,
  coalesce(v.primary_thumb_id,
          (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id)
) primary_thumb_id2
  from tmddba.tm_pg_rl v
 where v.item_type > 0
   and v.rl_deleted = 0) v

                    left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2
                    --sqlIdSearchJoin
                    where 1=1
                     AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0)
                    and v.id in
                    (select x.id from tmddba.tm_pg_rl x
                    start with x.id in (
                     select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m 
 where item_type>0 and rl_deleted=0  and m.PGM_ABS_ID=:param_0   AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0)
) A WHERE rnum>=1 and rnum <= 9999
                    ) connect by nocycle prior x.parent_id=x.id)

t Verbose: 1220 :      11|09:14:39.0795|Ys0iq7|CJPOWERCAST|imfx v3 API took 0.774s '/api/v3/title/299544/versions?_dc=1688717677294'
t Transfer: 1220 :     11|09:14:39.4815|fMP~4M|CJPOWERCAST|OAuth: /api/v3/title/299562/versions?_dc=1688717678500
t Transfer: 1220 :     11|09:14:39.4815|fMP~4M|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:39.4815|fMP~4M|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:39.4815|fMP~4M|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:39.4815|fMP~4M|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|09:14:39.4815|fMP~4M|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|09:14:39.4815|fMP~4M|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:39.4815|fMP~4M|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:39.4825|fMP~4M|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:39.4825|fMP~4M|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:39.4825|fMP~4M|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:39.4825|fMP~4M|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:39.4825|fMP~4M|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:39.4825|fMP~4M|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:39.4825|fMP~4M|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|09:14:39.4825|fMP~4M|CJPOWERCAST|SearchVersion SQL:
 select  v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name)
    from TM_CFG_AUDIO_CONTENT_MS_TYPES audio
    where v.audio_type = audio.id   
    ) SOUND  ,(select min(from_date_time)
  from TM_PG_RL_PROD_DATE prodDate
 where prodDate.Tm_Pg_Rl_Id = v.id 
   ) PROD_FROM_DATE  ,(select min(to_date_time)
  from TM_PG_RL_PROD_DATE prodDate
 where prodDate.Tm_Pg_Rl_Id = v.id 
    ) PROD_TO_DATE  ,(select min(full_name)
  from tm_lang_data lang, TM_PG_RL_LANG_LNX link
 where lang.id = link.lang_id
   and link.tm_pg_rl_id = v.id) PROD_LANGUAGE  ,(SELECT min(COLOUR_NAME)
  FROM tm_cfg_colour_list list, tm_pg_rl ver
 where ver.col_mono = list.id
   and ver.id = v.id) PROD_COLOUR_TEXT  ,(SELECT min(cfg.prod_date_type_name)
 FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg
where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE  ,(select min(status.description)
  from TM_CFG_PGM_STATUS status
 where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name
  from TM_CFG_SUB_MEDIUM submed
 where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID 
    from TM_PORTAL_VERSION_CONFIG cvt
    where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL
    ) MP_CONFIG_ID     from 

  (select v.*,
  coalesce(v.primary_thumb_id,
          (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id)
) primary_thumb_id2
  from tmddba.tm_pg_rl v
 where v.item_type > 0
   and v.rl_deleted = 0) v

                    left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2
                    --sqlIdSearchJoin
                    where 1=1
                     AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0)
                    and v.id in
                    (select x.id from tmddba.tm_pg_rl x
                    start with x.id in (
                     select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m 
 where item_type>0 and rl_deleted=0  and m.PGM_ABS_ID=:param_0   AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0)
) A WHERE rnum>=1 and rnum <= 9999
                    ) connect by nocycle prior x.parent_id=x.id)
t Transfer: 1220 :     11|09:14:39.4835|fMP~4M|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:39.4835|fMP~4M|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:39.4835|fMP~4M|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:39.6845|YhxmEM|CJPOWERCAST|OAuth: /api/v3/version/299545/media?_dc=1688717678535
t Transfer: 1220 :     11|09:14:39.6845|YhxmEM|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:39.6845|YhxmEM|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:39.6845|YhxmEM|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:39.6845|YhxmEM|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:39.6845|nIW28k|CJPOWERCAST|OAuth: /api/v3/version/299545/media?_dc=1688717678540
t Transfer: 1220 :     11|09:14:39.6845|nIW28k|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:39.6855|nIW28k|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:39.6855|nIW28k|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:39.6855|nIW28k|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|09:14:39.6855|YhxmEM|CJPOWERCAST|V3Api.SearchGeneric
t Information: 1220 :  11|09:14:39.6855|nIW28k|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|09:14:39.6855|nIW28k|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:39.6855|nIW28k|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:39.6855|YhxmEM|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:39.6855|nIW28k|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:39.6855|YhxmEM|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:39.6855|YhxmEM|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|09:14:39.6865|nIW28k|CJPOWERCAST|MediaSearch SQL:
--sqlFromPaging
select r.*,
    nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE,
    nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
    nvl(t.text_data_path,'') THUMBSERVER, 
    nvl(t.text_data_filename,'') THUMBFILE,
    nvl(t.text_id,-1) THUMBID , 
    (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status 
        WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , 
    (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , 
    (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , 
    (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records
            where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , 
    (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class
        where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, 
    (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names
        where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, 
    (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , 
    (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, 
    CASE
        WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED'
        WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE'
        WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED'
        ELSE ''
    END AS ORIGIN, 
    CASE
        WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached'
        WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached'
        ELSE ''
    END AS FLAGS, 
    (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang 
        where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , 
    (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names
        where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id
          and ctx.preferred_name = names.id) AGENCY_NUMBER, 
    (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, 
    (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, 
    (SELECT SUBSTR( trim( replace (replace (
          LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z
            FROM tm_media_tagging tt
              WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , 
    GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
    nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME 

    from (select t.*,
     coalesce(t.primary_thumb_id, 
             (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id)
) primary_thumb_id2
    from (
                 --sqlSubSelect   
                 select s.*  from
                (select a.*, rownum rnum from
                    (select  --sqlFrom
m.*
      from tmddba.tm_mis m 

--sqlWhere
where  media_type>0 and item_type>0  AND  PGM_PARENT_ID=:param_0  and m.mi_deleted=0   AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0)
 order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s 
     where rnum >= 1) t ) r
    
    ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat  from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk 
    ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t
    ,lateral(select /*+ NO_DECORRELATE */  d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename
        FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl 
    
     order by r.rnum

t Information: 1220 :  11|09:14:39.6865|YhxmEM|CJPOWERCAST|MediaSearch SQL:
--sqlFromPaging
select r.*,
    nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE,
    nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
    nvl(t.text_data_path,'') THUMBSERVER, 
    nvl(t.text_data_filename,'') THUMBFILE,
    nvl(t.text_id,-1) THUMBID , 
    (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status 
        WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , 
    (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , 
    (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , 
    (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records
            where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , 
    (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class
        where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, 
    (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names
        where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, 
    (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , 
    (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, 
    CASE
        WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED'
        WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE'
        WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED'
        ELSE ''
    END AS ORIGIN, 
    CASE
        WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached'
        WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached'
        ELSE ''
    END AS FLAGS, 
    (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang 
        where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , 
    (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names
        where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id
          and ctx.preferred_name = names.id) AGENCY_NUMBER, 
    (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, 
    (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, 
    (SELECT SUBSTR( trim( replace (replace (
          LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z
            FROM tm_media_tagging tt
              WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , 
    GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
    nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME 

    from (select t.*,
     coalesce(t.primary_thumb_id, 
             (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id)
) primary_thumb_id2
    from (
                 --sqlSubSelect   
                 select s.*  from
                (select a.*, rownum rnum from
                    (select  --sqlFrom
m.*
      from tmddba.tm_mis m 

--sqlWhere
where  media_type>0 and item_type>0  AND  PGM_PARENT_ID=:param_0  and m.mi_deleted=0   AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0)
 order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s 
     where rnum >= 1) t ) r
    
    ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat  from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk 
    ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t
    ,lateral(select /*+ NO_DECORRELATE */  d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename
        FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl 
    
     order by r.rnum

t Information: 1220 :  11|09:14:40.4905|fMP~4M|CJPOWERCAST|Running version search. User: 1165    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 5ms.  Returned lines: 1
Oracle version search timing: 996ms.
SQL run:
 select  v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name)
    from TM_CFG_AUDIO_CONTENT_MS_TYPES audio
    where v.audio_type = audio.id   
    ) SOUND  ,(select min(from_date_time)
  from TM_PG_RL_PROD_DATE prodDate
 where prodDate.Tm_Pg_Rl_Id = v.id 
   ) PROD_FROM_DATE  ,(select min(to_date_time)
  from TM_PG_RL_PROD_DATE prodDate
 where prodDate.Tm_Pg_Rl_Id = v.id 
    ) PROD_TO_DATE  ,(select min(full_name)
  from tm_lang_data lang, TM_PG_RL_LANG_LNX link
 where lang.id = link.lang_id
   and link.tm_pg_rl_id = v.id) PROD_LANGUAGE  ,(SELECT min(COLOUR_NAME)
  FROM tm_cfg_colour_list list, tm_pg_rl ver
 where ver.col_mono = list.id
   and ver.id = v.id) PROD_COLOUR_TEXT  ,(SELECT min(cfg.prod_date_type_name)
 FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg
where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = v.id ) PROD_DATE_TYPE  ,(select min(status.description)
  from TM_CFG_PGM_STATUS status
 where v.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name
  from TM_CFG_SUB_MEDIUM submed
 where v.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID 
    from TM_PORTAL_VERSION_CONFIG cvt
    where v.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL
    ) MP_CONFIG_ID     from 

  (select v.*,
  coalesce(v.primary_thumb_id,
          (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id)
) primary_thumb_id2
  from tmddba.tm_pg_rl v
 where v.item_type > 0
   and v.rl_deleted = 0) v

                    left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = v.primary_thumb_id2
                    --sqlIdSearchJoin
                    where 1=1
                     AND (INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|PMH|')>0 OR INSTR(v.OWNERS,'|PPL|')>0)
                    and v.id in
                    (select x.id from tmddba.tm_pg_rl x
                    start with x.id in (
                     select a.id from (select m.id, rownum rnum from tmddba.tm_pg_rl m 
 where item_type>0 and rl_deleted=0  and m.PGM_ABS_ID=:param_0   AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0)
) A WHERE rnum>=1 and rnum <= 9999
                    ) connect by nocycle prior x.parent_id=x.id)

t Verbose: 1220 :      11|09:14:40.4905|fMP~4M|CJPOWERCAST|imfx v3 API took 1.010s '/api/v3/title/299562/versions?_dc=1688717678500'
t Verbose: 1220 :      11|09:14:40.9545|YhxmEM|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o 
                    where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 
                    order by o.id desc fetch first 1 rows only)(+)
t Verbose: 1220 :      11|09:14:40.9545|nIW28k|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o 
                    where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 
                    order by o.id desc fetch first 1 rows only)(+)
t Transfer: 1220 :     11|09:14:40.9555|h7_m4G|CJPOWERCAST|OAuth: /api/v3/version/299563/media?_dc=1688717679802
t Transfer: 1220 :     11|09:14:40.9555|h7_m4G|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:40.9555|h7_m4G|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:40.9555|h7_m4G|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:40.9555|h7_m4G|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:40.9555|MZK0or|CJPOWERCAST|OAuth: /api/v3/version/299563/media?_dc=1688717679806
t Transfer: 1220 :     11|09:14:40.9565|MZK0or|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:40.9565|MZK0or|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:40.9565|MZK0or|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:40.9565|MZK0or|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|09:14:40.9565|h7_m4G|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|09:14:40.9565|h7_m4G|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:40.9575|h7_m4G|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:40.9575|h7_m4G|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|09:14:40.9575|MZK0or|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|09:14:40.9575|MZK0or|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:40.9575|MZK0or|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:40.9575|MZK0or|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|09:14:40.9585|h7_m4G|CJPOWERCAST|MediaSearch SQL:
--sqlFromPaging
select r.*,
    nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE,
    nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
    nvl(t.text_data_path,'') THUMBSERVER, 
    nvl(t.text_data_filename,'') THUMBFILE,
    nvl(t.text_id,-1) THUMBID , 
    (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status 
        WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , 
    (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , 
    (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , 
    (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records
            where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , 
    (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class
        where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, 
    (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names
        where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, 
    (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , 
    (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, 
    CASE
        WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED'
        WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE'
        WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED'
        ELSE ''
    END AS ORIGIN, 
    CASE
        WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached'
        WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached'
        ELSE ''
    END AS FLAGS, 
    (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang 
        where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , 
    (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names
        where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id
          and ctx.preferred_name = names.id) AGENCY_NUMBER, 
    (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, 
    (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, 
    (SELECT SUBSTR( trim( replace (replace (
          LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z
            FROM tm_media_tagging tt
              WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , 
    GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
    nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME 

    from (select t.*,
     coalesce(t.primary_thumb_id, 
             (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id)
) primary_thumb_id2
    from (
                 --sqlSubSelect   
                 select s.*  from
                (select a.*, rownum rnum from
                    (select  --sqlFrom
m.*
      from tmddba.tm_mis m 

--sqlWhere
where  media_type>0 and item_type>0  AND  PGM_PARENT_ID=:param_0  and m.mi_deleted=0   AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0)
 order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s 
     where rnum >= 1) t ) r
    
    ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat  from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk 
    ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t
    ,lateral(select /*+ NO_DECORRELATE */  d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename
        FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl 
    
     order by r.rnum

t Information: 1220 :  11|09:14:40.9585|MZK0or|CJPOWERCAST|MediaSearch SQL:
--sqlFromPaging
select r.*,
    nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE,
    nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
    nvl(t.text_data_path,'') THUMBSERVER, 
    nvl(t.text_data_filename,'') THUMBFILE,
    nvl(t.text_id,-1) THUMBID , 
    (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status 
        WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , 
    (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , 
    (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , 
    (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records
            where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , 
    (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class
        where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, 
    (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names
        where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, 
    (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , 
    (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, 
    CASE
        WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED'
        WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE'
        WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED'
        ELSE ''
    END AS ORIGIN, 
    CASE
        WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached'
        WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached'
        ELSE ''
    END AS FLAGS, 
    (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang 
        where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , 
    (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names
        where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id
          and ctx.preferred_name = names.id) AGENCY_NUMBER, 
    (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, 
    (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, 
    (SELECT SUBSTR( trim( replace (replace (
          LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z
            FROM tm_media_tagging tt
              WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , 
    GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
    nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME 

    from (select t.*,
     coalesce(t.primary_thumb_id, 
             (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id)
) primary_thumb_id2
    from (
                 --sqlSubSelect   
                 select s.*  from
                (select a.*, rownum rnum from
                    (select  --sqlFrom
m.*
      from tmddba.tm_mis m 

--sqlWhere
where  media_type>0 and item_type>0  AND  PGM_PARENT_ID=:param_0  and m.mi_deleted=0   AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0)
 order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s 
     where rnum >= 1) t ) r
    
    ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat  from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk 
    ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t
    ,lateral(select /*+ NO_DECORRELATE */  d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename
        FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl 
    
     order by r.rnum

t Verbose: 1220 :      11|09:14:40.9585|h7_m4G|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o 
                    where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 
                    order by o.id desc fetch first 1 rows only)(+)
t Information: 1220 :  11|09:14:40.9595|nIW28k|CJPOWERCAST|    timing: 00:00:01.2832535
t Verbose: 1220 :      11|09:14:40.9595|nIW28k|CJPOWERCAST|imfx v3 API took 1.295s '/api/v3/version/299545/media?_dc=1688717678540'
t Information: 1220 :  11|09:14:40.9595|YhxmEM|CJPOWERCAST|    timing: 00:00:01.2842753
t Verbose: 1220 :      11|09:14:40.9595|YhxmEM|CJPOWERCAST|imfx v3 API took 1.296s '/api/v3/version/299545/media?_dc=1688717678535'
t Information: 1220 :  11|09:14:40.9595|h7_m4G|CJPOWERCAST|    timing: 00:00:00.1186327
t Verbose: 1220 :      11|09:14:40.9595|h7_m4G|CJPOWERCAST|imfx v3 API took 0.119s '/api/v3/version/299563/media?_dc=1688717679802'
t Verbose: 1220 :      11|09:14:40.9605|MZK0or|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o 
                    where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 
                    order by o.id desc fetch first 1 rows only)(+)
t Information: 1220 :  11|09:14:41.1615|MZK0or|CJPOWERCAST|    timing: 00:00:00.2074176
t Verbose: 1220 :      11|09:14:41.1615|MZK0or|CJPOWERCAST|imfx v3 API took 0.208s '/api/v3/version/299563/media?_dc=1688717679806'
t Transfer: 1220 :     11|09:14:41.1615|nIW28k|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0178.mp4 subfolder 
t Transfer: 1220 :     11|09:14:41.1615|YhxmEM|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0178.mp4 subfolder 
t Transfer: 1220 :     11|09:14:41.1615|MZK0or|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0013.mp4 subfolder 
t Transfer: 1220 :     11|09:14:41.1615|MZK0or|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:14:41.1625|MZK0or|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:14:41.1625|nIW28k|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.mp4
t Transfer: 1220 :     11|09:14:41.1625|nIW28k|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.mp4
t Transfer: 1220 :     11|09:14:41.1625|MZK0or|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.1625|MZK0or|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.1625|nIW28k|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.1625|nIW28k|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.1625|nIW28k|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:41.1635|MZK0or|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:41.1635|YhxmEM|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.mp4
t Transfer: 1220 :     11|09:14:41.1635|YhxmEM|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.mp4
t Transfer: 1220 :     11|09:14:41.1635|YhxmEM|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.1635|YhxmEM|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.1635|YhxmEM|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:41.1635|h7_m4G|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0013.mp4 subfolder 
t Transfer: 1220 :     11|09:14:41.1635|h7_m4G|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:14:41.1645|h7_m4G|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:14:41.1645|h7_m4G|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.1645|h7_m4G|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.1645|h7_m4G|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:41.3655|MZK0or|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001993.mp4 subfolder 
t Transfer: 1220 :     11|09:14:41.3655|MZK0or|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4
t Transfer: 1220 :     11|09:14:41.3655|MZK0or|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4
t Transfer: 1220 :     11|09:14:41.3655|MZK0or|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.3655|MZK0or|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.3655|MZK0or|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:41.3655|h7_m4G|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001993.mp4 subfolder 
t Transfer: 1220 :     11|09:14:41.3655|h7_m4G|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4
t Transfer: 1220 :     11|09:14:41.3665|h7_m4G|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4
t Transfer: 1220 :     11|09:14:41.3665|h7_m4G|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.3665|h7_m4G|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.3665|h7_m4G|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:41.3665|nIW28k|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001992.mp4 subfolder 
t Transfer: 1220 :     11|09:14:41.3665|nIW28k|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4
t Transfer: 1220 :     11|09:14:41.3665|nIW28k|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4
t Transfer: 1220 :     11|09:14:41.3665|nIW28k|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.3665|nIW28k|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.3665|nIW28k|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:41.3675|YhxmEM|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001992.mp4 subfolder 
t Transfer: 1220 :     11|09:14:41.3675|YhxmEM|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4
t Transfer: 1220 :     11|09:14:41.3675|YhxmEM|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4
t Transfer: 1220 :     11|09:14:41.3675|YhxmEM|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.3675|YhxmEM|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.3675|YhxmEM|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:41.3675|MZK0or|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\GOPR0013.mp4 subfolder 
t Transfer: 1220 :     11|09:14:41.3675|MZK0or|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.3675|MZK0or|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.3675|MZK0or|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:41.3685|h7_m4G|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\GOPR0013.mp4 subfolder 
t Transfer: 1220 :     11|09:14:41.3685|h7_m4G|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.3685|h7_m4G|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.3685|h7_m4G|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:41.3685|nIW28k|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\N0001992.mp4 subfolder 
t Transfer: 1220 :     11|09:14:41.3685|nIW28k|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.3685|nIW28k|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.3685|nIW28k|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:41.3685|YhxmEM|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\N0001992.mp4 subfolder 
t Transfer: 1220 :     11|09:14:41.3685|YhxmEM|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.3695|YhxmEM|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.3695|YhxmEM|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:41.3695|MZK0or|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\N0001993.mp4 subfolder 
t Transfer: 1220 :     11|09:14:41.3695|MZK0or|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.3695|MZK0or|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.3695|MZK0or|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:41.3695|nIW28k|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0178.xml subfolder 
t Transfer: 1220 :     11|09:14:41.3695|nIW28k|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.xml
t Transfer: 1220 :     11|09:14:41.3695|nIW28k|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.xml
t Transfer: 1220 :     11|09:14:41.3695|nIW28k|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.3705|nIW28k|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.3705|nIW28k|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:41.3705|h7_m4G|CJPOWERCAST|GetUrl. Storage |Temp Storage| filename C:\TEMP\N0001993.mp4 subfolder 
t Transfer: 1220 :     11|09:14:41.3705|h7_m4G|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.3705|h7_m4G|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.3705|h7_m4G|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:41.3705|YhxmEM|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0178.xml subfolder 
t Transfer: 1220 :     11|09:14:41.3705|YhxmEM|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.xml
t Transfer: 1220 :     11|09:14:41.3705|YhxmEM|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0178.xml
t Transfer: 1220 :     11|09:14:41.3705|YhxmEM|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.3715|YhxmEM|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.3715|YhxmEM|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:41.5725|JgIwbi|CJPOWERCAST|OAuth: /api/v3/media/299528/carriers/digital?_dc=1688717680542
t Transfer: 1220 :     11|09:14:41.5725|JgIwbi|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.5725|JgIwbi|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.5725|JgIwbi|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:41.5725|JgIwbi|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|09:14:41.5725|JgIwbi|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|09:14:41.5725|JgIwbi|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.5725|JgIwbi|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.5725|JgIwbi|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:41.5735|JgIwbi|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.5735|JgIwbi|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.5735|JgIwbi|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:41.5735|sVkGvi|CJPOWERCAST|OAuth: /api/v3/media/299534/carriers/digital?_dc=1688717680589
t Transfer: 1220 :     11|09:14:41.5735|sVkGvi|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.5735|sVkGvi|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.5735|sVkGvi|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:41.5735|sVkGvi|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|09:14:41.5735|sVkGvi|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|09:14:41.5735|sVkGvi|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.5745|sVkGvi|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.5745|sVkGvi|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:41.5745|sVkGvi|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.5745|sVkGvi|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.5745|sVkGvi|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|09:14:41.7755|JgIwbi|CJPOWERCAST|SearchDigitalCarriersAdv SQL:
select r.*, l.dv_nam SRVER_ID_TEXT from ( select a.*, rownum rnum  from ( select  m.* from tmddba.tm_dfile m  where m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id)  where (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) and m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where mi.id = :param_0 AND (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) order by m.OS_FNAME, m.id  ) a where rownum <= 50) r left join tm_device_lst l on (r.srver_id = l.id)  where rnum >= 1 order by rnum
t Information: 1220 :  11|09:14:41.7755|sVkGvi|CJPOWERCAST|SearchDigitalCarriersAdv SQL:
select r.*, l.dv_nam SRVER_ID_TEXT from ( select a.*, rownum rnum  from ( select  m.* from tmddba.tm_dfile m  where m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id)  where (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) and m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where mi.id = :param_0 AND (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) order by m.OS_FNAME, m.id  ) a where rownum <= 50) r left join tm_device_lst l on (r.srver_id = l.id)  where rnum >= 1 order by rnum
t Transfer: 1220 :     11|09:14:41.7755|50kUJy|CJPOWERCAST|OAuth: /api/v3/media/299534/carriers/digital?_dc=1688717680809
t Transfer: 1220 :     11|09:14:41.7755|50kUJy|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.7755|50kUJy|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.7755|50kUJy|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:41.7755|50kUJy|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|09:14:41.7765|50kUJy|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|09:14:41.7765|50kUJy|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.7765|50kUJy|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.7765|50kUJy|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:41.7765|50kUJy|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:41.7765|50kUJy|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:41.7765|50kUJy|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|09:14:41.7765|50kUJy|CJPOWERCAST|SearchDigitalCarriersAdv SQL:
select r.*, l.dv_nam SRVER_ID_TEXT from ( select a.*, rownum rnum  from ( select  m.* from tmddba.tm_dfile m  where m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id)  where (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) and m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where mi.id = :param_0 AND (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) order by m.OS_FNAME, m.id  ) a where rownum <= 50) r left join tm_device_lst l on (r.srver_id = l.id)  where rnum >= 1 order by rnum
t Verbose: 1220 :      11|09:14:41.9775|JgIwbi|CJPOWERCAST|imfx v3 API took 0.339s '/api/v3/media/299528/carriers/digital?_dc=1688717680542'
t Verbose: 1220 :      11|09:14:41.9775|sVkGvi|CJPOWERCAST|imfx v3 API took 0.297s '/api/v3/media/299534/carriers/digital?_dc=1688717680589'
t Verbose: 1220 :      11|09:14:41.9775|50kUJy|CJPOWERCAST|imfx v3 API took 0.073s '/api/v3/media/299534/carriers/digital?_dc=1688717680809'
t Transfer: 1220 :     11|09:14:42.1785|nlchRf|CJPOWERCAST|OAuth: /api/v3/media/299528/carriers/digital?_dc=1688717681072
t Transfer: 1220 :     11|09:14:42.1785|nlchRf|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:42.1785|nlchRf|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:42.1785|nlchRf|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:42.1785|nlchRf|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|09:14:42.1785|nlchRf|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|09:14:42.1785|nlchRf|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:42.1785|nlchRf|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:42.1785|nlchRf|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:42.1795|nlchRf|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:42.1795|nlchRf|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:42.1795|nlchRf|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|09:14:42.1795|nlchRf|CJPOWERCAST|SearchDigitalCarriersAdv SQL:
select r.*, l.dv_nam SRVER_ID_TEXT from ( select a.*, rownum rnum  from ( select  m.* from tmddba.tm_dfile m  where m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id)  where (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) and m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where mi.id = :param_0 AND (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) order by m.OS_FNAME, m.id  ) a where rownum <= 50) r left join tm_device_lst l on (r.srver_id = l.id)  where rnum >= 1 order by rnum
t Verbose: 1220 :      11|09:14:42.1795|nlchRf|CJPOWERCAST|imfx v3 API took 0.011s '/api/v3/media/299528/carriers/digital?_dc=1688717681072'
t Transfer: 1220 :     11|09:14:43.3855|1nUfp~|CJPOWERCAST|OAuth: /api/v3/media/299560/carriers/digital?_dc=1688717682327
t Transfer: 1220 :     11|09:14:43.3855|1nUfp~|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:43.3855|1nUfp~|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:43.3855|1nUfp~|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:43.3855|1nUfp~|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|09:14:43.3855|1nUfp~|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|09:14:43.3855|1nUfp~|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:43.3865|1nUfp~|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:43.3865|1nUfp~|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:43.3865|1nUfp~|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:43.3865|1nUfp~|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:43.3865|1nUfp~|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|09:14:43.3865|1nUfp~|CJPOWERCAST|SearchDigitalCarriersAdv SQL:
select r.*, l.dv_nam SRVER_ID_TEXT from ( select a.*, rownum rnum  from ( select  m.* from tmddba.tm_dfile m  where m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id)  where (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) and m.id in (select l.dfile_id as ID from TMDDBA.tm_mi_dfile_lnx l join TMDDBA.TM_MIS mi on (l.mi_id = mi.id) where mi.id = :param_0 AND (INSTR(mi.OWNERS,'|SFP2|')>0 OR INSTR(mi.OWNERS,'|PSP|')>0 OR INSTR(mi.OWNERS,'|PMS|')>0 OR INSTR(mi.OWNERS,'|SFP1|')>0 OR INSTR(mi.OWNERS,'|PMH|')>0 OR INSTR(mi.OWNERS,'|PPL|')>0)and mi.MI_DELETED = 0 and mi.ITEM_TYPE > 0) order by m.OS_FNAME, m.id  ) a where rownum <= 50) r left join tm_device_lst l on (r.srver_id = l.id)  where rnum >= 1 order by rnum
t Verbose: 1220 :      11|09:14:43.3865|1nUfp~|CJPOWERCAST|imfx v3 API took 0.012s '/api/v3/media/299560/carriers/digital?_dc=1688717682327'
t Transfer: 1220 :     11|09:14:47.0035|fE8ANx|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=googleMapsApiSettings&_dc=1688717685528
t Transfer: 1220 :     11|09:14:47.0035|fE8ANx|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:47.0035|fE8ANx|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:47.0035|fE8ANx|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:47.0035|fE8ANx|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:47.0045|fE8ANx|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:47.0045|fE8ANx|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:47.0045|fE8ANx|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:47.0045|elWrv_|CJPOWERCAST|OAuth: /api/v3/media-details/299560?_dc=1688717685556
t Transfer: 1220 :     11|09:14:47.0045|elWrv_|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:47.0045|elWrv_|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:47.0045|elWrv_|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:47.0045|elWrv_|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:47.0045|elWrv_|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:47.0045|elWrv_|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:47.0055|elWrv_|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:47.0055|fE8ANx|CJPOWERCAST|imfx v3 API took 0.014s '/api/user-group-preferences?keys=googleMapsApiSettings&_dc=1688717685528'
t Information: 1220 :  11|09:14:47.6085|||TM_MIS. LoadSubtitles for ID: 299560
t Information: 1220 :  11|09:14:47.6085|||TM_MIS. LoadSubtitles for ID: 299560. SQL: 'select m.id, m.m_ctnr_id, m.m_ctnr_loc, m.modified_dt, m.tv_std, m.m_ctnr_fmt_id, d.sub_folder,
    nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id
  from tm_mis m
left join tm_dfile d on (m.externally_owned_id=d.id)
where m.mi_deleted=0 and m.item_type>0 and m.media_type=101 and m.PGM_PARENT_ID=299563'
t Information: 1220 :  11|09:14:47.6085|||TM_MIS. LoadSubtitles for ID: 299560 found no subtitles.
t Verbose: 1220 :      11|09:14:47.6085|elWrv_|CJPOWERCAST|imfx v3 API took 0.673s '/api/v3/media-details/299560?_dc=1688717685556'
t Transfer: 1220 :     11|09:14:47.6085|elWrv_|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0013.mp4 subfolder 
t Transfer: 1220 :     11|09:14:47.6085|elWrv_|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:14:47.6085|elWrv_|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:14:47.6094|elWrv_|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:47.6094|elWrv_|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:47.6094|elWrv_|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:48.0115|X5ecwo|CJPOWERCAST|OAuth: /api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1688717686934
t Transfer: 1220 :     11|09:14:48.0115|X5ecwo|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:48.0115|X5ecwo|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:48.0115|X5ecwo|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:48.0115|X5ecwo|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:48.0115|X5ecwo|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:48.0115|X5ecwo|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:48.0115|X5ecwo|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|09:14:48.0124|X5ecwo|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 5
t Information: 1220 :  11|09:14:48.0124|X5ecwo|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 0
t Information: 1220 :  11|09:14:48.0124|X5ecwo|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 5
t Information: 1220 :  11|09:14:48.0124|X5ecwo|CJPOWERCAST|GetSystemPref. Pref: DetailsView, Type: -4013, subType: 0
t Verbose: 1220 :      11|09:14:48.0124|X5ecwo|CJPOWERCAST|imfx v3 API took 0.073s '/api/v3/detailsview/MediaDetails/5?lang=en-GB&_dc=1688717686934'
t Transfer: 1220 :     11|09:14:48.4145|6lq7mF|CJPOWERCAST|OAuth: /api/v3/media-captions/299560?_dc=1688717687305
t Transfer: 1220 :     11|09:14:48.4145|6lq7mF|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:48.4145|6lq7mF|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:48.4145|6lq7mF|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:48.4155|6lq7mF|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:48.4155|EDglbg|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=googleMapsApiSettings&_dc=1688717687341
t Transfer: 1220 :     11|09:14:48.4155|EDglbg|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:48.4155|EDglbg|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:48.4155|EDglbg|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:48.4155|EDglbg|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:48.4165|GcFcup|CJPOWERCAST|OAuth: /api/v3/mediavideo/299560?info=smudge,scene,audiovolume&_dc=1688717687340
t Transfer: 1220 :     11|09:14:48.4165|GcFcup|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:48.4165|GcFcup|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:48.4165|GcFcup|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:48.4165|GcFcup|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:48.4165|EDglbg|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:48.4175|EDglbg|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:48.4175|EDglbg|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:48.4175|6lq7mF|CJPOWERCAST|imfx v3 API took 0.043s '/api/v3/media-captions/299560?_dc=1688717687305'
t Verbose: 1220 :      11|09:14:48.4175|EDglbg|CJPOWERCAST|imfx v3 API took 0.017s '/api/user-group-preferences?keys=googleMapsApiSettings&_dc=1688717687341'
t Transfer: 1220 :     11|09:14:48.4175|GcFcup|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0013.mp4 subfolder 
t Transfer: 1220 :     11|09:14:48.4184|GcFcup|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:14:48.4184|GcFcup|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:14:48.4184|GcFcup|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:48.4184|GcFcup|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:48.4184|GcFcup|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:48.4184|avdoqY|CJPOWERCAST|OAuth: /api/lookups/FriendlyNames?_dc=1688717687420
t Transfer: 1220 :     11|09:14:48.4194|avdoqY|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:48.4194|avdoqY|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:48.4194|avdoqY|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:48.4194|avdoqY|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|09:14:48.4194|avdoqY|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/FriendlyNames?_dc=1688717687420'
t Transfer: 1220 :     11|09:14:48.4194|Sxr3BM|CJPOWERCAST|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1688717687455
t Transfer: 1220 :     11|09:14:48.4205|Sxr3BM|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:48.4205|Sxr3BM|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:48.4205|Sxr3BM|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:48.4205|Sxr3BM|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:48.4205|Sxr3BM|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:48.4205|Sxr3BM|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:48.4205|Sxr3BM|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:14:48.4205|1Qrg_4|CJPOWERCAST|OAuth: /api/settings/user/videoPlayerSettings?_dc=1688717687458
t Transfer: 1220 :     11|09:14:48.4215|1Qrg_4|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:48.4215|1Qrg_4|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:48.4215|1Qrg_4|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:48.4215|1Qrg_4|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:48.4215|1Qrg_4|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:48.4215|1Qrg_4|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:48.4215|1Qrg_4|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:48.4215|GcFcup|CJPOWERCAST|imfx v3 API took 0.122s '/api/v3/mediavideo/299560?info=smudge,scene,audiovolume&_dc=1688717687340'
t Verbose: 1220 :      11|09:14:48.4215|1Qrg_4|CJPOWERCAST|imfx v3 API took 0.006s '/api/settings/user/videoPlayerSettings?_dc=1688717687458'
t Verbose: 1220 :      11|09:14:48.4215|Sxr3BM|CJPOWERCAST|imfx v3 API took 0.012s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1688717687455'
t Transfer: 1220 :     11|09:14:48.6235|9ZStvl|CJPOWERCAST|OAuth: /api/v3/ai-tags/299560?_dc=1688717687532
t Transfer: 1220 :     11|09:14:48.6235|9ZStvl|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:48.6235|9ZStvl|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:48.6235|9ZStvl|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:48.6235|9ZStvl|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|09:14:48.6235|9ZStvl|CJPOWERCAST|V3Api.GetMediaAiTags
t Transfer: 1220 :     11|09:14:48.6235|h1sgci|CJPOWERCAST|OAuth: /api/v3/mediavideo/299560?info=smudge&_dc=1688717687534
t Transfer: 1220 :     11|09:14:48.6245|h1sgci|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:48.6245|h1sgci|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:48.6245|h1sgci|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:48.6245|h1sgci|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:14:48.6245|h1sgci|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0013.mp4 subfolder 
t Transfer: 1220 :     11|09:14:48.6245|h1sgci|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:14:48.6255|h1sgci|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:14:48.6255|h1sgci|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:48.6255|h1sgci|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:48.6255|h1sgci|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:48.6255|h1sgci|CJPOWERCAST|imfx v3 API took 0.017s '/api/v3/mediavideo/299560?info=smudge&_dc=1688717687534'
t Verbose: 1220 :      11|09:14:48.6255|9ZStvl|CJPOWERCAST|imfx v3 API took 0.025s '/api/v3/ai-tags/299560?_dc=1688717687532'
t Transfer: 1220 :     11|09:14:48.8275|umVy21|CJPOWERCAST|OAuth: /api/metadata/4000/299560?_dc=1688717687595
t Transfer: 1220 :     11|09:14:48.8275|umVy21|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:14:48.8275|umVy21|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:14:48.8275|umVy21|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:14:48.8275|umVy21|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|09:14:48.8275|umVy21|CJPOWERCAST|imfx v3 API took 0.056s '/api/metadata/4000/299560?_dc=1688717687595'
t Transfer: 1220 :     11|09:15:18.5714|zZdcb2|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1688717717430
t Transfer: 1220 :     11|09:15:18.5714|zZdcb2|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:18.5714|zZdcb2|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:18.5714|zZdcb2|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:15:18.5714|zZdcb2|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:15:18.5714|Fh0t6o|CJPOWERCAST|OAuth: /api/v3/search/versions?_dc=1688717717429
t Transfer: 1220 :     11|09:15:18.5714|Fh0t6o|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:18.5725|Fh0t6o|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:18.5725|Fh0t6o|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:15:18.5725|Fh0t6o|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|09:15:18.5725|zZdcb2|CJPOWERCAST|V3Api.SearchMedia
t Information: 1220 :  11|09:15:18.5725|zZdcb2|CJPOWERCAST|V3Api.SearchGeneric
t Information: 1220 :  11|09:15:18.5725|Fh0t6o|CJPOWERCAST|V3Api.SearchVersions
t Information: 1220 :  11|09:15:18.5725|Fh0t6o|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|09:15:18.5725|Fh0t6o|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:18.5725|Fh0t6o|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:18.5725|Fh0t6o|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:15:18.5735|zZdcb2|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:18.5735|zZdcb2|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:18.5735|Fh0t6o|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:18.5735|zZdcb2|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:15:18.5735|Fh0t6o|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:18.5735|Fh0t6o|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|09:15:18.5735|zZdcb2|CJPOWERCAST|MediaSearch SQL:
--sqlFromPaging
select r.*,
    nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE,
    nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
    nvl(t.text_data_path,'') THUMBSERVER, 
    nvl(t.text_data_filename,'') THUMBFILE,
    nvl(t.text_id,-1) THUMBID , 
    (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status 
        WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , 
    (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , 
    (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , 
    (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records
            where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , 
    (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class
        where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, 
    (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names
        where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, 
    (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , 
    (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, 
    CASE
        WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED'
        WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE'
        WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED'
        ELSE ''
    END AS ORIGIN, 
    CASE
        WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached'
        WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached'
        ELSE ''
    END AS FLAGS, 
    (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang 
        where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , 
    (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names
        where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id
          and ctx.preferred_name = names.id) AGENCY_NUMBER, 
    (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, 
    (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, 
    (SELECT SUBSTR( trim( replace (replace (
          LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z
            FROM tm_media_tagging tt
              WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , 
    GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
    nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME 

    from (select t.*,
     coalesce(t.primary_thumb_id, 
             (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id)
) primary_thumb_id2
    from (
                 --sqlSubSelect   
                 select s.*  from
                (select a.*, rownum rnum from
                    (select  --sqlFrom
m.*
      from tmddba.tm_mis m 

--sqlWhere
where  media_type>0 and item_type>0  AND   m.ID = :param_0  and m.mi_deleted=0   AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0)
 order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s 
     where rnum >= 1) t ) r
    
    ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat  from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk 
    ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t
    ,lateral(select /*+ NO_DECORRELATE */  d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename
        FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl 
    
     order by r.rnum

t Information: 1220 :  11|09:15:18.5745|Fh0t6o|CJPOWERCAST|SearchVersion SQL:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name)
    from TM_CFG_AUDIO_CONTENT_MS_TYPES audio
    where m.audio_type = audio.id   
    ) SOUND  ,(select min(from_date_time)
  from TM_PG_RL_PROD_DATE prodDate
 where prodDate.Tm_Pg_Rl_Id = m.id 
   ) PROD_FROM_DATE  ,(select min(to_date_time)
  from TM_PG_RL_PROD_DATE prodDate
 where prodDate.Tm_Pg_Rl_Id = m.id 
    ) PROD_TO_DATE  ,(select min(full_name)
  from tm_lang_data lang, TM_PG_RL_LANG_LNX link
 where lang.id = link.lang_id
   and link.tm_pg_rl_id = m.id) PROD_LANGUAGE  ,(SELECT min(COLOUR_NAME)
  FROM tm_cfg_colour_list list, tm_pg_rl ver
 where ver.col_mono = list.id
   and ver.id = m.id) PROD_COLOUR_TEXT  ,(SELECT min(cfg.prod_date_type_name)
 FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg
where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = m.id ) PROD_DATE_TYPE  ,(select min(status.description)
  from TM_CFG_PGM_STATUS status
 where m.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name
  from TM_CFG_SUB_MEDIUM submed
 where m.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID 
    from TM_PORTAL_VERSION_CONFIG cvt
    where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL
    ) MP_CONFIG_ID     

  from (select v.*,
    coalesce(v.primary_thumb_id,
          (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id)
) primary_thumb_id2
  from tmddba.tm_pg_rl v) m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2
 where item_type>0 and rl_deleted=0  and  m.ID = :param_0  AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0)
 order by m.title,m.id) a where rownum <= 50) r where rnum >=1 order by rnum
t Information: 1220 :  11|09:15:18.9765|Fh0t6o|CJPOWERCAST|Running version search. User: 1165    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 9ms.  Returned lines: 1
Oracle version search timing: 495ms.
SQL run:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name)
    from TM_CFG_AUDIO_CONTENT_MS_TYPES audio
    where m.audio_type = audio.id   
    ) SOUND  ,(select min(from_date_time)
  from TM_PG_RL_PROD_DATE prodDate
 where prodDate.Tm_Pg_Rl_Id = m.id 
   ) PROD_FROM_DATE  ,(select min(to_date_time)
  from TM_PG_RL_PROD_DATE prodDate
 where prodDate.Tm_Pg_Rl_Id = m.id 
    ) PROD_TO_DATE  ,(select min(full_name)
  from tm_lang_data lang, TM_PG_RL_LANG_LNX link
 where lang.id = link.lang_id
   and link.tm_pg_rl_id = m.id) PROD_LANGUAGE  ,(SELECT min(COLOUR_NAME)
  FROM tm_cfg_colour_list list, tm_pg_rl ver
 where ver.col_mono = list.id
   and ver.id = m.id) PROD_COLOUR_TEXT  ,(SELECT min(cfg.prod_date_type_name)
 FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg
where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = m.id ) PROD_DATE_TYPE  ,(select min(status.description)
  from TM_CFG_PGM_STATUS status
 where m.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name
  from TM_CFG_SUB_MEDIUM submed
 where m.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID 
    from TM_PORTAL_VERSION_CONFIG cvt
    where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL
    ) MP_CONFIG_ID     

  from (select v.*,
    coalesce(v.primary_thumb_id,
          (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id)
) primary_thumb_id2
  from tmddba.tm_pg_rl v) m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2
 where item_type>0 and rl_deleted=0  and  m.ID = :param_0  AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0)
 order by m.title,m.id) a where rownum <= 50) r where rnum >=1 order by rnum

t Verbose: 1220 :      11|09:15:18.9765|Fh0t6o|CJPOWERCAST|imfx v3 API took 0.518s '/api/v3/search/versions?_dc=1688717717429'
t Verbose: 1220 :      11|09:15:19.1774|zZdcb2|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o 
                    where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 
                    order by o.id desc fetch first 1 rows only)(+)
t Information: 1220 :  11|09:15:19.1774|zZdcb2|CJPOWERCAST|    timing: 00:00:00.7259259
t Verbose: 1220 :      11|09:15:19.1774|zZdcb2|CJPOWERCAST|imfx v3 API took 0.727s '/api/v3/search/Media?_dc=1688717717430'
t Transfer: 1220 :     11|09:15:19.1774|zZdcb2|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0013.mp4 subfolder 
t Transfer: 1220 :     11|09:15:19.1774|zZdcb2|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:15:19.1774|zZdcb2|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:15:19.1774|zZdcb2|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:19.1774|zZdcb2|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:19.1784|zZdcb2|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:15:47.3154|fmK8AQ|CJPOWERCAST|OAuth: /api/v3/media-details/299560?_dc=1688717746234
t Transfer: 1220 :     11|09:15:47.3154|fmK8AQ|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:47.3154|fmK8AQ|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:47.3154|fmK8AQ|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:15:47.3154|fmK8AQ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:15:47.3154|fmK8AQ|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:47.3154|fmK8AQ|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:47.3154|fmK8AQ|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|09:15:47.3164|||TM_MIS. LoadSubtitles for ID: 299560
t Information: 1220 :  11|09:15:47.3164|||TM_MIS. LoadSubtitles for ID: 299560. SQL: 'select m.id, m.m_ctnr_id, m.m_ctnr_loc, m.modified_dt, m.tv_std, m.m_ctnr_fmt_id, d.sub_folder,
    nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id
  from tm_mis m
left join tm_dfile d on (m.externally_owned_id=d.id)
where m.mi_deleted=0 and m.item_type>0 and m.media_type=101 and m.PGM_PARENT_ID=299563'
t Information: 1220 :  11|09:15:47.3164|||TM_MIS. LoadSubtitles for ID: 299560 found no subtitles.
t Verbose: 1220 :      11|09:15:47.3164|fmK8AQ|CJPOWERCAST|imfx v3 API took 0.022s '/api/v3/media-details/299560?_dc=1688717746234'
t Transfer: 1220 :     11|09:15:47.3164|fmK8AQ|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0013.mp4 subfolder 
t Transfer: 1220 :     11|09:15:47.3164|fmK8AQ|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:15:47.3164|fmK8AQ|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:15:47.3164|fmK8AQ|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:47.3164|fmK8AQ|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:47.3164|fmK8AQ|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:15:47.7194|r4NpWG|CJPOWERCAST|OAuth: /api/v3/media-captions/299560?_dc=1688717746587
t Transfer: 1220 :     11|09:15:47.7194|r4NpWG|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:47.7194|r4NpWG|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:47.7194|r4NpWG|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:15:47.7194|r4NpWG|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|09:15:47.7194|r4NpWG|CJPOWERCAST|imfx v3 API took 0.005s '/api/v3/media-captions/299560?_dc=1688717746587'
t Transfer: 1220 :     11|09:15:47.7194|9qtbUh|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=googleMapsApiSettings&_dc=1688717746605
t Transfer: 1220 :     11|09:15:47.7194|9qtbUh|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:47.7204|9qtbUh|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:47.7204|9qtbUh|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:15:47.7204|9qtbUh|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:15:47.7204|9qtbUh|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:47.7204|9qtbUh|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:47.7204|9qtbUh|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:15:47.7204|KoRNh4|CJPOWERCAST|OAuth: /api/v3/mediavideo/299560?info=smudge,scene,audiovolume&_dc=1688717746604
t Transfer: 1220 :     11|09:15:47.7204|KoRNh4|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:47.7204|KoRNh4|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:47.7204|KoRNh4|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:15:47.7214|KoRNh4|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|09:15:47.7214|9qtbUh|CJPOWERCAST|imfx v3 API took 0.005s '/api/user-group-preferences?keys=googleMapsApiSettings&_dc=1688717746605'
t Transfer: 1220 :     11|09:15:47.7214|KoRNh4|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0013.mp4 subfolder 
t Transfer: 1220 :     11|09:15:47.7214|KoRNh4|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:15:47.7214|KoRNh4|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:15:47.7214|KoRNh4|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:47.7214|KoRNh4|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:47.7214|KoRNh4|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:15:47.7214|KoRNh4|CJPOWERCAST|imfx v3 API took 0.026s '/api/v3/mediavideo/299560?info=smudge,scene,audiovolume&_dc=1688717746604'
t Transfer: 1220 :     11|09:15:47.9234|4HASiL|CJPOWERCAST|OAuth: /api/v3/ai-tags/299560?_dc=1688717746806
t Transfer: 1220 :     11|09:15:47.9234|0ID6du|CJPOWERCAST|OAuth: /api/v3/mediavideo/299560?info=smudge&_dc=1688717746808
t Transfer: 1220 :     11|09:15:47.9234|4HASiL|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:47.9234|0ID6du|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:47.9234|4HASiL|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:47.9234|0ID6du|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:47.9234|4HASiL|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:15:47.9234|0ID6du|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:15:47.9234|0ID6du|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|09:15:47.9244|4HASiL|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|09:15:47.9244|4HASiL|CJPOWERCAST|V3Api.GetMediaAiTags
t Transfer: 1220 :     11|09:15:47.9244|0ID6du|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0013.mp4 subfolder 
t Transfer: 1220 :     11|09:15:47.9244|0ID6du|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:15:47.9244|0ID6du|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:15:47.9244|0ID6du|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:47.9244|0ID6du|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:47.9244|0ID6du|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:15:47.9244|4HASiL|CJPOWERCAST|imfx v3 API took 0.006s '/api/v3/ai-tags/299560?_dc=1688717746806'
t Verbose: 1220 :      11|09:15:47.9254|0ID6du|CJPOWERCAST|imfx v3 API took 0.014s '/api/v3/mediavideo/299560?info=smudge&_dc=1688717746808'
t Transfer: 1220 :     11|09:15:47.9254|XG312X|CJPOWERCAST|OAuth: /api/metadata/4000/299560?_dc=1688717746867
t Transfer: 1220 :     11|09:15:47.9254|XG312X|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:47.9254|XG312X|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:47.9254|XG312X|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:15:47.9254|XG312X|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|09:15:47.9254|XG312X|CJPOWERCAST|imfx v3 API took 0.003s '/api/metadata/4000/299560?_dc=1688717746867'
t Transfer: 1220 :     11|09:15:53.7544|OJ4G4t|CJPOWERCAST|OAuth: /api/v3/search/Media?_dc=1688717752688
t Transfer: 1220 :     11|09:15:53.7544|AdEJ_I|CJPOWERCAST|OAuth: /api/v3/search/versions?_dc=1688717752687
t Transfer: 1220 :     11|09:15:53.7544|OJ4G4t|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:53.7544|AdEJ_I|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:53.7544|AdEJ_I|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:53.7544|OJ4G4t|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:53.7544|AdEJ_I|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:15:53.7544|OJ4G4t|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:15:53.7554|AdEJ_I|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|09:15:53.7554|OJ4G4t|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|09:15:53.7554|OJ4G4t|CJPOWERCAST|V3Api.SearchMedia
t Information: 1220 :  11|09:15:53.7554|OJ4G4t|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|09:15:53.7554|OJ4G4t|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:53.7554|OJ4G4t|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:53.7554|OJ4G4t|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|09:15:53.7554|AdEJ_I|CJPOWERCAST|V3Api.SearchVersions
t Information: 1220 :  11|09:15:53.7554|AdEJ_I|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|09:15:53.7554|AdEJ_I|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:53.7554|AdEJ_I|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:53.7564|AdEJ_I|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:15:53.7564|AdEJ_I|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:53.7564|AdEJ_I|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:53.7564|AdEJ_I|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|09:15:53.7564|OJ4G4t|CJPOWERCAST|MediaSearch SQL:
--sqlFromPaging
select r.*,
    nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE,
    nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
    nvl(t.text_data_path,'') THUMBSERVER, 
    nvl(t.text_data_filename,'') THUMBFILE,
    nvl(t.text_id,-1) THUMBID , 
    (SELECT min(status.ACCESS_STATUS_NAME) FROM TMDDBA.TM_ACCESS_STATUS statusLnx, TM_CFG_ACCESS_STATUS status 
        WHERE statusLnx.Media_Id = r.id and statusLnx.Status_Id = status.id) ACCESS_STATUS , (select min(acq.ext_ref) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) CONSIGNMENT_NUMBER , 
    (select min(acq.alt_id1) from tm_acq acq, tm_acq_object obj where r.miid2 = obj.object_id and obj.acq_id = acq.id) TRANSFER_NUMBER , 
    (select min(crs.series_number) from tm_series_data crs where crs.id = r.GROUP_SERIES_ID) CRS_SERIES , 
    (select min(DISPOSAL_NAME) from TM_ACQ_DISPOSAL status, tm_disposal_records records
            where status.id = records.disposal_status_id and records.miid = r.id) DISPOSAL_STATUS , 
    (select min(class.class_number) from TM_ACQ_DISPOSAL status, tm_disposal_records records, tm_disposal_classes class
        where status.id = records.disposal_status_id and records.miid = r.id and class.id = records.disposal_class_id) DISPOSAL_CLASS, 
    (select min(names.concat_search_name) from tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names
        where r.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id and ctx.preferred_name = names.id) AGENCY, 
    (select min(c.u_id_ext1) from tmddba.tm_mi_tpi_lnx lnx, tm_ctnrs c where c.u_id = lnx.tpiid and lnx.miid = r.id) U_ID_EXT1 , 
    (select t.name from TM_CFG_MI_FMT_TYP t where t.id = r.mi_fmt_type) ITEM_FORMAT_TEXT, 
    CASE
        WHEN BITAND(r.COMPIL, 2) = 2 THEN 'SUPPLIED'
        WHEN BITAND(r.COMPIL, 4) = 4 THEN 'MADE'
        WHEN BITAND(r.COMPIL, 134217728) = 134217728 THEN 'IMPORTED'
        ELSE ''
    END AS ORIGIN, 
    CASE
        WHEN BITAND(r.COMPIL, 512) = 512 THEN 'Attached'
        WHEN BITAND(r.COMPIL, 1024) = 1024 THEN 'Un-Attached'
        ELSE ''
    END AS FLAGS, 
    (select min(lang.full_name) from TM_PG_RL_LANG_LNX lnx, TM_LANG_DATA lang 
        where lnx.tm_pg_rl_id = r.pgm_parent_id and lnx.lang_id = lang.id) AS PROD_LANGUAGE , 
    (select min(ctx.ITFC_CODE) from tm_mis mis, tm_mi_tpi_lnx links, tm_acq acq, tm_acq_object obj, tm_entities ctx, tm_names names
        where mis.id = r.id and links.miid = mis.id and mis.miid2 = obj.object_id and obj.acq_id = acq.id and acq.source = ctx.id
          and ctx.preferred_name = names.id) AGENCY_NUMBER, 
    (select min(status.description) from TM_CFG_PGM_STATUS status where r.status = status.id) PGM_STATUS_TEXT, 
    (select min(ver.DUR) from TM_PG_RL ver where r.pgm_PARENT_ID = ver.id) AS VERSION_DUR , (select tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = r.net_grp_id) CHANNEL_GROUP, 
    (SELECT SUBSTR( trim( replace (replace (
          LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z
            FROM tm_media_tagging tt
              WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , 
    GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
    nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME 

    from (select t.*,
     coalesce(t.primary_thumb_id, 
             (select v.primary_thumb_id from tm_pg_rl v where v.id=t.pgm_parent_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.pgm_abs_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs_id), 
             (select a.primary_thumb_id from tm_pg_abs a where a.id=t.ser_abs2_id)
) primary_thumb_id2
    from (
                 --sqlSubSelect   
                 select s.*  from
                (select a.*, rownum rnum from
                    (select  --sqlFrom
m.*
      from tmddba.tm_mis m 

--sqlWhere
where  media_type>0 and item_type>0  AND   m.ID = :param_0  and m.mi_deleted=0   AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0)
 order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) s 
     where rnum >= 1) t ) r
    
    ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat  from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk 
    ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t
    ,lateral(select /*+ NO_DECORRELATE */  d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename
        FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl 
    
     order by r.rnum

t Information: 1220 :  11|09:15:53.7564|AdEJ_I|CJPOWERCAST|SearchVersion SQL:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name)
    from TM_CFG_AUDIO_CONTENT_MS_TYPES audio
    where m.audio_type = audio.id   
    ) SOUND  ,(select min(from_date_time)
  from TM_PG_RL_PROD_DATE prodDate
 where prodDate.Tm_Pg_Rl_Id = m.id 
   ) PROD_FROM_DATE  ,(select min(to_date_time)
  from TM_PG_RL_PROD_DATE prodDate
 where prodDate.Tm_Pg_Rl_Id = m.id 
    ) PROD_TO_DATE  ,(select min(full_name)
  from tm_lang_data lang, TM_PG_RL_LANG_LNX link
 where lang.id = link.lang_id
   and link.tm_pg_rl_id = m.id) PROD_LANGUAGE  ,(SELECT min(COLOUR_NAME)
  FROM tm_cfg_colour_list list, tm_pg_rl ver
 where ver.col_mono = list.id
   and ver.id = m.id) PROD_COLOUR_TEXT  ,(SELECT min(cfg.prod_date_type_name)
 FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg
where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = m.id ) PROD_DATE_TYPE  ,(select min(status.description)
  from TM_CFG_PGM_STATUS status
 where m.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name
  from TM_CFG_SUB_MEDIUM submed
 where m.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID 
    from TM_PORTAL_VERSION_CONFIG cvt
    where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL
    ) MP_CONFIG_ID     

  from (select v.*,
    coalesce(v.primary_thumb_id,
          (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id)
) primary_thumb_id2
  from tmddba.tm_pg_rl v) m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2
 where item_type>0 and rl_deleted=0  and  m.ID = :param_0  AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0)
 order by m.title,m.id) a where rownum <= 50) r where rnum >=1 order by rnum
t Information: 1220 :  11|09:15:53.7574|AdEJ_I|CJPOWERCAST|Running version search. User: 1165    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 2ms.  Returned lines: 1
Oracle version search timing: 8ms.
SQL run:
 select * from (select a.*, rownum rnum  from ( select  m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select min(name)
    from TM_CFG_AUDIO_CONTENT_MS_TYPES audio
    where m.audio_type = audio.id   
    ) SOUND  ,(select min(from_date_time)
  from TM_PG_RL_PROD_DATE prodDate
 where prodDate.Tm_Pg_Rl_Id = m.id 
   ) PROD_FROM_DATE  ,(select min(to_date_time)
  from TM_PG_RL_PROD_DATE prodDate
 where prodDate.Tm_Pg_Rl_Id = m.id 
    ) PROD_TO_DATE  ,(select min(full_name)
  from tm_lang_data lang, TM_PG_RL_LANG_LNX link
 where lang.id = link.lang_id
   and link.tm_pg_rl_id = m.id) PROD_LANGUAGE  ,(SELECT min(COLOUR_NAME)
  FROM tm_cfg_colour_list list, tm_pg_rl ver
 where ver.col_mono = list.id
   and ver.id = m.id) PROD_COLOUR_TEXT  ,(SELECT min(cfg.prod_date_type_name)
 FROM TM_PG_RL_PROD_DATE pg_rl, tm_cfg_prod_date_type cfg
where cfg.id = pg_rl.PROD_DATE_TYPE_ID and TM_PG_RL_ID = m.id ) PROD_DATE_TYPE  ,(select min(status.description)
  from TM_CFG_PGM_STATUS status
 where m.ITEM_STATUS_ID = status.id) PGM_STATUS_TEXT ,(select submed.sub_medium_name
  from TM_CFG_SUB_MEDIUM submed
 where m.SUB_MEDIUM_ID = submed.id) SUB_MEDIUM_TEXT, (select cvt.ID 
    from TM_PORTAL_VERSION_CONFIG cvt
    where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL
    ) MP_CONFIG_ID     

  from (select v.*,
    coalesce(v.primary_thumb_id,
          (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), 
          (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id)
) primary_thumb_id2
  from tmddba.tm_pg_rl v) m 
        left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2
 where item_type>0 and rl_deleted=0  and  m.ID = :param_0  AND (INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|PPL|')>0)
 order by m.title,m.id) a where rownum <= 50) r where rnum >=1 order by rnum

t Verbose: 1220 :      11|09:15:53.7574|AdEJ_I|CJPOWERCAST|imfx v3 API took 0.014s '/api/v3/search/versions?_dc=1688717752687'
t Verbose: 1220 :      11|09:15:53.7574|OJ4G4t|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o 
                    where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 
                    order by o.id desc fetch first 1 rows only)(+)
t Information: 1220 :  11|09:15:53.7574|OJ4G4t|CJPOWERCAST|    timing: 00:00:00.0264921
t Verbose: 1220 :      11|09:15:53.7574|OJ4G4t|CJPOWERCAST|imfx v3 API took 0.027s '/api/v3/search/Media?_dc=1688717752688'
t Transfer: 1220 :     11|09:15:53.7574|OJ4G4t|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0013.mp4 subfolder 
t Transfer: 1220 :     11|09:15:53.7574|OJ4G4t|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:15:53.7574|OJ4G4t|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:15:53.7574|OJ4G4t|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:15:53.7574|OJ4G4t|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:15:53.7584|OJ4G4t|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:16:29.9363|FQM1pD|CJPOWERCAST|OAuth: /api/v3/media-details/299560?_dc=1688717788847
t Transfer: 1220 :     11|09:16:29.9363|FQM1pD|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:16:29.9363|FQM1pD|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:16:29.9363|FQM1pD|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:16:29.9363|FQM1pD|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:16:29.9363|FQM1pD|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:16:29.9363|FQM1pD|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:16:29.9363|FQM1pD|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|09:16:29.9373|||TM_MIS. LoadSubtitles for ID: 299560
t Information: 1220 :  11|09:16:29.9373|||TM_MIS. LoadSubtitles for ID: 299560. SQL: 'select m.id, m.m_ctnr_id, m.m_ctnr_loc, m.modified_dt, m.tv_std, m.m_ctnr_fmt_id, d.sub_folder,
    nvl((select max(l.language) from tm_audio l where l.miid=m.id),aud_language_id) aud_language_id
  from tm_mis m
left join tm_dfile d on (m.externally_owned_id=d.id)
where m.mi_deleted=0 and m.item_type>0 and m.media_type=101 and m.PGM_PARENT_ID=299563'
t Information: 1220 :  11|09:16:29.9373|||TM_MIS. LoadSubtitles for ID: 299560 found no subtitles.
t Verbose: 1220 :      11|09:16:29.9373|FQM1pD|CJPOWERCAST|imfx v3 API took 0.036s '/api/v3/media-details/299560?_dc=1688717788847'
t Transfer: 1220 :     11|09:16:29.9373|FQM1pD|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0013.mp4 subfolder 
t Transfer: 1220 :     11|09:16:29.9373|FQM1pD|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:16:29.9373|FQM1pD|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:16:29.9373|FQM1pD|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:16:29.9373|FQM1pD|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:16:29.9373|FQM1pD|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:16:30.3393|32D~5D|CJPOWERCAST|OAuth: /api/v3/media-captions/299560?_dc=1688717789230
t Transfer: 1220 :     11|09:16:30.3393|32D~5D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:16:30.3393|32D~5D|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:16:30.3393|32D~5D|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:16:30.3393|32D~5D|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|09:16:30.3393|32D~5D|CJPOWERCAST|imfx v3 API took 0.004s '/api/v3/media-captions/299560?_dc=1688717789230'
t Transfer: 1220 :     11|09:16:30.3393|eImuFY|CJPOWERCAST|OAuth: /api/v3/mediavideo/299560?info=smudge,scene,audiovolume&_dc=1688717789239
t Transfer: 1220 :     11|09:16:30.3393|eImuFY|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:16:30.3403|eImuFY|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:16:30.3403|eImuFY|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:16:30.3403|eImuFY|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:16:30.3403|0goPI5|CJPOWERCAST|OAuth: /api/user-group-preferences?keys=googleMapsApiSettings&_dc=1688717789240
t Transfer: 1220 :     11|09:16:30.3403|0goPI5|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:16:30.3403|0goPI5|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:16:30.3403|0goPI5|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:16:30.3403|0goPI5|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:16:30.3403|0goPI5|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:16:30.3403|0goPI5|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:16:30.3413|0goPI5|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|09:16:30.3413|eImuFY|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0013.mp4 subfolder 
t Transfer: 1220 :     11|09:16:30.3413|eImuFY|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:16:30.3413|eImuFY|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:16:30.3413|eImuFY|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:16:30.3413|eImuFY|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:16:30.3413|eImuFY|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:16:30.3413|0goPI5|CJPOWERCAST|imfx v3 API took 0.005s '/api/user-group-preferences?keys=googleMapsApiSettings&_dc=1688717789240'
t Verbose: 1220 :      11|09:16:30.3413|eImuFY|CJPOWERCAST|imfx v3 API took 0.024s '/api/v3/mediavideo/299560?info=smudge,scene,audiovolume&_dc=1688717789239'
t Transfer: 1220 :     11|09:16:30.3413|7iiwjL|CJPOWERCAST|OAuth: /api/v3/ai-tags/299560?_dc=1688717789390
t Transfer: 1220 :     11|09:16:30.3413|7iiwjL|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:16:30.3423|7iiwjL|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:16:30.3423|7iiwjL|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:16:30.3423|7iiwjL|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|09:16:30.3423|pHCAmc|CJPOWERCAST|OAuth: /api/v3/mediavideo/299560?info=smudge&_dc=1688717789392
t Transfer: 1220 :     11|09:16:30.3423|pHCAmc|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:16:30.3423|pHCAmc|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:16:30.3423|pHCAmc|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:16:30.3423|pHCAmc|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|09:16:30.3423|7iiwjL|CJPOWERCAST|V3Api.GetMediaAiTags
t Verbose: 1220 :      11|09:16:30.5434|7iiwjL|CJPOWERCAST|imfx v3 API took 0.006s '/api/v3/ai-tags/299560?_dc=1688717789390'
t Transfer: 1220 :     11|09:16:30.5434|pHCAmc|CJPOWERCAST|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0013.mp4 subfolder 
t Transfer: 1220 :     11|09:16:30.5434|pHCAmc|CJPOWERCAST|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:16:30.5434|pHCAmc|CJPOWERCAST|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0013.mp4
t Transfer: 1220 :     11|09:16:30.5434|pHCAmc|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:16:30.5434|pHCAmc|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:16:30.5434|pHCAmc|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:16:30.5434|pHCAmc|CJPOWERCAST|imfx v3 API took 0.013s '/api/v3/mediavideo/299560?info=smudge&_dc=1688717789392'
t Transfer: 1220 :     11|09:16:30.5443|B6LqLR|CJPOWERCAST|OAuth: /api/metadata/4000/299560?_dc=1688717789459
t Transfer: 1220 :     11|09:16:30.5443|B6LqLR|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:16:30.5443|B6LqLR|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:16:30.5443|B6LqLR|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:16:30.5443|B6LqLR|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|09:16:30.5443|B6LqLR|CJPOWERCAST|imfx v3 API took 0.003s '/api/metadata/4000/299560?_dc=1688717789459'
t Information: 1220 :  11|09:16:45.2703|XV3XFO|CJPOWERCAST|V3 Api exception handler: Devart.Data.Oracle.OracleException (0x80004005): ORA-00942: table or view does not exist
   at Devart.Data.Oracle.bu.d(Int32 A_0)
   at Devart.Data.Oracle.d0.a(Int32 A_0, ej A_1)
   at Devart.Data.Oracle.OracleCommand.InternalExecute(CommandBehavior behavior, IDisposable disposable, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
   at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
   at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
   at Devart.Data.Oracle.OracleCommand.ExecuteReader()
   at iMfxServerCore.Api.v3.MediaDetailsController.GetMediaGeoLocation(Int32 id) in C:\TeamCity\buildAgent\work\405c64e443a47d83\Server\iMfxServerCore\api\controllers\v3\MediaDetailsController.cs:line 145
   at lambda_method(Closure , Object , Object[] )
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.<GetExecutor>b__2(Object instance, Object[] methodParameters)
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments)
   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Web.Http.Filters.ActionFilterAttribute.<CallOnActionExecutedAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Filters.ActionFilterAttribute.<ExecuteActionFilterAsyncCore>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__5.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at System.Web.Http.Controllers.ExceptionFilterResult.<ExecuteAsync>d__6.MoveNext()
  [GET] https://imfxv3tm.tmd.tv/api/v3/media/299560/geolocation?_dc=1688717804074
  System.Web.Http.Routing.HttpRoute
t Transfer: 1220 :     11|09:16:52.3053|4r8Hv7|CJPOWERCAST|OAuth: /api/v3/history/8/299560?_dc=1688717811345
t Transfer: 1220 :     11|09:16:52.3053|4r8Hv7|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:16:52.3053|4r8Hv7|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:16:52.3053|4r8Hv7|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:16:52.3053|4r8Hv7|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|09:16:52.5063|4r8Hv7|CJPOWERCAST|imfx v3 API took 0.031s '/api/v3/history/8/299560?_dc=1688717811345'
t Transfer: 1220 :     11|09:16:55.5213|V7KsAo|CJPOWERCAST|OAuth: /api/v3/media-reports/299560?_dc=1688717814402
t Transfer: 1220 :     11|09:16:55.5213|V7KsAo|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|09:16:55.5213|V7KsAo|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|09:16:55.5213|V7KsAo|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|09:16:55.5213|V7KsAo|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|09:16:55.5213|V7KsAo|CJPOWERCAST|imfx v3 API took 0.074s '/api/v3/media-reports/299560?_dc=1688717814402'
t Information: 1220 :  11|09:33:45.1527|34j5br|CJPOWERCAST|V3Api.GetMediaTagging
t Information: 1220 :  11|14:44:29.0501|||OrabitWatcherBasic. Disposing.
t Information: 1220 :  11|14:44:29.0501|||OrabitWatcherBasic. Disposed.
t Information: 1220 :  11|14:44:29.0501|||==========================================================================
t Information: 1220 :  11|14:44:29.0501|||IMFX CORE SERVER APPLICATION END.