THE PASSING OF OUR BROTHER THOMAS GIANNONI more info

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], 4.4 kB)
 
SimpleHandler`2.StartEvent 0.357
 
2
(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.006
 
3
(iatse.carousel.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '2/24/2020 9:22:57 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 (2/24/2020 9:22:57 AM)
@NodeAliasPath ("/public/Home/CarouselSlides/%")
@DocumentCulture ("en-US")
854 B
 
Table (4 [163], 3.9 kB)
 
BasicRepeater.OnLoad 0.206
 
4
(iatse.events.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '2/24/2020 9:22:57 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 >= '2/24/2020 9:22:57 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 (2/24/2020 9:22:57 AM)
@NodeAliasPath ("/public/Events/%")
@DocumentCulture ("en-US")
862 B
 
Table (2 [164], 2.1 kB)
 
0.028
 
5
(iatse.announce.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '2/24/2020 9:22:57 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 (2/24/2020 9:22:57 AM)
@NodeAliasPath ("/public/Home/AnnouncementSlides/%")
@DocumentCulture ("en-US")
821 B
 
Table (2 [162], 2 kB)
 
0.007
 
  5 queries, 6.3 kB write, 16.3 kB read   0.604