Enter now

Why pick and mix when you can walk away with the whole shebang! I’m giving away hampers that are bursting at the seams with the candy you love! These hampers have everything and I mean EVERYTHING! Inside you’ll find incredible classics and recent additions, super sours and sweet delights, small gumballs and gigantic Jawbreakers. To enter this competition just tap on the button below and you could be the new owner of enough sweets to satisfy a small army’s sweet tooth.
Gender

By submitting this form I am consenting to be contacted by Zed Candy for the purposes of this competition and to have my contact information stored for marketing activities.
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'/zeds-hq/competitions';
DECLARE @NodeAliasPath nvarchar(max) = N'/zeds-hq/competitions';
DECLARE @DocumentCulture nvarchar(max) = N'en-IE';
DECLARE @Now datetime2 = '5/28/2018 3:58:24 AM';

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], [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-IE' THEN 2 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/zeds-hq/competitions' 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], [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))) AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
) AS SubData
ORDER BY CMS_P DESC
3.6 kB
 
Table (1 [64], 3.2 kB)
 
ApplicationModule.PostResolveRequestCache 0.016
 
2
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-IE';

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'/zeds-hq', N'/')) AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (2 [157], 8 kB)
 
ApplicationModule.AcquireRequestState 0.000
 
3
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 10
PageContext.CurrentPage_InitComplete 0.000
 
4
(cms.class.generalselect)
DECLARE @ClassID int = 5074;

SELECT *
FROM CMS_Class
WHERE [ClassID] = @ClassID
Table (1 [55], 9 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
5
(cms.alternativeform.generalselect)
SELECT TOP 1 *
FROM CMS_AlternativeForm
WHERE (FormClassID = 5074 AND FormName = 'insert')
PageContext.CurrentPage_InitComplete 0.000
 
6
(cms.class.generalselect)
DECLARE @ClassName nvarchar(max) = N'bizform.competitionentryform';

SELECT [ClassXmlSchema], [ClassTableName]
FROM CMS_Class
WHERE [ClassName] = @ClassName
Table (1 [2], 3.1 kB)
 
PageContext.CurrentPage_InitComplete 0.016
 
7

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('Form_ZEDCandy_CompetitionEntryForm');
Table (1 [1], 22 B)
 
PageContext.CurrentPage_InitComplete 0.000
 
8
(cms.formusercontrol.generalselect)
DECLARE @UserControlCodeName nvarchar(max) = N'DropDownListControl';

SELECT *
FROM CMS_FormUserControl
WHERE [UserControlCodeName] = @UserControlCodeName
Table (1 [34], 5.4 kB)
 
EditingFormControl.CreateChildControls 0.000
 
9
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'.empty';
DECLARE @CultureCode nvarchar(max) = N'en-IE';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
EditingFormControl.CreateChildControls 0.000
 
10
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'.empty';
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
EditingFormControl.CreateChildControls 0.000
 
11
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'general.empty';
DECLARE @CultureCode nvarchar(max) = N'en-IE';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
EditingFormControl.CreateChildControls 0.000
 
12
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'.defaultchoice';
DECLARE @CultureCode nvarchar(max) = N'en-IE';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
0.000
 
13
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'.defaultchoice';
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
EditingFormControl.CreateChildControls 0.000
 
14
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'general.defaultchoice';
DECLARE @CultureCode nvarchar(max) = N'en-IE';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
EditingFormControl.CreateChildControls 0.000
 
15
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'.selectall';
DECLARE @CultureCode nvarchar(max) = N'en-IE';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
0.016
 
16
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'.selectall';
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
EditingFormControl.CreateChildControls 0.000
 
17
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'general.selectall';
DECLARE @CultureCode nvarchar(max) = N'en-IE';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
EditingFormControl.CreateChildControls 0.000
 
18
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'.globalandsite';
DECLARE @CultureCode nvarchar(max) = N'en-IE';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
0.000
 
19
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'.globalandsite';
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
EditingFormControl.CreateChildControls 0.000
 
20
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'general.globalandsite';
DECLARE @CultureCode nvarchar(max) = N'en-IE';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
EditingFormControl.CreateChildControls 0.000
 
21
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'.global';
DECLARE @CultureCode nvarchar(max) = N'en-IE';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
0.000
 
22
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'.global';
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
EditingFormControl.CreateChildControls 0.000
 
23
(cms.resourcestring.generalselect)
DECLARE @StringKey nvarchar(max) = N'general.global';
DECLARE @CultureCode nvarchar(max) = N'en-IE';

SELECT TOP 1 [TranslationText]
FROM View_CMS_ResourceString_Joined
WHERE [TranslationText] IS NOT NULL AND [StringKey] = @StringKey AND [CultureCode] = @CultureCode
EditingFormControl.CreateChildControls 0.000
 
24
(cms.formusercontrol.generalselect)
DECLARE @UserControlCodeName nvarchar(max) = N'RadioButtonsControl';

SELECT *
FROM CMS_FormUserControl
WHERE [UserControlCodeName] = @UserControlCodeName
Table (1 [34], 6.2 kB)
 
EditingFormControl.CreateChildControls 0.000
 
25
(cms.formusercontrol.generalselect)
DECLARE @UserControlCodeName nvarchar(max) = N'CheckBoxControl';

SELECT *
FROM CMS_FormUserControl
WHERE [UserControlCodeName] = @UserControlCodeName
Table (1 [34], 319 B)
 
0.000
 
26
(cms.menuitem.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-IE';

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 = 8) AND [DocumentCulture] = @DocumentCulture
Table (1 [161], 3.6 kB)
 
ContentPage.OnLoad 0.016
 
  26 queries, 9.5 kB write, 39 kB read   0.078