January 31, 2020
 
Dear Brothers and Sisters,
 
It is with a deep sense of sadness and regret that I must report to you the passing of our retired 74-year member Brother Robert E. Colgan on January 28, 2020.  Brother Colgan worked throughout the Local One Jurisdiction and was the Head Electrician at the Winter Garden Theatre and the Helen Hayes Theatre. He was born in 1923 and was initiated into Local One in 1946.   He will be missed by family and friends alike.  May he rest in peace.
 
Reposing:  Thomas F. Dalton Funeral Home, 47 Jerusalem Avenue, Hicksville, NY 11801.  Phone:  516-931-0262.
 
Viewing:  Saturday, February 1, 2020 from 2:00 p.m. to 4:00 p.m. and 7:00 p.m. and 9:00 p.m. and Sunday, February 2, 2020 from 2:00 p.m. to 4:00 p.m. and 7:00 p.m. to 9:00 p.m. at the funeral home.
 
Funeral Mass:  Monday, February 3, 2020 at 10:00 a.m. at St. Paul the Apostle R.C. Church, 2534 Cedar Swamp Road, Brookville, NY 11753.  Phone:  516-935-1880.  
 
Interment:  Monday, February 3, 2020 at 12:00 Noon at Holy Rood Cemetery, 111 Old Country Road, Westbury, NY 11590.
 
In lieu of flowers, donations in Robert E. Colgan’s memory can be made to the Wounded Warrior Project at https://www.woundedwarriorproject.org/.
 
Fraternally,
 
Robert C. Score
Recording-Corresponding Secretary

 
 
 

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/News/Obituary/THE-PASSING-OF-OUR-BROTHER-ROBERT-COLGAN';
DECLARE @NodeAliasPath nvarchar(max) = N'/public/News/Obituary/THE-PASSING-OF-OUR-BROTHER-ROBERT-COLGAN';
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/News/Obituary/THE-PASSING-OF-OUR-BROTHER-ROBERT-COLGAN' 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/News/Obituary/THE-PASSING-OF-OUR-BROTHER-ROBERT-COLGAN")
@NodeAliasPath ("/public/News/Obituary/THE-PASSING-OF-OUR-BROTHER-ROBERT-COLGAN")
@DocumentCulture ("en-US")
3.7 kB
 
Table (1 [65], 3.2 kB)
 
SimpleHandler`2.StartEvent 0.000
 
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/News/Obituary', N'/public/News', N'/public', N'/') AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
418 B
 
Table (4 [157], 5.5 kB)
 
SimpleHandler`2.StartEvent 0.016
 
3
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 4067
PageContext.CurrentPage_InitComplete 0.000
 
4
(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 = 4095) AND [DocumentCulture] = @DocumentCulture
@DocumentCulture ("en-US")
396 B
 
Table (1 [161], 3.6 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
5
(.generalselect)
DECLARE @NodeID int = 559;
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 (559)
@DocumentCulture ("en-US")
@CMS_C (1)
618 B
 
Table (1 [162], 774 B)
 
PageContext.CurrentPage_InitComplete 0.000
 
  5 queries, 5.2 kB write, 13 kB read   0.016