t Transfer: 1220 :     12|10:15:04.7836|B2_EOM||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey
t Verbose: 1220 :      12|10:15:05.5876|VNd7jl||imfx v3 API took 0.110s '/api/v3/visual-asset/group/null/2/image'
t Verbose: 1220 :      12|10:15:20.8626|hADEay||Oauth validating..
t Verbose: 1220 :      12|10:15:20.8626|hADEay||GrantResourceOwnerCredentials.
t Verbose: 1220 :      12|10:15:20.8626|hADEay||LoginUser. daniel, login type OAuth, encrypt password True
t Information: 1220 :  12|10:15:20.8636|hADEay||TryLoginUser. daniel, login type OAuth, check password True, check hash False, encrypt password True, load user data False
t Information: 1220 :  12|10:15:21.2656|hADEay||  oauth token 00000000-0000-0000-0000-000000000000
t Information: 1220 :  12|10:15:21.2656|hADEay||TryLoginUser. Logged in..
t Information: 1220 :  12|10:15:21.2656|hADEay||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled.
t Verbose: 1220 :      12|10:15:21.2656|hADEay||LoginUser. Adding history. User Id 342, result DANIEL, host 192.168.127.6
t Verbose: 1220 :      12|10:15:21.2656|hADEay||GrantResourceOwnerCredentials. Try login finished. Logged: True
t Transfer: 1220 :     12|10:15:21.4676|~9jFBr|DANIEL|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=1665479723204
t Transfer: 1220 :     12|10:15:21.4676|~9jFBr|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:21.4676|~9jFBr|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:21.4676|~9jFBr|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:21.4676|~9jFBr|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:15:21.4686|~9jFBr|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:21.4686|~9jFBr|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:21.4686|~9jFBr|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:21.6697|~9jFBr|DANIEL|imfx v3 API took 0.057s '/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=1665479723204'
t Transfer: 1220 :     12|10:15:21.6697|3Jib~R|DANIEL|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1665479723351
t Transfer: 1220 :     12|10:15:21.6697|3Jib~R|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:21.6697|3Jib~R|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:21.6697|3Jib~R|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:21.6706|3Jib~R|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|10:15:21.6706|3Jib~R|DANIEL|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings
t Transfer: 1220 :     12|10:15:21.6706|3Jib~R|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:21.6706|3Jib~R|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:21.6706|3Jib~R|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:21.6706|3Jib~R|DANIEL|imfx v3 API took 0.054s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1665479723351'
t Information: 1220 :  12|10:15:21.8716|gvXJNu|DANIEL|GetUserProfile. Id: 0
t Transfer: 1220 :     12|10:15:21.8716|gvXJNu|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:21.8716|gvXJNu|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:21.8716|gvXJNu|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:15:22.0726|LwArwi|DANIEL|OAuth: /api/settings/group/0?_dc=1665479723765
t Transfer: 1220 :     12|10:15:22.0726|LwArwi|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:22.0726|LwArwi|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:22.0726|LwArwi|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:22.0726|LwArwi|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:15:22.0726|GondGc|DANIEL|OAuth: /api/settings/user/uploadSettings?_dc=1665479723832
t Transfer: 1220 :     12|10:15:22.0736|GondGc|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:22.0736|GondGc|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:22.0736|GondGc|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:22.0736|GondGc|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:15:22.2756|GondGc|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:22.2756|GondGc|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:22.2756|GondGc|DANIEL|    user DANIEL.
t Information: 1220 :  12|10:15:22.2756|SqSkVC||GetCache.
t Information: 1220 :  12|10:15:22.2756|SqSkVC||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\2_1_M6I_N7.png
t Information: 1220 :  12|10:15:22.2756|SqSkVC||GetCache. Data read: 0
t Verbose: 1220 :      12|10:15:22.2766|GondGc|DANIEL|imfx v3 API took 0.113s '/api/settings/user/uploadSettings?_dc=1665479723832'
t Verbose: 1220 :      12|10:15:22.2766|SqSkVC||imfx v3 API took 0.154s '/api/v3/visual-asset/group/M6I_N7/1/image'
t Verbose: 1220 :      12|10:15:22.4776|LwArwi|DANIEL|imfx v3 API took 0.320s '/api/settings/group/0?_dc=1665479723765'
t Transfer: 1220 :     12|10:15:22.4776|n9D1~N|DANIEL|OAuth: /api/settings/group/0?_dc=1665479724206
t Transfer: 1220 :     12|10:15:22.4776|n9D1~N|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:22.4776|n9D1~N|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:22.4776|n9D1~N|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:22.4786|n9D1~N|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|10:15:22.6916|4Q25A9||GetCache.
t Information: 1220 :  12|10:15:22.6916|4Q25A9||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\1_0_M6I_N7.png
t Information: 1220 :  12|10:15:22.6916|4Q25A9||GetCache. Data read: 0
t Verbose: 1220 :      12|10:15:22.6916|4Q25A9||imfx v3 API took 0.006s '/api/v3/visual-asset/group/M6I_N7/0/image'
t Transfer: 1220 :     12|10:15:22.6926|~wQLuR|DANIEL|OAuth: /api/lookups/MediaStatus?_dc=1665479724294
t Transfer: 1220 :     12|10:15:22.6926|~wQLuR|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:22.6926|~wQLuR|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:22.6926|~wQLuR|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:22.6926|~wQLuR|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      12|10:15:22.6926|n9D1~N|DANIEL|imfx v3 API took 0.084s '/api/settings/group/0?_dc=1665479724206'
t Transfer: 1220 :     12|10:15:22.6936|2dl5C3|DANIEL|OAuth: /api/lookup/CustomMediaStatusTypes?_dc=1665479724300
t Transfer: 1220 :     12|10:15:22.6936|2dl5C3|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:22.6936|2dl5C3|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:22.6946|2dl5C3|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:22.6946|2dl5C3|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:15:22.6946|K2NyPs|DANIEL|OAuth: /api/lookups/PgmStatus?_dc=1665479724296
t Transfer: 1220 :     12|10:15:22.6946|K2NyPs|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:22.6946|K2NyPs|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:22.6946|K2NyPs|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:22.6956|K2NyPs|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      12|10:15:22.6956|~wQLuR|DANIEL|imfx v3 API took 0.044s '/api/lookups/MediaStatus?_dc=1665479724294'
t Transfer: 1220 :     12|10:15:22.8966|p8xnyM|DANIEL|OAuth: /api/lookup/CustomTitleStatusTypes?_dc=1665479724304
t Transfer: 1220 :     12|10:15:22.8966|p8xnyM|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:22.8966|p8xnyM|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:22.8966|p8xnyM|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:22.8966|p8xnyM|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:15:22.8966|zNyVdm|DANIEL|OAuth: /api/lookup/CustomVersionStatusTypes?_dc=1665479724303
t Transfer: 1220 :     12|10:15:22.8966|zNyVdm|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:22.8976|zNyVdm|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:22.8976|zNyVdm|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:22.8976|zNyVdm|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:15:22.8976|1_jEEW|DANIEL|OAuth: /api/settings/user/defaultHomePage?_dc=1665479724306
t Transfer: 1220 :     12|10:15:22.8976|1_jEEW|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:22.8976|1_jEEW|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:22.8976|1_jEEW|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:22.8976|1_jEEW|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      12|10:15:22.8976|K2NyPs|DANIEL|imfx v3 API took 0.000s '/api/lookups/PgmStatus?_dc=1665479724296'
t Transfer: 1220 :     12|10:15:22.8986|1_jEEW|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:22.8986|1_jEEW|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:22.8986|1_jEEW|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:22.8986|1_jEEW|DANIEL|imfx v3 API took 0.022s '/api/settings/user/defaultHomePage?_dc=1665479724306'
t Verbose: 1220 :      12|10:15:22.8986|zNyVdm|DANIEL|imfx v3 API took 0.030s '/api/lookup/CustomVersionStatusTypes?_dc=1665479724303'
t Verbose: 1220 :      12|10:15:22.8986|p8xnyM|DANIEL|imfx v3 API took 0.037s '/api/lookup/CustomTitleStatusTypes?_dc=1665479724304'
t Verbose: 1220 :      12|10:15:22.8986|2dl5C3|DANIEL|imfx v3 API took 0.043s '/api/lookup/CustomMediaStatusTypes?_dc=1665479724300'
t Transfer: 1220 :     12|10:15:24.1046|QvVNIG|DANIEL|OAuth: /api/settings/user/consumer?_dc=1665479725897
t Transfer: 1220 :     12|10:15:24.1046|QvVNIG|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:24.1046|QvVNIG|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:24.1046|QvVNIG|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:24.1046|QvVNIG|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:15:24.1056|QvVNIG|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:24.1056|QvVNIG|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:24.1056|QvVNIG|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:24.3066|QvVNIG|DANIEL|imfx v3 API took 0.024s '/api/settings/user/consumer?_dc=1665479725897'
t Transfer: 1220 :     12|10:15:24.3066|uhyAix|DANIEL|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1665479726045
t Transfer: 1220 :     12|10:15:24.3066|uhyAix|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:24.3066|uhyAix|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:24.3066|uhyAix|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:24.3066|uhyAix|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|10:15:24.3076|uhyAix|DANIEL|GetUserDataByKeys: consumer.recent.data
t Transfer: 1220 :     12|10:15:24.3076|uhyAix|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:24.3076|uhyAix|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:24.3076|uhyAix|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:24.5086|uhyAix|DANIEL|imfx v3 API took 0.006s '/api/user-preferences?keys=consumer.recent.data&_dc=1665479726045'
t Transfer: 1220 :     12|10:15:24.7096|~71BG1|DANIEL|OAuth: /api/settings/user/defaultSearch?_dc=1665479726448
t Transfer: 1220 :     12|10:15:24.7096|~71BG1|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:24.7096|~71BG1|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:24.7096|~71BG1|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:24.7096|~71BG1|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:15:24.7096|~71BG1|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:24.7096|~71BG1|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:24.7106|~71BG1|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:15:24.7106|CCz4MX|DANIEL|OAuth: /api/settings/user/startSearch?_dc=1665479726450
t Transfer: 1220 :     12|10:15:24.7106|CCz4MX|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:24.7106|CCz4MX|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:24.7106|CCz4MX|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:24.7106|CCz4MX|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:15:24.7106|CCz4MX|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:24.7106|CCz4MX|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:24.7106|CCz4MX|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:24.7116|~71BG1|DANIEL|imfx v3 API took 0.017s '/api/settings/user/defaultSearch?_dc=1665479726448'
t Verbose: 1220 :      12|10:15:24.7116|CCz4MX|DANIEL|imfx v3 API took 0.013s '/api/settings/user/startSearch?_dc=1665479726450'
t Transfer: 1220 :     12|10:15:24.9126|UY0z3d|DANIEL|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1665479726495
t Transfer: 1220 :     12|10:15:24.9126|UY0z3d|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:24.9126|UY0z3d|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:24.9126|UY0z3d|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:24.9126|UY0z3d|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|10:15:24.9136|UY0z3d|DANIEL|GetUserDataByKeys: consumer.recent.data
t Transfer: 1220 :     12|10:15:24.9136|UY0z3d|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:24.9136|UY0z3d|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:24.9136|UY0z3d|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:24.9136|UY0z3d|DANIEL|imfx v3 API took 0.007s '/api/user-preferences?keys=consumer.recent.data&_dc=1665479726495'
t Information: 1220 :  12|10:15:24.9136|L5psZV||GetCache.
t Information: 1220 :  12|10:15:24.9136|L5psZV||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\5_3_M6I_N7.png
t Information: 1220 :  12|10:15:24.9146|L5psZV||GetCache. Data read: 40477
t Verbose: 1220 :      12|10:15:24.9146|L5psZV||imfx v3 API took 0.006s '/api/v3/visual-asset/group/M6I_N7/3/image'
t Transfer: 1220 :     12|10:15:29.5386|lrJh11|DANIEL|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1665479731160
t Transfer: 1220 :     12|10:15:29.5386|lrJh11|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:29.5386|lrJh11|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:29.5386|lrJh11|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:29.5396|lrJh11|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:15:29.5396|lrJh11|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:29.5396|lrJh11|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:29.5396|lrJh11|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:29.5396|lrJh11|DANIEL|imfx v3 API took 0.008s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1665479731160'
t Transfer: 1220 :     12|10:15:29.5396|YLZyuk|DANIEL|OAuth: /api/v3/versionvideo/299543?_dc=1665479731290
t Transfer: 1220 :     12|10:15:29.5406|YLZyuk|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:29.5406|YLZyuk|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:29.5406|YLZyuk|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:29.5406|YLZyuk|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:15:29.5406|GvdKqc|DANIEL|OAuth: /api/v3/versionvideo/299543?_dc=1665479731295
t Transfer: 1220 :     12|10:15:29.5406|GvdKqc|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:29.5406|GvdKqc|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:29.5416|GvdKqc|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:29.5416|GvdKqc|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:15:29.7426|YLZyuk|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:29.7426|YLZyuk|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:29.7426|YLZyuk|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:15:29.7426|GvdKqc|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:29.7426|GvdKqc|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:29.7426|GvdKqc|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:15:30.3046|GvdKqc|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder 
t Transfer: 1220 :     12|10:15:30.3146|YLZyuk|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder 
t Transfer: 1220 :     12|10:15:30.3146|GvdKqc|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4
t Transfer: 1220 :     12|10:15:30.3146|GvdKqc|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4
t Transfer: 1220 :     12|10:15:30.3146|YLZyuk|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4
t Transfer: 1220 :     12|10:15:30.3156|YLZyuk|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4
t Transfer: 1220 :     12|10:15:30.3156|YLZyuk|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:30.3156|YLZyuk|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:30.3156|YLZyuk|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:15:30.3156|GvdKqc|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:15:30.3156|GvdKqc|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:15:30.3156|GvdKqc|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:15:30.3166|GvdKqc|DANIEL|imfx v3 API took 0.582s '/api/v3/versionvideo/299543?_dc=1665479731295'
t Verbose: 1220 :      12|10:15:30.3166|YLZyuk|DANIEL|imfx v3 API took 0.590s '/api/v3/versionvideo/299543?_dc=1665479731290'
t Transfer: 1220 :     12|10:16:22.1676|78_Xpo|DANIEL|OAuth: /api/v3/versionvideo/299563?_dc=1665479783754
t Transfer: 1220 :     12|10:16:22.1676|78_Xpo|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:16:22.1676|78_Xpo|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:16:22.1676|78_Xpo|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:16:22.1676|78_Xpo|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:16:22.1676|78_Xpo|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:16:22.1686|78_Xpo|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:16:22.1686|78_Xpo|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:16:22.1686|BWIigY|DANIEL|OAuth: /api/v3/versionvideo/299563?_dc=1665479783766
t Transfer: 1220 :     12|10:16:22.1686|BWIigY|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:16:22.1686|BWIigY|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:16:22.1686|BWIigY|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:16:22.1686|BWIigY|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:16:22.1686|BWIigY|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:16:22.1686|BWIigY|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:16:22.1696|BWIigY|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:16:22.3706|78_Xpo|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001993.mp4 subfolder 
t Transfer: 1220 :     12|10:16:22.3706|78_Xpo|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4
t Transfer: 1220 :     12|10:16:22.3706|78_Xpo|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4
t Transfer: 1220 :     12|10:16:22.3706|78_Xpo|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:16:22.3706|78_Xpo|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:16:22.3706|78_Xpo|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:16:22.3716|BWIigY|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001993.mp4 subfolder 
t Transfer: 1220 :     12|10:16:22.3716|BWIigY|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4
t Transfer: 1220 :     12|10:16:22.3716|BWIigY|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001993.mp4
t Transfer: 1220 :     12|10:16:22.3716|BWIigY|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:16:22.3716|BWIigY|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:16:22.3716|BWIigY|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:16:22.3716|78_Xpo|DANIEL|imfx v3 API took 0.176s '/api/v3/versionvideo/299563?_dc=1665479783754'
t Verbose: 1220 :      12|10:16:22.3716|BWIigY|DANIEL|imfx v3 API took 0.123s '/api/v3/versionvideo/299563?_dc=1665479783766'
t Transfer: 1220 :     12|10:16:39.5026|xE2WXX|DANIEL|OAuth: /api/v3/versionvideo/299543?_dc=1665479801271
t Transfer: 1220 :     12|10:16:39.5026|xE2WXX|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:16:39.5026|xE2WXX|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:16:39.5036|xE2WXX|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:16:39.5036|xE2WXX|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:16:39.5036|xE2WXX|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:16:39.5036|xE2WXX|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:16:39.5046|xE2WXX|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:16:39.7306|xE2WXX|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder 
t Transfer: 1220 :     12|10:16:39.7306|xE2WXX|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4
t Transfer: 1220 :     12|10:16:39.7306|xE2WXX|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4
t Transfer: 1220 :     12|10:16:39.7306|xE2WXX|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:16:39.7316|xE2WXX|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:16:39.7336|xE2WXX|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:16:39.7336|xE2WXX|DANIEL|imfx v3 API took 0.031s '/api/v3/versionvideo/299543?_dc=1665479801271'
t Transfer: 1220 :     12|10:16:39.7346|kpf06S|DANIEL|OAuth: /api/v3/versionvideo/299543?_dc=1665479801359
t Transfer: 1220 :     12|10:16:39.7346|kpf06S|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:16:39.7346|kpf06S|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:16:39.7346|kpf06S|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:16:39.7346|kpf06S|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:16:39.7346|kpf06S|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:16:39.7346|kpf06S|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:16:39.7346|kpf06S|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:16:39.7346|hmiR0C|DANIEL|OAuth: /api/v3/versionvideo/299543?_dc=1665479801365
t Transfer: 1220 :     12|10:16:39.7346|hmiR0C|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:16:39.7356|hmiR0C|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:16:39.7356|hmiR0C|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:16:39.7356|hmiR0C|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:16:39.7356|hmiR0C|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:16:39.7356|hmiR0C|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:16:39.7356|hmiR0C|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:16:39.7356|kpf06S|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder 
t Transfer: 1220 :     12|10:16:39.7356|kpf06S|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4
t Transfer: 1220 :     12|10:16:39.7356|kpf06S|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4
t Transfer: 1220 :     12|10:16:39.7366|kpf06S|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:16:39.7366|kpf06S|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:16:39.7366|kpf06S|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:16:39.7366|kpf06S|DANIEL|imfx v3 API took 0.044s '/api/v3/versionvideo/299543?_dc=1665479801359'
t Transfer: 1220 :     12|10:16:39.9376|hmiR0C|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder 
t Transfer: 1220 :     12|10:16:39.9376|hmiR0C|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4
t Transfer: 1220 :     12|10:16:39.9376|hmiR0C|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4
t Transfer: 1220 :     12|10:16:39.9376|hmiR0C|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:16:39.9376|hmiR0C|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:16:39.9376|hmiR0C|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:16:39.9376|hmiR0C|DANIEL|imfx v3 API took 0.144s '/api/v3/versionvideo/299543?_dc=1665479801365'
t Transfer: 1220 :     12|10:16:39.9376|ZKoMbQ|DANIEL|OAuth: /api/v3/versionvideo/299543?_dc=1665479801628
t Transfer: 1220 :     12|10:16:39.9376|ZKoMbQ|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:16:39.9386|ZKoMbQ|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:16:39.9386|ZKoMbQ|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:16:39.9386|ZKoMbQ|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:16:39.9386|ZKoMbQ|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:16:39.9386|ZKoMbQ|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:16:39.9386|ZKoMbQ|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:16:39.9386|ZKoMbQ|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder 
t Transfer: 1220 :     12|10:16:39.9386|ZKoMbQ|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4
t Transfer: 1220 :     12|10:16:39.9386|ZKoMbQ|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4
t Transfer: 1220 :     12|10:16:39.9386|ZKoMbQ|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:16:39.9386|ZKoMbQ|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:16:39.9386|ZKoMbQ|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:16:39.9396|ZKoMbQ|DANIEL|imfx v3 API took 0.021s '/api/v3/versionvideo/299543?_dc=1665479801628'
t Transfer: 1220 :     12|10:18:27.9026|E45J5b|DANIEL|OAuth: /api/view/searchinfo/TitleSearch?_dc=1665479909615
t Transfer: 1220 :     12|10:18:27.9026|E45J5b|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:27.9026|E45J5b|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:27.9026|E45J5b|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:27.9026|E45J5b|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|10:18:27.9026|E45J5b|DANIEL|GetAdvSearchColumns. search type TitleSearch grid .
t Verbose: 1220 :      12|10:18:27.9036|E45J5b|DANIEL|imfx v3 API took 0.003s '/api/view/searchinfo/TitleSearch?_dc=1665479909615'
t Transfer: 1220 :     12|10:18:27.9036|ZpYgY~|DANIEL|OAuth: /api/lookups/SearchSupportedOperators?_dc=1665479909617
t Transfer: 1220 :     12|10:18:27.9036|ZpYgY~|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:27.9036|ZpYgY~|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:27.9036|ZpYgY~|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:27.9036|ZpYgY~|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      12|10:18:27.9036|ZpYgY~|DANIEL|imfx v3 API took 0.000s '/api/lookups/SearchSupportedOperators?_dc=1665479909617'
t Transfer: 1220 :     12|10:18:27.9036|Bp6Y3W|DANIEL|OAuth: /api/user-preferences?keys=adv.recent.searches.titles&_dc=1665479909622
t Transfer: 1220 :     12|10:18:27.9036|Bp6Y3W|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:27.9046|Bp6Y3W|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:27.9046|Bp6Y3W|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:27.9046|Bp6Y3W|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|10:18:27.9046|Bp6Y3W|DANIEL|GetUserDataByKeys: adv.recent.searches.titles
t Transfer: 1220 :     12|10:18:27.9046|Bp6Y3W|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:27.9046|Bp6Y3W|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:27.9046|Bp6Y3W|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:28.1056|Bp6Y3W|DANIEL|imfx v3 API took 0.005s '/api/user-preferences?keys=adv.recent.searches.titles&_dc=1665479909622'
t Transfer: 1220 :     12|10:18:28.1056|YvJ7Pf|DANIEL|OAuth: /api/view/searches/TitleSearch?_dc=1665479909826
t Transfer: 1220 :     12|10:18:28.1056|YvJ7Pf|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:28.1056|YvJ7Pf|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:28.1056|YvJ7Pf|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:28.1066|YvJ7Pf|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|10:18:28.1066|YvJ7Pf|DANIEL|GetSavedSearchNames. search type TitleSearch.
t Transfer: 1220 :     12|10:18:28.1066|YvJ7Pf|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:28.1076|YvJ7Pf|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:28.1076|YvJ7Pf|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:28.1076|YvJ7Pf|DANIEL|imfx v3 API took 0.048s '/api/view/searches/TitleSearch?_dc=1665479909826'
t Transfer: 1220 :     12|10:18:28.3296|HC3nVb|DANIEL|OAuth: /api/view/info/VersionGrid?lang=en-GB&_dc=1665479909891
t Transfer: 1220 :     12|10:18:28.3296|HC3nVb|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:28.3296|HC3nVb|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:28.3296|HC3nVb|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:28.3296|HC3nVb|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|10:18:28.3296|HC3nVb|DANIEL|GetGridViewBuilder. builder type VersionGrid.
t Transfer: 1220 :     12|10:18:28.3306|HC3nVb|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:28.3306|HC3nVb|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:28.3306|HC3nVb|DANIEL|    user DANIEL.
t Information: 1220 :  12|10:18:28.3306|HC3nVb|DANIEL|UserGridView. LoadView. ID 797, Name Default.
t Transfer: 1220 :     12|10:18:28.3306|HC3nVb|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:28.3306|HC3nVb|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:28.3306|HC3nVb|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:18:28.3306|HC3nVb|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:28.3316|HC3nVb|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:28.3316|HC3nVb|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:28.3316|HC3nVb|DANIEL|imfx v3 API took 0.163s '/api/view/info/VersionGrid?lang=en-GB&_dc=1665479909891'
t Transfer: 1220 :     12|10:18:28.3316|ZaddHS|DANIEL|OAuth: /api/view/info/MediaGrid?lang=en-GB&_dc=1665479910077
t Transfer: 1220 :     12|10:18:28.3316|ZaddHS|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:28.3316|ZaddHS|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:28.3316|ZaddHS|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:28.3326|ZaddHS|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|10:18:28.3326|ZaddHS|DANIEL|GetGridViewBuilder. builder type MediaGrid.
t Transfer: 1220 :     12|10:18:28.3326|ZaddHS|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:28.3326|ZaddHS|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:28.3326|ZaddHS|DANIEL|    user DANIEL.
t Information: 1220 :  12|10:18:28.3326|ZaddHS|DANIEL|UserGridView. LoadView. ID 760, Name Default.
t Transfer: 1220 :     12|10:18:28.3326|ZaddHS|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:28.3336|ZaddHS|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:28.3336|ZaddHS|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:18:28.5346|ZaddHS|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:28.5346|ZaddHS|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:28.5346|ZaddHS|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:28.5346|ZaddHS|DANIEL|imfx v3 API took 0.007s '/api/view/info/MediaGrid?lang=en-GB&_dc=1665479910077'
t Transfer: 1220 :     12|10:18:28.5346|RRj4TI|DANIEL|OAuth: /api/view/info/DigitalCarriers?lang=en-GB&_dc=1665479910264
t Transfer: 1220 :     12|10:18:28.5356|RRj4TI|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:28.5356|RRj4TI|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:28.5356|RRj4TI|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:28.5356|RRj4TI|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|10:18:28.5356|RRj4TI|DANIEL|GetGridViewBuilder. builder type DigitalCarriers.
t Transfer: 1220 :     12|10:18:28.5356|RRj4TI|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:28.5356|RRj4TI|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:28.5366|RRj4TI|DANIEL|    user DANIEL.
t Information: 1220 :  12|10:18:28.5366|RRj4TI|DANIEL|UserGridView. LoadView. ID -2, Name Default.
t Transfer: 1220 :     12|10:18:28.5366|RRj4TI|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:28.5366|RRj4TI|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:28.5366|RRj4TI|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:18:28.5366|RRj4TI|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:28.5376|RRj4TI|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:28.5376|RRj4TI|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:28.5376|RRj4TI|DANIEL|imfx v3 API took 0.010s '/api/view/info/DigitalCarriers?lang=en-GB&_dc=1665479910264'
t Transfer: 1220 :     12|10:18:28.7476|u1EiFB|DANIEL|OAuth: /api/view/info/TitleTree?lang=en-GB&_dc=1665479910368
t Transfer: 1220 :     12|10:18:28.7476|u1EiFB|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:28.7476|u1EiFB|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:28.7476|u1EiFB|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:28.7486|u1EiFB|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|10:18:28.7486|u1EiFB|DANIEL|GetGridViewBuilder. builder type TitleTree.
t Transfer: 1220 :     12|10:18:28.7486|u1EiFB|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:28.7486|u1EiFB|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:28.7486|u1EiFB|DANIEL|    user DANIEL.
t Information: 1220 :  12|10:18:28.7486|u1EiFB|DANIEL|UserGridView. LoadView. ID 796, Name Default.
t Transfer: 1220 :     12|10:18:28.7486|u1EiFB|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:28.7496|u1EiFB|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:28.7496|u1EiFB|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:18:28.7496|u1EiFB|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:28.7496|u1EiFB|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:28.7496|u1EiFB|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:28.7496|u1EiFB|DANIEL|imfx v3 API took 0.007s '/api/view/info/TitleTree?lang=en-GB&_dc=1665479910368'
t Transfer: 1220 :     12|10:18:31.1696|51GJpg|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1665479912755
t Transfer: 1220 :     12|10:18:31.1696|51GJpg|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:31.1696|51GJpg|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:31.1696|51GJpg|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:31.1706|51GJpg|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:18:31.1706|67fQ1u|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1665479912833
t Transfer: 1220 :     12|10:18:31.1706|67fQ1u|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:31.1706|67fQ1u|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:31.1706|67fQ1u|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:31.1706|67fQ1u|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:18:31.1706|51GJpg|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:31.1706|67fQ1u|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:31.1716|51GJpg|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:31.1716|67fQ1u|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:31.1716|51GJpg|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:18:31.1716|67fQ1u|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:18:31.3796|YmKx7x|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1665479913030
t Transfer: 1220 :     12|10:18:31.3796|YmKx7x|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:31.3796|YmKx7x|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:31.3816|YmKx7x|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:31.3816|YmKx7x|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:18:31.6176|YmKx7x|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:31.6176|YmKx7x|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:31.6176|YmKx7x|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:18:31.6176|MZZf6d|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1665479913152
t Transfer: 1220 :     12|10:18:31.6176|MZZf6d|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:31.6186|MZZf6d|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:31.6186|MZZf6d|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:31.6186|MZZf6d|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:18:31.6186|MZZf6d|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:31.6186|MZZf6d|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:31.6186|MZZf6d|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:18:31.8206|mUT1DO|DANIEL|OAuth: /api/v3/search-suggestion/?_dc=1665479913307
t Transfer: 1220 :     12|10:18:31.8206|mUT1DO|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:31.8206|mUT1DO|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:31.8206|mUT1DO|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:31.8206|mUT1DO|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:18:31.8206|mUT1DO|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:31.8216|mUT1DO|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:31.8216|mUT1DO|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:32.0226|67fQ1u|DANIEL|imfx v3 API took 0.818s '/api/v3/search-suggestion/?_dc=1665479912833'
t Verbose: 1220 :      12|10:18:32.0226|YmKx7x|DANIEL|imfx v3 API took 0.430s '/api/v3/search-suggestion/?_dc=1665479913030'
t Verbose: 1220 :      12|10:18:32.0226|MZZf6d|DANIEL|imfx v3 API took 0.430s '/api/v3/search-suggestion/?_dc=1665479913152'
t Verbose: 1220 :      12|10:18:32.2236|51GJpg|DANIEL|imfx v3 API took 0.955s '/api/v3/search-suggestion/?_dc=1665479912755'
t Verbose: 1220 :      12|10:18:32.2236|mUT1DO|DANIEL|imfx v3 API took 0.247s '/api/v3/search-suggestion/?_dc=1665479913307'
t Transfer: 1220 :     12|10:18:36.2436|RZythU|DANIEL|OAuth: /api/v3/search/title?_dc=1665479917979
t Transfer: 1220 :     12|10:18:36.2436|RZythU|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:36.2436|RZythU|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:36.2436|RZythU|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:36.2436|RZythU|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|10:18:36.2436|RZythU|DANIEL|V3Api.SearchTitles
t Information: 1220 :  12|10:18:36.2436|RZythU|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :     12|10:18:36.4456|RZythU|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:36.4456|RZythU|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:36.4456|RZythU|DANIEL|    user DANIEL.
t Information: 1220 :  12|10:18:36.4456|RZythU|DANIEL|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,'|VSHD|')>0  OR INSTR(OWNERS,'|VSE|')>0  OR INSTR(OWNERS,'|VS3|')>0  OR INSTR(OWNERS,'|VODS|')>0  OR INSTR(OWNERS,'|VHPO|')>0  OR INSTR(OWNERS,'|VEXE|')>0  OR INSTR(OWNERS,'|VEPL|')>0  OR INSTR(OWNERS,'|V4N|')>0  OR INSTR(OWNERS,'|V3H|')>0  OR INSTR(OWNERS,'|V1G|')>0  OR INSTR(OWNERS,'|TV6N|')>0  OR INSTR(OWNERS,'|TV3N|')>0  OR INSTR(OWNERS,'|TV1D|')>0  OR INSTR(OWNERS,'|T8LT|')>0  OR INSTR(OWNERS,'|T6LV|')>0  OR INSTR(OWNERS,'|T3LV|')>0  OR INSTR(OWNERS,'|DMY|')>0  OR INSTR(OWNERS,'|CENT|')>0  OR INSTR(OWNERS,'|03VT|')>0  OR INSTR(OWNERS,'|03SS|')>0  OR INSTR(OWNERS,'|03SE|')>0  OR INSTR(OWNERS,'|AMAY|')>0  OR INSTR(OWNERS,'|BBC|')>0  OR INSTR(OWNERS,'|SKY|')>0  OR INSTR(OWNERS,'|MED|')>0  OR INSTR(OWNERS,'|SFP1|')>0  OR INSTR(OWNERS,'|TMD|')>0  OR INSTR(OWNERS,'|HUB|')>0  OR INSTR(OWNERS,'|VNE|')>0  OR INSTR(OWNERS,'|TVPU|')>0  OR INSTR(OWNERS,'|PBOY|')>0  OR INSTR(OWNERS,'|CTCE|')>0  OR INSTR(OWNERS,'|03GO|')>0  OR INSTR(OWNERS,'|EST|')>0  OR INSTR(OWNERS,'|MTG|')>0  OR INSTR(OWNERS,'|NAA|')>0  OR INSTR(OWNERS,'|ATP|')>0  OR INSTR(OWNERS,'|ICCCTY|')>0  OR INSTR(OWNERS,'|ICCWCP|')>0  OR INSTR(OWNERS,'|ICCICC|')>0  OR INSTR(OWNERS,'|ITV|')>0  OR INSTR(OWNERS,'|SKYRUGUN|')>0  OR INSTR(OWNERS,'|SKYCRI|')>0  OR INSTR(OWNERS,'|VODD|')>0  OR INSTR(OWNERS,'|VEPO|')>0  OR INSTR(OWNERS,'|VEC|')>0  OR INSTR(OWNERS,'|TVSL|')>0  OR INSTR(OWNERS,'|TV8|')>0  OR INSTR(OWNERS,'|TV1N|')>0  OR INSTR(OWNERS,'|TV1K|')>0  OR INSTR(OWNERS,'|TV1F|')>0  OR INSTR(OWNERS,'|T6LT|')>0  OR INSTR(OWNERS,'|T3LT|')>0  OR INSTR(OWNERS,'|NVA|')>0  OR INSTR(OWNERS,'|KNL2|')>0  OR INSTR(OWNERS,'|DMF|')>0  OR INSTR(OWNERS,'|CTCB|')>0  OR INSTR(OWNERS,'|3PD|')>0  OR INSTR(OWNERS,'|03SK|')>0  OR INSTR(OWNERS,'|03HA|')>0  OR INSTR(OWNERS,'|EUROSPORT|')>0  OR INSTR(OWNERS,'|TVONE|')>0  OR INSTR(OWNERS,'|ICCCWC|')>0  OR INSTR(OWNERS,'|ICCU19CWC|')>0  OR INSTR(OWNERS,'|ICCWCL|')>0  OR INSTR(OWNERS,'|PSP|')>0  OR INSTR(OWNERS,'|SKYHORSE|')>0  OR INSTR(OWNERS,'|SFP2|')>0  OR INSTR(OWNERS,'|VODN|')>0  OR INSTR(OWNERS,'|VODF|')>0  OR INSTR(OWNERS,'|VNPO|')>0  OR INSTR(OWNERS,'|VHIS|')>0  OR INSTR(OWNERS,'|VEXR|')>0  OR INSTR(OWNERS,'|TVAE|')>0  OR INSTR(OWNERS,'|03SM|')>0  OR INSTR(OWNERS,'|TV1P|')>0  OR INSTR(OWNERS,'|TV1A|')>0  OR INSTR(OWNERS,'|RTR|')>0  OR INSTR(OWNERS,'|HDP2|')>0  OR INSTR(OWNERS,'|03VA|')>0  OR INSTR(OWNERS,'|03SN|')>0  OR INSTR(OWNERS,'|AECSD|')>0  OR INSTR(OWNERS,'|WCIU|')>0  OR INSTR(OWNERS,'|ICCTWT|')>0  OR INSTR(OWNERS,'|ICCCWL2|')>0  OR INSTR(OWNERS,'|BTS|')>0  OR INSTR(OWNERS,'|SKYGOLF|')>0  OR INSTR(OWNERS,'|ZTVS|')>0  OR INSTR(OWNERS,'|V1TZ|')>0  OR INSTR(OWNERS,'|TV6S|')>0  OR INSTR(OWNERS,'|TV5L|')>0  OR INSTR(OWNERS,'|TV2S|')>0  OR INSTR(OWNERS,'|DAVI|')>0  OR INSTR(OWNERS,'|3PLV|')>0  OR INSTR(OWNERS,'|03VL|')>0  OR INSTR(OWNERS,'|03VB|')>0  OR INSTR(OWNERS,'|03SY|')>0  OR INSTR(OWNERS,'|03SG|')>0  OR INSTR(OWNERS,'|03SB|')>0  OR INSTR(OWNERS,'|03OR|')>0  OR INSTR(OWNERS,'|03LI|')>0  OR INSTR(OWNERS,'|03JO|')>0  OR INSTR(OWNERS,'|03BO|')>0  OR INSTR(OWNERS,'|MBNS|')>0  OR INSTR(OWNERS,'|OSP|')>0  OR INSTR(OWNERS,'|ICCWTC|')>0  OR INSTR(OWNERS,'|PPL|')>0  OR INSTR(OWNERS,'|ANTV|')>0  OR INSTR(OWNERS,'|OUT|')>0  OR INSTR(OWNERS,'|SPG|')>0  OR INSTR(OWNERS,'|VSS|')>0  OR INSTR(OWNERS,'|VSAT|')>0  OR INSTR(OWNERS,'|VNHD|')>0  OR INSTR(OWNERS,'|VNC|')>0  OR INSTR(OWNERS,'|TV6H|')>0  OR INSTR(OWNERS,'|TV6E|')>0  OR INSTR(OWNERS,'|TV1C|')>0  OR INSTR(OWNERS,'|NICK|')>0  OR INSTR(OWNERS,'|HDP1|')>0  OR INSTR(OWNERS,'|HDC1|')>0  OR INSTR(OWNERS,'|DMA|')>0  OR INSTR(OWNERS,'|3+ES|')>0  OR INSTR(OWNERS,'|TV10|')>0  OR INSTR(OWNERS,'|AECHD|')>0  OR INSTR(OWNERS,'|TECHM|')>0  OR INSTR(OWNERS,'|ICCWWC|')>0  OR INSTR(OWNERS,'|LMH|')>0  OR INSTR(OWNERS,'|SKYDART|')>0  OR INSTR(OWNERS,'|VS2|')>0  OR INSTR(OWNERS,'|TV1S|')>0  OR INSTR(OWNERS,'|SPTV|')>0  OR INSTR(OWNERS,'|LNT|')>0  OR INSTR(OWNERS,'|DTV|')>0  OR INSTR(OWNERS,'|CS|')>0  OR INSTR(OWNERS,'|TV3D|')>0  OR INSTR(OWNERS,'|03SC|')>0  OR INSTR(OWNERS,'|03NM|')>0  OR INSTR(OWNERS,'|YLE TV1|')>0  OR INSTR(OWNERS,'|ICCWTT|')>0  OR INSTR(OWNERS,'|PMS|')>0  OR INSTR(OWNERS,'|VIVA|')>0  OR INSTR(OWNERS,'|BEDIG|')>0  OR INSTR(OWNERS,'|BT|')>0  OR INSTR(OWNERS,'|SKYFOOT|')>0  OR INSTR(OWNERS,'|VSG|')>0  OR INSTR(OWNERS,'|VSD2|')>0  OR INSTR(OWNERS,'|VSD|')>0  OR INSTR(OWNERS,'|VODE|')>0  OR INSTR(OWNERS,'|VNH|')>0  OR INSTR(OWNERS,'|TVPB|')>0  OR INSTR(OWNERS,'|TVDP|')>0  OR INSTR(OWNERS,'|TV3S|')>0  OR INSTR(OWNERS,'|AMC|')>0  OR INSTR(OWNERS,'|TV1E|')>0  OR INSTR(OWNERS,'|TV1B|')>0  OR INSTR(OWNERS,'|Play|')>0  OR INSTR(OWNERS,'|MM|')>0  OR INSTR(OWNERS,'|KNVA|')>0  OR INSTR(OWNERS,'|03UP|')>0  OR INSTR(OWNERS,'|03NO|')>0  OR INSTR(OWNERS,'|03NB|')>0  OR INSTR(OWNERS,'|03GD|')>0  OR INSTR(OWNERS,'|AL|')>0  OR INSTR(OWNERS,'|ICCWCCL|')>0  OR INSTR(OWNERS,'|PMH|')>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 :      12|10:18:36.6466|RZythU|DANIEL|imfx v3 API took 0.354s '/api/v3/search/title?_dc=1665479917979'
t Transfer: 1220 :     12|10:18:37.0506|LGmxXA|DANIEL|OAuth: /api/v3/title/299390/versions?_dc=1665479918677
t Transfer: 1220 :     12|10:18:37.0506|LGmxXA|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:37.0506|LGmxXA|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:37.0506|LGmxXA|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:37.0506|LGmxXA|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|10:18:37.0506|LGmxXA|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :     12|10:18:37.0516|LGmxXA|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:37.0516|LGmxXA|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:37.0516|LGmxXA|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:18:37.0516|LGmxXA|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:37.0516|LGmxXA|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:37.0516|LGmxXA|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:18:37.0516|m1PqXh|DANIEL|OAuth: /api/user-preferences?_dc=1665479918720
t Transfer: 1220 :     12|10:18:37.0526|m1PqXh|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:37.0526|m1PqXh|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:37.0526|m1PqXh|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:37.0526|m1PqXh|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|10:18:37.0526|LGmxXA|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:37.0526|LGmxXA|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:37.0526|LGmxXA|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:37.0536|m1PqXh|DANIEL|StoreUserDataByKeys..
t Transfer: 1220 :     12|10:18:37.0536|m1PqXh|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:37.0536|m1PqXh|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:37.0536|m1PqXh|DANIEL|    user DANIEL.
t Information: 1220 :  12|10:18:37.0536|LGmxXA|DANIEL|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 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 tmddba.tm_pg_rl 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_id
                    --sqlIdSearchJoin
                    where v.item_type>0 and v.rl_deleted=0
                     AND (INSTR(v.OWNERS,'|VSHD|')>0 OR INSTR(v.OWNERS,'|VSE|')>0 OR INSTR(v.OWNERS,'|VS3|')>0 OR INSTR(v.OWNERS,'|VODS|')>0 OR INSTR(v.OWNERS,'|VHPO|')>0 OR INSTR(v.OWNERS,'|VEXE|')>0 OR INSTR(v.OWNERS,'|VEPL|')>0 OR INSTR(v.OWNERS,'|V4N|')>0 OR INSTR(v.OWNERS,'|V3H|')>0 OR INSTR(v.OWNERS,'|V1G|')>0 OR INSTR(v.OWNERS,'|TV6N|')>0 OR INSTR(v.OWNERS,'|TV3N|')>0 OR INSTR(v.OWNERS,'|TV1D|')>0 OR INSTR(v.OWNERS,'|T8LT|')>0 OR INSTR(v.OWNERS,'|T6LV|')>0 OR INSTR(v.OWNERS,'|T3LV|')>0 OR INSTR(v.OWNERS,'|DMY|')>0 OR INSTR(v.OWNERS,'|CENT|')>0 OR INSTR(v.OWNERS,'|03VT|')>0 OR INSTR(v.OWNERS,'|03SS|')>0 OR INSTR(v.OWNERS,'|03SE|')>0 OR INSTR(v.OWNERS,'|AMAY|')>0 OR INSTR(v.OWNERS,'|BBC|')>0 OR INSTR(v.OWNERS,'|SKY|')>0 OR INSTR(v.OWNERS,'|MED|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|TMD|')>0 OR INSTR(v.OWNERS,'|HUB|')>0 OR INSTR(v.OWNERS,'|VNE|')>0 OR INSTR(v.OWNERS,'|TVPU|')>0 OR INSTR(v.OWNERS,'|PBOY|')>0 OR INSTR(v.OWNERS,'|CTCE|')>0 OR INSTR(v.OWNERS,'|03GO|')>0 OR INSTR(v.OWNERS,'|EST|')>0 OR INSTR(v.OWNERS,'|MTG|')>0 OR INSTR(v.OWNERS,'|NAA|')>0 OR INSTR(v.OWNERS,'|ATP|')>0 OR INSTR(v.OWNERS,'|ICCCTY|')>0 OR INSTR(v.OWNERS,'|ICCWCP|')>0 OR INSTR(v.OWNERS,'|ICCICC|')>0 OR INSTR(v.OWNERS,'|ITV|')>0 OR INSTR(v.OWNERS,'|SKYRUGUN|')>0 OR INSTR(v.OWNERS,'|SKYCRI|')>0 OR INSTR(v.OWNERS,'|VODD|')>0 OR INSTR(v.OWNERS,'|VEPO|')>0 OR INSTR(v.OWNERS,'|VEC|')>0 OR INSTR(v.OWNERS,'|TVSL|')>0 OR INSTR(v.OWNERS,'|TV8|')>0 OR INSTR(v.OWNERS,'|TV1N|')>0 OR INSTR(v.OWNERS,'|TV1K|')>0 OR INSTR(v.OWNERS,'|TV1F|')>0 OR INSTR(v.OWNERS,'|T6LT|')>0 OR INSTR(v.OWNERS,'|T3LT|')>0 OR INSTR(v.OWNERS,'|NVA|')>0 OR INSTR(v.OWNERS,'|KNL2|')>0 OR INSTR(v.OWNERS,'|DMF|')>0 OR INSTR(v.OWNERS,'|CTCB|')>0 OR INSTR(v.OWNERS,'|3PD|')>0 OR INSTR(v.OWNERS,'|03SK|')>0 OR INSTR(v.OWNERS,'|03HA|')>0 OR INSTR(v.OWNERS,'|EUROSPORT|')>0 OR INSTR(v.OWNERS,'|TVONE|')>0 OR INSTR(v.OWNERS,'|ICCCWC|')>0 OR INSTR(v.OWNERS,'|ICCU19CWC|')>0 OR INSTR(v.OWNERS,'|ICCWCL|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|SKYHORSE|')>0 OR INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|VODN|')>0 OR INSTR(v.OWNERS,'|VODF|')>0 OR INSTR(v.OWNERS,'|VNPO|')>0 OR INSTR(v.OWNERS,'|VHIS|')>0 OR INSTR(v.OWNERS,'|VEXR|')>0 OR INSTR(v.OWNERS,'|TVAE|')>0 OR INSTR(v.OWNERS,'|03SM|')>0 OR INSTR(v.OWNERS,'|TV1P|')>0 OR INSTR(v.OWNERS,'|TV1A|')>0 OR INSTR(v.OWNERS,'|RTR|')>0 OR INSTR(v.OWNERS,'|HDP2|')>0 OR INSTR(v.OWNERS,'|03VA|')>0 OR INSTR(v.OWNERS,'|03SN|')>0 OR INSTR(v.OWNERS,'|AECSD|')>0 OR INSTR(v.OWNERS,'|WCIU|')>0 OR INSTR(v.OWNERS,'|ICCTWT|')>0 OR INSTR(v.OWNERS,'|ICCCWL2|')>0 OR INSTR(v.OWNERS,'|BTS|')>0 OR INSTR(v.OWNERS,'|SKYGOLF|')>0 OR INSTR(v.OWNERS,'|ZTVS|')>0 OR INSTR(v.OWNERS,'|V1TZ|')>0 OR INSTR(v.OWNERS,'|TV6S|')>0 OR INSTR(v.OWNERS,'|TV5L|')>0 OR INSTR(v.OWNERS,'|TV2S|')>0 OR INSTR(v.OWNERS,'|DAVI|')>0 OR INSTR(v.OWNERS,'|3PLV|')>0 OR INSTR(v.OWNERS,'|03VL|')>0 OR INSTR(v.OWNERS,'|03VB|')>0 OR INSTR(v.OWNERS,'|03SY|')>0 OR INSTR(v.OWNERS,'|03SG|')>0 OR INSTR(v.OWNERS,'|03SB|')>0 OR INSTR(v.OWNERS,'|03OR|')>0 OR INSTR(v.OWNERS,'|03LI|')>0 OR INSTR(v.OWNERS,'|03JO|')>0 OR INSTR(v.OWNERS,'|03BO|')>0 OR INSTR(v.OWNERS,'|MBNS|')>0 OR INSTR(v.OWNERS,'|OSP|')>0 OR INSTR(v.OWNERS,'|ICCWTC|')>0 OR INSTR(v.OWNERS,'|PPL|')>0 OR INSTR(v.OWNERS,'|ANTV|')>0 OR INSTR(v.OWNERS,'|OUT|')>0 OR INSTR(v.OWNERS,'|SPG|')>0 OR INSTR(v.OWNERS,'|VSS|')>0 OR INSTR(v.OWNERS,'|VSAT|')>0 OR INSTR(v.OWNERS,'|VNHD|')>0 OR INSTR(v.OWNERS,'|VNC|')>0 OR INSTR(v.OWNERS,'|TV6H|')>0 OR INSTR(v.OWNERS,'|TV6E|')>0 OR INSTR(v.OWNERS,'|TV1C|')>0 OR INSTR(v.OWNERS,'|NICK|')>0 OR INSTR(v.OWNERS,'|HDP1|')>0 OR INSTR(v.OWNERS,'|HDC1|')>0 OR INSTR(v.OWNERS,'|DMA|')>0 OR INSTR(v.OWNERS,'|3+ES|')>0 OR INSTR(v.OWNERS,'|TV10|')>0 OR INSTR(v.OWNERS,'|AECHD|')>0 OR INSTR(v.OWNERS,'|TECHM|')>0 OR INSTR(v.OWNERS,'|ICCWWC|')>0 OR INSTR(v.OWNERS,'|LMH|')>0 OR INSTR(v.OWNERS,'|SKYDART|')>0 OR INSTR(v.OWNERS,'|VS2|')>0 OR INSTR(v.OWNERS,'|TV1S|')>0 OR INSTR(v.OWNERS,'|SPTV|')>0 OR INSTR(v.OWNERS,'|LNT|')>0 OR INSTR(v.OWNERS,'|DTV|')>0 OR INSTR(v.OWNERS,'|CS|')>0 OR INSTR(v.OWNERS,'|TV3D|')>0 OR INSTR(v.OWNERS,'|03SC|')>0 OR INSTR(v.OWNERS,'|03NM|')>0 OR INSTR(v.OWNERS,'|YLE TV1|')>0 OR INSTR(v.OWNERS,'|ICCWTT|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|VIVA|')>0 OR INSTR(v.OWNERS,'|BEDIG|')>0 OR INSTR(v.OWNERS,'|BT|')>0 OR INSTR(v.OWNERS,'|SKYFOOT|')>0 OR INSTR(v.OWNERS,'|VSG|')>0 OR INSTR(v.OWNERS,'|VSD2|')>0 OR INSTR(v.OWNERS,'|VSD|')>0 OR INSTR(v.OWNERS,'|VODE|')>0 OR INSTR(v.OWNERS,'|VNH|')>0 OR INSTR(v.OWNERS,'|TVPB|')>0 OR INSTR(v.OWNERS,'|TVDP|')>0 OR INSTR(v.OWNERS,'|TV3S|')>0 OR INSTR(v.OWNERS,'|AMC|')>0 OR INSTR(v.OWNERS,'|TV1E|')>0 OR INSTR(v.OWNERS,'|TV1B|')>0 OR INSTR(v.OWNERS,'|Play|')>0 OR INSTR(v.OWNERS,'|MM|')>0 OR INSTR(v.OWNERS,'|KNVA|')>0 OR INSTR(v.OWNERS,'|03UP|')>0 OR INSTR(v.OWNERS,'|03NO|')>0 OR INSTR(v.OWNERS,'|03NB|')>0 OR INSTR(v.OWNERS,'|03GD|')>0 OR INSTR(v.OWNERS,'|AL|')>0 OR INSTR(v.OWNERS,'|ICCWCCL|')>0 OR INSTR(v.OWNERS,'|PMH|')>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,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|SKY|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|SKYRUGUN|')>0 OR INSTR(m.OWNERS,'|SKYCRI|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|TVONE|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|SKYHORSE|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|BTS|')>0 OR INSTR(m.OWNERS,'|SKYGOLF|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|ANTV|')>0 OR INSTR(m.OWNERS,'|OUT|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|SKYDART|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|VIVA|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>0 OR INSTR(m.OWNERS,'|BT|')>0 OR INSTR(m.OWNERS,'|SKYFOOT|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|PMH|')>0)
) A WHERE rnum>=1 and rnum <= 9999
                    ) connect by nocycle prior x.parent_id=x.id)
t Transfer: 1220 :     12|10:18:37.0536|LGmxXA|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:37.0546|LGmxXA|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:37.0546|LGmxXA|DANIEL|    user DANIEL.
t Information: 1220 :  12|10:18:37.0546|LGmxXA|DANIEL|Running version search. User: 342    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 40ms.  Returned lines: 0

t Verbose: 1220 :      12|10:18:37.0546|LGmxXA|DANIEL|imfx v3 API took 0.086s '/api/v3/title/299390/versions?_dc=1665479918677'
t Verbose: 1220 :      12|10:18:37.0546|m1PqXh|DANIEL|imfx v3 API took 0.064s '/api/user-preferences?_dc=1665479918720'
t Transfer: 1220 :     12|10:18:55.3666|yyuINg|DANIEL|OAuth: /api/v3/title/299392/versions?_dc=1665479937093
t Transfer: 1220 :     12|10:18:55.3676|yyuINg|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:55.3676|yyuINg|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:55.3676|yyuINg|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:55.3676|yyuINg|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|10:18:55.3676|yyuINg|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :     12|10:18:55.3676|yyuINg|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:55.3676|yyuINg|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:55.3676|yyuINg|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:18:55.3676|yyuINg|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:55.3686|yyuINg|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:55.3686|yyuINg|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:18:55.3686|yyuINg|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:55.3686|yyuINg|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:55.3686|yyuINg|DANIEL|    user DANIEL.
t Information: 1220 :  12|10:18:55.3686|yyuINg|DANIEL|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 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 tmddba.tm_pg_rl 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_id
                    --sqlIdSearchJoin
                    where v.item_type>0 and v.rl_deleted=0
                     AND (INSTR(v.OWNERS,'|VSHD|')>0 OR INSTR(v.OWNERS,'|VSE|')>0 OR INSTR(v.OWNERS,'|VS3|')>0 OR INSTR(v.OWNERS,'|VODS|')>0 OR INSTR(v.OWNERS,'|VHPO|')>0 OR INSTR(v.OWNERS,'|VEXE|')>0 OR INSTR(v.OWNERS,'|VEPL|')>0 OR INSTR(v.OWNERS,'|V4N|')>0 OR INSTR(v.OWNERS,'|V3H|')>0 OR INSTR(v.OWNERS,'|V1G|')>0 OR INSTR(v.OWNERS,'|TV6N|')>0 OR INSTR(v.OWNERS,'|TV3N|')>0 OR INSTR(v.OWNERS,'|TV1D|')>0 OR INSTR(v.OWNERS,'|T8LT|')>0 OR INSTR(v.OWNERS,'|T6LV|')>0 OR INSTR(v.OWNERS,'|T3LV|')>0 OR INSTR(v.OWNERS,'|DMY|')>0 OR INSTR(v.OWNERS,'|CENT|')>0 OR INSTR(v.OWNERS,'|03VT|')>0 OR INSTR(v.OWNERS,'|03SS|')>0 OR INSTR(v.OWNERS,'|03SE|')>0 OR INSTR(v.OWNERS,'|AMAY|')>0 OR INSTR(v.OWNERS,'|BBC|')>0 OR INSTR(v.OWNERS,'|SKY|')>0 OR INSTR(v.OWNERS,'|MED|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|TMD|')>0 OR INSTR(v.OWNERS,'|HUB|')>0 OR INSTR(v.OWNERS,'|VNE|')>0 OR INSTR(v.OWNERS,'|TVPU|')>0 OR INSTR(v.OWNERS,'|PBOY|')>0 OR INSTR(v.OWNERS,'|CTCE|')>0 OR INSTR(v.OWNERS,'|03GO|')>0 OR INSTR(v.OWNERS,'|EST|')>0 OR INSTR(v.OWNERS,'|MTG|')>0 OR INSTR(v.OWNERS,'|NAA|')>0 OR INSTR(v.OWNERS,'|ATP|')>0 OR INSTR(v.OWNERS,'|ICCCTY|')>0 OR INSTR(v.OWNERS,'|ICCWCP|')>0 OR INSTR(v.OWNERS,'|ICCICC|')>0 OR INSTR(v.OWNERS,'|ITV|')>0 OR INSTR(v.OWNERS,'|SKYRUGUN|')>0 OR INSTR(v.OWNERS,'|SKYCRI|')>0 OR INSTR(v.OWNERS,'|VODD|')>0 OR INSTR(v.OWNERS,'|VEPO|')>0 OR INSTR(v.OWNERS,'|VEC|')>0 OR INSTR(v.OWNERS,'|TVSL|')>0 OR INSTR(v.OWNERS,'|TV8|')>0 OR INSTR(v.OWNERS,'|TV1N|')>0 OR INSTR(v.OWNERS,'|TV1K|')>0 OR INSTR(v.OWNERS,'|TV1F|')>0 OR INSTR(v.OWNERS,'|T6LT|')>0 OR INSTR(v.OWNERS,'|T3LT|')>0 OR INSTR(v.OWNERS,'|NVA|')>0 OR INSTR(v.OWNERS,'|KNL2|')>0 OR INSTR(v.OWNERS,'|DMF|')>0 OR INSTR(v.OWNERS,'|CTCB|')>0 OR INSTR(v.OWNERS,'|3PD|')>0 OR INSTR(v.OWNERS,'|03SK|')>0 OR INSTR(v.OWNERS,'|03HA|')>0 OR INSTR(v.OWNERS,'|EUROSPORT|')>0 OR INSTR(v.OWNERS,'|TVONE|')>0 OR INSTR(v.OWNERS,'|ICCCWC|')>0 OR INSTR(v.OWNERS,'|ICCU19CWC|')>0 OR INSTR(v.OWNERS,'|ICCWCL|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|SKYHORSE|')>0 OR INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|VODN|')>0 OR INSTR(v.OWNERS,'|VODF|')>0 OR INSTR(v.OWNERS,'|VNPO|')>0 OR INSTR(v.OWNERS,'|VHIS|')>0 OR INSTR(v.OWNERS,'|VEXR|')>0 OR INSTR(v.OWNERS,'|TVAE|')>0 OR INSTR(v.OWNERS,'|03SM|')>0 OR INSTR(v.OWNERS,'|TV1P|')>0 OR INSTR(v.OWNERS,'|TV1A|')>0 OR INSTR(v.OWNERS,'|RTR|')>0 OR INSTR(v.OWNERS,'|HDP2|')>0 OR INSTR(v.OWNERS,'|03VA|')>0 OR INSTR(v.OWNERS,'|03SN|')>0 OR INSTR(v.OWNERS,'|AECSD|')>0 OR INSTR(v.OWNERS,'|WCIU|')>0 OR INSTR(v.OWNERS,'|ICCTWT|')>0 OR INSTR(v.OWNERS,'|ICCCWL2|')>0 OR INSTR(v.OWNERS,'|BTS|')>0 OR INSTR(v.OWNERS,'|SKYGOLF|')>0 OR INSTR(v.OWNERS,'|ZTVS|')>0 OR INSTR(v.OWNERS,'|V1TZ|')>0 OR INSTR(v.OWNERS,'|TV6S|')>0 OR INSTR(v.OWNERS,'|TV5L|')>0 OR INSTR(v.OWNERS,'|TV2S|')>0 OR INSTR(v.OWNERS,'|DAVI|')>0 OR INSTR(v.OWNERS,'|3PLV|')>0 OR INSTR(v.OWNERS,'|03VL|')>0 OR INSTR(v.OWNERS,'|03VB|')>0 OR INSTR(v.OWNERS,'|03SY|')>0 OR INSTR(v.OWNERS,'|03SG|')>0 OR INSTR(v.OWNERS,'|03SB|')>0 OR INSTR(v.OWNERS,'|03OR|')>0 OR INSTR(v.OWNERS,'|03LI|')>0 OR INSTR(v.OWNERS,'|03JO|')>0 OR INSTR(v.OWNERS,'|03BO|')>0 OR INSTR(v.OWNERS,'|MBNS|')>0 OR INSTR(v.OWNERS,'|OSP|')>0 OR INSTR(v.OWNERS,'|ICCWTC|')>0 OR INSTR(v.OWNERS,'|PPL|')>0 OR INSTR(v.OWNERS,'|ANTV|')>0 OR INSTR(v.OWNERS,'|OUT|')>0 OR INSTR(v.OWNERS,'|SPG|')>0 OR INSTR(v.OWNERS,'|VSS|')>0 OR INSTR(v.OWNERS,'|VSAT|')>0 OR INSTR(v.OWNERS,'|VNHD|')>0 OR INSTR(v.OWNERS,'|VNC|')>0 OR INSTR(v.OWNERS,'|TV6H|')>0 OR INSTR(v.OWNERS,'|TV6E|')>0 OR INSTR(v.OWNERS,'|TV1C|')>0 OR INSTR(v.OWNERS,'|NICK|')>0 OR INSTR(v.OWNERS,'|HDP1|')>0 OR INSTR(v.OWNERS,'|HDC1|')>0 OR INSTR(v.OWNERS,'|DMA|')>0 OR INSTR(v.OWNERS,'|3+ES|')>0 OR INSTR(v.OWNERS,'|TV10|')>0 OR INSTR(v.OWNERS,'|AECHD|')>0 OR INSTR(v.OWNERS,'|TECHM|')>0 OR INSTR(v.OWNERS,'|ICCWWC|')>0 OR INSTR(v.OWNERS,'|LMH|')>0 OR INSTR(v.OWNERS,'|SKYDART|')>0 OR INSTR(v.OWNERS,'|VS2|')>0 OR INSTR(v.OWNERS,'|TV1S|')>0 OR INSTR(v.OWNERS,'|SPTV|')>0 OR INSTR(v.OWNERS,'|LNT|')>0 OR INSTR(v.OWNERS,'|DTV|')>0 OR INSTR(v.OWNERS,'|CS|')>0 OR INSTR(v.OWNERS,'|TV3D|')>0 OR INSTR(v.OWNERS,'|03SC|')>0 OR INSTR(v.OWNERS,'|03NM|')>0 OR INSTR(v.OWNERS,'|YLE TV1|')>0 OR INSTR(v.OWNERS,'|ICCWTT|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|VIVA|')>0 OR INSTR(v.OWNERS,'|BEDIG|')>0 OR INSTR(v.OWNERS,'|BT|')>0 OR INSTR(v.OWNERS,'|SKYFOOT|')>0 OR INSTR(v.OWNERS,'|VSG|')>0 OR INSTR(v.OWNERS,'|VSD2|')>0 OR INSTR(v.OWNERS,'|VSD|')>0 OR INSTR(v.OWNERS,'|VODE|')>0 OR INSTR(v.OWNERS,'|VNH|')>0 OR INSTR(v.OWNERS,'|TVPB|')>0 OR INSTR(v.OWNERS,'|TVDP|')>0 OR INSTR(v.OWNERS,'|TV3S|')>0 OR INSTR(v.OWNERS,'|AMC|')>0 OR INSTR(v.OWNERS,'|TV1E|')>0 OR INSTR(v.OWNERS,'|TV1B|')>0 OR INSTR(v.OWNERS,'|Play|')>0 OR INSTR(v.OWNERS,'|MM|')>0 OR INSTR(v.OWNERS,'|KNVA|')>0 OR INSTR(v.OWNERS,'|03UP|')>0 OR INSTR(v.OWNERS,'|03NO|')>0 OR INSTR(v.OWNERS,'|03NB|')>0 OR INSTR(v.OWNERS,'|03GD|')>0 OR INSTR(v.OWNERS,'|AL|')>0 OR INSTR(v.OWNERS,'|ICCWCCL|')>0 OR INSTR(v.OWNERS,'|PMH|')>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,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|SKY|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|SKYRUGUN|')>0 OR INSTR(m.OWNERS,'|SKYCRI|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|TVONE|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|SKYHORSE|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|BTS|')>0 OR INSTR(m.OWNERS,'|SKYGOLF|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|ANTV|')>0 OR INSTR(m.OWNERS,'|OUT|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|SKYDART|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|VIVA|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>0 OR INSTR(m.OWNERS,'|BT|')>0 OR INSTR(m.OWNERS,'|SKYFOOT|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|PMH|')>0)
) A WHERE rnum>=1 and rnum <= 9999
                    ) connect by nocycle prior x.parent_id=x.id)
t Transfer: 1220 :     12|10:18:55.3686|yyuINg|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:55.3686|yyuINg|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:55.3696|yyuINg|DANIEL|    user DANIEL.
t Information: 1220 :  12|10:18:55.5706|yyuINg|DANIEL|Running version search. User: 342    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 10ms.  Returned lines: 11
Oracle version search timing: 127ms.
SQL run:
 select  v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select 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 tmddba.tm_pg_rl 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_id
                    --sqlIdSearchJoin
                    where v.item_type>0 and v.rl_deleted=0
                     AND (INSTR(v.OWNERS,'|VSHD|')>0 OR INSTR(v.OWNERS,'|VSE|')>0 OR INSTR(v.OWNERS,'|VS3|')>0 OR INSTR(v.OWNERS,'|VODS|')>0 OR INSTR(v.OWNERS,'|VHPO|')>0 OR INSTR(v.OWNERS,'|VEXE|')>0 OR INSTR(v.OWNERS,'|VEPL|')>0 OR INSTR(v.OWNERS,'|V4N|')>0 OR INSTR(v.OWNERS,'|V3H|')>0 OR INSTR(v.OWNERS,'|V1G|')>0 OR INSTR(v.OWNERS,'|TV6N|')>0 OR INSTR(v.OWNERS,'|TV3N|')>0 OR INSTR(v.OWNERS,'|TV1D|')>0 OR INSTR(v.OWNERS,'|T8LT|')>0 OR INSTR(v.OWNERS,'|T6LV|')>0 OR INSTR(v.OWNERS,'|T3LV|')>0 OR INSTR(v.OWNERS,'|DMY|')>0 OR INSTR(v.OWNERS,'|CENT|')>0 OR INSTR(v.OWNERS,'|03VT|')>0 OR INSTR(v.OWNERS,'|03SS|')>0 OR INSTR(v.OWNERS,'|03SE|')>0 OR INSTR(v.OWNERS,'|AMAY|')>0 OR INSTR(v.OWNERS,'|BBC|')>0 OR INSTR(v.OWNERS,'|SKY|')>0 OR INSTR(v.OWNERS,'|MED|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|TMD|')>0 OR INSTR(v.OWNERS,'|HUB|')>0 OR INSTR(v.OWNERS,'|VNE|')>0 OR INSTR(v.OWNERS,'|TVPU|')>0 OR INSTR(v.OWNERS,'|PBOY|')>0 OR INSTR(v.OWNERS,'|CTCE|')>0 OR INSTR(v.OWNERS,'|03GO|')>0 OR INSTR(v.OWNERS,'|EST|')>0 OR INSTR(v.OWNERS,'|MTG|')>0 OR INSTR(v.OWNERS,'|NAA|')>0 OR INSTR(v.OWNERS,'|ATP|')>0 OR INSTR(v.OWNERS,'|ICCCTY|')>0 OR INSTR(v.OWNERS,'|ICCWCP|')>0 OR INSTR(v.OWNERS,'|ICCICC|')>0 OR INSTR(v.OWNERS,'|ITV|')>0 OR INSTR(v.OWNERS,'|SKYRUGUN|')>0 OR INSTR(v.OWNERS,'|SKYCRI|')>0 OR INSTR(v.OWNERS,'|VODD|')>0 OR INSTR(v.OWNERS,'|VEPO|')>0 OR INSTR(v.OWNERS,'|VEC|')>0 OR INSTR(v.OWNERS,'|TVSL|')>0 OR INSTR(v.OWNERS,'|TV8|')>0 OR INSTR(v.OWNERS,'|TV1N|')>0 OR INSTR(v.OWNERS,'|TV1K|')>0 OR INSTR(v.OWNERS,'|TV1F|')>0 OR INSTR(v.OWNERS,'|T6LT|')>0 OR INSTR(v.OWNERS,'|T3LT|')>0 OR INSTR(v.OWNERS,'|NVA|')>0 OR INSTR(v.OWNERS,'|KNL2|')>0 OR INSTR(v.OWNERS,'|DMF|')>0 OR INSTR(v.OWNERS,'|CTCB|')>0 OR INSTR(v.OWNERS,'|3PD|')>0 OR INSTR(v.OWNERS,'|03SK|')>0 OR INSTR(v.OWNERS,'|03HA|')>0 OR INSTR(v.OWNERS,'|EUROSPORT|')>0 OR INSTR(v.OWNERS,'|TVONE|')>0 OR INSTR(v.OWNERS,'|ICCCWC|')>0 OR INSTR(v.OWNERS,'|ICCU19CWC|')>0 OR INSTR(v.OWNERS,'|ICCWCL|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|SKYHORSE|')>0 OR INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|VODN|')>0 OR INSTR(v.OWNERS,'|VODF|')>0 OR INSTR(v.OWNERS,'|VNPO|')>0 OR INSTR(v.OWNERS,'|VHIS|')>0 OR INSTR(v.OWNERS,'|VEXR|')>0 OR INSTR(v.OWNERS,'|TVAE|')>0 OR INSTR(v.OWNERS,'|03SM|')>0 OR INSTR(v.OWNERS,'|TV1P|')>0 OR INSTR(v.OWNERS,'|TV1A|')>0 OR INSTR(v.OWNERS,'|RTR|')>0 OR INSTR(v.OWNERS,'|HDP2|')>0 OR INSTR(v.OWNERS,'|03VA|')>0 OR INSTR(v.OWNERS,'|03SN|')>0 OR INSTR(v.OWNERS,'|AECSD|')>0 OR INSTR(v.OWNERS,'|WCIU|')>0 OR INSTR(v.OWNERS,'|ICCTWT|')>0 OR INSTR(v.OWNERS,'|ICCCWL2|')>0 OR INSTR(v.OWNERS,'|BTS|')>0 OR INSTR(v.OWNERS,'|SKYGOLF|')>0 OR INSTR(v.OWNERS,'|ZTVS|')>0 OR INSTR(v.OWNERS,'|V1TZ|')>0 OR INSTR(v.OWNERS,'|TV6S|')>0 OR INSTR(v.OWNERS,'|TV5L|')>0 OR INSTR(v.OWNERS,'|TV2S|')>0 OR INSTR(v.OWNERS,'|DAVI|')>0 OR INSTR(v.OWNERS,'|3PLV|')>0 OR INSTR(v.OWNERS,'|03VL|')>0 OR INSTR(v.OWNERS,'|03VB|')>0 OR INSTR(v.OWNERS,'|03SY|')>0 OR INSTR(v.OWNERS,'|03SG|')>0 OR INSTR(v.OWNERS,'|03SB|')>0 OR INSTR(v.OWNERS,'|03OR|')>0 OR INSTR(v.OWNERS,'|03LI|')>0 OR INSTR(v.OWNERS,'|03JO|')>0 OR INSTR(v.OWNERS,'|03BO|')>0 OR INSTR(v.OWNERS,'|MBNS|')>0 OR INSTR(v.OWNERS,'|OSP|')>0 OR INSTR(v.OWNERS,'|ICCWTC|')>0 OR INSTR(v.OWNERS,'|PPL|')>0 OR INSTR(v.OWNERS,'|ANTV|')>0 OR INSTR(v.OWNERS,'|OUT|')>0 OR INSTR(v.OWNERS,'|SPG|')>0 OR INSTR(v.OWNERS,'|VSS|')>0 OR INSTR(v.OWNERS,'|VSAT|')>0 OR INSTR(v.OWNERS,'|VNHD|')>0 OR INSTR(v.OWNERS,'|VNC|')>0 OR INSTR(v.OWNERS,'|TV6H|')>0 OR INSTR(v.OWNERS,'|TV6E|')>0 OR INSTR(v.OWNERS,'|TV1C|')>0 OR INSTR(v.OWNERS,'|NICK|')>0 OR INSTR(v.OWNERS,'|HDP1|')>0 OR INSTR(v.OWNERS,'|HDC1|')>0 OR INSTR(v.OWNERS,'|DMA|')>0 OR INSTR(v.OWNERS,'|3+ES|')>0 OR INSTR(v.OWNERS,'|TV10|')>0 OR INSTR(v.OWNERS,'|AECHD|')>0 OR INSTR(v.OWNERS,'|TECHM|')>0 OR INSTR(v.OWNERS,'|ICCWWC|')>0 OR INSTR(v.OWNERS,'|LMH|')>0 OR INSTR(v.OWNERS,'|SKYDART|')>0 OR INSTR(v.OWNERS,'|VS2|')>0 OR INSTR(v.OWNERS,'|TV1S|')>0 OR INSTR(v.OWNERS,'|SPTV|')>0 OR INSTR(v.OWNERS,'|LNT|')>0 OR INSTR(v.OWNERS,'|DTV|')>0 OR INSTR(v.OWNERS,'|CS|')>0 OR INSTR(v.OWNERS,'|TV3D|')>0 OR INSTR(v.OWNERS,'|03SC|')>0 OR INSTR(v.OWNERS,'|03NM|')>0 OR INSTR(v.OWNERS,'|YLE TV1|')>0 OR INSTR(v.OWNERS,'|ICCWTT|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|VIVA|')>0 OR INSTR(v.OWNERS,'|BEDIG|')>0 OR INSTR(v.OWNERS,'|BT|')>0 OR INSTR(v.OWNERS,'|SKYFOOT|')>0 OR INSTR(v.OWNERS,'|VSG|')>0 OR INSTR(v.OWNERS,'|VSD2|')>0 OR INSTR(v.OWNERS,'|VSD|')>0 OR INSTR(v.OWNERS,'|VODE|')>0 OR INSTR(v.OWNERS,'|VNH|')>0 OR INSTR(v.OWNERS,'|TVPB|')>0 OR INSTR(v.OWNERS,'|TVDP|')>0 OR INSTR(v.OWNERS,'|TV3S|')>0 OR INSTR(v.OWNERS,'|AMC|')>0 OR INSTR(v.OWNERS,'|TV1E|')>0 OR INSTR(v.OWNERS,'|TV1B|')>0 OR INSTR(v.OWNERS,'|Play|')>0 OR INSTR(v.OWNERS,'|MM|')>0 OR INSTR(v.OWNERS,'|KNVA|')>0 OR INSTR(v.OWNERS,'|03UP|')>0 OR INSTR(v.OWNERS,'|03NO|')>0 OR INSTR(v.OWNERS,'|03NB|')>0 OR INSTR(v.OWNERS,'|03GD|')>0 OR INSTR(v.OWNERS,'|AL|')>0 OR INSTR(v.OWNERS,'|ICCWCCL|')>0 OR INSTR(v.OWNERS,'|PMH|')>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,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|SKY|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|SKYRUGUN|')>0 OR INSTR(m.OWNERS,'|SKYCRI|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|TVONE|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|SKYHORSE|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|BTS|')>0 OR INSTR(m.OWNERS,'|SKYGOLF|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|ANTV|')>0 OR INSTR(m.OWNERS,'|OUT|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|SKYDART|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|VIVA|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>0 OR INSTR(m.OWNERS,'|BT|')>0 OR INSTR(m.OWNERS,'|SKYFOOT|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|PMH|')>0)
) A WHERE rnum>=1 and rnum <= 9999
                    ) connect by nocycle prior x.parent_id=x.id)

t Verbose: 1220 :      12|10:18:55.5706|yyuINg|DANIEL|imfx v3 API took 0.155s '/api/v3/title/299392/versions?_dc=1665479937093'
t Transfer: 1220 :     12|10:18:55.9726|dRvdXM|DANIEL|OAuth: /api/v3/version/299393/media?_dc=1665479937647
t Transfer: 1220 :     12|10:18:55.9726|dRvdXM|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:55.9726|dRvdXM|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:55.9726|dRvdXM|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:55.9726|dRvdXM|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|10:18:55.9726|dRvdXM|DANIEL|V3Api.SearchGeneric
t Verbose: 1220 :      12|10:18:56.0286|dRvdXM|DANIEL|imfx v3 API took 0.022s '/api/v3/version/299393/media?_dc=1665479937647'
t Transfer: 1220 :     12|10:18:56.0296|E4uI~U|DANIEL|OAuth: /api/v3/version/299393/media?_dc=1665479937709
t Transfer: 1220 :     12|10:18:56.0296|E4uI~U|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:18:56.0296|E4uI~U|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:18:56.0296|E4uI~U|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:18:56.0296|E4uI~U|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|10:18:56.0296|E4uI~U|DANIEL|V3Api.SearchGeneric
t Verbose: 1220 :      12|10:18:56.0306|E4uI~U|DANIEL|imfx v3 API took 0.001s '/api/v3/version/299393/media?_dc=1665479937709'
t Transfer: 1220 :     12|10:20:36.5788|wf4rbs|DANIEL|OAuth: /api/v3/version/299405/media?_dc=1665480038290
t Transfer: 1220 :     12|10:20:36.5788|wf4rbs|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:20:36.5788|wf4rbs|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:20:36.5788|wf4rbs|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:20:36.5788|wf4rbs|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|10:20:36.5798|wf4rbs|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :     12|10:20:36.5798|wf4rbs|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:20:36.5798|wf4rbs|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:20:36.5798|wf4rbs|DANIEL|    user DANIEL.
t Information: 1220 :  12|10:20:36.5798|wf4rbs|DANIEL|MediaSearch SQL:
select r.*,
    nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE,
    nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
    nvl(t.text_data_path,'') THUMBSERVER, 
    nvl(t.text_data_filename,'') THUMBFILE,
    nvl(t.text_id,-1) THUMBID , 
    (SELECT SUBSTR( trim( replace (replace (
          LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z
            FROM tm_media_tagging tt
              WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , 
    GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
    nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME 

    from (select a.*, rownum rnum from 
      (select  m.*,
     coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 
      from tmddba.tm_mis m 
where  media_type>0 and item_type>0  AND  PGM_PARENT_ID=:param_0  and m.mi_deleted=0   AND (INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|SKY|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|SKYRUGUN|')>0 OR INSTR(m.OWNERS,'|SKYCRI|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|TVONE|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|SKYHORSE|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|BTS|')>0 OR INSTR(m.OWNERS,'|SKYGOLF|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|ANTV|')>0 OR INSTR(m.OWNERS,'|OUT|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|SKYDART|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|VIVA|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>0 OR INSTR(m.OWNERS,'|BT|')>0 OR INSTR(m.OWNERS,'|SKYFOOT|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|PMH|')>0)
 order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r 
    ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat  from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk 
    ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t
    ,lateral(select /*+ NO_DECORRELATE */  d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename
        FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl 
    
    where rnum >= 1 order by rnum

t Information: 1220 :  12|10:20:36.5798|wf4rbs|DANIEL|  count returned 0
t Verbose: 1220 :      12|10:20:36.5808|wf4rbs|DANIEL|imfx v3 API took 0.067s '/api/v3/version/299405/media?_dc=1665480038290'
t Transfer: 1220 :     12|10:20:38.5908|AQ1Ot5|DANIEL|OAuth: /api/v3/version/299393/media?_dc=1665480040285
t Transfer: 1220 :     12|10:20:38.5908|AQ1Ot5|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:20:38.5908|AQ1Ot5|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:20:38.5908|AQ1Ot5|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:20:38.5908|AQ1Ot5|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|10:20:38.5908|AQ1Ot5|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :     12|10:20:38.5908|AQ1Ot5|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:20:38.5908|AQ1Ot5|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:20:38.5908|AQ1Ot5|DANIEL|    user DANIEL.
t Information: 1220 :  12|10:20:38.5918|AQ1Ot5|DANIEL|MediaSearch SQL:
select r.*,
    nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE,
    nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
    nvl(t.text_data_path,'') THUMBSERVER, 
    nvl(t.text_data_filename,'') THUMBFILE,
    nvl(t.text_id,-1) THUMBID , 
    (SELECT SUBSTR( trim( replace (replace (
          LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z
            FROM tm_media_tagging tt
              WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , 
    GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
    nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME 

    from (select a.*, rownum rnum from 
      (select  m.*,
     coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 
      from tmddba.tm_mis m 
where  media_type>0 and item_type>0  AND  PGM_PARENT_ID=:param_0  and m.mi_deleted=0   AND (INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|SKY|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|SKYRUGUN|')>0 OR INSTR(m.OWNERS,'|SKYCRI|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|TVONE|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|SKYHORSE|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|BTS|')>0 OR INSTR(m.OWNERS,'|SKYGOLF|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|ANTV|')>0 OR INSTR(m.OWNERS,'|OUT|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|SKYDART|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|VIVA|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>0 OR INSTR(m.OWNERS,'|BT|')>0 OR INSTR(m.OWNERS,'|SKYFOOT|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|PMH|')>0)
 order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r 
    ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat  from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk 
    ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t
    ,lateral(select /*+ NO_DECORRELATE */  d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename
        FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl 
    
    where rnum >= 1 order by rnum

t Information: 1220 :  12|10:20:38.5918|AQ1Ot5|DANIEL|  count returned 0
t Verbose: 1220 :      12|10:20:38.5918|AQ1Ot5|DANIEL|imfx v3 API took 0.010s '/api/v3/version/299393/media?_dc=1665480040285'
t Transfer: 1220 :     12|10:20:39.9988|Exxm3G|DANIEL|OAuth: /api/v3/title/299394/versions?_dc=1665480041719
t Transfer: 1220 :     12|10:20:39.9988|Exxm3G|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:20:39.9988|Exxm3G|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:20:39.9988|Exxm3G|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:20:39.9988|Exxm3G|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|10:20:39.9998|Exxm3G|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :     12|10:20:39.9998|Exxm3G|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:20:39.9998|Exxm3G|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:20:39.9998|Exxm3G|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:20:39.9998|Exxm3G|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:20:39.9998|Exxm3G|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:20:39.9998|Exxm3G|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|10:20:39.9998|Exxm3G|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:20:40.0008|Exxm3G|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:20:40.0008|Exxm3G|DANIEL|    user DANIEL.
t Information: 1220 :  12|10:20:40.0008|Exxm3G|DANIEL|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 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 tmddba.tm_pg_rl 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_id
                    --sqlIdSearchJoin
                    where v.item_type>0 and v.rl_deleted=0
                     AND (INSTR(v.OWNERS,'|VSHD|')>0 OR INSTR(v.OWNERS,'|VSE|')>0 OR INSTR(v.OWNERS,'|VS3|')>0 OR INSTR(v.OWNERS,'|VODS|')>0 OR INSTR(v.OWNERS,'|VHPO|')>0 OR INSTR(v.OWNERS,'|VEXE|')>0 OR INSTR(v.OWNERS,'|VEPL|')>0 OR INSTR(v.OWNERS,'|V4N|')>0 OR INSTR(v.OWNERS,'|V3H|')>0 OR INSTR(v.OWNERS,'|V1G|')>0 OR INSTR(v.OWNERS,'|TV6N|')>0 OR INSTR(v.OWNERS,'|TV3N|')>0 OR INSTR(v.OWNERS,'|TV1D|')>0 OR INSTR(v.OWNERS,'|T8LT|')>0 OR INSTR(v.OWNERS,'|T6LV|')>0 OR INSTR(v.OWNERS,'|T3LV|')>0 OR INSTR(v.OWNERS,'|DMY|')>0 OR INSTR(v.OWNERS,'|CENT|')>0 OR INSTR(v.OWNERS,'|03VT|')>0 OR INSTR(v.OWNERS,'|03SS|')>0 OR INSTR(v.OWNERS,'|03SE|')>0 OR INSTR(v.OWNERS,'|AMAY|')>0 OR INSTR(v.OWNERS,'|BBC|')>0 OR INSTR(v.OWNERS,'|SKY|')>0 OR INSTR(v.OWNERS,'|MED|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|TMD|')>0 OR INSTR(v.OWNERS,'|HUB|')>0 OR INSTR(v.OWNERS,'|VNE|')>0 OR INSTR(v.OWNERS,'|TVPU|')>0 OR INSTR(v.OWNERS,'|PBOY|')>0 OR INSTR(v.OWNERS,'|CTCE|')>0 OR INSTR(v.OWNERS,'|03GO|')>0 OR INSTR(v.OWNERS,'|EST|')>0 OR INSTR(v.OWNERS,'|MTG|')>0 OR INSTR(v.OWNERS,'|NAA|')>0 OR INSTR(v.OWNERS,'|ATP|')>0 OR INSTR(v.OWNERS,'|ICCCTY|')>0 OR INSTR(v.OWNERS,'|ICCWCP|')>0 OR INSTR(v.OWNERS,'|ICCICC|')>0 OR INSTR(v.OWNERS,'|ITV|')>0 OR INSTR(v.OWNERS,'|SKYRUGUN|')>0 OR INSTR(v.OWNERS,'|SKYCRI|')>0 OR INSTR(v.OWNERS,'|VODD|')>0 OR INSTR(v.OWNERS,'|VEPO|')>0 OR INSTR(v.OWNERS,'|VEC|')>0 OR INSTR(v.OWNERS,'|TVSL|')>0 OR INSTR(v.OWNERS,'|TV8|')>0 OR INSTR(v.OWNERS,'|TV1N|')>0 OR INSTR(v.OWNERS,'|TV1K|')>0 OR INSTR(v.OWNERS,'|TV1F|')>0 OR INSTR(v.OWNERS,'|T6LT|')>0 OR INSTR(v.OWNERS,'|T3LT|')>0 OR INSTR(v.OWNERS,'|NVA|')>0 OR INSTR(v.OWNERS,'|KNL2|')>0 OR INSTR(v.OWNERS,'|DMF|')>0 OR INSTR(v.OWNERS,'|CTCB|')>0 OR INSTR(v.OWNERS,'|3PD|')>0 OR INSTR(v.OWNERS,'|03SK|')>0 OR INSTR(v.OWNERS,'|03HA|')>0 OR INSTR(v.OWNERS,'|EUROSPORT|')>0 OR INSTR(v.OWNERS,'|TVONE|')>0 OR INSTR(v.OWNERS,'|ICCCWC|')>0 OR INSTR(v.OWNERS,'|ICCU19CWC|')>0 OR INSTR(v.OWNERS,'|ICCWCL|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|SKYHORSE|')>0 OR INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|VODN|')>0 OR INSTR(v.OWNERS,'|VODF|')>0 OR INSTR(v.OWNERS,'|VNPO|')>0 OR INSTR(v.OWNERS,'|VHIS|')>0 OR INSTR(v.OWNERS,'|VEXR|')>0 OR INSTR(v.OWNERS,'|TVAE|')>0 OR INSTR(v.OWNERS,'|03SM|')>0 OR INSTR(v.OWNERS,'|TV1P|')>0 OR INSTR(v.OWNERS,'|TV1A|')>0 OR INSTR(v.OWNERS,'|RTR|')>0 OR INSTR(v.OWNERS,'|HDP2|')>0 OR INSTR(v.OWNERS,'|03VA|')>0 OR INSTR(v.OWNERS,'|03SN|')>0 OR INSTR(v.OWNERS,'|AECSD|')>0 OR INSTR(v.OWNERS,'|WCIU|')>0 OR INSTR(v.OWNERS,'|ICCTWT|')>0 OR INSTR(v.OWNERS,'|ICCCWL2|')>0 OR INSTR(v.OWNERS,'|BTS|')>0 OR INSTR(v.OWNERS,'|SKYGOLF|')>0 OR INSTR(v.OWNERS,'|ZTVS|')>0 OR INSTR(v.OWNERS,'|V1TZ|')>0 OR INSTR(v.OWNERS,'|TV6S|')>0 OR INSTR(v.OWNERS,'|TV5L|')>0 OR INSTR(v.OWNERS,'|TV2S|')>0 OR INSTR(v.OWNERS,'|DAVI|')>0 OR INSTR(v.OWNERS,'|3PLV|')>0 OR INSTR(v.OWNERS,'|03VL|')>0 OR INSTR(v.OWNERS,'|03VB|')>0 OR INSTR(v.OWNERS,'|03SY|')>0 OR INSTR(v.OWNERS,'|03SG|')>0 OR INSTR(v.OWNERS,'|03SB|')>0 OR INSTR(v.OWNERS,'|03OR|')>0 OR INSTR(v.OWNERS,'|03LI|')>0 OR INSTR(v.OWNERS,'|03JO|')>0 OR INSTR(v.OWNERS,'|03BO|')>0 OR INSTR(v.OWNERS,'|MBNS|')>0 OR INSTR(v.OWNERS,'|OSP|')>0 OR INSTR(v.OWNERS,'|ICCWTC|')>0 OR INSTR(v.OWNERS,'|PPL|')>0 OR INSTR(v.OWNERS,'|ANTV|')>0 OR INSTR(v.OWNERS,'|OUT|')>0 OR INSTR(v.OWNERS,'|SPG|')>0 OR INSTR(v.OWNERS,'|VSS|')>0 OR INSTR(v.OWNERS,'|VSAT|')>0 OR INSTR(v.OWNERS,'|VNHD|')>0 OR INSTR(v.OWNERS,'|VNC|')>0 OR INSTR(v.OWNERS,'|TV6H|')>0 OR INSTR(v.OWNERS,'|TV6E|')>0 OR INSTR(v.OWNERS,'|TV1C|')>0 OR INSTR(v.OWNERS,'|NICK|')>0 OR INSTR(v.OWNERS,'|HDP1|')>0 OR INSTR(v.OWNERS,'|HDC1|')>0 OR INSTR(v.OWNERS,'|DMA|')>0 OR INSTR(v.OWNERS,'|3+ES|')>0 OR INSTR(v.OWNERS,'|TV10|')>0 OR INSTR(v.OWNERS,'|AECHD|')>0 OR INSTR(v.OWNERS,'|TECHM|')>0 OR INSTR(v.OWNERS,'|ICCWWC|')>0 OR INSTR(v.OWNERS,'|LMH|')>0 OR INSTR(v.OWNERS,'|SKYDART|')>0 OR INSTR(v.OWNERS,'|VS2|')>0 OR INSTR(v.OWNERS,'|TV1S|')>0 OR INSTR(v.OWNERS,'|SPTV|')>0 OR INSTR(v.OWNERS,'|LNT|')>0 OR INSTR(v.OWNERS,'|DTV|')>0 OR INSTR(v.OWNERS,'|CS|')>0 OR INSTR(v.OWNERS,'|TV3D|')>0 OR INSTR(v.OWNERS,'|03SC|')>0 OR INSTR(v.OWNERS,'|03NM|')>0 OR INSTR(v.OWNERS,'|YLE TV1|')>0 OR INSTR(v.OWNERS,'|ICCWTT|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|VIVA|')>0 OR INSTR(v.OWNERS,'|BEDIG|')>0 OR INSTR(v.OWNERS,'|BT|')>0 OR INSTR(v.OWNERS,'|SKYFOOT|')>0 OR INSTR(v.OWNERS,'|VSG|')>0 OR INSTR(v.OWNERS,'|VSD2|')>0 OR INSTR(v.OWNERS,'|VSD|')>0 OR INSTR(v.OWNERS,'|VODE|')>0 OR INSTR(v.OWNERS,'|VNH|')>0 OR INSTR(v.OWNERS,'|TVPB|')>0 OR INSTR(v.OWNERS,'|TVDP|')>0 OR INSTR(v.OWNERS,'|TV3S|')>0 OR INSTR(v.OWNERS,'|AMC|')>0 OR INSTR(v.OWNERS,'|TV1E|')>0 OR INSTR(v.OWNERS,'|TV1B|')>0 OR INSTR(v.OWNERS,'|Play|')>0 OR INSTR(v.OWNERS,'|MM|')>0 OR INSTR(v.OWNERS,'|KNVA|')>0 OR INSTR(v.OWNERS,'|03UP|')>0 OR INSTR(v.OWNERS,'|03NO|')>0 OR INSTR(v.OWNERS,'|03NB|')>0 OR INSTR(v.OWNERS,'|03GD|')>0 OR INSTR(v.OWNERS,'|AL|')>0 OR INSTR(v.OWNERS,'|ICCWCCL|')>0 OR INSTR(v.OWNERS,'|PMH|')>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,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|SKY|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|SKYRUGUN|')>0 OR INSTR(m.OWNERS,'|SKYCRI|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|TVONE|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|SKYHORSE|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|BTS|')>0 OR INSTR(m.OWNERS,'|SKYGOLF|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|ANTV|')>0 OR INSTR(m.OWNERS,'|OUT|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|SKYDART|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|VIVA|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>0 OR INSTR(m.OWNERS,'|BT|')>0 OR INSTR(m.OWNERS,'|SKYFOOT|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|PMH|')>0)
) A WHERE rnum>=1 and rnum <= 9999
                    ) connect by nocycle prior x.parent_id=x.id)
t Transfer: 1220 :     12|10:20:40.0008|Exxm3G|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:20:40.0008|Exxm3G|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:20:40.0018|Exxm3G|DANIEL|    user DANIEL.
t Information: 1220 :  12|10:20:40.2028|Exxm3G|DANIEL|Running version search. User: 342    Simple Search: 
Running Oracle search.
Running Oracle search for COUNT
Oracle count completed in: 8ms.  Returned lines: 2
Oracle version search timing: 193ms.
SQL run:
 select  v.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE,  nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select 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 tmddba.tm_pg_rl 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_id
                    --sqlIdSearchJoin
                    where v.item_type>0 and v.rl_deleted=0
                     AND (INSTR(v.OWNERS,'|VSHD|')>0 OR INSTR(v.OWNERS,'|VSE|')>0 OR INSTR(v.OWNERS,'|VS3|')>0 OR INSTR(v.OWNERS,'|VODS|')>0 OR INSTR(v.OWNERS,'|VHPO|')>0 OR INSTR(v.OWNERS,'|VEXE|')>0 OR INSTR(v.OWNERS,'|VEPL|')>0 OR INSTR(v.OWNERS,'|V4N|')>0 OR INSTR(v.OWNERS,'|V3H|')>0 OR INSTR(v.OWNERS,'|V1G|')>0 OR INSTR(v.OWNERS,'|TV6N|')>0 OR INSTR(v.OWNERS,'|TV3N|')>0 OR INSTR(v.OWNERS,'|TV1D|')>0 OR INSTR(v.OWNERS,'|T8LT|')>0 OR INSTR(v.OWNERS,'|T6LV|')>0 OR INSTR(v.OWNERS,'|T3LV|')>0 OR INSTR(v.OWNERS,'|DMY|')>0 OR INSTR(v.OWNERS,'|CENT|')>0 OR INSTR(v.OWNERS,'|03VT|')>0 OR INSTR(v.OWNERS,'|03SS|')>0 OR INSTR(v.OWNERS,'|03SE|')>0 OR INSTR(v.OWNERS,'|AMAY|')>0 OR INSTR(v.OWNERS,'|BBC|')>0 OR INSTR(v.OWNERS,'|SKY|')>0 OR INSTR(v.OWNERS,'|MED|')>0 OR INSTR(v.OWNERS,'|SFP1|')>0 OR INSTR(v.OWNERS,'|TMD|')>0 OR INSTR(v.OWNERS,'|HUB|')>0 OR INSTR(v.OWNERS,'|VNE|')>0 OR INSTR(v.OWNERS,'|TVPU|')>0 OR INSTR(v.OWNERS,'|PBOY|')>0 OR INSTR(v.OWNERS,'|CTCE|')>0 OR INSTR(v.OWNERS,'|03GO|')>0 OR INSTR(v.OWNERS,'|EST|')>0 OR INSTR(v.OWNERS,'|MTG|')>0 OR INSTR(v.OWNERS,'|NAA|')>0 OR INSTR(v.OWNERS,'|ATP|')>0 OR INSTR(v.OWNERS,'|ICCCTY|')>0 OR INSTR(v.OWNERS,'|ICCWCP|')>0 OR INSTR(v.OWNERS,'|ICCICC|')>0 OR INSTR(v.OWNERS,'|ITV|')>0 OR INSTR(v.OWNERS,'|SKYRUGUN|')>0 OR INSTR(v.OWNERS,'|SKYCRI|')>0 OR INSTR(v.OWNERS,'|VODD|')>0 OR INSTR(v.OWNERS,'|VEPO|')>0 OR INSTR(v.OWNERS,'|VEC|')>0 OR INSTR(v.OWNERS,'|TVSL|')>0 OR INSTR(v.OWNERS,'|TV8|')>0 OR INSTR(v.OWNERS,'|TV1N|')>0 OR INSTR(v.OWNERS,'|TV1K|')>0 OR INSTR(v.OWNERS,'|TV1F|')>0 OR INSTR(v.OWNERS,'|T6LT|')>0 OR INSTR(v.OWNERS,'|T3LT|')>0 OR INSTR(v.OWNERS,'|NVA|')>0 OR INSTR(v.OWNERS,'|KNL2|')>0 OR INSTR(v.OWNERS,'|DMF|')>0 OR INSTR(v.OWNERS,'|CTCB|')>0 OR INSTR(v.OWNERS,'|3PD|')>0 OR INSTR(v.OWNERS,'|03SK|')>0 OR INSTR(v.OWNERS,'|03HA|')>0 OR INSTR(v.OWNERS,'|EUROSPORT|')>0 OR INSTR(v.OWNERS,'|TVONE|')>0 OR INSTR(v.OWNERS,'|ICCCWC|')>0 OR INSTR(v.OWNERS,'|ICCU19CWC|')>0 OR INSTR(v.OWNERS,'|ICCWCL|')>0 OR INSTR(v.OWNERS,'|PSP|')>0 OR INSTR(v.OWNERS,'|SKYHORSE|')>0 OR INSTR(v.OWNERS,'|SFP2|')>0 OR INSTR(v.OWNERS,'|VODN|')>0 OR INSTR(v.OWNERS,'|VODF|')>0 OR INSTR(v.OWNERS,'|VNPO|')>0 OR INSTR(v.OWNERS,'|VHIS|')>0 OR INSTR(v.OWNERS,'|VEXR|')>0 OR INSTR(v.OWNERS,'|TVAE|')>0 OR INSTR(v.OWNERS,'|03SM|')>0 OR INSTR(v.OWNERS,'|TV1P|')>0 OR INSTR(v.OWNERS,'|TV1A|')>0 OR INSTR(v.OWNERS,'|RTR|')>0 OR INSTR(v.OWNERS,'|HDP2|')>0 OR INSTR(v.OWNERS,'|03VA|')>0 OR INSTR(v.OWNERS,'|03SN|')>0 OR INSTR(v.OWNERS,'|AECSD|')>0 OR INSTR(v.OWNERS,'|WCIU|')>0 OR INSTR(v.OWNERS,'|ICCTWT|')>0 OR INSTR(v.OWNERS,'|ICCCWL2|')>0 OR INSTR(v.OWNERS,'|BTS|')>0 OR INSTR(v.OWNERS,'|SKYGOLF|')>0 OR INSTR(v.OWNERS,'|ZTVS|')>0 OR INSTR(v.OWNERS,'|V1TZ|')>0 OR INSTR(v.OWNERS,'|TV6S|')>0 OR INSTR(v.OWNERS,'|TV5L|')>0 OR INSTR(v.OWNERS,'|TV2S|')>0 OR INSTR(v.OWNERS,'|DAVI|')>0 OR INSTR(v.OWNERS,'|3PLV|')>0 OR INSTR(v.OWNERS,'|03VL|')>0 OR INSTR(v.OWNERS,'|03VB|')>0 OR INSTR(v.OWNERS,'|03SY|')>0 OR INSTR(v.OWNERS,'|03SG|')>0 OR INSTR(v.OWNERS,'|03SB|')>0 OR INSTR(v.OWNERS,'|03OR|')>0 OR INSTR(v.OWNERS,'|03LI|')>0 OR INSTR(v.OWNERS,'|03JO|')>0 OR INSTR(v.OWNERS,'|03BO|')>0 OR INSTR(v.OWNERS,'|MBNS|')>0 OR INSTR(v.OWNERS,'|OSP|')>0 OR INSTR(v.OWNERS,'|ICCWTC|')>0 OR INSTR(v.OWNERS,'|PPL|')>0 OR INSTR(v.OWNERS,'|ANTV|')>0 OR INSTR(v.OWNERS,'|OUT|')>0 OR INSTR(v.OWNERS,'|SPG|')>0 OR INSTR(v.OWNERS,'|VSS|')>0 OR INSTR(v.OWNERS,'|VSAT|')>0 OR INSTR(v.OWNERS,'|VNHD|')>0 OR INSTR(v.OWNERS,'|VNC|')>0 OR INSTR(v.OWNERS,'|TV6H|')>0 OR INSTR(v.OWNERS,'|TV6E|')>0 OR INSTR(v.OWNERS,'|TV1C|')>0 OR INSTR(v.OWNERS,'|NICK|')>0 OR INSTR(v.OWNERS,'|HDP1|')>0 OR INSTR(v.OWNERS,'|HDC1|')>0 OR INSTR(v.OWNERS,'|DMA|')>0 OR INSTR(v.OWNERS,'|3+ES|')>0 OR INSTR(v.OWNERS,'|TV10|')>0 OR INSTR(v.OWNERS,'|AECHD|')>0 OR INSTR(v.OWNERS,'|TECHM|')>0 OR INSTR(v.OWNERS,'|ICCWWC|')>0 OR INSTR(v.OWNERS,'|LMH|')>0 OR INSTR(v.OWNERS,'|SKYDART|')>0 OR INSTR(v.OWNERS,'|VS2|')>0 OR INSTR(v.OWNERS,'|TV1S|')>0 OR INSTR(v.OWNERS,'|SPTV|')>0 OR INSTR(v.OWNERS,'|LNT|')>0 OR INSTR(v.OWNERS,'|DTV|')>0 OR INSTR(v.OWNERS,'|CS|')>0 OR INSTR(v.OWNERS,'|TV3D|')>0 OR INSTR(v.OWNERS,'|03SC|')>0 OR INSTR(v.OWNERS,'|03NM|')>0 OR INSTR(v.OWNERS,'|YLE TV1|')>0 OR INSTR(v.OWNERS,'|ICCWTT|')>0 OR INSTR(v.OWNERS,'|PMS|')>0 OR INSTR(v.OWNERS,'|VIVA|')>0 OR INSTR(v.OWNERS,'|BEDIG|')>0 OR INSTR(v.OWNERS,'|BT|')>0 OR INSTR(v.OWNERS,'|SKYFOOT|')>0 OR INSTR(v.OWNERS,'|VSG|')>0 OR INSTR(v.OWNERS,'|VSD2|')>0 OR INSTR(v.OWNERS,'|VSD|')>0 OR INSTR(v.OWNERS,'|VODE|')>0 OR INSTR(v.OWNERS,'|VNH|')>0 OR INSTR(v.OWNERS,'|TVPB|')>0 OR INSTR(v.OWNERS,'|TVDP|')>0 OR INSTR(v.OWNERS,'|TV3S|')>0 OR INSTR(v.OWNERS,'|AMC|')>0 OR INSTR(v.OWNERS,'|TV1E|')>0 OR INSTR(v.OWNERS,'|TV1B|')>0 OR INSTR(v.OWNERS,'|Play|')>0 OR INSTR(v.OWNERS,'|MM|')>0 OR INSTR(v.OWNERS,'|KNVA|')>0 OR INSTR(v.OWNERS,'|03UP|')>0 OR INSTR(v.OWNERS,'|03NO|')>0 OR INSTR(v.OWNERS,'|03NB|')>0 OR INSTR(v.OWNERS,'|03GD|')>0 OR INSTR(v.OWNERS,'|AL|')>0 OR INSTR(v.OWNERS,'|ICCWCCL|')>0 OR INSTR(v.OWNERS,'|PMH|')>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,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|SKY|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|SKYRUGUN|')>0 OR INSTR(m.OWNERS,'|SKYCRI|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|TVONE|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|SKYHORSE|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|BTS|')>0 OR INSTR(m.OWNERS,'|SKYGOLF|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|ANTV|')>0 OR INSTR(m.OWNERS,'|OUT|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|SKYDART|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|VIVA|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>0 OR INSTR(m.OWNERS,'|BT|')>0 OR INSTR(m.OWNERS,'|SKYFOOT|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|PMH|')>0)
) A WHERE rnum>=1 and rnum <= 9999
                    ) connect by nocycle prior x.parent_id=x.id)

t Verbose: 1220 :      12|10:20:40.2028|Exxm3G|DANIEL|imfx v3 API took 0.215s '/api/v3/title/299394/versions?_dc=1665480041719'
t Transfer: 1220 :     12|10:20:40.8058|U9CHFG|DANIEL|OAuth: /api/v3/version/299395/media?_dc=1665480042437
t Transfer: 1220 :     12|10:20:40.8058|U9CHFG|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:20:40.8058|U9CHFG|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:20:40.8058|U9CHFG|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:20:40.8058|U9CHFG|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|10:20:40.8058|U9CHFG|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :     12|10:20:40.8068|U9CHFG|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:20:40.8068|U9CHFG|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:20:40.8068|U9CHFG|DANIEL|    user DANIEL.
t Information: 1220 :  12|10:20:40.8068|U9CHFG|DANIEL|MediaSearch SQL:
select r.*,
    nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE,
    nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
    nvl(t.text_data_path,'') THUMBSERVER, 
    nvl(t.text_data_filename,'') THUMBFILE,
    nvl(t.text_id,-1) THUMBID , 
    (SELECT SUBSTR( trim( replace (replace (
          LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z
            FROM tm_media_tagging tt
              WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , 
    GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
    nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME 

    from (select a.*, rownum rnum from 
      (select  m.*,
     coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 
      from tmddba.tm_mis m 
where  media_type>0 and item_type>0  AND  PGM_PARENT_ID=:param_0  and m.mi_deleted=0   AND (INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|SKY|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|SKYRUGUN|')>0 OR INSTR(m.OWNERS,'|SKYCRI|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|TVONE|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|SKYHORSE|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|BTS|')>0 OR INSTR(m.OWNERS,'|SKYGOLF|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|ANTV|')>0 OR INSTR(m.OWNERS,'|OUT|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|SKYDART|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|VIVA|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>0 OR INSTR(m.OWNERS,'|BT|')>0 OR INSTR(m.OWNERS,'|SKYFOOT|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|PMH|')>0)
 order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r 
    ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat  from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk 
    ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t
    ,lateral(select /*+ NO_DECORRELATE */  d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename
        FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl 
    
    where rnum >= 1 order by rnum

t Information: 1220 :  12|10:20:40.8068|U9CHFG|DANIEL|  count returned 0
t Verbose: 1220 :      12|10:20:40.8078|U9CHFG|DANIEL|imfx v3 API took 0.009s '/api/v3/version/299395/media?_dc=1665480042437'
t Transfer: 1220 :     12|10:20:40.8078|ZijRjT|DANIEL|OAuth: /api/v3/version/299395/media?_dc=1665480042554
t Transfer: 1220 :     12|10:20:40.8078|ZijRjT|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:20:40.8078|ZijRjT|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:20:40.8078|ZijRjT|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:20:40.8078|ZijRjT|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|10:20:40.8078|ZijRjT|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :     12|10:20:40.8088|ZijRjT|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:20:40.8088|ZijRjT|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:20:40.8088|ZijRjT|DANIEL|    user DANIEL.
t Information: 1220 :  12|10:20:40.8088|ZijRjT|DANIEL|MediaSearch SQL:
select r.*,
    nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE,
    nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
    nvl(t.text_data_path,'') THUMBSERVER, 
    nvl(t.text_data_filename,'') THUMBFILE,
    nvl(t.text_id,-1) THUMBID , 
    (SELECT SUBSTR( trim( replace (replace (
          LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z
            FROM tm_media_tagging tt
              WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , 
    GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
    nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME 

    from (select a.*, rownum rnum from 
      (select  m.*,
     coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 
      from tmddba.tm_mis m 
where  media_type>0 and item_type>0  AND  PGM_PARENT_ID=:param_0  and m.mi_deleted=0   AND (INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|SKY|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|SKYRUGUN|')>0 OR INSTR(m.OWNERS,'|SKYCRI|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|TVONE|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|SKYHORSE|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|BTS|')>0 OR INSTR(m.OWNERS,'|SKYGOLF|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|ANTV|')>0 OR INSTR(m.OWNERS,'|OUT|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|SKYDART|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|VIVA|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>0 OR INSTR(m.OWNERS,'|BT|')>0 OR INSTR(m.OWNERS,'|SKYFOOT|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|PMH|')>0)
 order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r 
    ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat  from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk 
    ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t
    ,lateral(select /*+ NO_DECORRELATE */  d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename
        FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl 
    
    where rnum >= 1 order by rnum

t Information: 1220 :  12|10:20:40.8088|ZijRjT|DANIEL|  count returned 0
t Verbose: 1220 :      12|10:20:40.8088|ZijRjT|DANIEL|imfx v3 API took 0.009s '/api/v3/version/299395/media?_dc=1665480042554'
t Transfer: 1220 :     12|10:20:42.0158|HU1wur|DANIEL|OAuth: /api/v3/version/299395/media?_dc=1665480043689
t Transfer: 1220 :     12|10:20:42.0158|HU1wur|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:20:42.0158|HU1wur|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:20:42.0158|HU1wur|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|10:20:42.0158|HU1wur|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|10:20:42.0158|HU1wur|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :     12|10:20:42.0158|HU1wur|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|10:20:42.0168|HU1wur|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|10:20:42.0168|HU1wur|DANIEL|    user DANIEL.
t Information: 1220 :  12|10:20:42.0168|HU1wur|DANIEL|MediaSearch SQL:
select r.*,
    nvl((select TMD_STR_AGG(c.u_id_pfix ) from tm_ctnrs c, tm_mi_tpi_lnx l where l.miid=r.id and c.u_id=l.tpiid and r.media_type in (1,110)),'') BARCODE,
    nvl(lnk.lib_loc_ext_id,0) lib_loc_ext_id, nvl(lnk.ctnr_loan_stat,0) ctnr_loan_status, nvl(lnk.ctnr_stat,0) ctnr_stat,
    nvl(t.text_data_path,'') THUMBSERVER, 
    nvl(t.text_data_filename,'') THUMBFILE,
    nvl(t.text_id,-1) THUMBID , 
    (SELECT SUBSTR( trim( replace (replace (
          LISTAGG(trim(tt.tags || ' ' || tt.notes), ' ') WITHIN GROUP (ORDER BY trim(tt.tags || ' ' || tt.notes)), chr (13), ''), chr (10), ' ')), 1, 150) z
            FROM tm_media_tagging tt
              WHERE link_guid = DFILE_LINK_GUID and rownum=1) TAGS_TEXT , 
    GETMEDIALOC(r.id, r.media_type, r.compil, r.m_ctnr_int_o_loc, r.m_ctnr_ext_o_loc, r.m_ctnr_loc) LOCATION,
    nvl(dfl.fSOM,0) FILE_SOM, nvl(dfl.fEOM,0) FILE_EOM, dfl.fos_fname FILENAME, dfl.DFILE_LINK_GUID, dfl.OS_GUID, dfl.SUB_FOLDER, dfl.ORIGINAL_FILENAME 

    from (select a.*, rownum rnum from 
      (select  m.*,
     coalesce(m.primary_thumb_id, (select v.primary_thumb_id from tm_pg_rl v where v.id=m.pgm_parent_id)) primary_thumb_id2 
      from tmddba.tm_mis m 
where  media_type>0 and item_type>0  AND  PGM_PARENT_ID=:param_0  and m.mi_deleted=0   AND (INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|SKY|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|SKYRUGUN|')>0 OR INSTR(m.OWNERS,'|SKYCRI|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|TVONE|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|SKYHORSE|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|BTS|')>0 OR INSTR(m.OWNERS,'|SKYGOLF|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|ANTV|')>0 OR INSTR(m.OWNERS,'|OUT|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|SKYDART|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|VIVA|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>0 OR INSTR(m.OWNERS,'|BT|')>0 OR INSTR(m.OWNERS,'|SKYFOOT|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|PMH|')>0)
 order by upper(m.title), m.media_type, m.ec_som, m.id ) a where rownum <= 50) r 
    ,lateral( select l.miid, max(c.C_EXT_OUT_LOC) lib_loc_ext_id, max(c.C_STAT) ctnr_stat, max(c.loan_stat) ctnr_loan_stat  from tm_mi_tpi_lnx l, tm_ctnrs c where c.u_id=l.tpiid and l.miid=r.id and r.media_type=1 group by l.miid)(+) lnk 
    ,lateral(select tt.* from tm_text tt where tt.text_id = r.primary_thumb_id2)(+) t
    ,lateral(select /*+ NO_DECORRELATE */  d.som fsom, d.eom feom, dl.mi_id fmi_id, d.os_fname fos_fname, d.DFILE_LINK_GUID, d.OS_GUID, d.SUB_FOLDER, dl.dfile_id, d.original_filename
        FROM tm_dfile d, tm_mi_dfile_lnx dl where d.id=dl.dfile_id and r.id=dl.mi_id and rownum=1)(+) dfl 
    
    where rnum >= 1 order by rnum

t Information: 1220 :  12|10:20:42.0168|HU1wur|DANIEL|  count returned 0
t Verbose: 1220 :      12|10:20:42.0168|HU1wur|DANIEL|imfx v3 API took 0.011s '/api/v3/version/299395/media?_dc=1665480043689'
t Information: 1220 :  12|14:02:10.1173|||OrabitWatcherBasic. Disposing.
t Information: 1220 :  12|14:02:10.1183|||OrabitWatcherBasic. Disposed.
t Information: 1220 :  12|14:02:10.1193|||==========================================================================
t Information: 1220 :  12|14:02:10.1193|||IMFX CORE SERVER APPLICATION END.