t Transfer: 1220 :     11|01:10:10.2763|fO7gbT||OAuth: /api/user-group-preferences?keys=logoImage&_dc=1583225253545
t Transfer: 1220 :     11|01:10:10.2763|fO7gbT||GetCurrentUser..
t Transfer: 1220 :     11|01:10:10.2763|fO7gbT||  OAuth authenticated
t Verbose: 1220 :      11|01:10:10.2763|fO7gbT||    uid claim is missing..
t Information: 1220 :  11|01:10:10.2763|fO7gbT||OAuth. AutoLogin no Windows identity  type WindowsIdentity
t Transfer: 1220 :     11|02:23:51.4479|34I3K~||OAuth: /api/v3/title/298848/versions?_dc=1583223866806
t Transfer: 1220 :     11|02:23:51.4479|34I3K~||GetCurrentUser..
t Transfer: 1220 :     11|02:23:51.4479|34I3K~||  OAuth authenticated
t Verbose: 1220 :      11|02:23:51.4479|34I3K~||    uid claim is missing..
t Information: 1220 :  11|02:23:51.4479|34I3K~||OAuth. AutoLogin no Windows identity  type WindowsIdentity
t Transfer: 1220 :     11|04:43:46.8782|BnviHZ||OAuth: /api/user-preferences?keys=ums.default.route&_dc=1583223488345
t Transfer: 1220 :     11|04:43:46.8782|BnviHZ||GetCurrentUser..
t Transfer: 1220 :     11|04:43:46.8782|BnviHZ||  OAuth authenticated
t Verbose: 1220 :      11|04:43:46.8782|BnviHZ||    uid claim is missing..
t Information: 1220 :  11|04:43:46.8782|BnviHZ||OAuth. AutoLogin no Windows identity  type WindowsIdentity
t Transfer: 1220 :     11|05:54:01.0661|YqPMQV||OAuth: /api/logout?_dc=1706853325606
t Transfer: 1220 :     11|05:54:01.0661|YqPMQV||GetCurrentUser..
t Transfer: 1220 :     11|05:54:01.0661|YqPMQV||  OAuth authenticated
t Verbose: 1220 :      11|05:54:01.0661|YqPMQV||    uid claim is missing..
t Information: 1220 :  11|05:54:01.0661|YqPMQV||OAuth. AutoLogin no Windows identity  type WindowsIdentity
t Transfer: 1220 :     11|05:54:01.6755|APBXc0||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey
t Information: 1220 :  11|05:54:02.0817|pQV3Zj||GetCache.
t Information: 1220 :  11|05:54:02.0817|pQV3Zj||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\108_2_PnqJC_.png
t Information: 1220 :  11|05:54:02.0817|pQV3Zj||GetCache. Data read: 154944
t Verbose: 1220 :      11|05:54:02.0817|pQV3Zj||imfx v3 API took 0.087s '/api/v3/visual-asset/group/PnqJC_/2/image'
t Verbose: 1220 :      11|05:54:06.3586|M0FLhW||Oauth validating..
t Verbose: 1220 :      11|05:54:06.3586|M0FLhW||GrantResourceOwnerCredentials.
t Verbose: 1220 :      11|05:54:06.3586|M0FLhW||LoginUser. cjpowercast, login type OAuth, encrypt password True
t Information: 1220 :  11|05:54:06.3586|M0FLhW||TryLoginUser. cjpowercast, login type OAuth, check password True, check hash False, encrypt password True, load user data False
t Information: 1220 :  11|05:54:06.7649|M0FLhW||  oauth token 00000000-0000-0000-0000-000000000000
t Information: 1220 :  11|05:54:06.7649|M0FLhW||TryLoginUser. Logged in..
t Information: 1220 :  11|05:54:06.7649|M0FLhW||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled.
t Verbose: 1220 :      11|05:54:06.7649|M0FLhW||LoginUser. Adding history. User Id 1165, result CJPOWERCAST, host 192.168.127.6
t Verbose: 1220 :      11|05:54:06.7649|M0FLhW||GrantResourceOwnerCredentials. Try login finished. Logged: True
t Transfer: 1220 :     11|05:54:07.1834|g0vSnT|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=1706853331730
t Transfer: 1220 :     11|05:54:07.1834|g0vSnT|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:07.1834|g0vSnT|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:07.1834|g0vSnT|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:07.1834|g0vSnT|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:07.1834|g0vSnT|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:07.1834|g0vSnT|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:07.1834|g0vSnT|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:07.1834|g0vSnT|CJPOWERCAST|imfx v3 API took 0.044s '/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=1706853331730'
t Transfer: 1220 :     11|05:54:07.5896|tee2VR|CJPOWERCAST|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1706853332079
t Transfer: 1220 :     11|05:54:07.5896|tee2VR|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:07.5896|tee2VR|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:07.5896|tee2VR|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:07.5896|tee2VR|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|05:54:07.5896|tee2VR|CJPOWERCAST|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings
t Transfer: 1220 :     11|05:54:07.5896|tee2VR|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:07.5896|tee2VR|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:07.5896|tee2VR|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:07.5896|tee2VR|CJPOWERCAST|imfx v3 API took 0.040s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1706853332079'
t Information: 1220 :  11|05:54:07.7927|lTDcgT|CJPOWERCAST|GetUserProfile. Id: 0
t Transfer: 1220 :     11|05:54:07.7927|lTDcgT|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:07.7927|lTDcgT|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:07.7927|lTDcgT|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|05:54:08.2053|Ugee2O|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1706853332811
t Transfer: 1220 :     11|05:54:08.2053|Ugee2O|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:08.2053|Ugee2O|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:08.2053|Ugee2O|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:08.2053|Ugee2O|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:08.2053|sIKU~B|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1706853332812
t Transfer: 1220 :     11|05:54:08.2053|sIKU~B|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:08.2053|sIKU~B|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:08.2053|sIKU~B|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:08.2053|sIKU~B|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:08.2053|sIKU~B|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:08.2053|sIKU~B|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:08.2053|sIKU~B|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|05:54:08.2053|EC8ufQ|CJPOWERCAST|OAuth: /api/settings/user/uploadSettings?_dc=1706853332824
t Transfer: 1220 :     11|05:54:08.2053|EC8ufQ|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:08.2053|EC8ufQ|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:08.2053|EC8ufQ|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:08.2053|EC8ufQ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|05:54:08.2053|sIKU~B|CJPOWERCAST|imfx v3 API took 0.009s '/api/settings/user/mainMenuSettings?_dc=1706853332812'
t Transfer: 1220 :     11|05:54:08.2053|aibidy|CJPOWERCAST|OAuth: /api/settings/group/0?_dc=1706853332847
t Transfer: 1220 :     11|05:54:08.2053|aibidy|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:08.2053|aibidy|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:08.2053|aibidy|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:08.2053|aibidy|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:08.2053|Nmw3J6|CJPOWERCAST|OAuth: /api/settings/user/mainMenuSettings?_dc=1706853332848
t Transfer: 1220 :     11|05:54:08.2053|Nmw3J6|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:08.2053|Nmw3J6|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:08.2053|Nmw3J6|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:08.2053|Nmw3J6|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:08.4240|EC8ufQ|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:08.4240|EC8ufQ|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:08.4240|EC8ufQ|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|05:54:08.4240|Nmw3J6|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:08.4240|Nmw3J6|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:08.4240|Nmw3J6|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:08.4240|Nmw3J6|CJPOWERCAST|imfx v3 API took 0.088s '/api/settings/user/mainMenuSettings?_dc=1706853332848'
t Verbose: 1220 :      11|05:54:08.6272|EC8ufQ|CJPOWERCAST|imfx v3 API took 0.190s '/api/settings/user/uploadSettings?_dc=1706853332824'
t Information: 1220 :  11|05:54:08.6272|XkLms1||GetCache.
t Information: 1220 :  11|05:54:08.6272|XkLms1||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\201_0_Any_gO.png
t Information: 1220 :  11|05:54:08.6272|XkLms1||GetCache. Data read: 0
t Verbose: 1220 :      11|05:54:08.6272|XkLms1||imfx v3 API took 0.006s '/api/v3/visual-asset/group/Any_gO/0/image'
t Verbose: 1220 :      11|05:54:08.6272|Ugee2O|CJPOWERCAST|imfx v3 API took 0.373s '/api/settings/group/0?_dc=1706853332811'
t Verbose: 1220 :      11|05:54:08.6272|aibidy|CJPOWERCAST|imfx v3 API took 0.194s '/api/settings/group/0?_dc=1706853332847'
t Transfer: 1220 :     11|05:54:08.8303|r2yYaW|CJPOWERCAST|OAuth: /api/lookups/MediaStatus?_dc=1706853332859
t Transfer: 1220 :     11|05:54:08.8303|r2yYaW|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:08.8303|r2yYaW|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:08.8303|r2yYaW|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:08.8303|r2yYaW|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:08.8303|9QfUpI|CJPOWERCAST|OAuth: /api/lookups/PgmStatus?_dc=1706853332860
t Transfer: 1220 :     11|05:54:08.8303|9QfUpI|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:08.8303|9QfUpI|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:08.8303|9QfUpI|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:08.8303|9QfUpI|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|05:54:08.8303|9QfUpI|CJPOWERCAST|imfx v3 API took 0.019s '/api/lookups/PgmStatus?_dc=1706853332860'
t Verbose: 1220 :      11|05:54:08.8303|r2yYaW|CJPOWERCAST|imfx v3 API took 0.028s '/api/lookups/MediaStatus?_dc=1706853332859'
t Transfer: 1220 :     11|05:54:08.8303|Isnn2y|CJPOWERCAST|OAuth: /api/lookup/CustomMediaStatusTypes?_dc=1706853332861
t Transfer: 1220 :     11|05:54:08.8303|Isnn2y|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:08.8303|Isnn2y|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:08.8303|Isnn2y|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:08.8303|Isnn2y|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:08.8303|rl2gIG|CJPOWERCAST|OAuth: /api/lookup/CustomVersionStatusTypes?_dc=1706853332862
t Transfer: 1220 :     11|05:54:08.8303|rl2gIG|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:08.8303|rl2gIG|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:08.8303|rl2gIG|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:08.8303|rl2gIG|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|05:54:08.8303|Isnn2y|CJPOWERCAST|imfx v3 API took 0.035s '/api/lookup/CustomMediaStatusTypes?_dc=1706853332861'
t Verbose: 1220 :      11|05:54:08.8303|rl2gIG|CJPOWERCAST|imfx v3 API took 0.029s '/api/lookup/CustomVersionStatusTypes?_dc=1706853332862'
t Transfer: 1220 :     11|05:54:08.8303|So~ExG|CJPOWERCAST|OAuth: /api/lookup/CustomTitleStatusTypes?_dc=1706853332863
t Transfer: 1220 :     11|05:54:08.8303|So~ExG|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:08.8303|So~ExG|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:08.8303|So~ExG|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:08.8303|So~ExG|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|05:54:09.0490|So~ExG|CJPOWERCAST|imfx v3 API took 0.016s '/api/lookup/CustomTitleStatusTypes?_dc=1706853332863'
t Information: 1220 :  11|05:54:09.0490|qSL72d||GetCache.
t Transfer: 1220 :     11|05:54:09.0490|S286_E|CJPOWERCAST|OAuth: /api/settings/user/defaultHomePage?_dc=1706853332864
t Transfer: 1220 :     11|05:54:09.0490|S286_E|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:09.0490|S286_E|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:09.0490|S286_E|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:09.0490|S286_E|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|05:54:09.0490|qSL72d||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\202_1_Any_gO.png
t Information: 1220 :  11|05:54:09.0490|qSL72d||GetCache. Data read: 0
t Verbose: 1220 :      11|05:54:09.0490|qSL72d||imfx v3 API took 0.004s '/api/v3/visual-asset/group/Any_gO/1/image'
t Transfer: 1220 :     11|05:54:09.0490|S286_E|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:09.0490|S286_E|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:09.0490|S286_E|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:09.0490|S286_E|CJPOWERCAST|imfx v3 API took 0.008s '/api/settings/user/defaultHomePage?_dc=1706853332864'
t Transfer: 1220 :     11|05:54:10.8881|JtydmR|CJPOWERCAST|OAuth: /api/settings/user/defaultSearch?_dc=1706853335491
t Transfer: 1220 :     11|05:54:10.8881|JtydmR|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:10.8881|JtydmR|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:10.8881|JtydmR|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:10.8881|JtydmR|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:10.8881|JjhNv6|CJPOWERCAST|OAuth: /api/settings/user/startSearch?_dc=1706853335492
t Transfer: 1220 :     11|05:54:10.8881|JjhNv6|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:10.8881|JjhNv6|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:10.8881|JjhNv6|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:10.8881|JjhNv6|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:10.8881|JtydmR|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:10.8881|JtydmR|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:10.8881|JtydmR|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|05:54:10.8881|JjhNv6|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:10.8881|JjhNv6|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:10.8881|JjhNv6|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:11.0912|JjhNv6|CJPOWERCAST|imfx v3 API took 0.008s '/api/settings/user/startSearch?_dc=1706853335492'
t Verbose: 1220 :      11|05:54:11.0912|JtydmR|CJPOWERCAST|imfx v3 API took 0.010s '/api/settings/user/defaultSearch?_dc=1706853335491'
t Transfer: 1220 :     11|05:54:11.4974|zAlh5n|CJPOWERCAST|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1706853335952
t Transfer: 1220 :     11|05:54:11.4974|zAlh5n|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:11.4974|zAlh5n|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:11.4974|zAlh5n|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:11.4974|zAlh5n|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|05:54:11.4974|zAlh5n|CJPOWERCAST|GetUserDataByKeys: consumer.recent.data
t Transfer: 1220 :     11|05:54:11.4974|zAlh5n|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:11.4974|zAlh5n|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:11.4974|zAlh5n|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:11.4974|zAlh5n|CJPOWERCAST|imfx v3 API took 0.008s '/api/user-preferences?keys=consumer.recent.data&_dc=1706853335952'
t Transfer: 1220 :     11|05:54:11.4974|WwTQdN|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.consumer&_dc=1706853335965
t Transfer: 1220 :     11|05:54:11.4974|WwTQdN|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:11.4974|WwTQdN|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:11.4974|WwTQdN|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:11.4974|WwTQdN|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|05:54:11.4974|WwTQdN|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.consumer
t Transfer: 1220 :     11|05:54:11.4974|WwTQdN|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:11.4974|WwTQdN|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:11.4974|WwTQdN|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:11.4974|WwTQdN|CJPOWERCAST|imfx v3 API took 0.008s '/api/user-preferences?keys=adv.recent.searches.consumer&_dc=1706853335965'
t Information: 1220 :  11|05:54:11.4974|yBpAL0||GetCache.
t Information: 1220 :  11|05:54:11.4974|yBpAL0||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\204_3_Any_gO.png
t Information: 1220 :  11|05:54:11.4974|yBpAL0||GetCache. Data read: 5504
t Verbose: 1220 :      11|05:54:11.4974|yBpAL0||imfx v3 API took 0.007s '/api/v3/visual-asset/group/Any_gO/3/image'
t Transfer: 1220 :     11|05:54:25.3349|qkCpOP|CJPOWERCAST|OAuth: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1706853349891
t Transfer: 1220 :     11|05:54:25.3349|qkCpOP|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:25.3349|qkCpOP|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:25.3349|qkCpOP|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:25.3349|qkCpOP|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|05:54:25.3349|qkCpOP|CJPOWERCAST|GetUserDataByKeys: adv.recent.searches.titles
t Transfer: 1220 :     11|05:54:25.3349|qkCpOP|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:25.3349|qkCpOP|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:25.3349|qkCpOP|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|05:54:25.3349|Jp2ZvE|CJPOWERCAST|OAuth: /api/lookups/SearchSupportedOperators?_dc=1706853349889
t Transfer: 1220 :     11|05:54:25.3349|Jp2ZvE|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:25.3349|Jp2ZvE|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:25.3349|Jp2ZvE|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:25.3349|Jp2ZvE|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:25.3349|_UXF8s|CJPOWERCAST|OAuth: /api/view/searchinfo/TitleSearch?_dc=1706853349887
t Transfer: 1220 :     11|05:54:25.3349|_UXF8s|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:25.3349|_UXF8s|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:25.3349|_UXF8s|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:25.3349|_UXF8s|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|05:54:25.3349|Jp2ZvE|CJPOWERCAST|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1706853349889'
t Verbose: 1220 :      11|05:54:25.3349|qkCpOP|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-preferences?keys=adv.recent.searches.titles&_dc=1706853349891'
t Information: 1220 :  11|05:54:25.3349|_UXF8s|CJPOWERCAST|GetAdvSearchColumns. search type TitleSearch grid .
t Verbose: 1220 :      11|05:54:25.3349|_UXF8s|CJPOWERCAST|imfx v3 API took 0.001s '/api/view/searchinfo/TitleSearch?_dc=1706853349887'
t Transfer: 1220 :     11|05:54:25.3349|slyMbe|CJPOWERCAST|OAuth: /api/view/searches/TitleSearch?_dc=1706853349952
t Transfer: 1220 :     11|05:54:25.3349|slyMbe|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:25.3349|slyMbe|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:25.3349|slyMbe|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:25.3349|slyMbe|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|05:54:25.3349|slyMbe|CJPOWERCAST|GetSavedSearchNames. search type TitleSearch.
t Transfer: 1220 :     11|05:54:25.3349|slyMbe|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:25.3349|slyMbe|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:25.3349|slyMbe|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:25.3349|slyMbe|CJPOWERCAST|imfx v3 API took 0.035s '/api/view/searches/TitleSearch?_dc=1706853349952'
t Transfer: 1220 :     11|05:54:25.7568|ltFaga|CJPOWERCAST|OAuth: /api/view/info/VersionGrid?lang=en-GB&_dc=1706853349975
t Transfer: 1220 :     11|05:54:25.7568|ltFaga|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:25.7568|ltFaga|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:25.7568|ltFaga|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:25.7568|ltFaga|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:25.7568|b9PgXA|CJPOWERCAST|OAuth: /api/view/info/DigitalCarriers?lang=en-GB&_dc=1706853350131
t Transfer: 1220 :     11|05:54:25.7568|b9PgXA|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:25.7568|b9PgXA|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:25.7568|b9PgXA|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:25.7568|b9PgXA|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:25.7568|uAnMPH|CJPOWERCAST|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1706853350087
t Transfer: 1220 :     11|05:54:25.7568|uAnMPH|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:25.7568|uAnMPH|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:25.7568|uAnMPH|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:25.7568|uAnMPH|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|05:54:25.7568|b9PgXA|CJPOWERCAST|GetGridViewBuilder. builder type DigitalCarriers.
t Information: 1220 :  11|05:54:25.7568|ltFaga|CJPOWERCAST|GetGridViewBuilder. builder type VersionGrid.
t Information: 1220 :  11|05:54:25.7568|uAnMPH|CJPOWERCAST|GetGridViewBuilder. builder type MediaGrid.
t Transfer: 1220 :     11|05:54:25.7568|b9PgXA|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:25.7568|b9PgXA|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:25.7568|b9PgXA|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|05:54:25.7568|uAnMPH|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:25.7568|uAnMPH|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:25.7568|uAnMPH|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|05:54:25.7568|ltFaga|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:25.7568|ltFaga|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:25.7568|ltFaga|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|05:54:25.7568|b9PgXA|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default.
t Information: 1220 :  11|05:54:25.7568|ltFaga|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default.
t Information: 1220 :  11|05:54:25.7568|uAnMPH|CJPOWERCAST|UserGridView. LoadView. ID 1881, Name Default.
t Transfer: 1220 :     11|05:54:25.7568|b9PgXA|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:25.7568|b9PgXA|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:25.7568|b9PgXA|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|05:54:25.7568|uAnMPH|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:25.7568|uAnMPH|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:25.7568|uAnMPH|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|05:54:25.7568|ltFaga|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:25.7568|ltFaga|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:25.7568|ltFaga|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|05:54:25.7568|b9PgXA|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:25.7568|b9PgXA|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:25.7568|b9PgXA|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|05:54:25.7568|ltFaga|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:25.7568|ltFaga|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:25.7568|ltFaga|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|05:54:25.7568|uAnMPH|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:25.7568|uAnMPH|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:25.7568|uAnMPH|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:25.7568|uAnMPH|CJPOWERCAST|imfx v3 API took 0.080s '/api/view/info/MediaGrid?lang=en-GB&_dc=1706853350087'
t Verbose: 1220 :      11|05:54:25.7568|ltFaga|CJPOWERCAST|imfx v3 API took 0.083s '/api/view/info/VersionGrid?lang=en-GB&_dc=1706853349975'
t Verbose: 1220 :      11|05:54:25.7568|b9PgXA|CJPOWERCAST|imfx v3 API took 0.083s '/api/view/info/DigitalCarriers?lang=en-GB&_dc=1706853350131'
t Transfer: 1220 :     11|05:54:25.9670|kx0FrA|CJPOWERCAST|OAuth: /api/view/info/TitleTree?lang=en-GB&_dc=1706853350169
t Transfer: 1220 :     11|05:54:25.9670|kx0FrA|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:25.9670|kx0FrA|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:25.9670|kx0FrA|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:25.9670|kx0FrA|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|05:54:25.9670|kx0FrA|CJPOWERCAST|GetGridViewBuilder. builder type TitleTree.
t Transfer: 1220 :     11|05:54:25.9670|kx0FrA|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:25.9670|kx0FrA|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:25.9670|kx0FrA|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|05:54:25.9670|kx0FrA|CJPOWERCAST|UserGridView. LoadView. ID -2, Name Default.
t Transfer: 1220 :     11|05:54:25.9670|kx0FrA|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:25.9670|kx0FrA|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:25.9670|kx0FrA|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|05:54:25.9670|kx0FrA|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:25.9670|kx0FrA|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:25.9670|kx0FrA|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:25.9670|kx0FrA|CJPOWERCAST|imfx v3 API took 0.007s '/api/view/info/TitleTree?lang=en-GB&_dc=1706853350169'
t Transfer: 1220 :     11|05:54:29.8495|qi2yIa|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853354463
t Transfer: 1220 :     11|05:54:29.8495|qi2yIa|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:29.8495|qi2yIa|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:29.8495|qi2yIa|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:29.8495|qi2yIa|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:30.0526|qi2yIa|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:30.0526|qi2yIa|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:30.0526|qi2yIa|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|05:54:30.0526|3V9Z4V|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853354597
t Transfer: 1220 :     11|05:54:30.0526|3V9Z4V|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:30.0526|3V9Z4V|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:30.0526|3V9Z4V|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:30.0526|3V9Z4V|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:30.0526|3V9Z4V|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:30.0526|3V9Z4V|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:30.0526|3V9Z4V|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|05:54:30.0526|9i8Sxm|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853354657
t Transfer: 1220 :     11|05:54:30.0526|9i8Sxm|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:30.0526|9i8Sxm|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:30.0526|9i8Sxm|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:30.0526|9i8Sxm|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:30.0526|9i8Sxm|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:30.0526|9i8Sxm|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:30.0526|9i8Sxm|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|05:54:30.0526|qtxMLz|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853354712
t Transfer: 1220 :     11|05:54:30.0526|qtxMLz|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:30.0526|qtxMLz|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:30.0526|qtxMLz|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:30.0526|qtxMLz|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:30.0526|qtxMLz|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:30.0526|qtxMLz|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:30.0526|qtxMLz|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:30.6721|3V9Z4V|CJPOWERCAST|imfx v3 API took 0.630s '/api/v3/search-suggestion/?_dc=1706853354597'
t Verbose: 1220 :      11|05:54:30.6721|qi2yIa|CJPOWERCAST|imfx v3 API took 0.722s '/api/v3/search-suggestion/?_dc=1706853354463'
t Verbose: 1220 :      11|05:54:30.6721|9i8Sxm|CJPOWERCAST|imfx v3 API took 0.580s '/api/v3/search-suggestion/?_dc=1706853354657'
t Verbose: 1220 :      11|05:54:30.6721|qtxMLz|CJPOWERCAST|imfx v3 API took 0.542s '/api/v3/search-suggestion/?_dc=1706853354712'
t Transfer: 1220 :     11|05:54:33.3250|5WMgbe|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1706853357976
t Transfer: 1220 :     11|05:54:33.3250|5WMgbe|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:33.3250|5WMgbe|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:33.3250|5WMgbe|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:33.3250|5WMgbe|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|05:54:33.5281|5WMgbe|CJPOWERCAST|V3Api.SearchTitles
t Information: 1220 :  11|05:54:33.5281|5WMgbe|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|05:54:33.5281|5WMgbe|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:33.5281|5WMgbe|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:33.5281|5WMgbe|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|05:54:33.5281|5WMgbe|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|05:54:33.7312|5WMgbe|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.id TitleId from TM_PG_ABS 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) and o.type_id=:param_1 
                    order by o.id desc fetch first 1 rows only)(+)
t Verbose: 1220 :      11|05:54:33.7312|5WMgbe|CJPOWERCAST|imfx v3 API took 0.284s '/api/v3/search/title?_dc=1706853357976'
t Transfer: 1220 :     11|05:54:34.1376|dW25ky|CJPOWERCAST|OAuth: /api/v3/title/299390/versions?_dc=1706853358723
t Transfer: 1220 :     11|05:54:34.1376|dW25ky|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:34.1376|dW25ky|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:34.1376|dW25ky|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:34.1376|dW25ky|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:34.1376|Yerod2|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1706853358727
t Transfer: 1220 :     11|05:54:34.1376|Yerod2|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:34.1376|Yerod2|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:34.1376|Yerod2|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:34.1376|Yerod2|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|05:54:34.1376|dW25ky|CJPOWERCAST|V3Api.SearchGeneric
t Verbose: 1220 :      11|05:54:34.1376|Yerod2|CJPOWERCAST|StoreUserDataByKeys..
t Transfer: 1220 :     11|05:54:34.1376|Yerod2|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:34.1376|Yerod2|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:34.1376|Yerod2|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|05:54:34.1376|dW25ky|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:34.1376|dW25ky|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:34.1376|dW25ky|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:34.1376|Yerod2|CJPOWERCAST|imfx v3 API took 0.014s '/api/user-preferences?_dc=1706853358727'
t Transfer: 1220 :     11|05:54:34.1376|dW25ky|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:34.1376|dW25ky|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:34.1376|dW25ky|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|05:54:34.1376|dW25ky|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:34.1376|dW25ky|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:34.1376|dW25ky|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|05:54:34.1376|dW25ky|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 med.medium_name
  from TM_CFG_MEDIUM med, TM_PG_ABS pgabs
 where pgabs.id=v.PGM_ABS_ID and pgabs.MEDIUM_ID = med.id) MEDIUM_TEXT ,(select replace(tmd_str_agg_pipe(cf.form_name),'|',' / ')
  from TM_PG_FORM_LNX fl
  join TM_CFG_FORM cf on (cf.id=fl.form_id)
 where fl.tm_pg_id = v.ID) FORM_TEXT ,(select replace(tmd_str_agg_pipe(dvb.item_name),'|',' / ')
  from TM_PG_ABS_GENRE_LNX gl
  join TM_DVB dvb on (dvb.id=gl.genre_id)
 where gl.tm_pg_abs_id = v.PGM_ABS_ID) GENRE_TEXT, (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = v.net_grp_id) CHANNEL_GROUP, (select count(id) from tm_mis where item_type>0 and pgm_parent_id=v.id) MEDIA_COUNT, (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|05:54:34.1376|dW25ky|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:34.1376|dW25ky|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:34.1376|dW25ky|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|05:54:34.1376|dW25ky|CJPOWERCAST|Running version search. User: 1165    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 23ms.  Returned lines: 0

t Verbose: 1220 :      11|05:54:34.1376|dW25ky|CJPOWERCAST|imfx v3 API took 0.056s '/api/v3/title/299390/versions?_dc=1706853358723'
t Transfer: 1220 :     11|05:54:40.0907|1L5IDh|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853364660
t Transfer: 1220 :     11|05:54:40.0907|1L5IDh|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:40.0907|1L5IDh|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:40.0907|1L5IDh|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:40.0907|1L5IDh|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:40.0907|1L5IDh|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:40.0907|1L5IDh|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:40.0907|1L5IDh|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:40.0907|1L5IDh|CJPOWERCAST|imfx v3 API took 0.062s '/api/v3/search-suggestion/?_dc=1706853364660'
t Transfer: 1220 :     11|05:54:40.7000|8J~EQy|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853365282
t Transfer: 1220 :     11|05:54:40.7000|8J~EQy|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:40.7000|8J~EQy|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:40.7000|8J~EQy|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:40.7000|8J~EQy|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:40.7000|8J~EQy|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:40.7000|8J~EQy|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:40.7000|8J~EQy|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:40.7000|8J~EQy|CJPOWERCAST|imfx v3 API took 0.014s '/api/v3/search-suggestion/?_dc=1706853365282'
t Transfer: 1220 :     11|05:54:40.9016|EVO4sm|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853365392
t Transfer: 1220 :     11|05:54:40.9016|EVO4sm|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:40.9016|EVO4sm|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:40.9016|EVO4sm|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:40.9016|EVO4sm|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:40.9016|EVO4sm|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:40.9016|EVO4sm|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:40.9016|EVO4sm|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:40.9016|EVO4sm|CJPOWERCAST|imfx v3 API took 0.017s '/api/v3/search-suggestion/?_dc=1706853365392'
t Transfer: 1220 :     11|05:54:41.1048|FNuWv_|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853365650
t Transfer: 1220 :     11|05:54:41.1048|FNuWv_|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:41.1048|FNuWv_|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:41.1048|FNuWv_|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:41.1048|FNuWv_|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:41.1048|FNuWv_|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:41.1048|FNuWv_|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:41.1048|FNuWv_|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:41.1048|FNuWv_|CJPOWERCAST|imfx v3 API took 0.013s '/api/v3/search-suggestion/?_dc=1706853365650'
t Transfer: 1220 :     11|05:54:41.3079|S4yBuJ|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853365839
t Transfer: 1220 :     11|05:54:41.3079|S4yBuJ|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:41.3079|S4yBuJ|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:41.3079|S4yBuJ|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:41.3079|S4yBuJ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:41.3079|S4yBuJ|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:41.3079|S4yBuJ|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:41.3079|S4yBuJ|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:41.3079|S4yBuJ|CJPOWERCAST|imfx v3 API took 0.013s '/api/v3/search-suggestion/?_dc=1706853365839'
t Transfer: 1220 :     11|05:54:42.7298|v1FuL0|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853367327
t Transfer: 1220 :     11|05:54:42.7298|v1FuL0|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:42.7298|v1FuL0|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:42.7298|v1FuL0|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:42.7298|v1FuL0|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:42.7298|v1FuL0|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:42.7298|v1FuL0|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:42.7298|v1FuL0|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:42.7298|v1FuL0|CJPOWERCAST|imfx v3 API took 0.013s '/api/v3/search-suggestion/?_dc=1706853367327'
t Transfer: 1220 :     11|05:54:42.9329|toJeYI|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853367453
t Transfer: 1220 :     11|05:54:42.9329|toJeYI|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:42.9329|toJeYI|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:42.9329|toJeYI|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:42.9329|toJeYI|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:42.9329|toJeYI|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:42.9329|toJeYI|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:42.9329|toJeYI|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:42.9329|toJeYI|CJPOWERCAST|imfx v3 API took 0.005s '/api/v3/search-suggestion/?_dc=1706853367453'
t Transfer: 1220 :     11|05:54:43.5423|eP54rG|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1706853368187
t Transfer: 1220 :     11|05:54:43.5423|eP54rG|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:43.5423|eP54rG|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:43.5423|eP54rG|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:43.5423|eP54rG|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|05:54:43.5423|eP54rG|CJPOWERCAST|V3Api.SearchTitles
t Information: 1220 :  11|05:54:43.5423|eP54rG|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|05:54:43.5423|eP54rG|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:43.5423|eP54rG|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:43.5423|eP54rG|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|05:54:43.5423|eP54rG|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 (id in ( (select tobj.pgm_abs_id
                 from TMDDBA.TM_TXT_OBJ tobj
                 join TMDDBA.TM_TXT_TYP ttyp
                   on (ttyp.id = tobj.TYPE_ID)
                where contains(tobj.ctx_text_col,
                               :param_0 || ' WITHIN TEXT_DATA_PLAIN') > 0
                  and ttyp.is_alt_title = 1) union (select id from tmddba.tm_pg_abs where  contains(ctx_ids_col, :param_0||' WITHIN PROGID1')>0) union (select id from tmddba.tm_pg_abs where  contains(ctx_text_col, :param_0||' WITHIN TITLE OR '||:param_0||' WITHIN SER_TITLE')>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|05:54:44.1517|eP54rG|CJPOWERCAST|imfx v3 API took 0.488s '/api/v3/search/title?_dc=1706853368187'
t Transfer: 1220 :     11|05:54:44.3548|aUn4_H|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1706853369007
t Transfer: 1220 :     11|05:54:44.3548|aUn4_H|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:44.3548|aUn4_H|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:44.3548|aUn4_H|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:44.3548|aUn4_H|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|05:54:44.3548|aUn4_H|CJPOWERCAST|StoreUserDataByKeys..
t Transfer: 1220 :     11|05:54:44.3548|aUn4_H|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:44.3548|aUn4_H|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:44.3548|aUn4_H|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:44.3548|aUn4_H|CJPOWERCAST|imfx v3 API took 0.008s '/api/user-preferences?_dc=1706853369007'
t Transfer: 1220 :     11|05:54:47.0426|9WQXq8|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853371570
t Transfer: 1220 :     11|05:54:47.0426|9WQXq8|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:47.0426|9WQXq8|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:47.0426|9WQXq8|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:47.0426|9WQXq8|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:47.0426|9WQXq8|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:47.0426|9WQXq8|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:47.0426|9WQXq8|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:47.0426|9WQXq8|CJPOWERCAST|imfx v3 API took 0.023s '/api/v3/search-suggestion/?_dc=1706853371570'
t Transfer: 1220 :     11|05:54:47.8551|kyPhKP|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853372336
t Transfer: 1220 :     11|05:54:47.8551|kyPhKP|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:47.8551|kyPhKP|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:47.8551|kyPhKP|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:47.8551|kyPhKP|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:47.8551|kyPhKP|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:47.8551|kyPhKP|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:47.8551|kyPhKP|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:47.8551|kyPhKP|CJPOWERCAST|imfx v3 API took 0.026s '/api/v3/search-suggestion/?_dc=1706853372336'
t Transfer: 1220 :     11|05:54:47.8551|jK9NB4|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853372380
t Transfer: 1220 :     11|05:54:47.8551|jK9NB4|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:47.8551|jK9NB4|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:47.8551|jK9NB4|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:47.8551|jK9NB4|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:47.8551|jK9NB4|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:47.8551|jK9NB4|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:47.8551|jK9NB4|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:47.8551|jK9NB4|CJPOWERCAST|imfx v3 API took 0.008s '/api/v3/search-suggestion/?_dc=1706853372380'
t Transfer: 1220 :     11|05:54:48.0626|UapbrW|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1706853372687
t Transfer: 1220 :     11|05:54:48.0626|UapbrW|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:48.0626|UapbrW|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:48.0626|UapbrW|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:48.0626|UapbrW|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|05:54:48.0626|UapbrW|CJPOWERCAST|V3Api.SearchTitles
t Information: 1220 :  11|05:54:48.0626|UapbrW|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|05:54:48.0626|UapbrW|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:48.0626|UapbrW|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:48.0626|UapbrW|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|05:54:48.0626|UapbrW|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 (id in ( (select tobj.pgm_abs_id
                 from TMDDBA.TM_TXT_OBJ tobj
                 join TMDDBA.TM_TXT_TYP ttyp
                   on (ttyp.id = tobj.TYPE_ID)
                where contains(tobj.ctx_text_col,
                               :param_0 || ' WITHIN TEXT_DATA_PLAIN') > 0
                  and ttyp.is_alt_title = 1) union (select id from tmddba.tm_pg_abs where  contains(ctx_ids_col, :param_0||' WITHIN PROGID1')>0) union (select id from tmddba.tm_pg_abs where  contains(ctx_text_col, :param_0||' WITHIN TITLE OR '||:param_0||' WITHIN SER_TITLE')>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|05:54:48.8751|UapbrW|CJPOWERCAST|imfx v3 API took 0.673s '/api/v3/search/title?_dc=1706853372687'
t Transfer: 1220 :     11|05:54:49.0782|UOEhbR|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1706853373697
t Transfer: 1220 :     11|05:54:49.0782|UOEhbR|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:49.0782|UOEhbR|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:49.0782|UOEhbR|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:49.0782|UOEhbR|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|05:54:49.0782|UOEhbR|CJPOWERCAST|StoreUserDataByKeys..
t Transfer: 1220 :     11|05:54:49.0782|UOEhbR|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:49.0782|UOEhbR|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:49.0782|UOEhbR|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:49.0782|UOEhbR|CJPOWERCAST|imfx v3 API took 0.009s '/api/user-preferences?_dc=1706853373697'
t Transfer: 1220 :     11|05:54:50.2994|XqTzlp|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853374822
t Transfer: 1220 :     11|05:54:50.2994|XqTzlp|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:50.2994|XqTzlp|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:50.2994|XqTzlp|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:50.2994|XqTzlp|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:50.2994|XqTzlp|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:50.2994|XqTzlp|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:50.2994|XqTzlp|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:50.2994|XqTzlp|CJPOWERCAST|imfx v3 API took 0.019s '/api/v3/search-suggestion/?_dc=1706853374822'
t Transfer: 1220 :     11|05:54:51.9299|aNzBva|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1706853376394
t Transfer: 1220 :     11|05:54:51.9299|aNzBva|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:51.9299|aNzBva|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:51.9299|aNzBva|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:51.9299|aNzBva|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|05:54:51.9299|aNzBva|CJPOWERCAST|V3Api.SearchTitles
t Information: 1220 :  11|05:54:51.9299|aNzBva|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|05:54:51.9299|aNzBva|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:51.9299|aNzBva|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:51.9299|aNzBva|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|05:54:51.9299|aNzBva|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 (id in ( (select tobj.pgm_abs_id
                 from TMDDBA.TM_TXT_OBJ tobj
                 join TMDDBA.TM_TXT_TYP ttyp
                   on (ttyp.id = tobj.TYPE_ID)
                where contains(tobj.ctx_text_col,
                               :param_0 || ' WITHIN TEXT_DATA_PLAIN') > 0
                  and ttyp.is_alt_title = 1) union (select id from tmddba.tm_pg_abs where  contains(ctx_ids_col, :param_0||' WITHIN PROGID1')>0) union (select id from tmddba.tm_pg_abs where  contains(ctx_text_col, :param_0||' WITHIN TITLE OR '||:param_0||' WITHIN SER_TITLE')>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|05:54:51.9299|aNzBva|CJPOWERCAST|imfx v3 API took 0.027s '/api/v3/search/title?_dc=1706853376394'
t Transfer: 1220 :     11|05:54:52.1330|ty5hMX|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1706853376756
t Transfer: 1220 :     11|05:54:52.1330|ty5hMX|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:52.1330|ty5hMX|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:52.1330|ty5hMX|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:52.1330|ty5hMX|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|05:54:52.1330|ty5hMX|CJPOWERCAST|StoreUserDataByKeys..
t Transfer: 1220 :     11|05:54:52.1330|ty5hMX|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:52.1330|ty5hMX|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:52.1330|ty5hMX|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:52.1330|ty5hMX|CJPOWERCAST|imfx v3 API took 0.006s '/api/user-preferences?_dc=1706853376756'
t Transfer: 1220 :     11|05:54:55.3870|7DJibz|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853380001
t Transfer: 1220 :     11|05:54:55.3870|7DJibz|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:55.3870|7DJibz|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:55.3870|7DJibz|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:55.3870|7DJibz|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:55.3870|7DJibz|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:55.3870|7DJibz|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:55.3870|7DJibz|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:55.3870|7DJibz|CJPOWERCAST|imfx v3 API took 0.013s '/api/v3/search-suggestion/?_dc=1706853380001'
t Transfer: 1220 :     11|05:54:56.0032|SYfv3T|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853380531
t Transfer: 1220 :     11|05:54:56.0032|SYfv3T|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:56.0032|SYfv3T|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:56.0032|SYfv3T|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:56.0032|SYfv3T|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:56.0032|SYfv3T|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:56.0032|SYfv3T|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:56.0032|SYfv3T|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:56.0032|SYfv3T|CJPOWERCAST|imfx v3 API took 0.022s '/api/v3/search-suggestion/?_dc=1706853380531'
t Transfer: 1220 :     11|05:54:56.2064|v3NzBU|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853380706
t Transfer: 1220 :     11|05:54:56.2064|v3NzBU|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:56.2064|v3NzBU|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:56.2064|v3NzBU|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:56.2064|v3NzBU|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:56.2064|v3NzBU|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:56.2064|v3NzBU|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:56.2064|v3NzBU|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:56.2064|v3NzBU|CJPOWERCAST|imfx v3 API took 0.013s '/api/v3/search-suggestion/?_dc=1706853380706'
t Transfer: 1220 :     11|05:54:56.2064|wl_Knp|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853380854
t Transfer: 1220 :     11|05:54:56.2064|wl_Knp|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:56.2064|wl_Knp|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:56.2064|wl_Knp|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:56.2064|wl_Knp|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:56.2064|wl_Knp|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:56.2064|wl_Knp|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:56.2064|wl_Knp|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:56.2064|wl_Knp|CJPOWERCAST|imfx v3 API took 0.013s '/api/v3/search-suggestion/?_dc=1706853380854'
t Transfer: 1220 :     11|05:54:56.4095|6JgFiu|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853381048
t Transfer: 1220 :     11|05:54:56.4095|6JgFiu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:56.4095|6JgFiu|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:56.4095|6JgFiu|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:56.4095|6JgFiu|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:56.4095|6JgFiu|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:56.4095|6JgFiu|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:56.4095|6JgFiu|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:56.4095|6JgFiu|CJPOWERCAST|imfx v3 API took 0.012s '/api/v3/search-suggestion/?_dc=1706853381048'
t Transfer: 1220 :     11|05:54:56.6126|Rm1h_O|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853381191
t Transfer: 1220 :     11|05:54:56.6126|Rm1h_O|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:56.6126|Rm1h_O|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:56.6126|Rm1h_O|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:56.6126|Rm1h_O|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:56.6126|Rm1h_O|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:56.6126|Rm1h_O|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:56.6126|Rm1h_O|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:56.6126|Rm1h_O|CJPOWERCAST|imfx v3 API took 0.004s '/api/v3/search-suggestion/?_dc=1706853381191'
t Transfer: 1220 :     11|05:54:56.8158|8oFUYD|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853381445
t Transfer: 1220 :     11|05:54:56.8158|8oFUYD|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:56.8158|8oFUYD|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:56.8158|8oFUYD|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:56.8158|8oFUYD|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:54:56.8158|8oFUYD|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:56.8158|8oFUYD|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:56.8158|8oFUYD|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:56.8158|8oFUYD|CJPOWERCAST|imfx v3 API took 0.012s '/api/v3/search-suggestion/?_dc=1706853381445'
t Transfer: 1220 :     11|05:54:57.2332|AgJWHs|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1706853381701
t Transfer: 1220 :     11|05:54:57.2332|AgJWHs|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:57.2332|AgJWHs|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:57.2332|AgJWHs|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:57.2332|AgJWHs|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|05:54:57.2332|AgJWHs|CJPOWERCAST|V3Api.SearchTitles
t Information: 1220 :  11|05:54:57.2332|AgJWHs|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|05:54:57.2332|AgJWHs|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:57.2332|AgJWHs|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:57.2332|AgJWHs|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|05:54:57.2332|AgJWHs|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 (id in ( (select tobj.pgm_abs_id
                 from TMDDBA.TM_TXT_OBJ tobj
                 join TMDDBA.TM_TXT_TYP ttyp
                   on (ttyp.id = tobj.TYPE_ID)
                where contains(tobj.ctx_text_col,
                               :param_0 || ' WITHIN TEXT_DATA_PLAIN') > 0
                  and ttyp.is_alt_title = 1) union (select id from tmddba.tm_pg_abs where  contains(ctx_ids_col, :param_0||' WITHIN PROGID1')>0) union (select id from tmddba.tm_pg_abs where  contains(ctx_text_col, :param_0||' WITHIN TITLE OR '||:param_0||' WITHIN SER_TITLE')>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|05:54:57.2332|AgJWHs|CJPOWERCAST|imfx v3 API took 0.020s '/api/v3/search/title?_dc=1706853381701'
t Transfer: 1220 :     11|05:54:57.4363|Evmblb|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1706853382061
t Transfer: 1220 :     11|05:54:57.4363|Evmblb|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:57.4363|Evmblb|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:57.4363|Evmblb|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:57.4363|Evmblb|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|05:54:57.4363|Evmblb|CJPOWERCAST|StoreUserDataByKeys..
t Transfer: 1220 :     11|05:54:57.4363|Evmblb|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:54:57.4363|Evmblb|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:54:57.4363|Evmblb|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:54:57.4363|Evmblb|CJPOWERCAST|imfx v3 API took 0.009s '/api/user-preferences?_dc=1706853382061'
t Transfer: 1220 :     11|05:55:03.3442|yoQUcJ|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853387842
t Transfer: 1220 :     11|05:55:03.3442|yoQUcJ|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:03.3442|yoQUcJ|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:03.3442|yoQUcJ|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:03.3442|yoQUcJ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:55:03.3442|yoQUcJ|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:03.3442|yoQUcJ|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:03.3442|yoQUcJ|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:03.3442|yoQUcJ|CJPOWERCAST|imfx v3 API took 0.013s '/api/v3/search-suggestion/?_dc=1706853387842'
t Transfer: 1220 :     11|05:55:03.5474|JCqlUH|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1706853388087
t Transfer: 1220 :     11|05:55:03.5474|JCqlUH|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:03.5474|JCqlUH|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:03.5474|JCqlUH|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:03.5474|JCqlUH|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|05:55:03.5474|JCqlUH|CJPOWERCAST|V3Api.SearchTitles
t Information: 1220 :  11|05:55:03.5474|JCqlUH|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|05:55:03.5474|JCqlUH|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:03.5474|JCqlUH|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:03.5474|JCqlUH|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|05:55:03.5474|JCqlUH|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 (id in ( (select tobj.pgm_abs_id
                 from TMDDBA.TM_TXT_OBJ tobj
                 join TMDDBA.TM_TXT_TYP ttyp
                   on (ttyp.id = tobj.TYPE_ID)
                where contains(tobj.ctx_text_col,
                               :param_0 || ' WITHIN TEXT_DATA_PLAIN') > 0
                  and ttyp.is_alt_title = 1) union (select id from tmddba.tm_pg_abs where  contains(ctx_ids_col, :param_0||' WITHIN PROGID1')>0) union (select id from tmddba.tm_pg_abs where  contains(ctx_text_col, :param_0||' WITHIN TITLE OR '||:param_0||' WITHIN SER_TITLE')>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|05:55:03.5474|JCqlUH|CJPOWERCAST|imfx v3 API took 0.019s '/api/v3/search/title?_dc=1706853388087'
t Transfer: 1220 :     11|05:55:03.9536|RDUzrN|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1706853388430
t Transfer: 1220 :     11|05:55:03.9536|RDUzrN|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:03.9536|RDUzrN|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:03.9536|RDUzrN|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:03.9536|RDUzrN|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Verbose: 1220 :      11|05:55:03.9536|RDUzrN|CJPOWERCAST|StoreUserDataByKeys..
t Transfer: 1220 :     11|05:55:03.9536|RDUzrN|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:03.9536|RDUzrN|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:03.9536|RDUzrN|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:03.9536|RDUzrN|CJPOWERCAST|imfx v3 API took 0.008s '/api/user-preferences?_dc=1706853388430'
t Transfer: 1220 :     11|05:55:06.0026|FTEM97|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853390493
t Transfer: 1220 :     11|05:55:06.0026|FTEM97|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:06.0026|FTEM97|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:06.0026|FTEM97|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:06.0026|FTEM97|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:55:06.0026|FTEM97|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:06.0026|FTEM97|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:06.0026|FTEM97|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:06.0026|FTEM97|CJPOWERCAST|imfx v3 API took 0.005s '/api/v3/search-suggestion/?_dc=1706853390493'
t Transfer: 1220 :     11|05:55:06.0026|Wa1p1o|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853390532
t Transfer: 1220 :     11|05:55:06.0026|Wa1p1o|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:06.0026|Wa1p1o|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:06.0026|Wa1p1o|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:06.0026|Wa1p1o|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:55:06.0026|Wa1p1o|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:06.0026|Wa1p1o|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:06.0026|Wa1p1o|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:06.0026|Wa1p1o|CJPOWERCAST|imfx v3 API took 0.004s '/api/v3/search-suggestion/?_dc=1706853390532'
t Transfer: 1220 :     11|05:55:06.2057|7p1Rjm|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853390697
t Transfer: 1220 :     11|05:55:06.2057|7p1Rjm|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:06.2057|7p1Rjm|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:06.2057|7p1Rjm|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:06.2057|7p1Rjm|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:55:06.2057|7p1Rjm|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:06.2057|7p1Rjm|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:06.2057|7p1Rjm|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:06.2057|7p1Rjm|CJPOWERCAST|imfx v3 API took 0.006s '/api/v3/search-suggestion/?_dc=1706853390697'
t Transfer: 1220 :     11|05:55:11.9065|zeBwBL|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853396378
t Transfer: 1220 :     11|05:55:11.9065|zeBwBL|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:11.9065|zeBwBL|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:11.9065|zeBwBL|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:11.9065|zeBwBL|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:55:11.9065|zeBwBL|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:11.9065|zeBwBL|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:11.9065|zeBwBL|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:11.9065|zeBwBL|CJPOWERCAST|imfx v3 API took 0.020s '/api/v3/search-suggestion/?_dc=1706853396378'
t Transfer: 1220 :     11|05:55:11.9065|OQC253|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853396510
t Transfer: 1220 :     11|05:55:11.9065|OQC253|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:11.9065|OQC253|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:11.9065|OQC253|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:11.9065|OQC253|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:55:11.9065|OQC253|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:11.9065|OQC253|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:11.9065|OQC253|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:11.9065|OQC253|CJPOWERCAST|imfx v3 API took 0.005s '/api/v3/search-suggestion/?_dc=1706853396510'
t Transfer: 1220 :     11|05:55:12.3128|OF3QNJ|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853396952
t Transfer: 1220 :     11|05:55:12.3128|OF3QNJ|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:12.3128|OF3QNJ|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:12.3128|OF3QNJ|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:12.3128|OF3QNJ|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:55:12.3128|OF3QNJ|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:12.3128|OF3QNJ|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:12.3128|OF3QNJ|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:12.3128|OF3QNJ|CJPOWERCAST|imfx v3 API took 0.014s '/api/v3/search-suggestion/?_dc=1706853396952'
t Transfer: 1220 :     11|05:55:12.5159|NbeIy2|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853397166
t Transfer: 1220 :     11|05:55:12.5159|NbeIy2|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:12.5159|NbeIy2|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:12.5159|NbeIy2|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:12.5159|NbeIy2|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:55:12.5159|NbeIy2|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:12.5159|NbeIy2|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:12.5159|NbeIy2|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:12.5159|NbeIy2|CJPOWERCAST|imfx v3 API took 0.014s '/api/v3/search-suggestion/?_dc=1706853397166'
t Transfer: 1220 :     11|05:55:12.7191|HVA1de|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853397283
t Transfer: 1220 :     11|05:55:12.7191|HVA1de|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:12.7191|HVA1de|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:12.7191|HVA1de|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:12.7191|HVA1de|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:55:12.7191|HVA1de|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:12.7191|HVA1de|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:12.7191|HVA1de|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:12.7191|HVA1de|CJPOWERCAST|imfx v3 API took 0.004s '/api/v3/search-suggestion/?_dc=1706853397283'
t Transfer: 1220 :     11|05:55:12.9222|G~Uh0D|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853397419
t Transfer: 1220 :     11|05:55:12.9222|G~Uh0D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:12.9222|G~Uh0D|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:12.9222|G~Uh0D|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:12.9222|G~Uh0D|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:55:12.9222|G~Uh0D|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:12.9222|G~Uh0D|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:12.9222|G~Uh0D|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:12.9222|G~Uh0D|CJPOWERCAST|imfx v3 API took 0.013s '/api/v3/search-suggestion/?_dc=1706853397419'
t Transfer: 1220 :     11|05:55:13.1253|BJItzk|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853397613
t Transfer: 1220 :     11|05:55:13.1253|BJItzk|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:13.1253|BJItzk|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:13.1253|BJItzk|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:13.1253|BJItzk|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:55:13.1253|BJItzk|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:13.1253|BJItzk|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:13.1253|BJItzk|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:13.1253|BJItzk|CJPOWERCAST|imfx v3 API took 0.012s '/api/v3/search-suggestion/?_dc=1706853397613'
t Transfer: 1220 :     11|05:55:13.1253|wUWzRn|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853397773
t Transfer: 1220 :     11|05:55:13.1253|wUWzRn|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:13.1253|wUWzRn|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:13.1253|wUWzRn|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:13.1253|wUWzRn|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:55:13.1253|wUWzRn|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:13.1253|wUWzRn|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:13.1253|wUWzRn|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:13.1253|wUWzRn|CJPOWERCAST|imfx v3 API took 0.012s '/api/v3/search-suggestion/?_dc=1706853397773'
t Transfer: 1220 :     11|05:55:13.3284|liTi38|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853397932
t Transfer: 1220 :     11|05:55:13.3284|liTi38|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:13.3284|liTi38|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:13.3284|liTi38|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:13.3284|liTi38|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:55:13.3284|liTi38|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:13.3284|liTi38|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:13.3284|liTi38|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:13.3284|liTi38|CJPOWERCAST|imfx v3 API took 0.004s '/api/v3/search-suggestion/?_dc=1706853397932'
t Transfer: 1220 :     11|05:55:13.7347|7gg9fg|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853398203
t Transfer: 1220 :     11|05:55:13.7347|7gg9fg|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:13.7347|7gg9fg|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:13.7347|7gg9fg|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:13.7347|7gg9fg|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:55:13.7347|7gg9fg|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:13.7347|7gg9fg|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:13.7347|7gg9fg|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:13.7347|7gg9fg|CJPOWERCAST|imfx v3 API took 0.018s '/api/v3/search-suggestion/?_dc=1706853398203'
t Transfer: 1220 :     11|05:55:13.9378|AMmYn5|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1706853398442
t Transfer: 1220 :     11|05:55:13.9378|AMmYn5|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:13.9378|AMmYn5|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:13.9378|AMmYn5|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:13.9378|AMmYn5|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|05:55:13.9378|AMmYn5|CJPOWERCAST|V3Api.SearchTitles
t Information: 1220 :  11|05:55:13.9378|AMmYn5|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|05:55:13.9378|AMmYn5|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:13.9378|AMmYn5|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:13.9378|AMmYn5|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|05:55:13.9378|AMmYn5|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 (id in ( (select tobj.pgm_abs_id
                 from TMDDBA.TM_TXT_OBJ tobj
                 join TMDDBA.TM_TXT_TYP ttyp
                   on (ttyp.id = tobj.TYPE_ID)
                where contains(tobj.ctx_text_col,
                               :param_0 || ' WITHIN TEXT_DATA_PLAIN') > 0
                  and ttyp.is_alt_title = 1) union (select id from tmddba.tm_pg_abs where  contains(ctx_ids_col, :param_0||' WITHIN PROGID1')>0) union (select id from tmddba.tm_pg_abs where  contains(ctx_text_col, :param_0||' WITHIN TITLE OR '||:param_0||' WITHIN SER_TITLE')>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|05:55:13.9378|AMmYn5|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.id TitleId from TM_PG_ABS 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) and o.type_id=:param_1 
                    order by o.id desc fetch first 1 rows only)(+)
t Verbose: 1220 :      11|05:55:13.9378|AMmYn5|CJPOWERCAST|imfx v3 API took 0.027s '/api/v3/search/title?_dc=1706853398442'
t Transfer: 1220 :     11|05:55:14.1409|_hErE3|CJPOWERCAST|OAuth: /api/v3/title/299390/versions?_dc=1706853398791
t Transfer: 1220 :     11|05:55:14.1409|_hErE3|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:14.1409|_hErE3|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:14.1409|_hErE3|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:14.1409|_hErE3|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:55:14.1409|1VcvNV|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1706853398793
t Transfer: 1220 :     11|05:55:14.1409|1VcvNV|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:14.1409|1VcvNV|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:14.1409|1VcvNV|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:14.1409|1VcvNV|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|05:55:14.1409|_hErE3|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|05:55:14.1409|_hErE3|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:14.1409|_hErE3|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:14.1409|_hErE3|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:14.1409|1VcvNV|CJPOWERCAST|StoreUserDataByKeys..
t Transfer: 1220 :     11|05:55:14.1409|1VcvNV|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:14.1409|1VcvNV|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:14.1409|1VcvNV|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|05:55:14.1409|_hErE3|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:14.1409|_hErE3|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:14.1409|_hErE3|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|05:55:14.1409|_hErE3|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:14.1409|_hErE3|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:14.1409|_hErE3|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:14.1409|1VcvNV|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-preferences?_dc=1706853398793'
t Information: 1220 :  11|05:55:14.1409|_hErE3|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 med.medium_name
  from TM_CFG_MEDIUM med, TM_PG_ABS pgabs
 where pgabs.id=v.PGM_ABS_ID and pgabs.MEDIUM_ID = med.id) MEDIUM_TEXT ,(select replace(tmd_str_agg_pipe(cf.form_name),'|',' / ')
  from TM_PG_FORM_LNX fl
  join TM_CFG_FORM cf on (cf.id=fl.form_id)
 where fl.tm_pg_id = v.ID) FORM_TEXT ,(select replace(tmd_str_agg_pipe(dvb.item_name),'|',' / ')
  from TM_PG_ABS_GENRE_LNX gl
  join TM_DVB dvb on (dvb.id=gl.genre_id)
 where gl.tm_pg_abs_id = v.PGM_ABS_ID) GENRE_TEXT, (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = v.net_grp_id) CHANNEL_GROUP, (select count(id) from tm_mis where item_type>0 and pgm_parent_id=v.id) MEDIA_COUNT, (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|05:55:14.1409|_hErE3|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:14.1409|_hErE3|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:14.1409|_hErE3|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|05:55:14.3440|_hErE3|CJPOWERCAST|Running version search. User: 1165    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 7ms.  Returned lines: 0

t Verbose: 1220 :      11|05:55:14.3440|_hErE3|CJPOWERCAST|imfx v3 API took 0.017s '/api/v3/title/299390/versions?_dc=1706853398791'
t Transfer: 1220 :     11|05:55:15.1635|YJ4OHw|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853399740
t Transfer: 1220 :     11|05:55:15.1635|YJ4OHw|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:15.1635|YJ4OHw|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:15.1635|YJ4OHw|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:15.1635|YJ4OHw|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:55:15.1635|YJ4OHw|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:15.1635|YJ4OHw|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:15.1635|YJ4OHw|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:15.1635|YJ4OHw|CJPOWERCAST|imfx v3 API took 0.004s '/api/v3/search-suggestion/?_dc=1706853399740'
t Transfer: 1220 :     11|05:55:17.8156|CYwM_L|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853402396
t Transfer: 1220 :     11|05:55:17.8156|CYwM_L|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:17.8156|CYwM_L|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:17.8156|CYwM_L|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:17.8156|CYwM_L|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:55:17.8156|CYwM_L|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:17.8156|CYwM_L|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:17.8156|CYwM_L|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:17.8156|CYwM_L|CJPOWERCAST|imfx v3 API took 0.005s '/api/v3/search-suggestion/?_dc=1706853402396'
t Transfer: 1220 :     11|05:55:18.0192|X2ebid|CJPOWERCAST|OAuth: /api/v3/search-suggestion/?_dc=1706853402551
t Transfer: 1220 :     11|05:55:18.0192|X2ebid|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:18.0192|X2ebid|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:18.0199|X2ebid|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:18.0199|X2ebid|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:55:18.0199|X2ebid|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:18.0199|X2ebid|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:18.0199|X2ebid|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:18.0199|X2ebid|CJPOWERCAST|imfx v3 API took 0.013s '/api/v3/search-suggestion/?_dc=1706853402551'
t Transfer: 1220 :     11|05:55:18.6343|yOhQPj|CJPOWERCAST|OAuth: /api/v3/search/title?_dc=1706853403204
t Transfer: 1220 :     11|05:55:18.6343|yOhQPj|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:18.6343|yOhQPj|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:18.6343|yOhQPj|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:18.6343|yOhQPj|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|05:55:18.6343|yOhQPj|CJPOWERCAST|V3Api.SearchTitles
t Information: 1220 :  11|05:55:18.6343|yOhQPj|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|05:55:18.6343|yOhQPj|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:18.6343|yOhQPj|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:18.6343|yOhQPj|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|05:55:18.6343|yOhQPj|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 (id in ( (select tobj.pgm_abs_id
                 from TMDDBA.TM_TXT_OBJ tobj
                 join TMDDBA.TM_TXT_TYP ttyp
                   on (ttyp.id = tobj.TYPE_ID)
                where contains(tobj.ctx_text_col,
                               :param_0 || ' WITHIN TEXT_DATA_PLAIN') > 0
                  and ttyp.is_alt_title = 1) union (select id from tmddba.tm_pg_abs where  contains(ctx_ids_col, :param_0||' WITHIN PROGID1')>0) union (select id from tmddba.tm_pg_abs where  contains(ctx_text_col, :param_0||' WITHIN TITLE OR '||:param_0||' WITHIN SER_TITLE')>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|05:55:18.6343|yOhQPj|CJPOWERCAST|Alternative title fields query: select * from (select x.id,x.id TitleId from TM_PG_ABS 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) and o.type_id=:param_1 
                    order by o.id desc fetch first 1 rows only)(+)
t Verbose: 1220 :      11|05:55:18.6343|yOhQPj|CJPOWERCAST|imfx v3 API took 0.079s '/api/v3/search/title?_dc=1706853403204'
t Transfer: 1220 :     11|05:55:19.0405|ZuVQg_|CJPOWERCAST|OAuth: /api/v3/title/299390/versions?_dc=1706853403608
t Transfer: 1220 :     11|05:55:19.0405|ZuVQg_|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:19.0405|ZuVQg_|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:19.0405|ZuVQg_|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:19.0405|ZuVQg_|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Transfer: 1220 :     11|05:55:19.0405|WDJBcN|CJPOWERCAST|OAuth: /api/user-preferences?_dc=1706853403610
t Transfer: 1220 :     11|05:55:19.0405|WDJBcN|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:19.0405|WDJBcN|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:19.0405|WDJBcN|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:19.0405|WDJBcN|CJPOWERCAST|OAuth. User logged in: CJPOWERCAST
t Information: 1220 :  11|05:55:19.0405|ZuVQg_|CJPOWERCAST|V3Api.SearchGeneric
t Transfer: 1220 :     11|05:55:19.0405|ZuVQg_|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:19.0405|ZuVQg_|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:19.0405|ZuVQg_|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|05:55:19.0405|ZuVQg_|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:19.0405|ZuVQg_|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:19.0405|ZuVQg_|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:19.0405|WDJBcN|CJPOWERCAST|StoreUserDataByKeys..
t Transfer: 1220 :     11|05:55:19.0405|WDJBcN|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:19.0405|WDJBcN|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:19.0405|WDJBcN|CJPOWERCAST|    user CJPOWERCAST.
t Transfer: 1220 :     11|05:55:19.0405|ZuVQg_|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:19.0405|ZuVQg_|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:19.0405|ZuVQg_|CJPOWERCAST|    user CJPOWERCAST.
t Information: 1220 :  11|05:55:19.0405|ZuVQg_|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 med.medium_name
  from TM_CFG_MEDIUM med, TM_PG_ABS pgabs
 where pgabs.id=v.PGM_ABS_ID and pgabs.MEDIUM_ID = med.id) MEDIUM_TEXT ,(select replace(tmd_str_agg_pipe(cf.form_name),'|',' / ')
  from TM_PG_FORM_LNX fl
  join TM_CFG_FORM cf on (cf.id=fl.form_id)
 where fl.tm_pg_id = v.ID) FORM_TEXT ,(select replace(tmd_str_agg_pipe(dvb.item_name),'|',' / ')
  from TM_PG_ABS_GENRE_LNX gl
  join TM_DVB dvb on (dvb.id=gl.genre_id)
 where gl.tm_pg_abs_id = v.PGM_ABS_ID) GENRE_TEXT, (select chgrp.chan_group_name from tm_ch_grps chgrp where chgrp.id = v.net_grp_id) CHANNEL_GROUP, (select count(id) from tm_mis where item_type>0 and pgm_parent_id=v.id) MEDIA_COUNT, (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|05:55:19.0405|ZuVQg_|CJPOWERCAST|GetCurrentUser..
t Transfer: 1220 :     11|05:55:19.0405|ZuVQg_|CJPOWERCAST|  OAuth authenticated
t Transfer: 1220 :     11|05:55:19.0405|ZuVQg_|CJPOWERCAST|    user CJPOWERCAST.
t Verbose: 1220 :      11|05:55:19.0405|WDJBcN|CJPOWERCAST|imfx v3 API took 0.007s '/api/user-preferences?_dc=1706853403610'
t Information: 1220 :  11|05:55:19.0405|ZuVQg_|CJPOWERCAST|Running version search. User: 1165    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 4ms.  Returned lines: 0

t Verbose: 1220 :      11|05:55:19.0405|ZuVQg_|CJPOWERCAST|imfx v3 API took 0.012s '/api/v3/title/299390/versions?_dc=1706853403608'
t Information: 1220 :  11|08:17:04.5658|||OrabitWatcherBasic. Disposing.
t Information: 1220 :  11|08:17:04.5658|||OrabitWatcherBasic. Disposed.
t Information: 1220 :  11|08:17:04.5658|||==========================================================================
t Information: 1220 :  11|08:17:04.5658|||IMFX CORE SERVER APPLICATION END.