Xtract Research -

Xtract Research is widely recognized as a leading provider of covenant research throughout the world.
The experience of our lawyers coupled with the most technologically advanced platform gives you a distinct advantage when analyzing covenants, spotting trends and tracking events.
Bonds

With the largest 144A library, the scope of our bond coverage is unmatched in the market. We provide sophisticated legal analysis on bond covenants together with the ability to compare covenants by simply clicking a button. Learn More
Loans

Our reports have fundamentally changed how lenders analyze credit agreements from North America and facility agreements from Europe. Market players use our reports to spot off-market terms, understand loopholes and to quickly digest material provisions. Learn More
Referenced Around the Web
Special Reports

Our special report service provides timely legal analysis on exchange offers, LBO’s, widely debated covenant issues and other market moving events. In addition, we track and provide commentary on the latest covenant trends. Learn More
Deal Data

The Deal Data platforms are used by law firms, investment banks and sell side analysts to find precedent language, understand market trends and structure deals.
Learn More
Our NY and London legal teams consist of lawyers from the top international law firms with a deep understanding of the credit markets across the globe.
Trending Special Reports

Region Head Offices

North America/Latin America
1501 Broadway
8th Floor
New York, NY 10036
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
+852 2158 9790

Elapsed: 0.75
PHP: 46.29%
SQL: 53.71%
Queries: 28

SQL Queries

Order	Elapsed	Query
0	0.0007	SELECT @@global.time_zone, @@system_time_zone, NOW() AS currentTime
1	0.0154	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')
2	0.0046	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
3	0.0646	SELECT `t0`.`TABLE_NAME`, `t0`.`COLUMN_NAME`, `t0`.`REFERENCED_TABLE_NAME`, `t0`.`REFERENCED_COLUMN_NAME`, `t0`.`CONSTRAINT_NAME`, `t1`.`UPDATE_RULE`, `t1`.`DELETE_RULE` FROM `information_schema`.`KEY_COLUMN_USAGE` t0 LEFT JOIN `information_schema`.`REFERENTIAL_CONSTRAINTS` `t1` ON ((`t0`.`CONSTRAINT_SCHEMA` = `t1`.`CONSTRAINT_SCHEMA`) AND (`t0`.`CONSTRAINT_NAME` = `t1`.`CONSTRAINT_NAME`) ) WHERE (`t0`.`TABLE_SCHEMA` = 'xtract') AND (`t0`.`TABLE_NAME` IS NOT NULL)
4	0.0567	SELECT `t0`.`TABLE_NAME`, `t0`.`COLUMN_NAME`, `t0`.`REFERENCED_TABLE_NAME`, `t0`.`REFERENCED_COLUMN_NAME`, `t0`.`CONSTRAINT_NAME`, `t1`.`UPDATE_RULE`, `t1`.`DELETE_RULE` FROM `information_schema`.`KEY_COLUMN_USAGE` t0 LEFT JOIN `information_schema`.`REFERENTIAL_CONSTRAINTS` `t1` ON ((`t0`.`CONSTRAINT_SCHEMA` = `t1`.`CONSTRAINT_SCHEMA`) AND (`t0`.`CONSTRAINT_NAME` = `t1`.`CONSTRAINT_NAME`) ) WHERE (`t0`.`TABLE_SCHEMA` = 'xtract') AND (`t0`.`REFERENCED_TABLE_NAME` IS NOT NULL)
5	0.0015	SELECT `s`.`sessionKey` AS `_sess_sessionKey`, `s`.`userID` AS `_sess_userID`, `s`.`expires` AS `_sess_expires`, `s`.`value` AS `_sess_value`, `s`.`lastSeen` AS `_sess_lastSeen`, `s`.`firstSeen` AS `_sess_firstSeen`, `s`.`userAgent` AS `_sess_userAgent`, `s`.`fromIP` AS `_sess_fromIP`, `u`.`Id` AS `_user_Id`, `u`.`Clientid` AS `_user_Clientid`, `u`.`UserName` AS `_user_UserName`, `u`.`UserId` AS `_user_UserId`, `u`.`Password` AS `_user_Password`, `u`.`Address` AS `_user_Address`, `u`.`address2` AS `_user_address2`, `u`.`city` AS `_user_city`, `u`.`state` AS `_user_state`, `u`.`zip` AS `_user_zip`, `u`.`country` AS `_user_country`, `u`.`PhoneNo` AS `_user_PhoneNo`, `u`.`Email` AS `_user_Email`, `u`.`bloomEmail` AS `_user_bloomEmail`, `u`.`userType` AS `_user_userType`, `u`.`IPAddress` AS `_user_IPAddress`, `u`.`AgreedDate` AS `_user_AgreedDate`, `u`.`AgreedFromIP` AS `_user_AgreedFromIP`, `u`.`AgreedFlag` AS `_user_AgreedFlag`, `u`.`AgreedMD5` AS `_user_AgreedMD5`, `u`.`LoginTime` AS `_user_LoginTime`, `u`.`LoggedFlag` AS `_user_LoggedFlag`, `u`.`sessionid` AS `_user_sessionid`, `u`.`Privilege_Login` AS `_user_Privilege_Login`, `u`.`LoginIP` AS `_user_LoginIP`, `u`.`VisitCount` AS `_user_VisitCount`, `u`.`adminPriv` AS `_user_adminPriv`, `u`.`isGeneric` AS `_user_isGeneric`, `u`.`noLogin` AS `_user_noLogin`, `u`.`position` AS `_user_position`, `u`.`userGroup` AS `_user_userGroup`, `u`.`biography` AS `_user_biography`, `u`.`forceNewPass` AS `_user_forceNewPass`, `u`.`createdBy` AS `_user_createdBy`, `u`.`createdDate` AS `_user_createdDate`, `u`.`FaxNo` AS `_user_FaxNo`, `u`.`industry` AS `_user_industry`, `u`.`userSide` AS `_user_userSide`, `u`.`isAttorney` AS `_user_isAttorney`, `u`.`forumUserCode` AS `_user_forumUserCode`, `u`.`forumXtractCode` AS `_user_forumXtractCode`, `u`.`forumBan` AS `_user_forumBan`, `u`.`hadTrial` AS `_user_hadTrial`, `u`.`forumAgreedTime` AS `_user_forumAgreedTime`, `u`.`forumAgreedFromIP` AS `_user_forumAgreedFromIP`, `u`.`forumAgreedFlag` AS `_user_forumAgreedFlag`, `u`.`updatedTime` AS `_user_updatedTime`, `u`.`forumAllAlerts` AS `_user_forumAllAlerts`, `u`.`isSalesLead` AS `_user_isSalesLead`, `u`.`isCRM` AS `_user_isCRM`, `u`.`cell` AS `_user_cell`, `u`.`freeTrialTime` AS `_user_freeTrialTime`, `u`.`sha1Pass` AS `_user_sha1Pass`, `u`.`privDocDisclaim` AS `_user_privDocDisclaim`, `u`.`euroUserID` AS `_user_euroUserID`, `u`.`asiaUserID` AS `_user_asiaUserID`, `u`.`tempPassLink` AS `_user_tempPassLink`, `u`.`tempPassTime` AS `_user_tempPassTime`, `u`.`isTempUser` AS `_user_isTempUser`, `u`.`isTrained` AS `_user_isTrained`, `u`.`primaryRole` AS `_user_primaryRole`, `u`.`displayTz` AS `_user_displayTz`, `u`.`debtwireId` AS `_user_debtwireId`, `c`.`Client_Id` AS `_client_Client_Id`, `c`.`ClientName` AS `_client_ClientName`, `c`.`Address` AS `_client_Address`, `c`.`address2` AS `_client_address2`, `c`.`city` AS `_client_city`, `c`.`state` AS `_client_state`, `c`.`zip` AS `_client_zip`, `c`.`country` AS `_client_country`, `c`.`Emailid` AS `_client_Emailid`, `c`.`PhoneNo` AS `_client_PhoneNo`, `c`.`fax` AS `_client_fax`, `c`.`website` AS `_client_website`, `c`.`description` AS `_client_description`, `c`.`Interpretation` AS `_client_Interpretation`, `c`.`docsInTA` AS `_client_docsInTA`, `c`.`useSecurityPassword` AS `_client_useSecurityPassword`, `c`.`QIB` AS `_client_QIB`, `c`.`emailReminders` AS `_client_emailReminders`, `c`.`startDate` AS `_client_startDate`, `c`.`inceptionDate` AS `_client_inceptionDate`, `c`.`principals` AS `_client_principals`, `c`.`principalBios` AS `_client_principalBios`, `c`.`demoOld` AS `_client_demoOld`, `c`.`demoExpireDateOld` AS `_client_demoExpireDateOld`, `c`.`demoAllowCov` AS `_client_demoAllowCov`, `c`.`consulting` AS `_client_consulting`, `c`.`consultingExpireDate` AS `_client_consultingExpireDate`, `c`.`showSaveDoc` AS `_client_showSaveDoc`, `c`.`showSupSum` AS `_client_showSupSum`, `c`.`noResAlert` AS `_client_noResAlert`, `c`.`createdDate` AS `_client_createdDate`, `c`.`createdBy` AS `_client_createdBy`, `c`.`overdue` AS `_client_overdue`, `c`.`isPotential` AS `_client_isPotential`, `c`.`gimme` AS `_client_gimme`, `c`.`hasChargeTo` AS `_client_hasChargeTo`, `c`.`singleAccess` AS `_client_singleAccess`, `c`.`singleAccessHY` AS `_client_singleAccessHY`, `c`.`singleAccessCA` AS `_client_singleAccessCA`, `c`.`cipherKey` AS `_client_cipherKey`, `c`.`iv` AS `_client_iv`, `c`.`hasCreditFilter` AS `_client_hasCreditFilter`, `c`.`hasHighYieldFilter` AS `_client_hasHighYieldFilter`, `c`.`hasLegalXtract` AS `_client_hasLegalXtract`, `c`.`lawfirm` AS `_client_lawfirm`, `c`.`hasHighGradeFilter` AS `_client_hasHighGradeFilter`, `c`.`hasConvertFilter` AS `_client_hasConvertFilter`, `c`.`demoLegalXtract` AS `_client_demoLegalXtract`, `c`.`LSTAmember` AS `_client_LSTAmember`, `c`.`LSTAboard` AS `_client_LSTAboard`, `c`.`salesLead` AS `_client_salesLead`, `c`.`has144a` AS `_client_has144a`, `c`.`hasChargeSilent` AS `_client_hasChargeSilent`, `c`.`crmManager` AS `_client_crmManager`, `c`.`assetsUnderManagement` AS `_client_assetsUnderManagement`, `c`.`forumClientType` AS `_client_forumClientType`, `c`.`forumClientCode` AS `_client_forumClientCode`, `c`.`forumUserCount` AS `_client_forumUserCount`, `c`.`hasMergerFilter` AS `_client_hasMergerFilter`, `c`.`looksLike` AS `_client_looksLike`, `c`.`hideQIB` AS `_client_hideQIB`, `c`.`hideReports` AS `_client_hideReports`, `c`.`hide144a` AS `_client_hide144a`, `c`.`hidePortfolio` AS `_client_hidePortfolio`, `c`.`hideForum` AS `_client_hideForum`, `c`.`salesLeadID` AS `_client_salesLeadID`, `c`.`crmID` AS `_client_crmID`, `c`.`privDocProc` AS `_client_privDocProc`, `c`.`formerClient` AS `_client_formerClient`, `c`.`defDemoExpireDate` AS `_client_defDemoExpireDate`, `c`.`noIconForward` AS `_client_noIconForward`, `c`.`hidePipeline` AS `_client_hidePipeline`, `c`.`hideReqReport` AS `_client_hideReqReport`, `c`.`billBackNoSelect` AS `_client_billBackNoSelect`, `c`.`redAccount` AS `_client_redAccount`, `c`.`privDocDisclaim` AS `_client_privDocDisclaim`, `c`.`hideIndemnify` AS `_client_hideIndemnify`, `c`.`euroClientID` AS `_client_euroClientID`, `c`.`privDocEmail` AS `_client_privDocEmail`, `c`.`sendPrivDocEmail` AS `_client_sendPrivDocEmail`, `c`.`defaultRegion` AS `_client_defaultRegion`, `c`.`asiaClientID` AS `_client_asiaClientID`, `c`.`hideXtractRatings` AS `_client_hideXtractRatings`, `c`.`onlySpecificSpecialReports` AS `_client_onlySpecificSpecialReports`, `c`.`showTimekeeper` AS `_client_showTimekeeper`, `c`.`isPremierLoan` AS `_client_isPremierLoan`, `c`.`highClickLimit` AS `_client_highClickLimit`, `c`.`counselID` AS `_client_counselID`, `c`.`disableDocUpload` AS `_client_disableDocUpload`, `c`.`hideSavedSearches` AS `_client_hideSavedSearches`, `c`.`hideCovScore` AS `_client_hideCovScore`, `c`.`ihsMarkitClient` AS `_client_ihsMarkitClient`, `c`.`noSendDaily` AS `_client_noSendDaily`, `c`.`hideAdvSearch` AS `_client_hideAdvSearch` FROM sessions s LEFT JOIN DataMgmt_Users u ON s.userID = u.Id LEFT JOIN DataMgmt_Clients c ON u.Clientid = c.Client_Id WHERE sessionKey = '38a21298cd7aad7344fa0e7b965d3af7' ORDER BY expires DESC LIMIT 1
6	0.0011	SELECT `s`.`sessionKey` AS `_sess_sessionKey`, `s`.`userID` AS `_sess_userID`, `s`.`expires` AS `_sess_expires`, `s`.`value` AS `_sess_value`, `s`.`lastSeen` AS `_sess_lastSeen`, `s`.`firstSeen` AS `_sess_firstSeen`, `s`.`userAgent` AS `_sess_userAgent`, `s`.`fromIP` AS `_sess_fromIP`, `u`.`Id` AS `_user_Id`, `u`.`Clientid` AS `_user_Clientid`, `u`.`UserName` AS `_user_UserName`, `u`.`UserId` AS `_user_UserId`, `u`.`Password` AS `_user_Password`, `u`.`Address` AS `_user_Address`, `u`.`address2` AS `_user_address2`, `u`.`city` AS `_user_city`, `u`.`state` AS `_user_state`, `u`.`zip` AS `_user_zip`, `u`.`country` AS `_user_country`, `u`.`PhoneNo` AS `_user_PhoneNo`, `u`.`Email` AS `_user_Email`, `u`.`bloomEmail` AS `_user_bloomEmail`, `u`.`userType` AS `_user_userType`, `u`.`IPAddress` AS `_user_IPAddress`, `u`.`AgreedDate` AS `_user_AgreedDate`, `u`.`AgreedFromIP` AS `_user_AgreedFromIP`, `u`.`AgreedFlag` AS `_user_AgreedFlag`, `u`.`AgreedMD5` AS `_user_AgreedMD5`, `u`.`LoginTime` AS `_user_LoginTime`, `u`.`LoggedFlag` AS `_user_LoggedFlag`, `u`.`sessionid` AS `_user_sessionid`, `u`.`Privilege_Login` AS `_user_Privilege_Login`, `u`.`LoginIP` AS `_user_LoginIP`, `u`.`VisitCount` AS `_user_VisitCount`, `u`.`adminPriv` AS `_user_adminPriv`, `u`.`isGeneric` AS `_user_isGeneric`, `u`.`noLogin` AS `_user_noLogin`, `u`.`position` AS `_user_position`, `u`.`userGroup` AS `_user_userGroup`, `u`.`biography` AS `_user_biography`, `u`.`forceNewPass` AS `_user_forceNewPass`, `u`.`createdBy` AS `_user_createdBy`, `u`.`createdDate` AS `_user_createdDate`, `u`.`FaxNo` AS `_user_FaxNo`, `u`.`industry` AS `_user_industry`, `u`.`userSide` AS `_user_userSide`, `u`.`isAttorney` AS `_user_isAttorney`, `u`.`forumUserCode` AS `_user_forumUserCode`, `u`.`forumXtractCode` AS `_user_forumXtractCode`, `u`.`forumBan` AS `_user_forumBan`, `u`.`hadTrial` AS `_user_hadTrial`, `u`.`forumAgreedTime` AS `_user_forumAgreedTime`, `u`.`forumAgreedFromIP` AS `_user_forumAgreedFromIP`, `u`.`forumAgreedFlag` AS `_user_forumAgreedFlag`, `u`.`updatedTime` AS `_user_updatedTime`, `u`.`forumAllAlerts` AS `_user_forumAllAlerts`, `u`.`isSalesLead` AS `_user_isSalesLead`, `u`.`isCRM` AS `_user_isCRM`, `u`.`cell` AS `_user_cell`, `u`.`freeTrialTime` AS `_user_freeTrialTime`, `u`.`sha1Pass` AS `_user_sha1Pass`, `u`.`privDocDisclaim` AS `_user_privDocDisclaim`, `u`.`euroUserID` AS `_user_euroUserID`, `u`.`asiaUserID` AS `_user_asiaUserID`, `u`.`tempPassLink` AS `_user_tempPassLink`, `u`.`tempPassTime` AS `_user_tempPassTime`, `u`.`isTempUser` AS `_user_isTempUser`, `u`.`isTrained` AS `_user_isTrained`, `u`.`primaryRole` AS `_user_primaryRole`, `u`.`displayTz` AS `_user_displayTz`, `u`.`debtwireId` AS `_user_debtwireId`, `c`.`Client_Id` AS `_client_Client_Id`, `c`.`ClientName` AS `_client_ClientName`, `c`.`Address` AS `_client_Address`, `c`.`address2` AS `_client_address2`, `c`.`city` AS `_client_city`, `c`.`state` AS `_client_state`, `c`.`zip` AS `_client_zip`, `c`.`country` AS `_client_country`, `c`.`Emailid` AS `_client_Emailid`, `c`.`PhoneNo` AS `_client_PhoneNo`, `c`.`fax` AS `_client_fax`, `c`.`website` AS `_client_website`, `c`.`description` AS `_client_description`, `c`.`Interpretation` AS `_client_Interpretation`, `c`.`docsInTA` AS `_client_docsInTA`, `c`.`useSecurityPassword` AS `_client_useSecurityPassword`, `c`.`QIB` AS `_client_QIB`, `c`.`emailReminders` AS `_client_emailReminders`, `c`.`startDate` AS `_client_startDate`, `c`.`inceptionDate` AS `_client_inceptionDate`, `c`.`principals` AS `_client_principals`, `c`.`principalBios` AS `_client_principalBios`, `c`.`demoOld` AS `_client_demoOld`, `c`.`demoExpireDateOld` AS `_client_demoExpireDateOld`, `c`.`demoAllowCov` AS `_client_demoAllowCov`, `c`.`consulting` AS `_client_consulting`, `c`.`consultingExpireDate` AS `_client_consultingExpireDate`, `c`.`showSaveDoc` AS `_client_showSaveDoc`, `c`.`showSupSum` AS `_client_showSupSum`, `c`.`noResAlert` AS `_client_noResAlert`, `c`.`createdDate` AS `_client_createdDate`, `c`.`createdBy` AS `_client_createdBy`, `c`.`overdue` AS `_client_overdue`, `c`.`isPotential` AS `_client_isPotential`, `c`.`gimme` AS `_client_gimme`, `c`.`hasChargeTo` AS `_client_hasChargeTo`, `c`.`singleAccess` AS `_client_singleAccess`, `c`.`singleAccessHY` AS `_client_singleAccessHY`, `c`.`singleAccessCA` AS `_client_singleAccessCA`, `c`.`cipherKey` AS `_client_cipherKey`, `c`.`iv` AS `_client_iv`, `c`.`hasCreditFilter` AS `_client_hasCreditFilter`, `c`.`hasHighYieldFilter` AS `_client_hasHighYieldFilter`, `c`.`hasLegalXtract` AS `_client_hasLegalXtract`, `c`.`lawfirm` AS `_client_lawfirm`, `c`.`hasHighGradeFilter` AS `_client_hasHighGradeFilter`, `c`.`hasConvertFilter` AS `_client_hasConvertFilter`, `c`.`demoLegalXtract` AS `_client_demoLegalXtract`, `c`.`LSTAmember` AS `_client_LSTAmember`, `c`.`LSTAboard` AS `_client_LSTAboard`, `c`.`salesLead` AS `_client_salesLead`, `c`.`has144a` AS `_client_has144a`, `c`.`hasChargeSilent` AS `_client_hasChargeSilent`, `c`.`crmManager` AS `_client_crmManager`, `c`.`assetsUnderManagement` AS `_client_assetsUnderManagement`, `c`.`forumClientType` AS `_client_forumClientType`, `c`.`forumClientCode` AS `_client_forumClientCode`, `c`.`forumUserCount` AS `_client_forumUserCount`, `c`.`hasMergerFilter` AS `_client_hasMergerFilter`, `c`.`looksLike` AS `_client_looksLike`, `c`.`hideQIB` AS `_client_hideQIB`, `c`.`hideReports` AS `_client_hideReports`, `c`.`hide144a` AS `_client_hide144a`, `c`.`hidePortfolio` AS `_client_hidePortfolio`, `c`.`hideForum` AS `_client_hideForum`, `c`.`salesLeadID` AS `_client_salesLeadID`, `c`.`crmID` AS `_client_crmID`, `c`.`privDocProc` AS `_client_privDocProc`, `c`.`formerClient` AS `_client_formerClient`, `c`.`defDemoExpireDate` AS `_client_defDemoExpireDate`, `c`.`noIconForward` AS `_client_noIconForward`, `c`.`hidePipeline` AS `_client_hidePipeline`, `c`.`hideReqReport` AS `_client_hideReqReport`, `c`.`billBackNoSelect` AS `_client_billBackNoSelect`, `c`.`redAccount` AS `_client_redAccount`, `c`.`privDocDisclaim` AS `_client_privDocDisclaim`, `c`.`hideIndemnify` AS `_client_hideIndemnify`, `c`.`euroClientID` AS `_client_euroClientID`, `c`.`privDocEmail` AS `_client_privDocEmail`, `c`.`sendPrivDocEmail` AS `_client_sendPrivDocEmail`, `c`.`defaultRegion` AS `_client_defaultRegion`, `c`.`asiaClientID` AS `_client_asiaClientID`, `c`.`hideXtractRatings` AS `_client_hideXtractRatings`, `c`.`onlySpecificSpecialReports` AS `_client_onlySpecificSpecialReports`, `c`.`showTimekeeper` AS `_client_showTimekeeper`, `c`.`isPremierLoan` AS `_client_isPremierLoan`, `c`.`highClickLimit` AS `_client_highClickLimit`, `c`.`counselID` AS `_client_counselID`, `c`.`disableDocUpload` AS `_client_disableDocUpload`, `c`.`hideSavedSearches` AS `_client_hideSavedSearches`, `c`.`hideCovScore` AS `_client_hideCovScore`, `c`.`ihsMarkitClient` AS `_client_ihsMarkitClient`, `c`.`noSendDaily` AS `_client_noSendDaily`, `c`.`hideAdvSearch` AS `_client_hideAdvSearch` FROM sessions s LEFT JOIN DataMgmt_Users u ON s.userID = u.Id LEFT JOIN DataMgmt_Clients c ON u.Clientid = c.Client_Id WHERE sessionKey = '38a21298cd7aad7344fa0e7b965d3af7' ORDER BY expires DESC LIMIT 1
7	0.0008	SELECT `t0`.`role` FROM `userRoles` t0 WHERE (`t0`.`userID` IS NULL) GROUP BY `t0`.`role`
8	0.0008	SELECT `t0`.`role`, `t0`.`level` FROM `roles` t0
9	0.0008	SELECT `t0`.* FROM `regions` t0 WHERE (`t0`.`region` = 'US')
10	0.0008	SELECT `t0`.* FROM `countries` t0 WHERE (`t0`.`countryCode` = 'HK')
11	0.0009	SELECT `t0`.* FROM `ipLogins` t0
12	0.0008	SELECT `t0`.* FROM `DataMgmt_Clients` t0 WHERE (`t0`.`Client_Id` = '0')
13	0.0008	SELECT `t0`.* FROM `DataMgmt_Services` t0 WHERE (`t0`.`active` = 1)
14	0.0009	SELECT `t0`.`ServiceType`, `t0`.`ServiceName` FROM `DataMgmt_Services` t0 WHERE (`t0`.`active` = 1) ORDER BY `t0`.`ServiceType` ASC
15	0.0009	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
16	0.0011	SELECT `t0`.`countryCode`, `t0`.`countryName` FROM `countries` t0 ORDER BY `t0`.`countryName` ASC
17	0.0484	SELECT count() as hits, n. FROM `trackClicks` tc INNER JOIN newsLinks n on n.newsLinkID = tc.targetID INNER JOIN `newsLinkRegionService` nls ON nls.newsLinkID = n.newsLinkID WHERE `clickType` = 'specReport' AND tc.`createdTime` > DATE_SUB(NOW(),INTERVAL 7 DAY) AND nls.region != 'EURO' GROUP BY n.newsLinkID ORDER BY hits DESC LIMIT 5
18	0.0406	SELECT count() as hits, n. FROM `trackClicks` tc INNER JOIN newsLinks n on n.newsLinkID = tc.targetID INNER JOIN `newsLinkRegionService` nls ON nls.newsLinkID = n.newsLinkID WHERE `clickType` = 'specReport' AND tc.`createdTime` > DATE_SUB(NOW(),INTERVAL 7 DAY) AND nls.region != 'EURO' GROUP BY n.newsLinkID ORDER BY hits DESC LIMIT 5
19	0.0402	SELECT count() as hits, n. FROM `trackClicks` tc INNER JOIN newsLinks n on n.newsLinkID = tc.targetID INNER JOIN `newsLinkRegionService` nls ON nls.newsLinkID = n.newsLinkID WHERE `clickType` = 'specReport' AND tc.`createdTime` > DATE_SUB(NOW(),INTERVAL 7 DAY) AND nls.region != 'EURO' GROUP BY n.newsLinkID ORDER BY hits DESC LIMIT 5
20	0.0393	SELECT count() as hits, n. FROM `trackClicks` tc INNER JOIN newsLinks n on n.newsLinkID = tc.targetID INNER JOIN `newsLinkRegionService` nls ON nls.newsLinkID = n.newsLinkID WHERE `clickType` = 'specReport' AND tc.`createdTime` > DATE_SUB(NOW(),INTERVAL 7 DAY) AND nls.region != 'EURO' GROUP BY n.newsLinkID ORDER BY hits DESC LIMIT 5
21	0.0394	SELECT count() as hits, n. FROM `trackClicks` tc INNER JOIN newsLinks n on n.newsLinkID = tc.targetID INNER JOIN `newsLinkRegionService` nls ON nls.newsLinkID = n.newsLinkID WHERE `clickType` = 'specReport' AND tc.`createdTime` > DATE_SUB(NOW(),INTERVAL 7 DAY) AND nls.region != 'EURO' GROUP BY n.newsLinkID ORDER BY hits DESC LIMIT 5
22	0.0394	SELECT count() as hits, n. FROM `trackClicks` tc INNER JOIN newsLinks n on n.newsLinkID = tc.targetID INNER JOIN `newsLinkRegionService` nls ON nls.newsLinkID = n.newsLinkID WHERE `clickType` = 'specReport' AND tc.`createdTime` > DATE_SUB(NOW(),INTERVAL 7 DAY) AND nls.region != 'EURO' GROUP BY n.newsLinkID ORDER BY hits DESC LIMIT 5
23	0.0007	SELECT `t0`.* FROM `regions` t0 WHERE (`t0`.`region` = 'US')
24	0.0008	SELECT `t0`.* FROM `countries` t0 WHERE (`t0`.`countryCode` = 'US')
25	0.0008	SELECT `t0`.* FROM `regions` t0 WHERE (`t0`.`region` = 'EURO')
26	0.0007	SELECT `t0`.* FROM `countries` t0 WHERE (`t0`.`countryCode` = 'GB')
27	0.0008	SELECT `t0`.* FROM `regions` t0 WHERE (`t0`.`region` = 'ASIA')

Covenant Analysis that Guides

Fixed Income Professionals

The Xtract Research Advantage

Xtract Research is widely recognized as a leading provider of covenant research throughout the world.
The experience of our lawyers coupled with the most technologically advanced platform gives you a distinct advantage when analyzing covenants, spotting trends and tracking events.

Bonds

Loans

Referenced Around the Web

Special Reports

Deal Data

Our NY and London legal teams consist of lawyers from the top international law firms with a deep understanding of the credit markets across the globe.

Trending Special Reports

Covenant Analysis that GuidesFixed Income Professionals

The Xtract Research Advantage

Xtract Research is widely recognized as a leading provider of covenant research throughout the world. The experience of our lawyers coupled with the most technologically advanced platform gives you a distinct advantage when analyzing covenants, spotting trends and tracking events.

Bonds

Loans

Referenced Around the Web

Special Reports

Deal Data

Our NY and London legal teams consist of lawyers from the top international law firms with a deep understanding of the credit markets across the globe.

Trending Special Reports

Login Failed

Free Trial

Covenant Analysis that Guides

Fixed Income Professionals

Xtract Research is widely recognized as a leading provider of covenant research throughout the world.
The experience of our lawyers coupled with the most technologically advanced platform gives you a distinct advantage when analyzing covenants, spotting trends and tracking events.