Logout

Email Alert Preferences

My Xtract Portfolio

Email

inquiry@xtractresearch.com

Unsubscribe

* Indicates required field

Enter your email address below to review your settings.

Please ensure that the address you enter is the same as the address at which you receive Xtract emails. If you have multiple email addresses or aliases, you may need to change settings for each of them or contact us to see which we have on file.

Knowledge Base
Report Lists
Graveyard

Region Head Offices

North America/Latin America
1345 Avenue of the Americas
49th Floor
New York, NY 10105
United States
+1 212 574 7883
Europe
10 Queen Street Place
London EC4R 1BE
United Kingdom
+44 (0)20 3741 1311
Asia
Suite 1602-6, Grand Millennium Plaza
181 Queen's Road
Central
Hong Kong (China)
+852 3110 6513

Elapsed: 0.38
PHP: 43.24%
SQL: 56.76%
Queries: 25

Show Queries

SQL Queries

Order	Elapsed	Query
0	0.0008	SELECT `t0`.`sessionKey` AS `_sess_sessionKey`, `t0`.`userID` AS `_sess_userID`, `t0`.`expires` AS `_sess_expires`, `t0`.`value` AS `_sess_value`, `t0`.`lastSeen` AS `_sess_lastSeen`, `t0`.`firstSeen` AS `_sess_firstSeen`, `t0`.`userAgent` AS `_sess_userAgent`, `t0`.`fromIP` AS `_sess_fromIP`, `t2`.`Id` AS `_user_Id`, `t2`.`Clientid` AS `_user_Clientid`, `t2`.`UserName` AS `_user_UserName`, `t2`.`UserId` AS `_user_UserId`, `t2`.`Password` AS `_user_Password`, `t2`.`nameTitle` AS `_user_nameTitle`, `t2`.`nameFirst` AS `_user_nameFirst`, `t2`.`nameLast` AS `_user_nameLast`, `t2`.`nameSuffix` AS `_user_nameSuffix`, `t2`.`Address` AS `_user_Address`, `t2`.`address2` AS `_user_address2`, `t2`.`city` AS `_user_city`, `t2`.`state` AS `_user_state`, `t2`.`zip` AS `_user_zip`, `t2`.`country` AS `_user_country`, `t2`.`PhoneNo` AS `_user_PhoneNo`, `t2`.`Email` AS `_user_Email`, `t2`.`bloomEmail` AS `_user_bloomEmail`, `t2`.`userType` AS `_user_userType`, `t2`.`IPAddress` AS `_user_IPAddress`, `t2`.`AgreedDate` AS `_user_AgreedDate`, `t2`.`AgreedFromIP` AS `_user_AgreedFromIP`, `t2`.`AgreedFlag` AS `_user_AgreedFlag`, `t2`.`AgreedMD5` AS `_user_AgreedMD5`, `t2`.`LoginTime` AS `_user_LoginTime`, `t2`.`LoggedFlag` AS `_user_LoggedFlag`, `t2`.`sessionid` AS `_user_sessionid`, `t2`.`Privilege_Login` AS `_user_Privilege_Login`, `t2`.`LoginIP` AS `_user_LoginIP`, `t2`.`VisitCount` AS `_user_VisitCount`, `t2`.`adminPriv` AS `_user_adminPriv`, `t2`.`isGeneric` AS `_user_isGeneric`, `t2`.`noLogin` AS `_user_noLogin`, `t2`.`position` AS `_user_position`, `t2`.`userGroup` AS `_user_userGroup`, `t2`.`biography` AS `_user_biography`, `t2`.`forceNewPass` AS `_user_forceNewPass`, `t2`.`createdBy` AS `_user_createdBy`, `t2`.`createdDate` AS `_user_createdDate`, `t2`.`FaxNo` AS `_user_FaxNo`, `t2`.`industry` AS `_user_industry`, `t2`.`userSide` AS `_user_userSide`, `t2`.`isAttorney` AS `_user_isAttorney`, `t2`.`forumUserCode` AS `_user_forumUserCode`, `t2`.`forumXtractCode` AS `_user_forumXtractCode`, `t2`.`forumBan` AS `_user_forumBan`, `t2`.`hadTrial` AS `_user_hadTrial`, `t2`.`forumAgreedTime` AS `_user_forumAgreedTime`, `t2`.`forumAgreedFromIP` AS `_user_forumAgreedFromIP`, `t2`.`forumAgreedFlag` AS `_user_forumAgreedFlag`, `t2`.`updatedTime` AS `_user_updatedTime`, `t2`.`forumAllAlerts` AS `_user_forumAllAlerts`, `t2`.`isSalesLead` AS `_user_isSalesLead`, `t2`.`isCRM` AS `_user_isCRM`, `t2`.`cell` AS `_user_cell`, `t2`.`freeTrialTime` AS `_user_freeTrialTime`, `t2`.`sha1Pass` AS `_user_sha1Pass`, `t2`.`privDocDisclaim` AS `_user_privDocDisclaim`, `t2`.`euroUserID` AS `_user_euroUserID`, `t2`.`asiaUserID` AS `_user_asiaUserID`, `t2`.`tempPassLink` AS `_user_tempPassLink`, `t2`.`tempPassTime` AS `_user_tempPassTime`, `t2`.`isTempUser` AS `_user_isTempUser`, `t2`.`isTrained` AS `_user_isTrained`, `t2`.`primaryRole` AS `_user_primaryRole`, `t2`.`displayTz` AS `_user_displayTz`, `t2`.`debtwireId` AS `_user_debtwireId`, `t2`.`targetUi` AS `_user_targetUi`, `t2`.`twoFactor` AS `_user_twoFactor`, `t2`.`twoFactorTime` AS `_user_twoFactorTime`, `t2`.`u3id` AS `_user_u3id`, `t2`.`isNgDebtwire` AS `_user_isNgDebtwire`, `t4`.`Client_Id` AS `_client_Client_Id`, `t4`.`ClientName` AS `_client_ClientName`, `t4`.`Address` AS `_client_Address`, `t4`.`address2` AS `_client_address2`, `t4`.`city` AS `_client_city`, `t4`.`state` AS `_client_state`, `t4`.`zip` AS `_client_zip`, `t4`.`country` AS `_client_country`, `t4`.`Emailid` AS `_client_Emailid`, `t4`.`PhoneNo` AS `_client_PhoneNo`, `t4`.`fax` AS `_client_fax`, `t4`.`website` AS `_client_website`, `t4`.`description` AS `_client_description`, `t4`.`Interpretation` AS `_client_Interpretation`, `t4`.`docsInTA` AS `_client_docsInTA`, `t4`.`useSecurityPassword` AS `_client_useSecurityPassword`, `t4`.`QIB` AS `_client_QIB`, `t4`.`emailReminders` AS `_client_emailReminders`, `t4`.`startDate` AS `_client_startDate`, `t4`.`inceptionDate` AS `_client_inceptionDate`, `t4`.`principals` AS `_client_principals`, `t4`.`principalBios` AS `_client_principalBios`, `t4`.`demoOld` AS `_client_demoOld`, `t4`.`demoExpireDateOld` AS `_client_demoExpireDateOld`, `t4`.`demoAllowCov` AS `_client_demoAllowCov`, `t4`.`consulting` AS `_client_consulting`, `t4`.`consultingExpireDate` AS `_client_consultingExpireDate`, `t4`.`showSaveDoc` AS `_client_showSaveDoc`, `t4`.`showSupSum` AS `_client_showSupSum`, `t4`.`noResAlert` AS `_client_noResAlert`, `t4`.`createdDate` AS `_client_createdDate`, `t4`.`createdBy` AS `_client_createdBy`, `t4`.`overdue` AS `_client_overdue`, `t4`.`isPotential` AS `_client_isPotential`, `t4`.`gimme` AS `_client_gimme`, `t4`.`hasChargeTo` AS `_client_hasChargeTo`, `t4`.`singleAccess` AS `_client_singleAccess`, `t4`.`singleAccessHY` AS `_client_singleAccessHY`, `t4`.`singleAccessCA` AS `_client_singleAccessCA`, `t4`.`cipherKey` AS `_client_cipherKey`, `t4`.`iv` AS `_client_iv`, `t4`.`hasCreditFilter` AS `_client_hasCreditFilter`, `t4`.`hasHighYieldFilter` AS `_client_hasHighYieldFilter`, `t4`.`hasLegalXtract` AS `_client_hasLegalXtract`, `t4`.`lawfirm` AS `_client_lawfirm`, `t4`.`hasHighGradeFilter` AS `_client_hasHighGradeFilter`, `t4`.`hasConvertFilter` AS `_client_hasConvertFilter`, `t4`.`demoLegalXtract` AS `_client_demoLegalXtract`, `t4`.`LSTAmember` AS `_client_LSTAmember`, `t4`.`LSTAboard` AS `_client_LSTAboard`, `t4`.`salesLead` AS `_client_salesLead`, `t4`.`has144a` AS `_client_has144a`, `t4`.`hasChargeSilent` AS `_client_hasChargeSilent`, `t4`.`crmManager` AS `_client_crmManager`, `t4`.`assetsUnderManagement` AS `_client_assetsUnderManagement`, `t4`.`forumClientType` AS `_client_forumClientType`, `t4`.`forumClientCode` AS `_client_forumClientCode`, `t4`.`forumUserCount` AS `_client_forumUserCount`, `t4`.`hasMergerFilter` AS `_client_hasMergerFilter`, `t4`.`looksLike` AS `_client_looksLike`, `t4`.`hideQIB` AS `_client_hideQIB`, `t4`.`hideReports` AS `_client_hideReports`, `t4`.`hide144a` AS `_client_hide144a`, `t4`.`hidePortfolio` AS `_client_hidePortfolio`, `t4`.`hideForum` AS `_client_hideForum`, `t4`.`salesLeadID` AS `_client_salesLeadID`, `t4`.`crmID` AS `_client_crmID`, `t4`.`privDocProc` AS `_client_privDocProc`, `t4`.`formerClient` AS `_client_formerClient`, `t4`.`defDemoExpireDate` AS `_client_defDemoExpireDate`, `t4`.`noIconForward` AS `_client_noIconForward`, `t4`.`hidePipeline` AS `_client_hidePipeline`, `t4`.`hideReqReport` AS `_client_hideReqReport`, `t4`.`billBackNoSelect` AS `_client_billBackNoSelect`, `t4`.`redAccount` AS `_client_redAccount`, `t4`.`privDocDisclaim` AS `_client_privDocDisclaim`, `t4`.`hideIndemnify` AS `_client_hideIndemnify`, `t4`.`euroClientID` AS `_client_euroClientID`, `t4`.`privDocEmail` AS `_client_privDocEmail`, `t4`.`sendPrivDocEmail` AS `_client_sendPrivDocEmail`, `t4`.`defaultRegion` AS `_client_defaultRegion`, `t4`.`asiaClientID` AS `_client_asiaClientID`, `t4`.`hideXtractRatings` AS `_client_hideXtractRatings`, `t4`.`onlySpecificSpecialReports` AS `_client_onlySpecificSpecialReports`, `t4`.`showTimekeeper` AS `_client_showTimekeeper`, `t4`.`isPremierLoan` AS `_client_isPremierLoan`, `t4`.`highClickLimit` AS `_client_highClickLimit`, `t4`.`counselID` AS `_client_counselID`, `t4`.`disableDocUpload` AS `_client_disableDocUpload`, `t4`.`hideSavedSearches` AS `_client_hideSavedSearches`, `t4`.`hideCovScore` AS `_client_hideCovScore`, `t4`.`ihsMarkitClient` AS `_client_ihsMarkitClient`, `t4`.`noSendDaily` AS `_client_noSendDaily`, `t4`.`hideAdvSearch` AS `_client_hideAdvSearch`, `t4`.`showCovDownload` AS `_client_showCovDownload`, `t4`.`canAccessXt10x` AS `_client_canAccessXt10x`, `t4`.`updatedTime` AS `_client_updatedTime` FROM `sessions` t0 LEFT JOIN `DataMgmt_Users` `t2` ON ((`t2`.`Id` = `t0`.`userID`) ) LEFT JOIN `DataMgmt_Clients` `t4` ON ((`t4`.`Client_Id` = `t2`.`Clientid`) ) WHERE (`t0`.`sessionKey` = 'c6376ad10b39829089b1d528cdc9afb3') ORDER BY `t0`.`expires` DESC LIMIT 1
1	0.0003	INSERT INTO `sessions` (`sessionKey`, `value`) VALUES ('c6376ad10b39829089b1d528cdc9afb3',NULL)
2	0.0003	SELECT `t0`.* FROM `sessions` t0 WHERE (`t0`.`sessionKey` = 'c6376ad10b39829089b1d528cdc9afb3')
3	0.0172	SELECT `t0`.`TABLE_NAME`, `t0`.`COLUMN_NAME`, `t0`.`IS_NULLABLE`, `t0`.`COLUMN_TYPE`, `t0`.`COLUMN_DEFAULT`, `t0`.`EXTRA`, `t0`.`COLUMN_KEY` FROM `information_schema`.`COLUMNS` t0 WHERE (`t0`.`TABLE_SCHEMA` = 'xtract')
4	0.0061	SELECT `t0`.`TABLE_NAME`, `t0`.`INDEX_NAME`, `t0`.`SEQ_IN_INDEX`, `t0`.`COLUMN_NAME`, `t0`.`NON_UNIQUE` FROM `information_schema`.`STATISTICS` t0 WHERE (`t0`.`TABLE_SCHEMA` = 'xtract') ORDER BY `t0`.`TABLE_NAME` ASC, `t0`.`INDEX_NAME` ASC, `t0`.`SEQ_IN_INDEX` ASC
5	0.1863	SELECT `t0`.`TABLE_NAME`, `t0`.`COLUMN_NAME`, `t0`.`REFERENCED_TABLE_NAME`, `t0`.`REFERENCED_COLUMN_NAME`, `t0`.`CONSTRAINT_NAME`, `t2`.`UPDATE_RULE`, `t2`.`DELETE_RULE`, MAX(`t4`.`NON_UNIQUE`) AS `NON_UNIQUE` FROM `information_schema`.`KEY_COLUMN_USAGE` t0 LEFT JOIN `information_schema`.`REFERENTIAL_CONSTRAINTS` `t2` ON ((`t0`.`CONSTRAINT_SCHEMA` = `t2`.`CONSTRAINT_SCHEMA`) AND (`t0`.`CONSTRAINT_NAME` = `t2`.`CONSTRAINT_NAME`) ) LEFT JOIN `information_schema`.`STATISTICS` `t4` ON ((`t0`.`TABLE_NAME` = `t4`.`TABLE_NAME`) AND (`t0`.`COLUMN_NAME` = `t4`.`COLUMN_NAME`) AND (`t0`.`TABLE_SCHEMA` = `t4`.`TABLE_SCHEMA`) AND (`t4`.`SEQ_IN_INDEX` = 1) ) WHERE (`t0`.`TABLE_SCHEMA` = 'xtract') AND (`t0`.`TABLE_NAME` IS NOT NULL) AND (`t0`.`REFERENCED_TABLE_NAME` IS NOT NULL) GROUP BY `t0`.`TABLE_SCHEMA`, `t0`.`TABLE_NAME`, `t0`.`COLUMN_NAME`, `t0`.`REFERENCED_TABLE_NAME`, `t0`.`REFERENCED_COLUMN_NAME`, `t0`.`CONSTRAINT_NAME`, `t2`.`UPDATE_RULE`, `t2`.`DELETE_RULE`
6	0.0009	SELECT `t0`.`sessionKey` AS `_sess_sessionKey`, `t0`.`userID` AS `_sess_userID`, `t0`.`expires` AS `_sess_expires`, `t0`.`value` AS `_sess_value`, `t0`.`lastSeen` AS `_sess_lastSeen`, `t0`.`firstSeen` AS `_sess_firstSeen`, `t0`.`userAgent` AS `_sess_userAgent`, `t0`.`fromIP` AS `_sess_fromIP`, `t2`.`Id` AS `_user_Id`, `t2`.`Clientid` AS `_user_Clientid`, `t2`.`UserName` AS `_user_UserName`, `t2`.`UserId` AS `_user_UserId`, `t2`.`Password` AS `_user_Password`, `t2`.`nameTitle` AS `_user_nameTitle`, `t2`.`nameFirst` AS `_user_nameFirst`, `t2`.`nameLast` AS `_user_nameLast`, `t2`.`nameSuffix` AS `_user_nameSuffix`, `t2`.`Address` AS `_user_Address`, `t2`.`address2` AS `_user_address2`, `t2`.`city` AS `_user_city`, `t2`.`state` AS `_user_state`, `t2`.`zip` AS `_user_zip`, `t2`.`country` AS `_user_country`, `t2`.`PhoneNo` AS `_user_PhoneNo`, `t2`.`Email` AS `_user_Email`, `t2`.`bloomEmail` AS `_user_bloomEmail`, `t2`.`userType` AS `_user_userType`, `t2`.`IPAddress` AS `_user_IPAddress`, `t2`.`AgreedDate` AS `_user_AgreedDate`, `t2`.`AgreedFromIP` AS `_user_AgreedFromIP`, `t2`.`AgreedFlag` AS `_user_AgreedFlag`, `t2`.`AgreedMD5` AS `_user_AgreedMD5`, `t2`.`LoginTime` AS `_user_LoginTime`, `t2`.`LoggedFlag` AS `_user_LoggedFlag`, `t2`.`sessionid` AS `_user_sessionid`, `t2`.`Privilege_Login` AS `_user_Privilege_Login`, `t2`.`LoginIP` AS `_user_LoginIP`, `t2`.`VisitCount` AS `_user_VisitCount`, `t2`.`adminPriv` AS `_user_adminPriv`, `t2`.`isGeneric` AS `_user_isGeneric`, `t2`.`noLogin` AS `_user_noLogin`, `t2`.`position` AS `_user_position`, `t2`.`userGroup` AS `_user_userGroup`, `t2`.`biography` AS `_user_biography`, `t2`.`forceNewPass` AS `_user_forceNewPass`, `t2`.`createdBy` AS `_user_createdBy`, `t2`.`createdDate` AS `_user_createdDate`, `t2`.`FaxNo` AS `_user_FaxNo`, `t2`.`industry` AS `_user_industry`, `t2`.`userSide` AS `_user_userSide`, `t2`.`isAttorney` AS `_user_isAttorney`, `t2`.`forumUserCode` AS `_user_forumUserCode`, `t2`.`forumXtractCode` AS `_user_forumXtractCode`, `t2`.`forumBan` AS `_user_forumBan`, `t2`.`hadTrial` AS `_user_hadTrial`, `t2`.`forumAgreedTime` AS `_user_forumAgreedTime`, `t2`.`forumAgreedFromIP` AS `_user_forumAgreedFromIP`, `t2`.`forumAgreedFlag` AS `_user_forumAgreedFlag`, `t2`.`updatedTime` AS `_user_updatedTime`, `t2`.`forumAllAlerts` AS `_user_forumAllAlerts`, `t2`.`isSalesLead` AS `_user_isSalesLead`, `t2`.`isCRM` AS `_user_isCRM`, `t2`.`cell` AS `_user_cell`, `t2`.`freeTrialTime` AS `_user_freeTrialTime`, `t2`.`sha1Pass` AS `_user_sha1Pass`, `t2`.`privDocDisclaim` AS `_user_privDocDisclaim`, `t2`.`euroUserID` AS `_user_euroUserID`, `t2`.`asiaUserID` AS `_user_asiaUserID`, `t2`.`tempPassLink` AS `_user_tempPassLink`, `t2`.`tempPassTime` AS `_user_tempPassTime`, `t2`.`isTempUser` AS `_user_isTempUser`, `t2`.`isTrained` AS `_user_isTrained`, `t2`.`primaryRole` AS `_user_primaryRole`, `t2`.`displayTz` AS `_user_displayTz`, `t2`.`debtwireId` AS `_user_debtwireId`, `t2`.`targetUi` AS `_user_targetUi`, `t2`.`twoFactor` AS `_user_twoFactor`, `t2`.`twoFactorTime` AS `_user_twoFactorTime`, `t2`.`u3id` AS `_user_u3id`, `t2`.`isNgDebtwire` AS `_user_isNgDebtwire`, `t4`.`Client_Id` AS `_client_Client_Id`, `t4`.`ClientName` AS `_client_ClientName`, `t4`.`Address` AS `_client_Address`, `t4`.`address2` AS `_client_address2`, `t4`.`city` AS `_client_city`, `t4`.`state` AS `_client_state`, `t4`.`zip` AS `_client_zip`, `t4`.`country` AS `_client_country`, `t4`.`Emailid` AS `_client_Emailid`, `t4`.`PhoneNo` AS `_client_PhoneNo`, `t4`.`fax` AS `_client_fax`, `t4`.`website` AS `_client_website`, `t4`.`description` AS `_client_description`, `t4`.`Interpretation` AS `_client_Interpretation`, `t4`.`docsInTA` AS `_client_docsInTA`, `t4`.`useSecurityPassword` AS `_client_useSecurityPassword`, `t4`.`QIB` AS `_client_QIB`, `t4`.`emailReminders` AS `_client_emailReminders`, `t4`.`startDate` AS `_client_startDate`, `t4`.`inceptionDate` AS `_client_inceptionDate`, `t4`.`principals` AS `_client_principals`, `t4`.`principalBios` AS `_client_principalBios`, `t4`.`demoOld` AS `_client_demoOld`, `t4`.`demoExpireDateOld` AS `_client_demoExpireDateOld`, `t4`.`demoAllowCov` AS `_client_demoAllowCov`, `t4`.`consulting` AS `_client_consulting`, `t4`.`consultingExpireDate` AS `_client_consultingExpireDate`, `t4`.`showSaveDoc` AS `_client_showSaveDoc`, `t4`.`showSupSum` AS `_client_showSupSum`, `t4`.`noResAlert` AS `_client_noResAlert`, `t4`.`createdDate` AS `_client_createdDate`, `t4`.`createdBy` AS `_client_createdBy`, `t4`.`overdue` AS `_client_overdue`, `t4`.`isPotential` AS `_client_isPotential`, `t4`.`gimme` AS `_client_gimme`, `t4`.`hasChargeTo` AS `_client_hasChargeTo`, `t4`.`singleAccess` AS `_client_singleAccess`, `t4`.`singleAccessHY` AS `_client_singleAccessHY`, `t4`.`singleAccessCA` AS `_client_singleAccessCA`, `t4`.`cipherKey` AS `_client_cipherKey`, `t4`.`iv` AS `_client_iv`, `t4`.`hasCreditFilter` AS `_client_hasCreditFilter`, `t4`.`hasHighYieldFilter` AS `_client_hasHighYieldFilter`, `t4`.`hasLegalXtract` AS `_client_hasLegalXtract`, `t4`.`lawfirm` AS `_client_lawfirm`, `t4`.`hasHighGradeFilter` AS `_client_hasHighGradeFilter`, `t4`.`hasConvertFilter` AS `_client_hasConvertFilter`, `t4`.`demoLegalXtract` AS `_client_demoLegalXtract`, `t4`.`LSTAmember` AS `_client_LSTAmember`, `t4`.`LSTAboard` AS `_client_LSTAboard`, `t4`.`salesLead` AS `_client_salesLead`, `t4`.`has144a` AS `_client_has144a`, `t4`.`hasChargeSilent` AS `_client_hasChargeSilent`, `t4`.`crmManager` AS `_client_crmManager`, `t4`.`assetsUnderManagement` AS `_client_assetsUnderManagement`, `t4`.`forumClientType` AS `_client_forumClientType`, `t4`.`forumClientCode` AS `_client_forumClientCode`, `t4`.`forumUserCount` AS `_client_forumUserCount`, `t4`.`hasMergerFilter` AS `_client_hasMergerFilter`, `t4`.`looksLike` AS `_client_looksLike`, `t4`.`hideQIB` AS `_client_hideQIB`, `t4`.`hideReports` AS `_client_hideReports`, `t4`.`hide144a` AS `_client_hide144a`, `t4`.`hidePortfolio` AS `_client_hidePortfolio`, `t4`.`hideForum` AS `_client_hideForum`, `t4`.`salesLeadID` AS `_client_salesLeadID`, `t4`.`crmID` AS `_client_crmID`, `t4`.`privDocProc` AS `_client_privDocProc`, `t4`.`formerClient` AS `_client_formerClient`, `t4`.`defDemoExpireDate` AS `_client_defDemoExpireDate`, `t4`.`noIconForward` AS `_client_noIconForward`, `t4`.`hidePipeline` AS `_client_hidePipeline`, `t4`.`hideReqReport` AS `_client_hideReqReport`, `t4`.`billBackNoSelect` AS `_client_billBackNoSelect`, `t4`.`redAccount` AS `_client_redAccount`, `t4`.`privDocDisclaim` AS `_client_privDocDisclaim`, `t4`.`hideIndemnify` AS `_client_hideIndemnify`, `t4`.`euroClientID` AS `_client_euroClientID`, `t4`.`privDocEmail` AS `_client_privDocEmail`, `t4`.`sendPrivDocEmail` AS `_client_sendPrivDocEmail`, `t4`.`defaultRegion` AS `_client_defaultRegion`, `t4`.`asiaClientID` AS `_client_asiaClientID`, `t4`.`hideXtractRatings` AS `_client_hideXtractRatings`, `t4`.`onlySpecificSpecialReports` AS `_client_onlySpecificSpecialReports`, `t4`.`showTimekeeper` AS `_client_showTimekeeper`, `t4`.`isPremierLoan` AS `_client_isPremierLoan`, `t4`.`highClickLimit` AS `_client_highClickLimit`, `t4`.`counselID` AS `_client_counselID`, `t4`.`disableDocUpload` AS `_client_disableDocUpload`, `t4`.`hideSavedSearches` AS `_client_hideSavedSearches`, `t4`.`hideCovScore` AS `_client_hideCovScore`, `t4`.`ihsMarkitClient` AS `_client_ihsMarkitClient`, `t4`.`noSendDaily` AS `_client_noSendDaily`, `t4`.`hideAdvSearch` AS `_client_hideAdvSearch`, `t4`.`showCovDownload` AS `_client_showCovDownload`, `t4`.`canAccessXt10x` AS `_client_canAccessXt10x`, `t4`.`updatedTime` AS `_client_updatedTime` FROM `sessions` t0 LEFT JOIN `DataMgmt_Users` `t2` ON ((`t2`.`Id` = `t0`.`userID`) ) LEFT JOIN `DataMgmt_Clients` `t4` ON ((`t4`.`Client_Id` = `t2`.`Clientid`) ) WHERE (`t0`.`sessionKey` = 'c6376ad10b39829089b1d528cdc9afb3') ORDER BY `t0`.`expires` DESC LIMIT 1
7	0.0004	UPDATE `sessions` `t0` SET `t0`.`expires` = '1745553940',`t0`.`value` = NULL WHERE (`t0`.`sessionKey` = 'c6376ad10b39829089b1d528cdc9afb3')
8	0.0003	SELECT `t0`.* FROM `sessions` t0 WHERE (`t0`.`sessionKey` = 'c6376ad10b39829089b1d528cdc9afb3')
9	0.0003	SELECT `t0`.`role` FROM `userRoles` t0 WHERE (`t0`.`userID` IS NULL) GROUP BY `t0`.`role`
10	0.0003	SELECT `t0`.`role`, `t0`.`level` FROM `roles` t0
11	0.0004	SELECT `t0`.`level`, `t0`.`message`, `t0`.`details` FROM `daxSystemMessages` t0 WHERE (`t0`.`sessionKey` = 'c6376ad10b39829089b1d528cdc9afb3') LIMIT 250
12	0.0003	SELECT `t0`.* FROM `regions` t0 WHERE (`t0`.`region` = 'US')
13	0.0004	SELECT `t0`.* FROM `ipLogins` t0
14	0.0002	SELECT `t0`.* FROM `regions` t0 WHERE (`t0`.`region` = 'US')
15	0.0003	SELECT `t0`.`role`, `t0`.`level` FROM `roles` t0
16	0.0004	SELECT `t0`.`ServiceType`, `t0`.`ServiceName` FROM `DataMgmt_Services` t0 WHERE (`t0`.`active` = '1') ORDER BY `t0`.`ServiceType` ASC
17	0.0004	SELECT SUM(`t0`.`legalXtract`) AS `legalXtract`, SUM(`t0`.`covXtract`) AS `covXtract`, `t1`.`ServiceType`, CASE `t1`.`ServiceType` WHEN 'Credit' THEN 3 WHEN 'High Yield' THEN 2 WHEN 'High Grade' THEN 1 WHEN 'Convertible' THEN 0 ELSE -1 END AS `servOrder` FROM `clientServices` t0 INNER JOIN `DataMgmt_Services` `t1` ON ((`t0`.`serviceID` = `t1`.`ServiceId`) ) WHERE (`t0`.`clientID` IS NULL) GROUP BY `t1`.`ServiceType` ORDER BY `servOrder` ASC
18	0.0005	SELECT `t0`.`countryCode`, `t0`.`countryName` FROM `countries` t0 ORDER BY `t0`.`countryName` ASC
19	0.0003	SELECT `t0`.* FROM `regions` t0 WHERE (`t0`.`region` = 'US')
20	0.0002	SELECT `t0`.* FROM `countries` t0 WHERE (`t0`.`countryCode` = 'US')
21	0.0002	SELECT `t0`.* FROM `regions` t0 WHERE (`t0`.`region` = 'EURO')
22	0.0002	SELECT `t0`.* FROM `countries` t0 WHERE (`t0`.`countryCode` = 'GB')
23	0.0002	SELECT `t0`.* FROM `regions` t0 WHERE (`t0`.`region` = 'ASIA')
24	0.0002	SELECT `t0`.* FROM `countries` t0 WHERE (`t0`.`countryCode` = 'HK')

Unsubscribe

Login Failed

Free Trial