t Information: 1220 :  12|11:06:09.8141|||Get Configuration Values:
t Information: 1220 :  12|11:06:09.8151|||	AdminPassEnc, default: , value: ffqjrn0leKv4Lj2YJHe2dw==.
t Information: 1220 :  12|11:06:09.8161|||	EncryptedPasswords, default: false, value: true.
t Information: 1220 :  12|11:06:09.8161|||	OraConnectionString, default: , value: Server=TECHM;User Id=imfx;Password=xxxxx;Unicode=true;.
t Information: 1220 :  12|11:06:09.8161|||	SecondTimezone, default: , value: .
t Information: 1220 :  12|11:06:09.8161|||	UseActiveDirectoryAuth, default: false, value: false.
t Information: 1220 :  12|11:06:09.8161|||	ReportingServiceUrl, default: , value: http://localhost:92/ReportingService.svc.
t Information: 1220 :  12|11:06:09.8181|||	ReportsPath, default: , value: .
t Information: 1220 :  12|11:06:09.8181|||	ReportsURL, default: , value: .
t Information: 1220 :  12|11:06:09.8181|||	TapeServiceUrl, default: , value: .
t Information: 1220 :  12|11:06:09.8191|||	GatekeeperUrl, default: , value: .
t Information: 1220 :  12|11:06:09.8191|||	ValuationUrl, default: , value: .
t Information: 1220 :  12|11:06:09.8191|||	QueueManagerDelay, default: 30, value: 30.
t Information: 1220 :  12|11:06:09.8191|||	QueueManagerFullRefresh, default: 90, value: 90.
t Information: 1220 :  12|11:06:09.8191|||	AudioLoopDuration, default: 0, value: 150.
t Information: 1220 :  12|11:06:09.8191|||	AudioLoopsCount, default: 0, value: 0.
t Information: 1220 :  12|11:06:09.8191|||	PlayerFakeStep, default: 500, value: 500.
t Information: 1220 :  12|11:06:09.8201|||	PlayerForceRatio, default: 0, value: 1.
t Information: 1220 :  12|11:06:09.8201|||	CheckVersionsInProd, default: false, value: True.
t Information: 1220 :  12|11:06:09.8201|||	MaxResults, default: 3000, value: 10000.
t Information: 1220 :  12|11:06:09.8201|||	TEReportID, default: 0, value: 0.
t Information: 1220 :  12|11:06:09.8211|||	ClosedCaptionsCache, default: , value: C:\inetpub\wwwroot\imfxcore\timedtextcache\.
t Information: 1220 :  12|11:06:09.8211|||	ClosedCaptionsStorage, default: , value: c:\Mediaflex\subs.
t Information: 1220 :  12|11:06:09.8211|||	TimeCodeFormat, default: , value: pal.
t Information: 1220 :  12|11:06:09.8211|||	RceMediaPath, default: , value: C:\edl\.
t Information: 1220 :  12|11:06:09.8211|||	RceMediaPath, default: , value: C:\edl\.
t Information: 1220 :  12|11:06:09.8221|||	RceCsmOutputPath, default: , value: C:\Inetpub\wwwroot\csm\.
t Information: 1220 :  12|11:06:09.8221|||	RceCsmUrl, default: , value: http://localhost/csm/.
t Information: 1220 :  12|11:06:09.8221|||	RceMediaSelection, default: , value: miLinkIdMatch.
t Information: 1220 :  12|11:06:09.8221|||	RequestBrowseJobPresetName, default: , value: .
t Information: 1220 :  12|11:06:09.8221|||	DontExtendDuration, default: false, value: False.
t Information: 1220 :  12|11:06:09.8221|||	V3ConfigUrl, default: , value: .
t Information: 1220 :  12|11:06:09.8221|||	StopWords, default: , value: .
t Information: 1220 :  12|11:06:09.8231|||	MisrTxFormat, default: G, value: G.
t Information: 1220 :  12|11:06:09.8231|||	ApiServer, default: , value: http://192.168.120.10:85.
t Information: 1220 :  12|11:06:09.8231|||	ApiTimeout, default: 120, value: 120.
t Information: 1220 :  12|11:06:09.8231|||	ApiWorkers, default: 10, value: 10.
t Information: 1220 :  12|11:06:09.8231|||	UsePerfCounters, default: false, value: false.
t Information: 1220 :  12|11:06:09.8231|||	LogGetCurrentUser, default: true, value: true.
t Information: 1220 :  12|11:06:09.8231|||	LogInternalApi, default: true, value: true.
t Information: 1220 :  12|11:06:09.8241|||	LivePlayApiUrl, default: , value: .
t Information: 1220 :  12|11:06:09.8241|||	LivePlayApiTimeout, default: 120, value: 120.
t Information: 1220 :  12|11:06:09.8241|||	ThumbnailServer, default: , value: .
t Information: 1220 :  12|11:06:09.8241|||	PasswordResetEmailTemplateId, default: 0, value: 0.
t Information: 1220 :  12|11:06:09.8241|||	PasswordResetEmailTemplateId_MediaPortal, default: 0, value: 0.
t Information: 1220 :  12|11:06:09.8241|||	imfxBaseUrl, default: , value: .
t Information: 1220 :  12|11:06:09.8241|||	imfxBaseUrl_MediaPortal, default: , value: .
t Information: 1220 :  12|11:06:09.8251|||	imfxBaseUrl_VideoBrowser, default: , value: .
t Information: 1220 :  12|11:06:09.8251|||	ShowDetailedErrors, default: false, value: false.
t Information: 1220 :  12|11:06:09.8251|||	AllowXmlRequests, default: false, value: false.
t Information: 1220 :  12|11:06:09.8251|||	MaxLoginAttempts, default: 3, value: 3.
t Information: 1220 :  12|11:06:09.8251|||	MaxLoginAttemptsPeriod, default: 15, value: 15.
t Information: 1220 :  12|11:06:09.8251|||	LocationFilter, default: , value: .
t Information: 1220 :  12|11:06:09.8261|||	SvUtilServiceUrl, default: , value: .
t Information: 1220 :  12|11:06:09.8261|||	SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 :  12|11:06:09.8261|||	UseIndexServerSearch, default: false, value: True.
t Information: 1220 :  12|11:06:09.8261|||	SolrIndexVersion, default: 1, value: 6.
t Information: 1220 :  12|11:06:09.8261|||	SolrConnection, default: , value: http://192.168.120.14:8983/solr.
t Information: 1220 :  12|11:06:09.8261|||	FacetsGroups, default: , value: owners,season_id, series_id,version_key,item_type,media_type,media_format,episode_number.
t Information: 1220 :  12|11:06:09.8271|||	FacetsGroupsVersion, default: , value: owners,season_id, series_id,version_key,episode_number.
t Information: 1220 :  12|11:06:09.8271|||	FacetsGroupsChameleon, default: , value: season_id, series_id,genre,prod_year,version_key.
t Information: 1220 :  12|11:06:09.8271|||	PreviewPreset, default: , value: .
t Information: 1220 :  12|11:06:09.8271|||	DevMode, default: false, value: false.
t Information: 1220 :  12|11:06:09.8271|||	DisableSysMan, default: false, value: false.
t Information: 1220 :  12|11:06:09.8281|||	TimeCodeFormat, default: , value: pal.
t Information: 1220 :  12|11:06:09.8281|||	FileCatalystStorageDevice, default: , value: .
t Information: 1220 :  12|11:06:09.8281|||	UseResponsibilityTracking, default: true, value: True.
t Information: 1220 :  12|11:06:09.8281|||	SubtitleDeviceFilter, default: , value: .
t Information: 1220 :  12|11:06:09.8281|||	SystemMonitorNamedPipe, default: , value: .
t Information: 1220 :  12|11:06:09.8281|||	OracleMonitorEnable, default: false, value: False.
t Information: 1220 :  12|11:06:09.8281|||	ArcApiHost, default: , value: .
t Information: 1220 :  12|11:06:09.8291|||	SolrTimedTextSearch, default: false, value: false.
t Information: 1220 :  12|11:06:09.8291|||	ProductionDurationUsageID, default: 1, value: 1.
t Information: 1220 :  12|11:06:09.8291|||	MediaFacetOrder, default: ResultCountAsc, value: ResultCountAsc.
t Information: 1220 :  12|11:06:09.8291|||	VersionFacetOrder, default: ResultCountAsc, value: ResultCountAsc.
t Information: 1220 :  12|11:06:10.2311|||GetStreamServers..
t Information: 1220 :  12|11:06:10.8341|||	https://demo.tmd.tv/CBR Video/ |CBR Video| False  
t Information: 1220 :  12|11:06:10.8351|||	https://demo.tmd.tv/CBR Images/ |CBR Images| False  
t Information: 1220 :  12|11:06:10.8351|||	https://demo.tmd.tv/CBR Audio/ |CBR Audio| False  
t Information: 1220 :  12|11:06:10.8351|||	https://demo.tmd.tv/Temp Upload/ |TEMP_UPLOAD| False  
t Information: 1220 :  12|11:06:10.8351|||	http://localhost:82/images/ |IMAGES| False  
t Information: 1220 :  12|11:06:10.8351|||	http://192.168.91.73/smoothcloud/ |SMOOTH_CLOUD| False  
t Information: 1220 :  12|11:06:10.8351|||	http://192.168.91.73/cloudstore/ |CLOUD_STORE| False  
t Information: 1220 :  12|11:06:10.8351|||	http://192.168.91.73/editsystemin/ |EDIT_SYSTEM_IN| False  
t Information: 1220 :  12|11:06:10.8361|||	http://192.168.91.27:89/APPLEPROXY/ |APPLE_PROXY| False  
t Information: 1220 :  12|11:06:10.8361|||	http://localhost:82/video/ |FILESTORE_VIDEO| False  
t Information: 1220 :  12|11:06:10.8361|||	https://imfxv3tm.tmd.tv/streaming/ |Streaming| False  
t Information: 1220 :  12|11:06:10.8361|||	https://imfxv3tm.tmd.tv/VideoServer/ |Video| False  
t Information: 1220 :  12|11:06:10.8361|||	https://imfxv3tm.tmd.tv/Proxy/ |Proxy| False  
t Information: 1220 :  12|11:06:10.8361|||	https://imfxv3tm.tmd.tv/AdobeIn/ |Adobe Premiere Pro In| False  
t Information: 1220 :  12|11:06:10.8371|||	https://imfxv3tm.tmd.tv/AudioServer/ |Audio| False  
t Information: 1220 :  12|11:06:10.8371|||	https://imfxv3tm.tmd.tv/ImageServer/ |Image| False  
t Information: 1220 :  12|11:06:10.8371|||	https://imfxv3tm.tmd.tv/DocsServer/ |Docs| False  
t Information: 1220 :  12|11:06:10.8371|||	https://imfxv3tm.tmd.tv/AmazonLabs/ |TEST HOUSE| False  
t Information: 1220 :  12|11:06:10.8371|||	SolrConnectionUms, default: http://192.168.120.14:8983/solr, value: http://192.168.120.14:8983/solr.
t Information: 1220 :  12|11:06:10.8371|||	LogWebApi, default: false, value: false.
t Information: 1220 :  12|11:06:10.8371|||	EmbeddedRceUrl, default: , value: .
t Information: 1220 :  12|11:06:10.8381|||	InstallMode, default: , value: .
t Information: 1220 :  12|11:06:10.8381|||	SamlRequestAddress, default: , value: .
t Information: 1220 :  12|11:06:10.8381|||	SamlTrustedIssuer, default: , value: .
t Information: 1220 :  12|11:06:10.8381|||	SamlLoginRedirect, default: , value: .
t Information: 1220 :  12|11:06:10.8381|||	NaturalLangSearch, default: false, value: True.
t Information: 1220 :  12|11:06:10.8381|||	LocalUploadExpirationHours, default: 0, value: 0.
t Information: 1220 :  12|11:06:10.8381|||	LocalUploadDeviceId, default: 0, value: 0.
t Information: 1220 :  12|11:06:10.8381|||	VideosFileFormatIds, default: , value: .
t Information: 1220 :  12|11:06:10.8390|||	VideosStorageIds, default: , value: .
t Information: 1220 :  12|11:06:10.8390|||	OktaLoginField, default: , value: .
t Information: 1220 :  12|11:06:10.8390|||	AuthenticationTypes, default: , value: Native,PublicApiKey.
t Information: 1220 :  12|11:06:10.8390|||OrabitWatcherBasic. Initialize.
t Information: 1220 :  12|11:06:10.8390|||FillDictionaryCache.
t Information: 1220 :  12|11:06:15.8709|||OrabitWatcherBasic trying to connect..
t Information: 1220 :  12|11:06:16.0729|||OrabitWatcherBasic connected.
t Information: 1220 :  12|11:06:16.0729|||OrabitWatcherBasic queue created tmd.cfg.in.3124d46b-5955-4304-bc2d-a3d0adc1b9bd
t Information: 1220 :  12|11:06:17.1458|||GetSupportedOperators
t Information: 1220 :  12|11:06:17.5558|||CacheTechReports.
t Information: 1220 :  12|11:06:17.5568|||& Cache update. Server (global) filled with timestamp 11:10:17.5098906. types null
t Information: 1220 :  12|11:06:17.7819|||InitializeFromDatabase.
  'Server=TECHM;User Id=imfx;password=..;Unicode=true;'
  direct False, home , timeout 15
t Information: 1220 :  12|11:06:17.7829|||FillDictionaryCache.
t Information: 1220 :  12|11:06:17.7829|||& Cache update. Server (global) filled with timestamp 11:10:17.6518985. types FriendlyNames, DatabaseSearchFieldData
t Information: 1220 :  12|11:06:18.5908|||==========================================================================
t Information: 1220 :  12|11:06:18.5908|||IMFX CORE SERVER APPLICATION START.
t Information: 1220 :  12|11:06:18.5908|||DLL VERSION: 3.0.0.970.
t Information: 1220 :  12|11:06:18.5908|||IS TIMER HIGH RESOLUTION : True.
t Information: 1220 :  12|11:06:18.5908|||	UmsDev, default: False, value: False.
t Transfer: 1220 :     12|15:13:50.6234|W_WtRc|DANIEL|OAuth: /api/v3/search/Media?_dc=1666275231235
t Transfer: 1220 :     12|15:13:50.6234|T3IYfM|DANIEL|OAuth: /api/v3/media-captions/299691?_dc=1666275231252
t Transfer: 1220 :     12|15:13:50.6234|0CgvN2|DANIEL|OAuth: /api/v3/mediavideo/299691?info=smudge&_dc=1666275231566
t Transfer: 1220 :     12|15:13:50.6244|W_WtRc|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:13:50.6244|T3IYfM|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:13:50.6244|W_WtRc|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:13:50.6244|T3IYfM|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:13:50.6244|T3IYfM|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|15:13:50.6244|W_WtRc|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:13:50.6254|W_WtRc|DANIEL|OAuth. User logged in: DANIEL
t Verbose: 1220 :      12|15:13:50.6254|T3IYfM|DANIEL|OAuth. User logged in: DANIEL
t Transfer: 1220 :     12|15:13:50.6254|0CgvN2|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:13:50.6254|0CgvN2|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:13:50.6254|0CgvN2|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:13:50.6254|0CgvN2|DANIEL|OAuth. User logged in: DANIEL
t Information: 1220 :  12|15:13:50.6254|frMxiB|DANIEL|V3Api.GetMediaTagging
t Verbose: 1220 :      12|15:13:50.8274|T3IYfM|DANIEL|imfx v3 API took 0.130s '/api/v3/media-captions/299691?_dc=1666275231252'
t Transfer: 1220 :     12|15:13:51.0284|0CgvN2|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001992.mp4 subfolder 
t Transfer: 1220 :     12|15:13:51.0284|0CgvN2|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4
t Transfer: 1220 :     12|15:13:51.0284|0CgvN2|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4
t Transfer: 1220 :     12|15:13:51.0284|0CgvN2|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:13:51.0284|0CgvN2|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:13:51.0284|0CgvN2|DANIEL|    user DANIEL.
t Verbose: 1220 :      12|15:13:51.0294|0CgvN2|DANIEL|imfx v3 API took 0.274s '/api/v3/mediavideo/299691?info=smudge&_dc=1666275231566'
t Information: 1220 :  12|15:13:51.0294|W_WtRc|DANIEL|V3Api.SearchMedia
t Information: 1220 :  12|15:13:51.0294|W_WtRc|DANIEL|V3Api.SearchGeneric
t Transfer: 1220 :     12|15:13:51.2304|W_WtRc|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:13:51.2304|W_WtRc|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:13:51.2304|W_WtRc|DANIEL|    user DANIEL.
t Information: 1220 :  12|15:13:51.2304|W_WtRc|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 tmd_str_agg_pipe(cms.status_type_id ||',' ||cms.status_id) from tm_mi_cust_med_stat_lnx cms where cms.media_id=r.id) "CustomStatusesRaw", 
    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   m.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 Verbose: 1220 :      12|15:13:51.2304|W_WtRc|DANIEL|Alternative title fields query: select * from (select x.id,x.pgm_abs_id TitleId, x.pgm_parent_id VersionId from tm_mis x where id in (select /*+ cardinality(4) */ column_value id from table(:ids))) y,lateral (select dbms_lob.substr( o.text_data_plain, 1000, 1 ) Field_5799344 from tm_txt_obj o 
                    where (o.pgm_abs_id=y.TitleId or o.pgm_rl_id = y.VersionId) and o.type_id=:param_1 
                    order by o.id desc fetch first 1 rows only)(+)
t Information: 1220 :  12|15:13:51.2314|W_WtRc|DANIEL|    timing: 00:00:00.1134958
t Verbose: 1220 :      12|15:13:51.2314|W_WtRc|DANIEL|imfx v3 API took 0.133s '/api/v3/search/Media?_dc=1666275231235'
t Transfer: 1220 :     12|15:13:51.4324|W_WtRc|DANIEL|GetUrl. Storage |Video| filename \\192.168.120.254\DemoFS\Digital Assets\Video\N0001992.mp4 subfolder 
t Transfer: 1220 :     12|15:13:51.4324|W_WtRc|DANIEL|  GetFileName result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4
t Transfer: 1220 :     12|15:13:51.4324|W_WtRc|DANIEL|GetUrl. result https://imfxv3tm.tmd.tv/VideoServer/N0001992.mp4
t Transfer: 1220 :     12|15:13:51.4324|W_WtRc|DANIEL|GetCurrentUser..
t Transfer: 1220 :     12|15:13:51.4324|W_WtRc|DANIEL|  OAuth authenticated
t Transfer: 1220 :     12|15:13:51.4324|W_WtRc|DANIEL|    user DANIEL.
t Transfer: 1220 :     12|17:14:30.5395|ZhTFCN||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey
t Verbose: 1220 :      12|17:14:30.5395|D9SGB8||imfx v3 API took 0.008s '/api/v3/visual-asset/group/null/2/image'
t Transfer: 1220 :     12|20:32:51.4172|Pi7iuh||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey
t Verbose: 1220 :      12|20:32:51.6182|80tMAI||imfx v3 API took 0.004s '/api/v3/visual-asset/group/null/2/image'
t Transfer: 1220 :     12|20:33:00.2612|w5mpsw||GetAppInfo. DB: TMDDEMO. Install mode: . Auth types: Native, PublicApiKey