SELECT HTMLContent.PageKey, HTMLContent.PageHeading, HTMLContent.PageContent, HTMLContent.NumLatestArticles, HTMLContent.Thumbnail, HTMLContent.DateCreated, HTMLArticles.Thumbnail AS ArticleThumbnail, HTMLArticles.StartDate, HTMLArticles.EndDate FROM HTMLContent INNER JOIN HTMLContent_XREF ON HTMLContent.ID = HTMLContent_XREF.ContentID INNER JOIN HTMLArticles ON HTMLContent.ID = HTMLArticles.ContentID WHERE ISNULL(HTMLArticles.Display,1) <> 0 AND HTMLContent.SiteID = 1 AND HTMLContent_XREF.ParentContentID IN (212) AND (HTMLArticles.ExpirationDate IS NULL OR HTMLArticles.ExpirationDate='' OR HTMLArticles.ExpirationDate >= GETDATE()) ORDER BY HtmlContent.DateCreated DESC, HTMLArticles.OrderPriority ASCshow
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Sidebar Block 1'
-
0.0156247
8.
0.4426469
DBInterface.GetDataTable; LanguageManager.GetAvailableLanguagesForThisPage; MasterPage.Page_Load; Control.OnLoad; show
StoredProcedure
LanguagePageCheck
@PageUrl=/info/privacy/default.aspx
0.0641322
9.
0.4426469
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show
Text
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header Social Links'show
-
0
10.
0.4589774
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show
Text
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header Social Links'show
-
0
11.
0.4746335
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show
Text
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Custom Footer Links 1'show
-
0
12.
0.4746335
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show
Text
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Custom Footer Links 2'show
-
0
13.
0.4746335
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show
Text
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Custom Footer Links 3'show
-
0
14.
0.4902927
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show
Text
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Custom Footer Links 4'show
-
0.0156592
15.
0.4902927
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show
Text
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Custom Footer Links 5'show
-
0
16.
0.4902927
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show
Text
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Footer Location 1'
-
0
17.
0.4902927
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show
Text
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Footer Location 2'
-
0
18.
0.4902927
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show
Text
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Footer Location 3'
-
0
19.
0.4902927
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show
Text
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Footer Location 4'
-
0
20.
0.4902927
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show
Text
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Footer Location 5'
-
0
21.
0.5378031
DBInterface.GetDataTable; GlobalHTMLMiscContent.AddHTMLMiscContent; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; show
Text
SELECT ID FROM HTMLMiscContent_Proposed WHERE SiteID = 1 AND ContentKey = 'Footer Location 5'
-
0.0475104
22.
0.5378031
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show
Text
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Footer Location 6'
-
0
23.
0.5378031
DBInterface.GetDataTable; GlobalHTMLMiscContent.AddHTMLMiscContent; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; show
Text
SELECT ID FROM HTMLMiscContent_Proposed WHERE SiteID = 1 AND ContentKey = 'Footer Location 6'
WITH CatPath (ParentContentID, ContentID, Iteration) AS ( SELECT HTMLContent_XREF.ParentContentID, HTMLContent_XREF.ContentID, 0 FROM HTMLContent_XREF INNER JOIN HTMLContent ON HTMLContent.ID = HTMLContent_XREF.ContentID INNER JOIN HTMLContent AS HTMLContent_1 ON HTMLContent_1.ID = HTMLContent_XREF.ParentContentID WHERE ContentID = 212 UNION ALL SELECT a.ParentContentID, a.ContentID, b.Iteration + 1 FROM HTMLContent_XREF AS a INNER JOIN HTMLContent AS c ON c.ID=a.ContentID INNER JOIN HTMLContent AS d ON d.ID = a.ParentContentID INNER JOIN CatPath AS b ON a.ContentID = b.ParentContentID ) SELECT TOP 20 ParentContentID, ContentID, Iteration FROM CatPath ORDER BY Iteration ASCshow
SELECT ID, PageKey, PageTitle, PageHeading, MenuText, IsMenuItem, CASE WHEN ID = 209 THEN 1 WHEN ID = 212 THEN 2 END AS Sorter FROM HTMLContent WHERE SiteID = 1 AND ID IN (209,212) ORDER BY Sortershow
-
0.0164824
26.
0.5699177
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show
Text
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header Phone Number - RI'show
-
0
27.
0.5699177
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show
Text
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header Phone Number - CA'show
-
0
28.
0.5699177
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show
Text
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header Phone Number - FL'show
-
0
29.
0.5699177
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show
Text
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header Phone Number - RI'show
-
0
30.
0.5699177
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show
Text
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header Phone Number - CA'show
-
0
31.
0.5856112
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show
Text
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header Phone Number - FL'show
-
0.0156935
32.
0.6168887
SqlBASE.GetDataTable; HTMLContent.GetHTMLHeaderLinks; MasterPage.Page_Load; Control.OnLoad; show
Text
SELECT HTMLHeaderLinks.LinkText, HTMLContent.PageHeading, HTMLContent.PageKey FROM dbo.HTMLHeaderLinks INNER JOIN dbo.HTMLContent ON HTMLHeaderLinks.ContentID = HTMLContent.ID WHERE HTMLContent.SiteID = @SiteID ORDER BY HTMLHeaderLinks.OrderPriority, HTMLHeaderLinks.LinkText, HTMLContent.PageHeadingshow
SiteID=1
0.0312775
33.
0.6168887
SqlBASE.GetDataTable; HTMLContent.GetHTMLHeaderLinks; MasterPage.Page_Load; Control.OnLoad; show
Text
SELECT HTMLHeaderLinks.LinkText, HTMLContent.PageHeading, HTMLContent.PageKey FROM dbo.HTMLHeaderLinks INNER JOIN dbo.HTMLContent ON HTMLHeaderLinks.ContentID = HTMLContent.ID WHERE HTMLContent.SiteID = @SiteID ORDER BY HTMLHeaderLinks.OrderPriority, HTMLHeaderLinks.LinkText, HTMLContent.PageHeadingshow
SiteID=1
0
34.
0.6168887
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show
Text
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header - Custom Links'show
-
0
35.
0.6168887
DBInterface.GetDataTable; GlobalHTMLMiscContent.GetSingleHTMLMiscContent; GlobalHTMLMiscContent.GetHTMLMiscContent; MasterPage.Page_Load; show
Text
SELECT TOP(1) ID, Content FROM HTMLMiscContent WHERE SiteID = 1 AND ContentKey = 'Header - Custom Links'show
-
0
36.
0.695782
DBInterface.GetDataTable; BaseUser.GetDefaultSearch; UserSession.get_DefaultSearchAttribute; CatalogGlobalItems.get_oCategoryMenu; show
StoredProcedure
[dbo].[DefaultSearchAttributeGetByUserID]
@g_UserID =964a4800-903b-4e81-9c17-690fb785a5ce
0.0633351
37.
0.7270035
DBInterface.get_oSQLDataReader; VirtualSiteProperties.GetVirtualSiteProperties; VirtualSiteProperties..ctor; MegaMenu.LoadMenu; show
StoredProcedure
[dbo].[VirtualSitePropertiesLoadBySiteID]
@SiteID=1
0.0156248
38.
0.7905682
DBInterface.GetDataTable; MegaMenu.LoadVideoData; MegaMenu.LoadMenu; MegaMenu.Page_Load; show
StoredProcedure
[dbo].[VideoMenu_Load]
-
0.0479395
39.
1.1229086
DBInterface.GetDataTable; MegaMenu.LoadMenu; MegaMenu.Page_Load; Control.OnLoad; show