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: 4.21
PHP: 7.11%
SQL: 92.89%
Queries: 184

SQL Queries

Order	Elapsed	Query
0	0.0004	SELECT @@global.time_zone, @@system_time_zone, NOW() AS currentTime
1	0.0014	SHOW FULL COLUMNS FROM `DataMgmt_Users`
2	0.0008	SHOW INDEX FROM `DataMgmt_Users`
3	0.0739	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'DataMgmt_Users' AND u.TABLE_NAME IS NOT NULL
4	0.0009	SHOW FULL COLUMNS FROM `ipLogins`
5	0.0007	SHOW INDEX FROM `ipLogins`
6	0.0717	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'ipLogins' AND u.TABLE_NAME IS NOT NULL
7	0.0391	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'ipLogins' and u.REFERENCED_TABLE_NAME IS NOT NULL
8	0.0007	SHOW FULL COLUMNS FROM `userGroups`
9	0.0005	SHOW INDEX FROM `userGroups`
10	0.0005	SHOW INDEX FROM `industry`
11	0.0896	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'userGroups' AND u.TABLE_NAME IS NOT NULL
12	0.0647	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'userGroups' and u.REFERENCED_TABLE_NAME IS NOT NULL
13	0.0008	SHOW FULL COLUMNS FROM `userPrefs`
14	0.0008	SHOW FULL COLUMNS FROM `clientBilling`
15	0.0006	SHOW INDEX FROM `userPrefs`
16	0.091	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'userPrefs' AND u.TABLE_NAME IS NOT NULL
17	0.2588	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'userPrefs' and u.REFERENCED_TABLE_NAME IS NOT NULL
18	0.0008	SHOW FULL COLUMNS FROM `userRoles`
19	0.0006	SHOW INDEX FROM `userRoles`
20	0.1001	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'userRoles' AND u.TABLE_NAME IS NOT NULL
21	0.0657	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'userRoles' and u.REFERENCED_TABLE_NAME IS NOT NULL
22	0.0008	SHOW FULL COLUMNS FROM `roles`
23	0.0006	SHOW INDEX FROM `roles`
24	0.0977	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'roles' AND u.TABLE_NAME IS NOT NULL
25	0.0702	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'roles' and u.REFERENCED_TABLE_NAME IS NOT NULL
26	0.0659	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'DataMgmt_Users' and u.REFERENCED_TABLE_NAME IS NOT NULL
27	0.0026	SHOW FULL COLUMNS FROM `sessions`
28	0.0006	SHOW INDEX FROM `sessions`
29	0.0907	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'sessions' AND u.TABLE_NAME IS NOT NULL
30	0.0368	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'sessions' and u.REFERENCED_TABLE_NAME IS NOT NULL
31	0.001	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`.`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 = 'b2d47bb1345a256d93097c1826e25df5' ORDER BY expires DESC LIMIT 1
32	0.001	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`.`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 = 'b2d47bb1345a256d93097c1826e25df5' ORDER BY expires DESC LIMIT 1
33	0.0005	SELECT `t0`.`role` FROM `userRoles` t0 WHERE (`t0`.`userID` IS NULL) GROUP BY `t0`.`role`
34	0.0005	SHOW INDEX FROM `auxRegions`
35	0.0005	SELECT `t0`.`role`, `t0`.`level` FROM `roles` t0
36	0.0008	SHOW FULL COLUMNS FROM `regions`
37	0.0006	SHOW INDEX FROM `regions`
38	0.0377	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'regions' AND u.TABLE_NAME IS NOT NULL
39	0.0007	SHOW FULL COLUMNS FROM `DataMgmt_Services`
40	0.0005	SHOW INDEX FROM `DataMgmt_Services`
41	0.0005	SELECT `t0`.`ServiceType`, `t0`.`ServiceName` FROM `DataMgmt_Services` t0 WHERE (`t0`.`active` = 1) ORDER BY `t0`.`ServiceType` ASC
42	0.0381	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'DataMgmt_Services' AND u.TABLE_NAME IS NOT NULL
43	0.0009	SHOW FULL COLUMNS FROM `clientServices`
44	0.0005	SHOW INDEX FROM `clientServices`
45	0.0376	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'clientServices' AND u.TABLE_NAME IS NOT NULL
46	0.0339	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'clientServices' and u.REFERENCED_TABLE_NAME IS NOT NULL
47	0.0009	SHOW FULL COLUMNS FROM `legalXtractSearch`
48	0.0006	SHOW INDEX FROM `legalXtractSearch`
49	0.0381	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'legalXtractSearch' AND u.TABLE_NAME IS NOT NULL
50	0.0329	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'legalXtractSearch' and u.REFERENCED_TABLE_NAME IS NOT NULL
51	0.035	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'DataMgmt_Services' and u.REFERENCED_TABLE_NAME IS NOT NULL
52	0.0007	SHOW FULL COLUMNS FROM `countries`
53	0.0007	SHOW FULL COLUMNS FROM `portfolioInd`
54	0.0005	SHOW INDEX FROM `countries`
55	0.0005	SHOW INDEX FROM `secNotes`
56	0.038	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'countries' AND u.TABLE_NAME IS NOT NULL
57	0.0008	SHOW FULL COLUMNS FROM `clientAddress`
58	0.0005	SHOW INDEX FROM `clientAddress`
59	0.0382	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'clientAddress' AND u.TABLE_NAME IS NOT NULL
60	0.0005	SHOW INDEX FROM `clientBilling`
61	0.0371	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'clientBilling' AND u.TABLE_NAME IS NOT NULL
62	0.0344	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'clientBilling' and u.REFERENCED_TABLE_NAME IS NOT NULL
63	0.0337	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'clientAddress' and u.REFERENCED_TABLE_NAME IS NOT NULL
64	0.0007	SHOW FULL COLUMNS FROM `countryAliases`
65	0.0007	SHOW FULL COLUMNS FROM `lxDataCompareItem`
66	0.0005	SHOW INDEX FROM `countryAliases`
67	0.0387	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'countryAliases' AND u.TABLE_NAME IS NOT NULL
68	0.0342	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'countryAliases' and u.REFERENCED_TABLE_NAME IS NOT NULL
69	0.0014	SHOW FULL COLUMNS FROM `customSecurity`
70	0.0008	SHOW INDEX FROM `customSecurity`
71	0.0387	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'customSecurity' AND u.TABLE_NAME IS NOT NULL
72	0.0007	SHOW FULL COLUMNS FROM `auxRegions`
73	0.0389	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'auxRegions' AND u.TABLE_NAME IS NOT NULL
74	0.0347	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'auxRegions' and u.REFERENCED_TABLE_NAME IS NOT NULL
75	0.0007	SHOW FULL COLUMNS FROM `customSecurityXref`
76	0.0005	SHOW INDEX FROM `customSecurityXref`
77	0.0374	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'customSecurityXref' AND u.TABLE_NAME IS NOT NULL
78	0.0329	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'customSecurityXref' and u.REFERENCED_TABLE_NAME IS NOT NULL
79	0.0007	SHOW FULL COLUMNS FROM `legalAdvisors`
80	0.0007	SHOW FULL COLUMNS FROM `exchanges`
81	0.0005	SHOW INDEX FROM `legalAdvisors`
82	0.0377	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'legalAdvisors' AND u.TABLE_NAME IS NOT NULL
83	0.0385	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'legalAdvisors' and u.REFERENCED_TABLE_NAME IS NOT NULL
84	0.0006	SHOW INDEX FROM `lxDataCompareItem`
85	0.0378	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'lxDataCompareItem' AND u.TABLE_NAME IS NOT NULL
86	0.0331	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'lxDataCompareItem' and u.REFERENCED_TABLE_NAME IS NOT NULL
87	0.0013	SHOW FULL COLUMNS FROM `lxDataConvertible`
88	0.0005	SHOW INDEX FROM `lxDataConvertible`
89	0.0384	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'lxDataConvertible' AND u.TABLE_NAME IS NOT NULL
90	0.0395	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'lxDataConvertible' and u.REFERENCED_TABLE_NAME IS NOT NULL
91	0.0007	SHOW FULL COLUMNS FROM `secIds`
92	0.0006	SHOW INDEX FROM `secIds`
93	0.0414	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'secIds' AND u.TABLE_NAME IS NOT NULL
94	0.0372	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'secIds' and u.REFERENCED_TABLE_NAME IS NOT NULL
95	0.0007	SHOW FULL COLUMNS FROM `secNotes`
96	0.0373	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'secNotes' AND u.TABLE_NAME IS NOT NULL
97	0.0324	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'secNotes' and u.REFERENCED_TABLE_NAME IS NOT NULL
98	0.0327	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'customSecurity' and u.REFERENCED_TABLE_NAME IS NOT NULL
99	0.0008	SHOW FULL COLUMNS FROM `customSite`
100	0.0005	SHOW INDEX FROM `customSite`
101	0.0005	SELECT `t0`.* FROM `DataMgmt_Services` t0 WHERE (`t0`.`active` = 1)
102	0.0372	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'customSite' AND u.TABLE_NAME IS NOT NULL
103	0.0341	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'customSite' and u.REFERENCED_TABLE_NAME IS NOT NULL
104	0.0008	SHOW FULL COLUMNS FROM `tickerLinks`
105	0.0006	SHOW INDEX FROM `tickerLinks`
106	0.0375	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'tickerLinks' AND u.TABLE_NAME IS NOT NULL
107	0.0008	SHOW FULL COLUMNS FROM `newsLinks`
108	0.0005	SHOW INDEX FROM `newsLinks`
109	0.0005	SELECT `t0`.* FROM `regions` t0 WHERE (`t0`.`region` = 'US')
110	0.0377	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'newsLinks' AND u.TABLE_NAME IS NOT NULL
111	0.0007	SHOW FULL COLUMNS FROM `newsLinkRegionService`
112	0.0005	SHOW INDEX FROM `newsLinkRegionService`
113	0.0385	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'newsLinkRegionService' AND u.TABLE_NAME IS NOT NULL
114	0.0336	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'newsLinkRegionService' and u.REFERENCED_TABLE_NAME IS NOT NULL
115	0.0007	SHOW FULL COLUMNS FROM `newsLinkTags`
116	0.0006	SHOW INDEX FROM `newsLinkTags`
117	0.0376	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'newsLinkTags' AND u.TABLE_NAME IS NOT NULL
118	0.0328	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'newsLinkTags' and u.REFERENCED_TABLE_NAME IS NOT NULL
119	0.0007	SHOW FULL COLUMNS FROM `topicTags`
120	0.0005	SHOW INDEX FROM `topicTags`
121	0.0379	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'topicTags' AND u.TABLE_NAME IS NOT NULL
122	0.0336	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'topicTags' and u.REFERENCED_TABLE_NAME IS NOT NULL
123	0.0335	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'newsLinks' and u.REFERENCED_TABLE_NAME IS NOT NULL
124	0.0007	SHOW FULL COLUMNS FROM `tickerLinkExchanges`
125	0.0005	SHOW INDEX FROM `tickerLinkExchanges`
126	0.0377	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'tickerLinkExchanges' AND u.TABLE_NAME IS NOT NULL
127	0.0337	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'tickerLinkExchanges' and u.REFERENCED_TABLE_NAME IS NOT NULL
128	0.0005	SHOW INDEX FROM `exchanges`
129	0.0383	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'exchanges' AND u.TABLE_NAME IS NOT NULL
130	0.0336	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'exchanges' and u.REFERENCED_TABLE_NAME IS NOT NULL
131	0.033	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'tickerLinks' and u.REFERENCED_TABLE_NAME IS NOT NULL
132	0.0006	SHOW FULL COLUMNS FROM `industry`
133	0.0371	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'industry' AND u.TABLE_NAME IS NOT NULL
134	0.0006	SHOW INDEX FROM `portfolioInd`
135	0.0389	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'portfolioInd' AND u.TABLE_NAME IS NOT NULL
136	0.0324	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'portfolioInd' and u.REFERENCED_TABLE_NAME IS NOT NULL
137	0.0339	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'industry' and u.REFERENCED_TABLE_NAME IS NOT NULL
138	0.0007	SHOW FULL COLUMNS FROM `indSector`
139	0.0006	SHOW INDEX FROM `indSector`
140	0.0383	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'indSector' AND u.TABLE_NAME IS NOT NULL
141	0.0007	SHOW FULL COLUMNS FROM `portfolioSector`
142	0.0005	SHOW INDEX FROM `portfolioSector`
143	0.0383	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'portfolioSector' AND u.TABLE_NAME IS NOT NULL
144	0.0338	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'portfolioSector' and u.REFERENCED_TABLE_NAME IS NOT NULL
145	0.0337	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'indSector' and u.REFERENCED_TABLE_NAME IS NOT NULL
146	0.0007	SHOW FULL COLUMNS FROM `currency`
147	0.0007	SHOW FULL COLUMNS FROM `invoiceService`
148	0.0005	SHOW INDEX FROM `currency`
149	0.0416	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'currency' AND u.TABLE_NAME IS NOT NULL
150	0.0005	SHOW INDEX FROM `invoiceService`
151	0.0395	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'invoiceService' AND u.TABLE_NAME IS NOT NULL
152	0.0328	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'invoiceService' and u.REFERENCED_TABLE_NAME IS NOT NULL
153	0.0007	SHOW FULL COLUMNS FROM `invoice`
154	0.0006	SHOW INDEX FROM `invoice`
155	0.0405	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'invoice' AND u.TABLE_NAME IS NOT NULL
156	0.033	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'invoice' and u.REFERENCED_TABLE_NAME IS NOT NULL
157	0.0009	SHOW FULL COLUMNS FROM `lxDataCreditTranche2`
158	0.0006	SHOW INDEX FROM `lxDataCreditTranche2`
159	0.0382	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'lxDataCreditTranche2' AND u.TABLE_NAME IS NOT NULL
160	0.0329	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'lxDataCreditTranche2' and u.REFERENCED_TABLE_NAME IS NOT NULL
161	0.0007	SHOW FULL COLUMNS FROM `termSheetFacility`
162	0.0005	SHOW INDEX FROM `termSheetFacility`
163	0.0389	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.REFERENCED_TABLE_NAME = 'termSheetFacility' AND u.TABLE_NAME IS NOT NULL
164	0.0334	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'termSheetFacility' and u.REFERENCED_TABLE_NAME IS NOT NULL
165	0.0334	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'currency' and u.REFERENCED_TABLE_NAME IS NOT NULL
166	0.0331	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'countries' and u.REFERENCED_TABLE_NAME IS NOT NULL
167	0.0323	select u.TABLE_NAME, u.COLUMN_NAME, u.REFERENCED_TABLE_NAME, u.REFERENCED_COLUMN_NAME, u.CONSTRAINT_NAME, r.UPDATE_RULE, r.DELETE_RULE from information_schema.KEY_COLUMN_USAGE u left join information_schema.REFERENTIAL_CONSTRAINTS r on u.CONSTRAINT_SCHEMA = r.CONSTRAINT_SCHEMA AND u.CONSTRAINT_NAME = r.CONSTRAINT_NAME where u.TABLE_SCHEMA = 'xtract' and u.TABLE_NAME = 'regions' and u.REFERENCED_TABLE_NAME IS NOT NULL
168	0.0007	SELECT `t0`.* FROM `ipLogins` t0
169	0.0005	SELECT `t0`.`ServiceId` AS `_key`, `t0`.`ServiceId` FROM `DataMgmt_Services` t0 WHERE (`t0`.`ServiceType` = 'High Grade')
170	0.0006	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
171	0.0008	SELECT `t0`.`countryCode`, `t0`.`countryName` FROM `countries` t0 ORDER BY `t0`.`countryName` ASC
172	0.0417	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
173	0.0411	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
174	0.0408	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
175	0.0411	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
176	0.0405	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
177	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
178	0.0005	SELECT `t0`.* FROM `regions` t0 WHERE (`t0`.`region` = 'US')
179	0.0004	SELECT `t0`.* FROM `countries` t0 WHERE (`t0`.`countryCode` = 'US')
180	0.0004	SELECT `t0`.* FROM `regions` t0 WHERE (`t0`.`region` = 'EURO')
181	0.0004	SELECT `t0`.* FROM `countries` t0 WHERE (`t0`.`countryCode` = 'GB')
182	0.0004	SELECT `t0`.* FROM `regions` t0 WHERE (`t0`.`region` = 'ASIA')
183	0.0004	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.