You can contact Local One directly by selecting one of the Officers and Staff members or by filling out the form below.

320 West 46th Street 
New York, NY 10036-8399
Telephone (212) 333-2500
Outside NYC (800) 745-0045
Fax (212) 586-2437 
Web http://www.iatselocalone.org
Inquiries to: Recording-Corresponding Secretary Robert C. Score

Email

 
President James J. Claffey Jr
Vice-President Adam Braunstein
Treasurer Robert Toby McDonough
Rec Corresponding Secretary Robert C. Score
Theatrical Business Mgr. Paul F. Dean Jr.
Theatrical Business Mgr. Kevin McGarty
Television Business Mgr. Edward j. McMahon Jr
Television Business Mgr. Robert Nimmo
Chairman, Board of Trustees Frank Lazarto
Trustee Joseph Valentino
Trustee Eileen Macdonald
Admin Secretary Michael A Caffrey
Financial Secretary Anthony Manno
Replacement Rm Chairman Bobby Terrill Jr
 

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/Public-Misc-Pages/Contact-Us';
DECLARE @NodeAliasPath nvarchar(max) = N'/public/Public-Misc-Pages/Contact-Us';
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/Public-Misc-Pages/Contact-Us' 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/Public-Misc-Pages/Contact-Us")
@NodeAliasPath ("/public/Public-Misc-Pages/Contact-Us")
@DocumentCulture ("en-US")
3.6 kB
 
Table (1 [65], 5.8 kB)
 
SimpleHandler`2.StartEvent 0.692
 
2
(cms.pagetemplate.generalselect)
DECLARE @PageTemplateID int = 25783;

SELECT *
FROM CMS_PageTemplate
WHERE [PageTemplateID] = @PageTemplateID
@PageTemplateID (25783)
117 B
 
Table (1 [33], 13.9 kB)
 
SimpleHandler`2.StartEvent 0.016
 
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/Public-Misc-Pages', N'/public', N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
405 B
 
Table (3 [157], 4.7 kB)
 
SimpleHandler`2.StartEvent 0.000
 
4
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 428
PageContext.CurrentPage_InitComplete 0.000
 
5
(cms.webpart.generalselect)
DECLARE @WebPartID int = 203;

SELECT *
FROM CMS_WebPart
WHERE [WebPartID] = @WebPartID
@WebPartID (203)
95 B
 
Table (1 [20], 3.7 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
6
(cms.form.generalselect)
SELECT *
FROM CMS_Form
Table (3 [25], 599 B)
 
PageContext.CurrentPage_InitComplete 0.016
 
7
(cms.alternativeform.generalselect)
SELECT TOP 1 *
FROM CMS_AlternativeForm
WHERE ([FormClassID] = 5380 AND [FormName] = N'insert')
PageContext.CurrentPage_InitComplete 0.000
 
8
(cms.formusercontrol.generalselect)
DECLARE @UserControlCodeName nvarchar(max) = N'DropDownListControl';

SELECT *
FROM CMS_FormUserControl
WHERE [UserControlCodeName] = @UserControlCodeName
@UserControlCodeName ("DropDownListControl")
177 B
 
Table (1 [34], 5.4 kB)
 
EditingFormControl.InitializeControl 0.258
 
9
(cms.formusercontrol.generalselect)
DECLARE @UserControlCodeName nvarchar(max) = N'TextAreaControl';

SELECT *
FROM CMS_FormUserControl
WHERE [UserControlCodeName] = @UserControlCodeName
@UserControlCodeName ("TextAreaControl")
169 B
 
Table (1 [34], 18.8 kB)
 
0.000
 
10
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.WebPartContainer';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.WebPartContainer")
172 B
 
Table (1 [2], 2.6 kB)
 
CMSAbstractWebPart.OnPreRender 0.031
 
11
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'CMS.WebPartContainer';

SELECT *
FROM CMS_Class
WHERE [ClassName] = @ClassName
@ClassName ("CMS.WebPartContainer")
139 B
 
Table (1 [55], 7.1 kB)
 
CMSAbstractWebPart.OnPreRender 0.039
 
12
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'selectall' AND ClassID = 929)
CMSAbstractWebPart.OnPreRender 0.000
 
13
(cms.query.generalselect)
SELECT TOP 1 *
FROM CMS_Query
WHERE (QueryName = N'generalselect' AND ClassID = 929)
CMSAbstractWebPart.OnPreRender 0.000
 
14
(cms.webpartcontainer.generalselect)
SELECT *
FROM CMS_WebPartContainer
Table (9 [8], 1.3 kB)
 
CMSAbstractWebPart.OnPreRender 0.000
 
15
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'general.submit';
DECLARE @CultureCode nvarchar(max) = N'en-US';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
@StringKey ("general.submit")
@CultureCode ("en-US")
290 B
 
LocalizedButton.OnPreRender 0.016
 
  15 queries, 5.6 kB write, 64 kB read   1.067