Why Local One?

Local One has served the entertainment industry in New York City for more than 131 years. Our experienced, skilled professionals and our "can do" attitudes translate into the best bang for your production dollar in New York City. You have the personal assurance that your project will be executed to the highest standards and your satisfaction guaranteed.

Need a stage exhibit? Built or rented, we have the shops and craftsmen to make your concepts a reality.

Need lighting or sound equipment? Knowledgeable representatives are waiting to tailor a package to your needs.

Need a crew? We are lighting directors, property persons, stage and studio electricians, set carpenters, sound and audio technicians, moving-light operators, riggers, special effects people, and tele-prompters.

Our clients represent a "Who's Who" of the industry: ABC, CBS, NBC, FOX, PBS, WPIX, StudiosUSA, FX (cable), Disney, The Shubert, Nederlander, and Jujamcyn Organizations, The Metropolitan Opera, Lincoln Center, Madison Square Garden, and Radio City Music Hall. This is just a partial list of the venues we serve!

We are dedicated to making your project a success. Our primary goal is to guide you through all aspects of the New York City production scene. We work with and accommodate any size show or budget. We tailor rates and manpower to your immediate needs.

So put the backing, clout, and resources of IATSE Local One behind your next production. Satisfaction is guaranteed!

Planning an Event in NYC? Contact one of our Business Managers

Member Login
SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
1
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentUrlPath nvarchar(max) = N'/public/Hire-Local-One/Why-Local-One';
DECLARE @NodeAliasPath nvarchar(max) = N'/public/Hire-Local-One/Why-Local-One';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT TOP 1 [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild], CASE WHEN [DocumentCulture] = N'en-US' THEN 2 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/public/Hire-Local-One/Why-Local-One' THEN 4 ELSE 0 END + CASE WHEN [NodeLinkedNodeID] IS NULL THEN 8 ELSE 0 END AS [CMS_P]
FROM (
SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE ([NodeSiteID] = @NodeSiteID AND (([DocumentUrlPath] = @DocumentUrlPath AND ([DocumentUrlPath] <> [NodeAliasPath])) OR ([NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)))
) AS SubData
ORDER BY CMS_P DESC
@NodeSiteID (1)
@DocumentUrlPath ("/public/Hire-Local-One/Why-Local-One")
@NodeAliasPath ("/public/Hire-Local-One/Why-Local-One")
@DocumentCulture ("en-US")
3.6 kB
 
Table (1 [65], 2.4 kB)
 
SimpleHandler`2.StartEvent 0.016
 
2
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.WorkflowStep';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.WorkflowStep")
164 B
 
Table (1 [2], 4.2 kB)
 
SimpleHandler`2.StartEvent 0.016
 
3
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.WorkflowStep';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.WorkflowStep")
131 B
 
Table (1 [55], 12.8 kB)
 
SimpleHandler`2.StartEvent 0.000
 
4

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('CMS_WorkflowStep');
Table (1 [1], 6 B)
 
SimpleHandler`2.StartEvent 0.000
 
5
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 172)
SimpleHandler`2.StartEvent 0.000
 
6
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 172)
SimpleHandler`2.StartEvent 0.000
 
7
(cms.workflowstep.generalselect)
DECLARE @StepID int = 255;

SELECT *
FROM CMS_WorkflowStep
WHERE [StepID] = @StepID
@StepID (255)
91 B
 
Table (1 [23], 132 B)
 
SimpleHandler`2.StartEvent 0.000
 
8
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Workflow';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Workflow")
156 B
 
Table (1 [2], 4.8 kB)
 
SimpleHandler`2.StartEvent 0.016
 
9
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Workflow';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Workflow")
123 B
 
Table (1 [55], 16.4 kB)
 
SimpleHandler`2.StartEvent 0.000
 
10

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('CMS_Workflow');
Table (1 [1], 10 B)
 
SimpleHandler`2.StartEvent 0.000
 
11
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 171)
SimpleHandler`2.StartEvent 0.000
 
12
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 171)
SimpleHandler`2.StartEvent 0.000
 
13
(cms.workflow.generalselect)
DECLARE @WorkflowID int = 46;

SELECT *
FROM CMS_Workflow
WHERE [WorkflowID] = @WorkflowID
@WorkflowID (46)
98 B
 
Table (1 [23], 124 B)
 
SimpleHandler`2.StartEvent 0.000
 
14
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 25752;

SELECT *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
@PageTemplateID (25752)
117 B
 
Table (1 [33], 27 kB)
 
SimpleHandler`2.StartEvent 0.000
 
15
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSRedirectAliasesToMainURL';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
@SiteID (1)
@KeyName ("CMSRedirectAliasesToMainURL")
215 B
 
SimpleHandler`2.StartEvent 0.000
 
16
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSRedirectToMainExtension';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
@SiteID (1)
@KeyName ("CMSRedirectToMainExtension")
213 B
 
SimpleHandler`2.StartEvent 0.000
 
17
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSAnalyticsExcludedURLs';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
@SiteID (1)
@KeyName ("CMSAnalyticsExcludedURLs")
209 B
 
SimpleHandler`2.StartEvent 0.000
 
18
(cms.user.generalselect)
DECLARE @UserID int = 65;

SELECT *
FROM CMS_User
WHERE [UserID] = @UserID
@UserID (65)
82 B
 
Table (1 [42], 185 B)
 
SimpleHandler`2.StartEvent 0.000
 
19
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.UserSettings';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.UserSettings")
164 B
 
Table (1 [2], 11.1 kB)
 
SimpleHandler`2.StartEvent 0.000
 
20
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.UserSettings';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.UserSettings")
131 B
 
Table (1 [55], 28 kB)
 
SimpleHandler`2.StartEvent 0.000
 
21
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 1768)
SimpleHandler`2.StartEvent 0.016
 
22
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 1768)
SimpleHandler`2.StartEvent 0.000
 
23
(cms.usersettings.generalselect)
DECLARE @UserSettingsUserID int = 65;

SELECT *
FROM CMS_UserSettings
WHERE [UserSettingsUserID] = @UserSettingsUserID
@UserSettingsUserID (65)
126 B
 
Table (1 [50], 210 B)
 
SimpleHandler`2.StartEvent 0.000
 
24

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('CMS_UserSettings');
Table (1 [1], 14 B)
 
SimpleHandler`2.StartEvent 0.000
 
25
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSBannedIPEnabled';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
@SiteID (1)
@KeyName ("CMSBannedIPEnabled")
197 B
 
SimpleHandler`2.StartEvent 0.000
 
26
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND [NodeAliasPath] IN (N'/public/Hire-Local-One', N'/public', N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
402 B
 
Table (3 [157], 9.4 kB)
 
SimpleHandler`2.StartEvent 0.016
 
27
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSCheckPagePermissions';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
@SiteID (1)
@KeyName ("CMSCheckPagePermissions")
207 B
 
SimpleHandler`2.StartEvent 0.000
 
28
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSAnalyticsVisitorsSmartCheck';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
@SiteID (1)
@KeyName ("CMSAnalyticsVisitorsSmartCheck")
221 B
 
SimpleHandler`2.StartEvent 0.000
 
29
(cms.settingskey.generalselect)
DECLARE @SiteID int = 1;
DECLARE @KeyName nvarchar(max) = N'CMSTrackSearchCrawlers';

SELECT [KeyValue]
FROM CMS_SettingsKey
WHERE [SiteID] = @SiteID AND [KeyName] = @KeyName
@SiteID (1)
@KeyName ("CMSTrackSearchCrawlers")
205 B
 
SimpleHandler`2.StartEvent 0.016
 
30
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.SearchEngine';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.SearchEngine")
164 B
 
Table (1 [2], 2.6 kB)
 
SimpleHandler`2.StartEvent 0.000
 
31
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.SearchEngine';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.SearchEngine")
131 B
 
Table (1 [55], 6.3 kB)
 
SimpleHandler`2.StartEvent 0.000
 
32
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 2881)
SimpleHandler`2.StartEvent 0.000
 
33
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 2881)
SimpleHandler`2.StartEvent 0.016
 
34
(cms.searchengine.generalselect)
DECLARE @SearchEngineCrawler nvarchar(max) = N'';

SELECT [SearchEngineID], [SearchEngineCrawler]
FROM CMS_SearchEngine
WHERE ([SearchEngineCrawler] <> @SearchEngineCrawler AND [SearchEngineCrawler] IS NOT NULL)
@SearchEngineCrawler ("")
215 B
 
Table (5 [2], 68 B)
 
SimpleHandler`2.StartEvent 0.000
 
35
(.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @NodeID int = 18;

SELECT TOP 1 [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild], CASE WHEN [DocumentCulture] = N'en-US' THEN 2 ELSE 0 END AS [CMS_P]
FROM (
SELECT [ClassName], [NodeID], [NodeAliasPath], [NodeName], [NodeAlias], [NodeClassID], [NodeParentID], [NodeLevel], [NodeACLID], [NodeSiteID], [NodeGUID], [NodeOrder], [NodeLinkedNodeSiteID], [IsSecuredNode], [NodeCacheMinutes], [NodeSKUID], [NodeDocType], [NodeHeadTags], [NodeInheritPageLevels], [NodeHasChildren], [NodeBodyElementAttributes], [RequiresSSL], [NodeLinkedNodeID], [NodeOwner], [NodeTemplateForAllCultures], [NodeInheritPageTemplate], [NodeAllowCacheInFileSystem], [NodeTemplateID], [NodeGroupID], [NodeBodyScripts], [DocumentMenuClass], [DocumentMenuItemInactive], [DocumentMenuStyle], [DocumentMenuItemHideInNavigation], [DocumentContent], [DocumentStylesheetID], [DocumentInheritsStylesheet], [DocumentID], [DocumentName], [DocumentNamePath], [DocumentPublishFrom], [DocumentPublishTo], [DocumentUrlPath], [DocumentCulture], [DocumentPageTitle], [DocumentPageKeyWords], [DocumentPageDescription], [DocumentMenuCaption], [DocumentPageTemplateID], [DocumentMenuRedirectUrl], [DocumentMenuJavascript], [DocumentCheckedOutVersionHistoryID], [DocumentPublishedVersionHistoryID], [DocumentWorkflowStepID], [DocumentExtensions], [DocumentWebParts], [DocumentGroupWebParts], [DocumentTrackConversionName], [DocumentConversionValue], [DocumentWorkflowCycleGUID], [DocumentGUID], [DocumentSearchExcluded], [DocumentLogVisitActivity], [DocumentMenuRedirectToFirstChild]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE ([DocumentCulture] = @DocumentCulture AND [NodeID] = @NodeID)
) AS SubData
ORDER BY CMS_P DESC
@DocumentCulture ("en-US")
@NodeID (18)
3.1 kB
 
Table (1 [65], 5 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
36
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 25751;

SELECT *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
@PageTemplateID (25751)
117 B
 
Table (1 [33], 57 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
37
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 19
PageContext.CurrentPage_InitComplete 0.000
 
38
(cms.menuitem.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[MenuItemID] AND V.ClassName = N'CMS.MenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE (NodeID = 19) AND [DocumentCulture] = @DocumentCulture
@DocumentCulture ("en-US")
394 B
 
Table (1 [161], 2.7 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
39
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Relationship';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Relationship")
164 B
 
Table (1 [2], 1.5 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
40
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.Relationship';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.Relationship")
131 B
 
Table (1 [55], 3.5 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
41

SELECT c.name
FROM sys.indexes AS i
INNER JOIN sys.index_columns AS ic ON i.object_id = ic.object_id AND i.index_id = ic.index_id
INNER JOIN sys.columns AS c ON i.object_id = c.object_id AND c.column_id = ic.column_id
WHERE i.is_primary_key = 1 AND i.object_id = OBJECT_ID('CMS_Relationship');
Table (1 [1], 14 B)
 
PageContext.CurrentPage_InitComplete 0.016
 
42
(cms.tree.generalselect)
DECLARE @NodeID int = 18;

SELECT *
FROM CMS_Tree
WHERE [NodeID] = @NodeID
@NodeID (18)
82 B
 
Table (1 [34], 187 B)
 
PageContext.CurrentPage_InitComplete 0.000
 
43
(.generalselect)
DECLARE @NodeID int = 18;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';
DECLARE @CMS_C int = 1;

SELECT *
FROM (
SELECT *, ROW_NUMBER() OVER (PARTITION BY NodeID ORDER BY CASE WHEN [DocumentCulture] = @DocumentCulture THEN 1 ELSE 2 END, DocumentCulture) AS [CMS_C]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_MenuItem AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[MenuItemID] AND V.ClassName = N'CMS.MenuItem' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeID] = @NodeID
) AS SubData
WHERE [CMS_C] = @CMS_C
@NodeID (18)
@DocumentCulture ("en-US")
@CMS_C (1)
617 B
 
Table (1 [162], 5.4 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
44
(cms.user.generalselect)
DECLARE @UserName nvarchar(max) = N'administrator';

SELECT *
FROM CMS_User
WHERE [UserName] = @UserName
@UserName ("administrator")
121 B
 
Table (1 [42], 399 B)
 
PageContext.CurrentPage_InitComplete 0.000
 
45
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/10/2020 3:53:03 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/public/Hire-Local-One/%';
DECLARE @NodeLevel int = 3;
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT [ClassName], [DocumentCulture], [DocumentGUID], [DocumentModifiedWhen], [DocumentMenuCaption], [DocumentMenuClass], [DocumentMenuClassHighLighted], [DocumentShowInSiteMap], [DocumentMenuItemHideInNavigation], [DocumentMenuItemImage], [DocumentMenuItemImageHighlighted], [DocumentMenuItemInactive], [DocumentMenuItemLeftImage], [DocumentMenuItemLeftImageHighlighted], [DocumentMenuItemRightImage], [DocumentMenuItemRightImageHighlighted], [DocumentMenuJavascript], [DocumentMenuRedirectUrl], [DocumentMenuRedirectToFirstChild], [DocumentMenuStyle], [DocumentMenuStyleHighlighted], [DocumentName], [DocumentUrlPath], [NodeAliasPath], [NodeID], [NodeHasChildren], [NodeClassID], [NodeLevel], [NodeLinkedNodeID], [NodeParentID], [NodeSiteID], [NodeACLID], [NodeOwner], [NodeOrder], [NodeName], [DocumentSitemapSettings]
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE ([NodeSiteID] = @NodeSiteID AND (DocumentMenuItemHideInNavigation = 0)) AND ([ClassName] = N'CMS.MenuItem') AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeLevel, NodeOrder, DocumentName
@NodeSiteID (1)
@Now (4/10/2020 3:53:03 AM)
@NodeAliasPath ("/public/Hire-Local-One/%")
@NodeLevel (3)
@DocumentCulture ("en-US")
1.6 kB
 
Table (2 [36], 452 B)
 
CMSListMenu.OnLoad 0.000
 
  45 queries, 15.6 kB write, 202 kB read   0.156