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.82
PHP: 45.30%
SQL: 54.70%
Queries: 28

SQL Queries

Order	Elapsed	Query
0	0.001	SELECT @@global.time_zone, @@system_time_zone, NOW() AS currentTime
1	0.017	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.0051	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.0602	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.0529	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.0016	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 = 'f187423c70b14df66ba8c6c05c13dea5' ORDER BY expires DESC LIMIT 1
6	0.0014	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 = 'f187423c70b14df66ba8c6c05c13dea5' ORDER BY expires DESC LIMIT 1
7	0.0013	SELECT `t0`.`role` FROM `userRoles` t0 WHERE (`t0`.`userID` IS NULL) GROUP BY `t0`.`role`
8	0.0011	SELECT `t0`.`role`, `t0`.`level` FROM `roles` t0
9	0.0013	SELECT `t0`.* FROM `regions` t0 WHERE (`t0`.`region` = 'US')
10	0.0013	SELECT `t0`.* FROM `ipLogins` t0
11	0.0012	SELECT `t0`.* FROM `DataMgmt_Clients` t0 WHERE (`t0`.`Client_Id` = '0')
12	0.0011	SELECT `t0`.* FROM `DataMgmt_Services` t0 WHERE (`t0`.`active` = 1)
13	0.0011	SELECT `t0`.`ServiceType`, `t0`.`ServiceName` FROM `DataMgmt_Services` t0 WHERE (`t0`.`active` = 1) ORDER BY `t0`.`ServiceType` ASC
14	0.0014	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
15	0.0014	SELECT `t0`.`countryCode`, `t0`.`countryName` FROM `countries` t0 ORDER BY `t0`.`countryName` ASC
16	0.055	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
17	0.0492	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.048	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.0481	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.0469	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.0461	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.0011	SELECT `t0`.* FROM `regions` t0 WHERE (`t0`.`region` = 'US')
23	0.0011	SELECT `t0`.* FROM `countries` t0 WHERE (`t0`.`countryCode` = 'US')
24	0.0011	SELECT `t0`.* FROM `regions` t0 WHERE (`t0`.`region` = 'EURO')
25	0.0011	SELECT `t0`.* FROM `countries` t0 WHERE (`t0`.`countryCode` = 'GB')
26	0.0011	SELECT `t0`.* FROM `regions` t0 WHERE (`t0`.`region` = 'ASIA')
27	0.0011	SELECT `t0`.* FROM `countries` t0 WHERE (`t0`.`countryCode` = 'HK')

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.