Local ONE HAS ENDORSED THE FOLLOWING CANDIDATES

NASSAU COUNTY - TOWN HEMPSTEAD
LAURA GILLEN TOWN OF HEMPSTEAD SUPERVISOR
DEBRA MULE NASSAU COUNTY LD 5
LAURA BURNS NASSAU COUNTY LD 6
DEBRA SIEGEL NASSAU COUNTY LD 7
BARBARA HAFNER NASSAU COUNTY LD 8
TOM TWEEDY - TOH DISTRICT 2
SHARI JAMES-PIERRE - TOH DISTRICT 3
LORA WEBSTER - TOH DISTRICT 5

SUFFOLK COUNTY
JOHN KENNEDY SUFFOLK COUNTY EXECUTIVE
TIM SINI - SUFFOLK CTY D.A.
SUSAN BERLAND - SUFFOLK CTY LEGISLATOR
LESLIE KENNEDY - SUFFOLK CTY LEGISLATOR
JUDY PASCALE - SUFFOLK CTY CLERK
ED WEHRHEIM SMITHTOWN TOWN SUPERVISOR
VINCENT PULEO - SMITHTOWN TOWN CLERK
ED ROMAINE - BROOKHAVEN TOWN SUPERVISOR

WESTCHESTER COUNTY - TOWN OF HARRISON
FRANK GORDON FOR MAYOR
LAUREN LEADER FOR TOWN BOARD
MICHAEL ROMITA FOR TOWN BOARD
Public Misc. Pages

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/ENDORSED-CANDIDATES';
DECLARE @NodeAliasPath nvarchar(max) = N'/public/Public-Misc-Pages/ENDORSED-CANDIDATES';
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/ENDORSED-CANDIDATES' 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/ENDORSED-CANDIDATES")
@NodeAliasPath ("/public/Public-Misc-Pages/ENDORSED-CANDIDATES")
@DocumentCulture ("en-US")
3.6 kB
 
Table (1 [65], 5.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/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.016
 
3
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 3798
 PageContext.CurrentPage_InitComplete 0.016
 
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 = 3826) AND [DocumentCulture] = @DocumentCulture
@DocumentCulture ("en-US")
396 B
 
Table (1 [161], 5.6 kB)
 
 PageContext.CurrentPage_InitComplete 0.034
 
5
(cms.tree.generalselect)
DECLARE @NodeID int = 289;

SELECT *
FROM CMS_Tree
WHERE [NodeID] = @NodeID
@NodeID (289)
83 B
 
Table (1 [34], 197 B)
 
 PageContext.CurrentPage_InitComplete 0.000
 
6
(.generalselect)
DECLARE @NodeID int = 289;
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) LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON [V].[NodeSKUID] = [S].[SKUID]
WHERE [NodeID] = @NodeID AND V.ClassName = N'cms.folder'
) AS SubData
WHERE [CMS_C] = @CMS_C
@NodeID (289)
@DocumentCulture ("en-US")
@CMS_C (1)
517 B
 
Table (1 [158], 715 B)
 
 PageContext.CurrentPage_InitComplete 0.000
 
7
(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.013
 
  7 queries, 5.2 kB write, 16.7 kB read   0.078