t Information: 1220 : 11|13:41:10.7327|||Get Configuration Values: t Information: 1220 : 11|13:41:10.7327||| AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==. t Information: 1220 : 11|13:41:10.7327||| EncryptedPasswords, default: true, value: true. t Information: 1220 : 11|13:41:10.7327||| OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=xxxxx;Unicode=true;. t Information: 1220 : 11|13:41:10.7327||| SecondTimezone, default: , value: . t Information: 1220 : 11|13:41:10.7327||| UseActiveDirectoryAuth, default: false, value: false. t Information: 1220 : 11|13:41:10.7327||| ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc. t Information: 1220 : 11|13:41:10.7327||| ReportsPath, default: , value: . t Information: 1220 : 11|13:41:10.7327||| ReportsURL, default: , value: . t Information: 1220 : 11|13:41:10.7327||| TapeServiceUrl, default: , value: . t Information: 1220 : 11|13:41:10.7327||| GatekeeperUrl, default: , value: . t Information: 1220 : 11|13:41:10.7327||| ValuationUrl, default: , value: . t Information: 1220 : 11|13:41:10.7327||| QueueManagerDelay, default: 30, value: 30. t Information: 1220 : 11|13:41:10.7327||| QueueManagerFullRefresh, default: 90, value: 90. t Information: 1220 : 11|13:41:10.7327||| AudioLoopDuration, default: 0, value: 150. t Information: 1220 : 11|13:41:10.7327||| AudioLoopsCount, default: 0, value: 0. t Information: 1220 : 11|13:41:10.7327||| PlayerFakeStep, default: 500, value: 500. t Information: 1220 : 11|13:41:10.7327||| PlayerForceRatio, default: 0, value: 1. t Information: 1220 : 11|13:41:10.7327||| CheckVersionsInProd, default: false, value: True. t Information: 1220 : 11|13:41:10.7327||| MaxResults, default: 3000, value: 10000. t Information: 1220 : 11|13:41:10.7327||| TEReportID, default: 0, value: 0. t Information: 1220 : 11|13:41:10.7327||| ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\. t Information: 1220 : 11|13:41:10.7327||| ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs. t Information: 1220 : 11|13:41:10.7327||| TimeCodeFormat, default: , value: pal. t Information: 1220 : 11|13:41:10.7327||| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 11|13:41:10.7327||| RceMediaPath, default: , value: C:\edl\. t Information: 1220 : 11|13:41:10.7327||| RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\. t Information: 1220 : 11|13:41:10.7327||| RceCsmUrl, default: , value: http://localhost/csm/. t Information: 1220 : 11|13:41:10.7327||| RceMediaSelection, default: , value: miLinkIdMatch. t Information: 1220 : 11|13:41:10.7327||| RequestBrowseJobPresetName, default: , value: . t Information: 1220 : 11|13:41:10.7327||| DontExtendDuration, default: false, value: False. t Information: 1220 : 11|13:41:10.7327||| V3ConfigUrl, default: , value: . t Information: 1220 : 11|13:41:10.7327||| StopWords, default: , value: . t Information: 1220 : 11|13:41:10.7327||| MisrTxFormat, default: G, value: G. t Information: 1220 : 11|13:41:10.7327||| ApiServer, default: , value: http://192.168.120.10:85. t Information: 1220 : 11|13:41:10.7327||| ApiTimeout, default: 120, value: 120. t Information: 1220 : 11|13:41:10.7327||| ApiWorkers, default: 10, value: 10. t Information: 1220 : 11|13:41:10.7327||| UsePerfCounters, default: false, value: false. t Information: 1220 : 11|13:41:10.7327||| LogGetCurrentUser, default: true, value: true. t Information: 1220 : 11|13:41:10.7327||| LogInternalApi, default: true, value: true. t Information: 1220 : 11|13:41:10.7327||| LivePlayApiUrl, default: , value: . t Information: 1220 : 11|13:41:10.7327||| LivePlayApiTimeout, default: 120, value: 120. t Information: 1220 : 11|13:41:10.7327||| ThumbnailServer, default: , value: . t Information: 1220 : 11|13:41:10.7327||| PasswordResetEmailTemplateId, default: 0, value: 0. t Information: 1220 : 11|13:41:10.7327||| PasswordResetEmailTemplateId_MediaPortal, default: 0, value: 0. t Information: 1220 : 11|13:41:10.7327||| imfxBaseUrl, default: , value: . t Information: 1220 : 11|13:41:10.7327||| imfxBaseUrl_MediaPortal, default: , value: . t Information: 1220 : 11|13:41:10.7327||| imfxBaseUrl_VideoBrowser, default: , value: . t Information: 1220 : 11|13:41:10.7327||| ShowDetailedErrors, default: false, value: false. t Information: 1220 : 11|13:41:10.7327||| AllowXmlRequests, default: false, value: false. t Information: 1220 : 11|13:41:10.7327||| MaxLoginAttempts, default: 3, value: 3. t Information: 1220 : 11|13:41:10.7327||| MaxLoginAttemptsPeriod, default: 15, value: 15. t Information: 1220 : 11|13:41:10.7327||| AllowRaisePreviewInMiSR, default: false, value: false. t Information: 1220 : 11|13:41:10.7327||| LocationFilter, default: , value: . t Information: 1220 : 11|13:41:10.7327||| SvUtilServiceUrl, default: , value: . t Information: 1220 : 11|13:41:10.7327||| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 11|13:41:10.7327||| UseIndexServerSearch, default: false, value: True. t Information: 1220 : 11|13:41:10.7327||| SolrIndexVersion, default: 1, value: 6. t Information: 1220 : 11|13:41:10.7327||| SolrConnection, default: , value: http://192.168.120.14:8983/solr. t Information: 1220 : 11|13:41:10.7327||| FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number. t Information: 1220 : 11|13:41:10.7327||| FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number. t Information: 1220 : 11|13:41:10.7327||| FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key. t Information: 1220 : 11|13:41:10.7327||| PreviewPreset, default: , value: . t Information: 1220 : 11|13:41:10.7327||| DevMode, default: false, value: false. t Information: 1220 : 11|13:41:10.7327||| DisableSysMan, default: false, value: false. t Information: 1220 : 11|13:41:10.7484||| TimeCodeFormat, default: , value: pal. t Information: 1220 : 11|13:41:10.7484||| FileCatalystStorageDevice, default: , value: . t Information: 1220 : 11|13:41:10.7484||| UseResponsibilityTracking, default: true, value: True. t Information: 1220 : 11|13:41:10.7484||| SubtitleDeviceFilter, default: , value: . t Information: 1220 : 11|13:41:10.7484||| SystemMonitorNamedPipe, default: , value: . t Information: 1220 : 11|13:41:10.7484||| OracleMonitorEnable, default: false, value: False. t Information: 1220 : 11|13:41:10.7484||| ArcApiHost, default: , value: . t Information: 1220 : 11|13:41:10.7484||| SolrTimedTextSearch, default: false, value: false. t Information: 1220 : 11|13:41:10.7484||| ProductionDurationUsageID, default: 1, value: 1. t Information: 1220 : 11|13:41:10.7484||| MediaFacetOrder, default: ResultCountAsc, value: ResultCountAsc. t Information: 1220 : 11|13:41:10.7484||| VersionFacetOrder, default: ResultCountAsc, value: ResultCountAsc. t Information: 1220 : 11|13:41:10.9515|||GetStreamServers.. t Information: 1220 : 11|13:41:11.5609||| https://demo.tmd.tv/CBR Video/ |CBR Video| False t Information: 1220 : 11|13:41:11.5609||| https://demo.tmd.tv/CBR Images/ |CBR Images| False t Information: 1220 : 11|13:41:11.5609||| https://demo.tmd.tv/CBR Audio/ |CBR Audio| False t Information: 1220 : 11|13:41:11.5609||| https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False t Information: 1220 : 11|13:41:11.5609||| http://localhost:82/images/ |IMAGES| False t Information: 1220 : 11|13:41:11.5609||| http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False t Information: 1220 : 11|13:41:11.5609||| http://192.168.91.73/cloudstore/ |CLOUD_STORE| False t Information: 1220 : 11|13:41:11.5609||| http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False t Information: 1220 : 11|13:41:11.5609||| http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False t Information: 1220 : 11|13:41:11.5609||| http://localhost:82/video/ |FILESTORE_VIDEO| False t Information: 1220 : 11|13:41:11.5609||| https://imfxv3tm.tmd.tv/streaming/ |Streaming| False t Information: 1220 : 11|13:41:11.5609||| https://imfxv3tm.tmd.tv/VideoServer/ |Video| False t Information: 1220 : 11|13:41:11.5609||| https://imfxv3tm.tmd.tv/Proxy/ |Proxy| False t Information: 1220 : 11|13:41:11.5609||| https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False t Information: 1220 : 11|13:41:11.5609||| https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False t Information: 1220 : 11|13:41:11.5609||| https://imfxv3tm.tmd.tv/ImageServer/ |Image| False t Information: 1220 : 11|13:41:11.5609||| https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False t Information: 1220 : 11|13:41:11.5609||| https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False t Information: 1220 : 11|13:41:11.5609||| SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr. t Information: 1220 : 11|13:41:11.5609||| LogWebApi, default: false, value: false. t Information: 1220 : 11|13:41:11.5609||| EmbeddedRceUrl, default: , value: . t Information: 1220 : 11|13:41:11.5609||| InstallMode, default: , value: . t Information: 1220 : 11|13:41:11.5609||| SamlRequestAddress, default: , value: . t Information: 1220 : 11|13:41:11.5609||| SamlTrustedIssuer, default: , value: . t Information: 1220 : 11|13:41:11.5609||| SamlLoginRedirect, default: , value: . t Information: 1220 : 11|13:41:11.5609||| NaturalLangSearch, default: false, value: True. t Information: 1220 : 11|13:41:11.5609||| LocalUploadExpirationHours, default: 0, value: 0. t Information: 1220 : 11|13:41:11.5609||| LocalUploadDeviceId, default: 0, value: 0. t Information: 1220 : 11|13:41:11.5609||| VideosFileFormatIds, default: , value: . t Information: 1220 : 11|13:41:11.5609||| VideosStorageIds, default: , value: . t Information: 1220 : 11|13:41:11.5609||| OktaLoginField, default: , value: . t Information: 1220 : 11|13:41:11.5609||| AuthenticationTypes, default: , value: Native,PublicApiKey. t Information: 1220 : 11|13:41:11.5609|||OrabitWatcherBasic. Initialize. t Information: 1220 : 11|13:41:11.5609|||FillDictionaryCache. t Information: 1220 : 11|13:41:15.2478|||GetSupportedOperators t Information: 1220 : 11|13:41:15.6540|||CacheTechReports. t Information: 1220 : 11|13:41:15.8572|||& Cache update. Server (global) filled with timestamp 01:09:15.6853347. types null t Information: 1220 : 11|13:41:15.8572|||InitializeFromDatabase. 'Server=TECHM;User Id=imfx;password=..;Unicode=true;' direct False, home , timeout 15 t Information: 1220 : 11|13:41:15.8572|||FillDictionaryCache. t Information: 1220 : 11|13:41:15.8572|||& Cache update. Server (global) filled with timestamp 01:09:15.7165750. types FriendlyNames, DatabaseSearchFieldData t Information: 1220 : 11|13:41:16.5290|||OrabitWatcherBasic trying to connect.. t Information: 1220 : 11|13:41:16.5290|||========================================================================== t Information: 1220 : 11|13:41:16.5290|||IMFX CORE SERVER APPLICATION START. t Information: 1220 : 11|13:41:16.5290|||DLL VERSION: 3.0.0.1034. t Information: 1220 : 11|13:41:16.5290|||IS TIMER HIGH RESOLUTION : True. t Information: 1220 : 11|13:41:16.5290||| UmsDev, default: False, value: False. t Information: 1220 : 11|13:41:16.5290|||OrabitWatcherBasic connected. t Information: 1220 : 11|13:41:16.5290|||OrabitWatcherBasic queue created tmd.cfg.in.04d0abd0-7d45-4d14-ab15-74c5f539b231 t Transfer: 1220 : 11|15:38:52.5431|2qlyWj||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey t Information: 1220 : 11|15:38:52.9493|SZWcYV||GetCache. t Information: 1220 : 11|15:38:52.9493|SZWcYV||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\108_2_PnqJC_.png t Information: 1220 : 11|15:38:52.9493|SZWcYV||GetCache. Data read: 154944 t Verbose: 1220 : 11|15:38:52.9493|SZWcYV||imfx v3 API took 0.069s '/api/v3/visual-asset/group/PnqJC_/2/image' t Verbose: 1220 : 11|15:45:01.1988|R53DHw||Oauth validating.. t Verbose: 1220 : 11|15:45:01.1988|R53DHw||GrantResourceOwnerCredentials. t Verbose: 1220 : 11|15:45:01.4019|R53DHw||LoginUser. tmddba, login type OAuth, encrypt password True t Information: 1220 : 11|15:45:01.4019|R53DHw||TryLoginUser. tmddba, login type OAuth, check password True, check hash False, encrypt password True, load user data False t Information: 1220 : 11|15:45:02.0113|R53DHw|| oauth token 00000000-0000-0000-0000-000000000000 t Information: 1220 : 11|15:45:02.0113|R53DHw||TryLoginUser. Logged in.. t Information: 1220 : 11|15:45:02.0113|R53DHw||GetPasswordPolicy. WARNING: Policy not found for system Imediaflex. Validation disabled. t Verbose: 1220 : 11|15:45:02.0113|R53DHw||LoginUser. Adding history. User Id 1, result TMDDBA, host 192.168.127.6 t Verbose: 1220 : 11|15:45:02.0113|R53DHw||GrantResourceOwnerCredentials. Try login finished. Logged: True t Transfer: 1220 : 11|15:45:02.2144|p7IAsi|TMDDBA|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=1695912302040 t Transfer: 1220 : 11|15:45:02.2144|p7IAsi|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:02.2144|p7IAsi|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:02.2144|p7IAsi|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:02.2144|p7IAsi|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 11|15:45:02.2144|p7IAsi|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:02.2144|p7IAsi|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:02.2144|p7IAsi|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:02.2144|p7IAsi|TMDDBA|imfx v3 API took 0.046s '/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=1695912302040' t Transfer: 1220 : 11|15:45:02.2144|GZxX8b|TMDDBA|OAuth: /api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1695912302133 t Transfer: 1220 : 11|15:45:02.2144|GZxX8b|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:02.2144|GZxX8b|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:02.2144|GZxX8b|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:02.2144|GZxX8b|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 11|15:45:02.2144|GZxX8b|TMDDBA|GetUserDataByKeys: personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings t Transfer: 1220 : 11|15:45:02.2144|GZxX8b|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:02.2144|GZxX8b|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:02.2144|GZxX8b|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:02.4175|GZxX8b|TMDDBA|imfx v3 API took 0.048s '/api/user-preferences?keys=personal_settings;basket;default_page;color_schema;media.basket.data;defaultSearch;workflow_queues_actions;workflow_queues_settings&_dc=1695912302133' t Information: 1220 : 11|15:45:02.4175|kh~8Rh|TMDDBA|GetUserProfile. Id: 0 t Transfer: 1220 : 11|15:45:02.4175|kh~8Rh|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:02.4175|kh~8Rh|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:02.4175|kh~8Rh|TMDDBA| user TMDDBA. t Transfer: 1220 : 11|15:45:02.4175|fbW~M0|TMDDBA|OAuth: /api/settings/group/0?_dc=1695912302372 t Transfer: 1220 : 11|15:45:02.4175|fbW~M0|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:02.4175|fbW~M0|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:02.4175|fbW~M0|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:02.4175|fbW~M0|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 11|15:45:02.6206|jBsuYQ|TMDDBA|OAuth: /api/settings/user/mainMenuSettings?_dc=1695912302373 t Transfer: 1220 : 11|15:45:02.6206|jBsuYQ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:02.6206|jBsuYQ|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:02.6206|jBsuYQ|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:02.6206|jBsuYQ|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 11|15:45:02.6206|gFH_oQ|TMDDBA|OAuth: /api/settings/user/uploadSettings?_dc=1695912302380 t Transfer: 1220 : 11|15:45:02.6206|gFH_oQ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:02.6206|gFH_oQ|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:02.6206|gFH_oQ|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:02.6206|gFH_oQ|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 11|15:45:02.6206|C4_bht|TMDDBA|OAuth: /api/settings/user/mainMenuSettings?_dc=1695912302402 t Transfer: 1220 : 11|15:45:02.6206|C4_bht|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:02.6206|C4_bht|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:02.6206|C4_bht|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:02.6206|C4_bht|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 11|15:45:02.6206|jBsuYQ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:02.6206|jBsuYQ|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:02.6206|jBsuYQ|TMDDBA| user TMDDBA. t Transfer: 1220 : 11|15:45:02.8238|C4_bht|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:02.8238|C4_bht|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:02.8238|C4_bht|TMDDBA| user TMDDBA. t Transfer: 1220 : 11|15:45:02.8238|gFH_oQ|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:02.8238|gFH_oQ|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:02.8238|gFH_oQ|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:02.8238|fbW~M0|TMDDBA|imfx v3 API took 0.284s '/api/settings/group/0?_dc=1695912302372' t Verbose: 1220 : 11|15:45:02.8238|C4_bht|TMDDBA|imfx v3 API took 0.088s '/api/settings/user/mainMenuSettings?_dc=1695912302402' t Transfer: 1220 : 11|15:45:02.8238|zXdI6G|TMDDBA|OAuth: /api/settings/group/0?_dc=1695912302402 t Transfer: 1220 : 11|15:45:02.8238|zXdI6G|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:02.8238|zXdI6G|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:02.8238|zXdI6G|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:02.8238|zXdI6G|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 11|15:45:02.8238|jBsuYQ|TMDDBA|imfx v3 API took 0.200s '/api/settings/user/mainMenuSettings?_dc=1695912302373' t Information: 1220 : 11|15:45:02.8238|rIfMYg||GetCache. t Information: 1220 : 11|15:45:02.8238|rIfMYg||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\106_0_PnqJC_.png t Verbose: 1220 : 11|15:45:02.8238|gFH_oQ|TMDDBA|imfx v3 API took 0.096s '/api/settings/user/uploadSettings?_dc=1695912302380' t Information: 1220 : 11|15:45:02.8238|rIfMYg||GetCache. Data read: 0 t Verbose: 1220 : 11|15:45:02.8238|rIfMYg||imfx v3 API took 0.005s '/api/v3/visual-asset/group/PnqJC_/0/image' t Transfer: 1220 : 11|15:45:02.8238|rM0Yru|TMDDBA|OAuth: /api/lookups/MediaStatus?_dc=1695912302412 t Transfer: 1220 : 11|15:45:02.8238|rM0Yru|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:02.8238|rM0Yru|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:02.8238|rM0Yru|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:02.8238|rM0Yru|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 11|15:45:02.8238|KBuawM|TMDDBA|OAuth: /api/lookups/PgmStatus?_dc=1695912302413 t Transfer: 1220 : 11|15:45:02.8238|RpmIRh|TMDDBA|OAuth: /api/lookup/CustomMediaStatusTypes?_dc=1695912302413 t Transfer: 1220 : 11|15:45:02.8238|KBuawM|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:02.8238|RpmIRh|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:02.8238|RpmIRh|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:02.8238|KBuawM|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:02.8238|RpmIRh|TMDDBA| user TMDDBA. t Transfer: 1220 : 11|15:45:02.8238|KBuawM|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:02.8238|KBuawM|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 11|15:45:02.8238|RpmIRh|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 11|15:45:02.8238|rM0Yru|TMDDBA|imfx v3 API took 0.029s '/api/lookups/MediaStatus?_dc=1695912302412' t Verbose: 1220 : 11|15:45:02.8238|KBuawM|TMDDBA|imfx v3 API took 0.029s '/api/lookups/PgmStatus?_dc=1695912302413' t Transfer: 1220 : 11|15:45:02.8238|83uc0q|TMDDBA|OAuth: /api/lookup/CustomVersionStatusTypes?_dc=1695912302415 t Transfer: 1220 : 11|15:45:02.8238|83uc0q|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:02.8238|83uc0q|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:02.8238|83uc0q|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:02.8238|83uc0q|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 11|15:45:03.0425|zXdI6G|TMDDBA|imfx v3 API took 0.094s '/api/settings/group/0?_dc=1695912302402' t Verbose: 1220 : 11|15:45:03.0425|RpmIRh|TMDDBA|imfx v3 API took 0.065s '/api/lookup/CustomMediaStatusTypes?_dc=1695912302413' t Transfer: 1220 : 11|15:45:03.0425|NS5b3F|TMDDBA|OAuth: /api/lookup/CustomTitleStatusTypes?_dc=1695912302416 t Transfer: 1220 : 11|15:45:03.0425|NS5b3F|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:03.0425|NS5b3F|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:03.0425|NS5b3F|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:03.0425|NS5b3F|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 11|15:45:03.0425|NS5b3F|TMDDBA|imfx v3 API took 0.008s '/api/lookup/CustomTitleStatusTypes?_dc=1695912302416' t Verbose: 1220 : 11|15:45:03.0425|83uc0q|TMDDBA|imfx v3 API took 0.024s '/api/lookup/CustomVersionStatusTypes?_dc=1695912302415' t Transfer: 1220 : 11|15:45:03.0425|kLha8z|TMDDBA|OAuth: /api/settings/user/defaultHomePage?_dc=1695912302417 t Transfer: 1220 : 11|15:45:03.0425|kLha8z|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:03.0425|kLha8z|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:03.0425|kLha8z|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:03.0425|kLha8z|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 11|15:45:03.0425|evetlM||GetCache. t Transfer: 1220 : 11|15:45:03.0425|kLha8z|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:03.0425|kLha8z|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:03.0425|kLha8z|TMDDBA| user TMDDBA. t Information: 1220 : 11|15:45:03.0425|evetlM||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\107_1_PnqJC_.png t Information: 1220 : 11|15:45:03.0425|evetlM||GetCache. Data read: 0 t Verbose: 1220 : 11|15:45:03.0425|evetlM||imfx v3 API took 0.004s '/api/v3/visual-asset/group/PnqJC_/1/image' t Verbose: 1220 : 11|15:45:03.0425|kLha8z|TMDDBA|imfx v3 API took 0.008s '/api/settings/user/defaultHomePage?_dc=1695912302417' t Transfer: 1220 : 11|15:45:03.2457|NHNKEV|TMDDBA|OAuth: /api/settings/user/consumer?_dc=1695912303023 t Transfer: 1220 : 11|15:45:03.2457|NHNKEV|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:03.2457|NHNKEV|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:03.2457|NHNKEV|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:03.2457|NHNKEV|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 11|15:45:03.2457|NHNKEV|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:03.2457|NHNKEV|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:03.2457|NHNKEV|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:03.2457|NHNKEV|TMDDBA|imfx v3 API took 0.015s '/api/settings/user/consumer?_dc=1695912303023' t Transfer: 1220 : 11|15:45:03.2457|nppxvz|TMDDBA|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1695912303075 t Transfer: 1220 : 11|15:45:03.2457|nppxvz|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:03.2457|nppxvz|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:03.2457|nppxvz|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:03.2457|nppxvz|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 11|15:45:03.2457|nppxvz|TMDDBA|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 11|15:45:03.2457|nppxvz|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:03.2457|nppxvz|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:03.2457|nppxvz|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:03.2457|nppxvz|TMDDBA|imfx v3 API took 0.006s '/api/user-preferences?keys=consumer.recent.data&_dc=1695912303075' t Transfer: 1220 : 11|15:45:03.4477|cFJmnX|TMDDBA|OAuth: /api/settings/user/defaultSearch?_dc=1695912303217 t Transfer: 1220 : 11|15:45:03.4477|cFJmnX|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:03.4477|cFJmnX|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:03.4477|cFJmnX|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:03.4477|cFJmnX|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 11|15:45:03.4477|Ck2wx0|TMDDBA|OAuth: /api/settings/user/startSearch?_dc=1695912303218 t Transfer: 1220 : 11|15:45:03.4477|Ck2wx0|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:03.4477|Ck2wx0|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:03.4487|Ck2wx0|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:03.4487|Ck2wx0|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 11|15:45:03.4487|cFJmnX|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:03.4487|cFJmnX|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:03.4487|cFJmnX|TMDDBA| user TMDDBA. t Transfer: 1220 : 11|15:45:03.4487|Ck2wx0|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:03.4487|Ck2wx0|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:03.4487|Ck2wx0|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:03.4497|Ck2wx0|TMDDBA|imfx v3 API took 0.008s '/api/settings/user/startSearch?_dc=1695912303218' t Verbose: 1220 : 11|15:45:03.4497|cFJmnX|TMDDBA|imfx v3 API took 0.010s '/api/settings/user/defaultSearch?_dc=1695912303217' t Transfer: 1220 : 11|15:45:03.4497|iFJYk_|TMDDBA|OAuth: /api/user-preferences?keys=consumer.recent.data&_dc=1695912303303 t Transfer: 1220 : 11|15:45:03.4497|iFJYk_|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:03.4497|iFJYk_|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:03.4497|iFJYk_|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:45:03.4497|iFJYk_|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 11|15:45:03.4497|9eV9Fn||GetCache. t Information: 1220 : 11|15:45:03.4497|iFJYk_|TMDDBA|GetUserDataByKeys: consumer.recent.data t Transfer: 1220 : 11|15:45:03.4497|iFJYk_|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:45:03.4497|iFJYk_|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:45:03.4507|iFJYk_|TMDDBA| user TMDDBA. t Information: 1220 : 11|15:45:03.4507|9eV9Fn||GetCache. Found: C:\inetpub\wwwroot\imfxcore\VisualAssetsCache\109_3_PnqJC_.png t Information: 1220 : 11|15:45:03.4507|9eV9Fn||GetCache. Data read: 154944 t Verbose: 1220 : 11|15:45:03.4507|9eV9Fn||imfx v3 API took 0.004s '/api/v3/visual-asset/group/PnqJC_/3/image' t Verbose: 1220 : 11|15:45:03.4507|iFJYk_|TMDDBA|imfx v3 API took 0.004s '/api/user-preferences?keys=consumer.recent.data&_dc=1695912303303' t Transfer: 1220 : 11|15:46:19.1009|tRKMcz|TMDDBA|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1695912378975 t Transfer: 1220 : 11|15:46:19.1009|tRKMcz|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:19.1009|tRKMcz|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:19.1009|tRKMcz|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:46:19.1009|tRKMcz|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 11|15:46:19.1009|BF4FnH|TMDDBA|OAuth: /api/v3/versionvideo/299543?_dc=1695912378993 t Transfer: 1220 : 11|15:46:19.1009|BF4FnH|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:19.1009|BF4FnH|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:19.1009|BF4FnH|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:46:19.1009|BF4FnH|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 11|15:46:19.1009|tRKMcz|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:19.1009|tRKMcz|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:19.1009|tRKMcz|TMDDBA| user TMDDBA. t Transfer: 1220 : 11|15:46:19.1009|VT0XuN|TMDDBA|OAuth: /api/settings/user/videoPlayerSettings?_dc=1695912378979 t Transfer: 1220 : 11|15:46:19.1009|VT0XuN|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:19.1009|VT0XuN|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:19.1009|VT0XuN|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:46:19.1009|VT0XuN|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 11|15:46:19.3197|tRKMcz|TMDDBA|imfx v3 API took 0.008s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1695912378975' t Transfer: 1220 : 11|15:46:19.3197|Q~wjmF|TMDDBA|OAuth: /api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1695912379047 t Transfer: 1220 : 11|15:46:19.3197|Q~wjmF|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:19.3197|Q~wjmF|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:19.3197|Q~wjmF|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:46:19.3197|Q~wjmF|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 11|15:46:19.3197|BF4FnH|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:19.3197|BF4FnH|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:19.3197|BF4FnH|TMDDBA| user TMDDBA. t Transfer: 1220 : 11|15:46:19.3197|BF4FnH|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:19.3197|BF4FnH|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:19.3197|BF4FnH|TMDDBA| user TMDDBA. t Transfer: 1220 : 11|15:46:19.3197|Q~wjmF|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:19.3197|Q~wjmF|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:19.3197|Q~wjmF|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:46:19.3197|Q~wjmF|TMDDBA|imfx v3 API took 0.005s '/api/user-group-preferences?globals=htmlplayerhotkeys,audioOnFrameForward&_dc=1695912379047' t Transfer: 1220 : 11|15:46:19.3197|VT0XuN|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:19.3197|VT0XuN|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:19.3197|VT0XuN|TMDDBA| user TMDDBA. t Transfer: 1220 : 11|15:46:19.3197|02zoVe|TMDDBA|OAuth: /api/settings/user/videoPlayerSettings?_dc=1695912379050 t Transfer: 1220 : 11|15:46:19.3197|02zoVe|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:19.3197|02zoVe|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:19.3197|02zoVe|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:46:19.3197|02zoVe|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 11|15:46:19.3197|02zoVe|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:19.3197|02zoVe|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:19.3197|02zoVe|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:46:19.3197|VT0XuN|TMDDBA|imfx v3 API took 0.016s '/api/settings/user/videoPlayerSettings?_dc=1695912378979' t Transfer: 1220 : 11|15:46:19.3197|v07GHo|TMDDBA|OAuth: /api/v3/versionvideo/299543?_dc=1695912379054 t Transfer: 1220 : 11|15:46:19.3197|v07GHo|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:19.3197|v07GHo|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:19.3197|v07GHo|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:46:19.3197|v07GHo|TMDDBA|OAuth. User logged in: TMDDBA t Verbose: 1220 : 11|15:46:19.3197|02zoVe|TMDDBA|imfx v3 API took 0.015s '/api/settings/user/videoPlayerSettings?_dc=1695912379050' t Transfer: 1220 : 11|15:46:19.3197|v07GHo|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:19.3197|v07GHo|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:19.3197|v07GHo|TMDDBA| user TMDDBA. t Transfer: 1220 : 11|15:46:19.3197|v07GHo|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:19.3197|v07GHo|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:19.3197|v07GHo|TMDDBA| user TMDDBA. t Transfer: 1220 : 11|15:46:19.3197|TXo81_|TMDDBA|OAuth: /api/v3/versionvideo/299543?_dc=1695912379055 t Transfer: 1220 : 11|15:46:19.3197|TXo81_|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:19.3197|TXo81_|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:19.3197|TXo81_|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:46:19.3197|TXo81_|TMDDBA|OAuth. User logged in: TMDDBA t Information: 1220 : 11|15:46:19.3197|BF4FnH|TMDDBA|SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v) m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2 where item_type>0 and rl_deleted=0 and m.ID = :param_0 AND (INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0 OR INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|OUT|')>0 OR INSTR(m.OWNERS,'|SKY|')>0 OR INSTR(m.OWNERS,'|SKYHORSE|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|BTS|')>0 OR INSTR(m.OWNERS,'|SKYDART|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|SKYRUGUN|')>0 OR INSTR(m.OWNERS,'|SKYGOLF|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>0 OR INSTR(m.OWNERS,'|SKYFOOT|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|BT|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|TVONE|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|VIVA|')>0 OR INSTR(m.OWNERS,'|ANTV|')>0 OR INSTR(m.OWNERS,'|SKYCRI|')>0) order by m.title,m.id) a where rownum <= 50) r where rnum >=1 order by rnum t Transfer: 1220 : 11|15:46:19.3197|TXo81_|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:19.3197|TXo81_|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:19.3197|TXo81_|TMDDBA| user TMDDBA. t Transfer: 1220 : 11|15:46:19.3197|TXo81_|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:19.3197|TXo81_|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:19.3197|TXo81_|TMDDBA| user TMDDBA. t Information: 1220 : 11|15:46:19.3197|TXo81_|TMDDBA|SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v) m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2 where item_type>0 and rl_deleted=0 and m.ID = :param_0 AND (INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0 OR INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|OUT|')>0 OR INSTR(m.OWNERS,'|SKY|')>0 OR INSTR(m.OWNERS,'|SKYHORSE|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|BTS|')>0 OR INSTR(m.OWNERS,'|SKYDART|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|SKYRUGUN|')>0 OR INSTR(m.OWNERS,'|SKYGOLF|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>0 OR INSTR(m.OWNERS,'|SKYFOOT|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|BT|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|TVONE|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|VIVA|')>0 OR INSTR(m.OWNERS,'|ANTV|')>0 OR INSTR(m.OWNERS,'|SKYCRI|')>0) order by m.title,m.id) a where rownum <= 50) r where rnum >=1 order by rnum t Information: 1220 : 11|15:46:19.3197|v07GHo|TMDDBA|SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v) m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2 where item_type>0 and rl_deleted=0 and m.ID = :param_0 AND (INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0 OR INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|OUT|')>0 OR INSTR(m.OWNERS,'|SKY|')>0 OR INSTR(m.OWNERS,'|SKYHORSE|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|BTS|')>0 OR INSTR(m.OWNERS,'|SKYDART|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|SKYRUGUN|')>0 OR INSTR(m.OWNERS,'|SKYGOLF|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>0 OR INSTR(m.OWNERS,'|SKYFOOT|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|BT|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|TVONE|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|VIVA|')>0 OR INSTR(m.OWNERS,'|ANTV|')>0 OR INSTR(m.OWNERS,'|SKYCRI|')>0) order by m.title,m.id) a where rownum <= 50) r where rnum >=1 order by rnum t Information: 1220 : 11|15:46:19.7416|BF4FnH|TMDDBA|Running version search. User: 1 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 76ms. Returned lines: 1 Oracle version search timing: 248ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v) m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2 where item_type>0 and rl_deleted=0 and m.ID = :param_0 AND (INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0 OR INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|OUT|')>0 OR INSTR(m.OWNERS,'|SKY|')>0 OR INSTR(m.OWNERS,'|SKYHORSE|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|BTS|')>0 OR INSTR(m.OWNERS,'|SKYDART|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|SKYRUGUN|')>0 OR INSTR(m.OWNERS,'|SKYGOLF|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>0 OR INSTR(m.OWNERS,'|SKYFOOT|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|BT|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|TVONE|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|VIVA|')>0 OR INSTR(m.OWNERS,'|ANTV|')>0 OR INSTR(m.OWNERS,'|SKYCRI|')>0) order by m.title,m.id) a where rownum <= 50) r where rnum >=1 order by rnum t Information: 1220 : 11|15:46:19.7416|v07GHo|TMDDBA|Running version search. User: 1 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 66ms. Returned lines: 1 Oracle version search timing: 247ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v) m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2 where item_type>0 and rl_deleted=0 and m.ID = :param_0 AND (INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0 OR INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|OUT|')>0 OR INSTR(m.OWNERS,'|SKY|')>0 OR INSTR(m.OWNERS,'|SKYHORSE|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|BTS|')>0 OR INSTR(m.OWNERS,'|SKYDART|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|SKYRUGUN|')>0 OR INSTR(m.OWNERS,'|SKYGOLF|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>0 OR INSTR(m.OWNERS,'|SKYFOOT|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|BT|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|TVONE|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|VIVA|')>0 OR INSTR(m.OWNERS,'|ANTV|')>0 OR INSTR(m.OWNERS,'|SKYCRI|')>0) order by m.title,m.id) a where rownum <= 50) r where rnum >=1 order by rnum t Information: 1220 : 11|15:46:19.7416|TXo81_|TMDDBA|Running version search. User: 1 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 66ms. Returned lines: 1 Oracle version search timing: 247ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v) m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2 where item_type>0 and rl_deleted=0 and m.ID = :param_0 AND (INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0 OR INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|OUT|')>0 OR INSTR(m.OWNERS,'|SKY|')>0 OR INSTR(m.OWNERS,'|SKYHORSE|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|BTS|')>0 OR INSTR(m.OWNERS,'|SKYDART|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|SKYRUGUN|')>0 OR INSTR(m.OWNERS,'|SKYGOLF|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>0 OR INSTR(m.OWNERS,'|SKYFOOT|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|BT|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|TVONE|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|VIVA|')>0 OR INSTR(m.OWNERS,'|ANTV|')>0 OR INSTR(m.OWNERS,'|SKYCRI|')>0) order by m.title,m.id) a where rownum <= 50) r where rnum >=1 order by rnum t Transfer: 1220 : 11|15:46:19.9460|TXo81_|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 11|15:46:19.9460|TXo81_|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 11|15:46:19.9460|TXo81_|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 11|15:46:19.9460|v07GHo|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 11|15:46:19.9460|v07GHo|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 11|15:46:19.9460|v07GHo|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 11|15:46:19.9460|BF4FnH|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 11|15:46:19.9460|BF4FnH|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 11|15:46:19.9460|BF4FnH|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 11|15:46:19.9460|TXo81_|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:19.9460|v07GHo|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:19.9460|v07GHo|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:19.9460|TXo81_|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:19.9460|TXo81_|TMDDBA| user TMDDBA. t Transfer: 1220 : 11|15:46:19.9460|v07GHo|TMDDBA| user TMDDBA. t Transfer: 1220 : 11|15:46:19.9460|BF4FnH|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:19.9460|BF4FnH|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:19.9460|BF4FnH|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:46:19.9460|BF4FnH|TMDDBA|imfx v3 API took 0.729s '/api/v3/versionvideo/299543?_dc=1695912378993' t Verbose: 1220 : 11|15:46:19.9460|v07GHo|TMDDBA|imfx v3 API took 0.621s '/api/v3/versionvideo/299543?_dc=1695912379054' t Verbose: 1220 : 11|15:46:19.9460|TXo81_|TMDDBA|imfx v3 API took 0.605s '/api/v3/versionvideo/299543?_dc=1695912379055' t Transfer: 1220 : 11|15:46:20.1504|FvvkBp|TMDDBA|OAuth: /api/v3/versionvideo/299543?_dc=1695912378993 t Transfer: 1220 : 11|15:46:20.1504|FvvkBp|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:20.1504|FvvkBp|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:20.1504|FvvkBp|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:46:20.1504|FvvkBp|TMDDBA|OAuth. User logged in: TMDDBA t Transfer: 1220 : 11|15:46:20.1504|FvvkBp|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:20.1504|FvvkBp|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:20.1504|FvvkBp|TMDDBA| user TMDDBA. t Transfer: 1220 : 11|15:46:20.1504|FvvkBp|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:20.1504|FvvkBp|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:20.1504|FvvkBp|TMDDBA| user TMDDBA. t Information: 1220 : 11|15:46:20.1504|FvvkBp|TMDDBA|SearchVersion SQL: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v) m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2 where item_type>0 and rl_deleted=0 and m.ID = :param_0 AND (INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0 OR INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|OUT|')>0 OR INSTR(m.OWNERS,'|SKY|')>0 OR INSTR(m.OWNERS,'|SKYHORSE|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|BTS|')>0 OR INSTR(m.OWNERS,'|SKYDART|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|SKYRUGUN|')>0 OR INSTR(m.OWNERS,'|SKYGOLF|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>0 OR INSTR(m.OWNERS,'|SKYFOOT|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|BT|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|TVONE|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|VIVA|')>0 OR INSTR(m.OWNERS,'|ANTV|')>0 OR INSTR(m.OWNERS,'|SKYCRI|')>0) order by m.title,m.id) a where rownum <= 50) r where rnum >=1 order by rnum t Information: 1220 : 11|15:46:20.1504|FvvkBp|TMDDBA|Running version search. User: 1 Simple Search: Running Oracle search. Running Oracle search for COUNT Oracle count completed in: 2ms. Returned lines: 1 Oracle version search timing: 4ms. SQL run: select * from (select a.*, rownum rnum from ( select m.*, nvl(t.text_data_path,'') THUMBSERVER, nvl(t.text_data_filename,'') THUMBFILE, nvl(t.text_id,-1) THUMBID, BUILD_PGRL_FULLTITLE(item_type, title, ser_name, ser_title) FULLTITLE , (select cvt.ID from TM_PORTAL_VERSION_CONFIG cvt where m.CUSTOM_VERSION_TYPE = cvt.CUSTOM_VERSION_TYPE AND cvt.CUSTOM_VERSION_TYPE IS NOT NULL ) MP_CONFIG_ID from (select v.*, coalesce(v.primary_thumb_id, (select x.primary_thumb_id from tm_pg_rl x where x.id=v.parent_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.pgm_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs_id), (select t.primary_thumb_id from tm_pg_abs t where t.id=v.ser_abs2_id) ) primary_thumb_id2 from tmddba.tm_pg_rl v) m left outer join (select text_id, text_data_path, text_data_filename, text_ref_object from tmddba.tm_text) t on t.text_id = m.primary_thumb_id2 where item_type>0 and rl_deleted=0 and m.ID = :param_0 AND (INSTR(m.OWNERS,'|VNC|')>0 OR INSTR(m.OWNERS,'|TV3N|')>0 OR INSTR(m.OWNERS,'|TV1E|')>0 OR INSTR(m.OWNERS,'|T3LV|')>0 OR INSTR(m.OWNERS,'|RTR|')>0 OR INSTR(m.OWNERS,'|NVA|')>0 OR INSTR(m.OWNERS,'|LNT|')>0 OR INSTR(m.OWNERS,'|HDC1|')>0 OR INSTR(m.OWNERS,'|DAVI|')>0 OR INSTR(m.OWNERS,'|03SS|')>0 OR INSTR(m.OWNERS,'|03SN|')>0 OR INSTR(m.OWNERS,'|03SK|')>0 OR INSTR(m.OWNERS,'|03LI|')>0 OR INSTR(m.OWNERS,'|MBNS|')>0 OR INSTR(m.OWNERS,'|ATP|')>0 OR INSTR(m.OWNERS,'|ICCU19CWC|')>0 OR INSTR(m.OWNERS,'|PPL|')>0 OR INSTR(m.OWNERS,'|SPG|')>0 OR INSTR(m.OWNERS,'|TMD|')>0 OR INSTR(m.OWNERS,'|ZTVS|')>0 OR INSTR(m.OWNERS,'|VSHD|')>0 OR INSTR(m.OWNERS,'|VSE|')>0 OR INSTR(m.OWNERS,'|VSD|')>0 OR INSTR(m.OWNERS,'|VS3|')>0 OR INSTR(m.OWNERS,'|VODE|')>0 OR INSTR(m.OWNERS,'|VNPO|')>0 OR INSTR(m.OWNERS,'|VEPO|')>0 OR INSTR(m.OWNERS,'|V3H|')>0 OR INSTR(m.OWNERS,'|TVSL|')>0 OR INSTR(m.OWNERS,'|TV6H|')>0 OR INSTR(m.OWNERS,'|TV2S|')>0 OR INSTR(m.OWNERS,'|TV1P|')>0 OR INSTR(m.OWNERS,'|HDP1|')>0 OR INSTR(m.OWNERS,'|CTCE|')>0 OR INSTR(m.OWNERS,'|3PLV|')>0 OR INSTR(m.OWNERS,'|3PD|')>0 OR INSTR(m.OWNERS,'|3+ES|')>0 OR INSTR(m.OWNERS,'|03SC|')>0 OR INSTR(m.OWNERS,'|03OR|')>0 OR INSTR(m.OWNERS,'|03NB|')>0 OR INSTR(m.OWNERS,'|EST|')>0 OR INSTR(m.OWNERS,'|EUROSPORT|')>0 OR INSTR(m.OWNERS,'|YLE TV1|')>0 OR INSTR(m.OWNERS,'|LMH|')>0 OR INSTR(m.OWNERS,'|ICCWCL|')>0 OR INSTR(m.OWNERS,'|PSP|')>0 OR INSTR(m.OWNERS,'|OUT|')>0 OR INSTR(m.OWNERS,'|SKY|')>0 OR INSTR(m.OWNERS,'|SKYHORSE|')>0 OR INSTR(m.OWNERS,'|VSS|')>0 OR INSTR(m.OWNERS,'|HUB|')>0 OR INSTR(m.OWNERS,'|TV6E|')>0 OR INSTR(m.OWNERS,'|TV3S|')>0 OR INSTR(m.OWNERS,'|MM|')>0 OR INSTR(m.OWNERS,'|03VT|')>0 OR INSTR(m.OWNERS,'|03SB|')>0 OR INSTR(m.OWNERS,'|ICCWCCL|')>0 OR INSTR(m.OWNERS,'|BTS|')>0 OR INSTR(m.OWNERS,'|SKYDART|')>0 OR INSTR(m.OWNERS,'|VSAT|')>0 OR INSTR(m.OWNERS,'|VHPO|')>0 OR INSTR(m.OWNERS,'|V1G|')>0 OR INSTR(m.OWNERS,'|T6LV|')>0 OR INSTR(m.OWNERS,'|T6LT|')>0 OR INSTR(m.OWNERS,'|03GO|')>0 OR INSTR(m.OWNERS,'|ICCWWC|')>0 OR INSTR(m.OWNERS,'|ICCCWL2|')>0 OR INSTR(m.OWNERS,'|BBC|')>0 OR INSTR(m.OWNERS,'|PMH|')>0 OR INSTR(m.OWNERS,'|SKYRUGUN|')>0 OR INSTR(m.OWNERS,'|SKYGOLF|')>0 OR INSTR(m.OWNERS,'|MED|')>0 OR INSTR(m.OWNERS,'|VSG|')>0 OR INSTR(m.OWNERS,'|VODS|')>0 OR INSTR(m.OWNERS,'|VODD|')>0 OR INSTR(m.OWNERS,'|VHIS|')>0 OR INSTR(m.OWNERS,'|V4N|')>0 OR INSTR(m.OWNERS,'|TVPU|')>0 OR INSTR(m.OWNERS,'|TV8|')>0 OR INSTR(m.OWNERS,'|TV6S|')>0 OR INSTR(m.OWNERS,'|TV6N|')>0 OR INSTR(m.OWNERS,'|TV1N|')>0 OR INSTR(m.OWNERS,'|TV1K|')>0 OR INSTR(m.OWNERS,'|TV1C|')>0 OR INSTR(m.OWNERS,'|NICK|')>0 OR INSTR(m.OWNERS,'|DMY|')>0 OR INSTR(m.OWNERS,'|DMF|')>0 OR INSTR(m.OWNERS,'|CTCB|')>0 OR INSTR(m.OWNERS,'|CS|')>0 OR INSTR(m.OWNERS,'|03VL|')>0 OR INSTR(m.OWNERS,'|03UP|')>0 OR INSTR(m.OWNERS,'|03SY|')>0 OR INSTR(m.OWNERS,'|03SG|')>0 OR INSTR(m.OWNERS,'|03JO|')>0 OR INSTR(m.OWNERS,'|03HA|')>0 OR INSTR(m.OWNERS,'|TV10|')>0 OR INSTR(m.OWNERS,'|ICCWTC|')>0 OR INSTR(m.OWNERS,'|PMS|')>0 OR INSTR(m.OWNERS,'|ITV|')>0 OR INSTR(m.OWNERS,'|VODN|')>0 OR INSTR(m.OWNERS,'|VNHD|')>0 OR INSTR(m.OWNERS,'|VNH|')>0 OR INSTR(m.OWNERS,'|VEXE|')>0 OR INSTR(m.OWNERS,'|VEPL|')>0 OR INSTR(m.OWNERS,'|TV1S|')>0 OR INSTR(m.OWNERS,'|AMC|')>0 OR INSTR(m.OWNERS,'|TV1F|')>0 OR INSTR(m.OWNERS,'|T8LT|')>0 OR INSTR(m.OWNERS,'|Play|')>0 OR INSTR(m.OWNERS,'|KNL2|')>0 OR INSTR(m.OWNERS,'|DMA|')>0 OR INSTR(m.OWNERS,'|03VB|')>0 OR INSTR(m.OWNERS,'|03NO|')>0 OR INSTR(m.OWNERS,'|OSP|')>0 OR INSTR(m.OWNERS,'|NAA|')>0 OR INSTR(m.OWNERS,'|ICCCTY|')>0 OR INSTR(m.OWNERS,'|ICCICC|')>0 OR INSTR(m.OWNERS,'|BEDIG|')>0 OR INSTR(m.OWNERS,'|SKYFOOT|')>0 OR INSTR(m.OWNERS,'|SFP1|')>0 OR INSTR(m.OWNERS,'|VSD2|')>0 OR INSTR(m.OWNERS,'|VNE|')>0 OR INSTR(m.OWNERS,'|VEXR|')>0 OR INSTR(m.OWNERS,'|VEC|')>0 OR INSTR(m.OWNERS,'|TVDP|')>0 OR INSTR(m.OWNERS,'|TVAE|')>0 OR INSTR(m.OWNERS,'|03SM|')>0 OR INSTR(m.OWNERS,'|TV1B|')>0 OR INSTR(m.OWNERS,'|TV1A|')>0 OR INSTR(m.OWNERS,'|PBOY|')>0 OR INSTR(m.OWNERS,'|HDP2|')>0 OR INSTR(m.OWNERS,'|DTV|')>0 OR INSTR(m.OWNERS,'|03VA|')>0 OR INSTR(m.OWNERS,'|TV3D|')>0 OR INSTR(m.OWNERS,'|AECSD|')>0 OR INSTR(m.OWNERS,'|ICCWCP|')>0 OR INSTR(m.OWNERS,'|ICCTWT|')>0 OR INSTR(m.OWNERS,'|BT|')>0 OR INSTR(m.OWNERS,'|SFP2|')>0 OR INSTR(m.OWNERS,'|VS2|')>0 OR INSTR(m.OWNERS,'|VODF|')>0 OR INSTR(m.OWNERS,'|V1TZ|')>0 OR INSTR(m.OWNERS,'|TVPB|')>0 OR INSTR(m.OWNERS,'|TV5L|')>0 OR INSTR(m.OWNERS,'|TV1D|')>0 OR INSTR(m.OWNERS,'|T3LT|')>0 OR INSTR(m.OWNERS,'|SPTV|')>0 OR INSTR(m.OWNERS,'|KNVA|')>0 OR INSTR(m.OWNERS,'|CENT|')>0 OR INSTR(m.OWNERS,'|03SE|')>0 OR INSTR(m.OWNERS,'|03NM|')>0 OR INSTR(m.OWNERS,'|03GD|')>0 OR INSTR(m.OWNERS,'|03BO|')>0 OR INSTR(m.OWNERS,'|AECHD|')>0 OR INSTR(m.OWNERS,'|AMAY|')>0 OR INSTR(m.OWNERS,'|MTG|')>0 OR INSTR(m.OWNERS,'|AL|')>0 OR INSTR(m.OWNERS,'|TECHM|')>0 OR INSTR(m.OWNERS,'|WCIU|')>0 OR INSTR(m.OWNERS,'|ICCWTT|')>0 OR INSTR(m.OWNERS,'|TVONE|')>0 OR INSTR(m.OWNERS,'|ICCCWC|')>0 OR INSTR(m.OWNERS,'|VIVA|')>0 OR INSTR(m.OWNERS,'|ANTV|')>0 OR INSTR(m.OWNERS,'|SKYCRI|')>0) order by m.title,m.id) a where rownum <= 50) r where rnum >=1 order by rnum t Transfer: 1220 : 11|15:46:20.1504|FvvkBp|TMDDBA|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\GOPR0156.mp4 subfolder t Transfer: 1220 : 11|15:46:20.1504|FvvkBp|TMDDBA| GetFileName result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 11|15:46:20.1504|FvvkBp|TMDDBA|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/GOPR0156.mp4 t Transfer: 1220 : 11|15:46:20.1504|FvvkBp|TMDDBA|GetCurrentUser.. t Transfer: 1220 : 11|15:46:20.1504|FvvkBp|TMDDBA| OAuth authenticated t Transfer: 1220 : 11|15:46:20.1504|FvvkBp|TMDDBA| user TMDDBA. t Verbose: 1220 : 11|15:46:20.1504|FvvkBp|TMDDBA|imfx v3 API took 0.022s '/api/v3/versionvideo/299543?_dc=1695912378993'