Local One does it all – lights, sound, video, scenery and rigging, special effects.

Whatever your production needs may be, however big or small, we have a group of talented professional stage employees who are known for their dedication and unique abilities.

How to Hire Local One

Local One has served the entertainment industry in New York City for more than 132 years.

How to Become a Member

As a Local One member, you will earn better wages and benefits than stagehands and technicians who aren’t union members.

Happenings

1932640_1475574859330042_1579849538_o

Our 132 Year History

What hasn't changed in all that time? Our love of the craft, doing a tough job well, and the pride in being the best.

 

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/home';
DECLARE @NodeAliasPath nvarchar(max) = N'/public/home';
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/home' 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/home")
@NodeAliasPath ("/public/home")
@DocumentCulture ("en-US")
3.5 kB
 
Table (1 [65], 2.7 kB)
 
SimpleHandler`2.StartEvent 0.016
 
2
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 25748;

SELECT *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
@PageTemplateID (25748)
117 B
 
Table (1 [33], 33 kB)
 
SimpleHandler`2.StartEvent 0.000
 
3
(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', N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
375 B
 
Table (2 [157], 4 kB)
 
SimpleHandler`2.StartEvent 0.000
 
4
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 4
PageContext.CurrentPage_InitComplete 0.016
 
5
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'iatse.carousel';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("iatse.carousel")
160 B
 
Table (1 [2], 2.3 kB)
 
BasicRepeater.OnLoad 0.000
 
6

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('IATSE_Carousel');
Table (1 [1], 10 B)
 
BasicRepeater.OnLoad 0.000
 
7
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 5353)
BasicRepeater.OnLoad 0.016
 
8
(iatse.carousel.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/10/2020 5:35:17 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/public/Home/CarouselSlides/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN IATSE_Carousel AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[CarouselID] AND V.ClassName = N'IATSE.Carousel' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
ORDER BY NodeLevel, NodeOrder, NodeName
@NodeSiteID (1)
@Now (4/10/2020 5:35:17 AM)
@NodeAliasPath ("/public/Home/CarouselSlides/%")
@DocumentCulture ("en-US")
854 B
 
Table (3 [163], 2.9 kB)
 
BasicRepeater.OnLoad 0.000
 
9
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE ([TransformationClassID] = 5353 AND [TransformationName] = N'slide_en-US')
BasicRepeater.OnLoad 0.000
 
10
(iatse.events.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/10/2020 5:35:17 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/public/Events/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT TOP 2 *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_IATSE_Event AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[EventsID] AND V.ClassName = N'IATSE.Events' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND ((EventDate >= '4/10/2020 5:35:17 AM')) AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
ORDER BY EventDate ASC
@NodeSiteID (1)
@Now (4/10/2020 5:35:17 AM)
@NodeAliasPath ("/public/Events/%")
@DocumentCulture ("en-US")
862 B
 
Table (2 [164], 2.1 kB)
 
BasicRepeater.OnLoad 0.014
 
11
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE ([TransformationClassID] = 5375 AND [TransformationName] = N'Home_en-US')
BasicRepeater.OnLoad 0.000
 
12
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'iatse.announce';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("iatse.announce")
160 B
 
Table (1 [2], 2 kB)
 
BasicRepeater.OnLoad 0.000
 
13

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('IATSE_Announce');
Table (1 [1], 10 B)
 
BasicRepeater.OnLoad 0.000
 
14
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 5354)
BasicRepeater.OnLoad 0.000
 
15
(iatse.announce.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/10/2020 5:35:17 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/public/Home/AnnouncementSlides/%';
DECLARE @DocumentCulture nvarchar(max) = N'en-US';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN IATSE_Announce AS C WITH (NOLOCK) ON [V].[DocumentForeignKeyValue] = [C].[AnnounceID] AND V.ClassName = N'IATSE.Announce' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeSiteID] = @NodeSiteID AND (([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now)) AND [NodeAliasPath] LIKE @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
@NodeSiteID (1)
@Now (4/10/2020 5:35:17 AM)
@NodeAliasPath ("/public/Home/AnnouncementSlides/%")
@DocumentCulture ("en-US")
821 B
 
Table (2 [162], 2 kB)
 
BasicRepeater.OnLoad 0.016
 
16
(cms.transformation.generalselect)
SELECT TOP 1 *
FROM CMS_Transformation
WHERE ([TransformationClassID] = 5354 AND [TransformationName] = N'slide_en-US')
BasicRepeater.OnLoad 0.000
 
  16 queries, 8 kB write, 51 kB read   0.076