Refinancing to upgrade? Pick the right agent

Refinancing to upgrade? Pick the right agent

As a homeowner, there may well come a time when your existing property no longer suits your needs. Even if it's a gorgeous property and is close to transport links, a lack of space may lead to you investigating roomier homes. Perhaps space isn't an issue, but the kids are getting older and you want to relocate to an area that's got a better selection of local schools.

Whatever your reasons for packing up and moving on, it's important to follow the right steps when selling, as well as getting  your finances in check.

Choosing the right agent is incredibly important, as well as investigating what home loan interest rates are on offer for your next mortgage. When it comes to picking the right agent, we've got a few pointers.

What do the experts say?

The Real Estate Institute of Victoria (REIV) commented on the importance of obtaining the right agent for your selling needs on June 20.

The REIV explained that the key reasons people take out the services of a licensed agent is to get sound advice and the most favourable price on their property.

From the industry body's perspective, working with a licensed agent is essential, given that they are trained professionals. Being up to date with the latest movements in the property market and knowing which sales techniques are acceptable - and which are not - are invaluable skills.

The industry body also explained what training is required to earn specific titles in the industry.

"A licensed estate agent can own or manage an estate agency and conduct auctions, while an agent's representative is a employed by a licensed estate agent and may work in sales or property management," the REIV noted.

Furthermore, the industry representative explained that agents are experienced in a number of areas, from residential real estate to property management and commercial property. Some agents will focus on a niche area, becoming masters in their chosen field.

The REIV stated that the most important thing to bear in mind as a homeowner is to select a real estate agent who is licensed.

How do I pick a real estate agent?

Even if you've used a mortgage calculator, found a great interest rate and received loan pre-approval, your efforts could go to waste if you don't get the right agent on board to sell your existing property.

When looking for a real estate agent, treat the process like a job interview. Ask your preferred candidates plenty of questions and find out about their previous experience in your area.

There's no point getting an agent who's an inner-city commercial property specialist to sell your three-bedroom home in the suburbs. Think about what kind of property agents have sold before as well as the area they have worked in.

An agent who hasn't worked in your exact suburb but has extensive experience selling properties similar to yours in neighbouring areas could still have the right kind of experience to run a selling campaign for you. Alternatively, you might prefer to get an agent to sell your home who is an expert in your specific suburb. It's up to you who you pick; just be confident they can back up their talk with proof of their successes.

You want to be able to work with someone who is able to communicate with you easily. For many homeowners, real estate jargon can go in one ear and out the other. And it's no wonder; some of it is incredibly technical! Make sure the agent you select is an expert, but ensure they can explain what's going on in straightforward terms.

Image credit: Mark Moz

Follow loans.com.au

x-smallsmallmediumlarge
x-smallsmallmediumlarge
Event handlers called by this request / thread:
 NameContext
1 RequestEvents.Begin.Execute SimpleHandler`2.StartEvent
> HelpersHandlers.BeginRequest
> LicenseHandlers.CheckApplicationValidityAndLicense
> URLRewritingHandlers.BeginRequest
> WebDAVHandlers.PropFindEndRequest
> WIFIntegrationHandlers.ProcessRequest
2 RequestEvents.Authenticate.Execute
> MembershipHandlers.HandleAutomaticSignIn
3 RequestEvents.Authorize.Execute
> URLRewritingHandlers.AuthorizeRequest
4 RequestEvents.PostAuthorize.Execute
> HelpersHandlers.HandleClickjacking
5 RequestEvents.PostResolveRequestCache.Execute
> URLRewritingHandlers.RewriteUrl
6 >> DocumentEvents.GetData SimpleHandler`2.StartEvent
7 >>> TypeInfo(cms.document).Events.GetData SimpleHandler`2.StartEvent
8 >> URLRewritingEvents.ProcessABTest.Execute SimpleHandler`2.StartEvent
>>> ABHandlers.ProcessABTest
9 >> URLRewritingEvents.ProcessRewritingResult SimpleHandler`2.StartEvent
10 RequestEvents.PostMapRequestHandler.Execute SimpleHandler`2.StartEvent
> WebAnalyticsHandlers.LogCampaign
> URLRewritingHandlers.PostMapRequestHandler
> ABHandlers.ExcludeVisitorFromAB
11 ApplicationEvents.SessionStart.Execute
> MembershipHandlers.SessionStart
12 >> SessionEvents.UpdateSession SimpleHandler`2.StartEvent
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
13 >>> TypeInfo(om.contact).Events.Insert SimpleHandler`2.StartEvent
>>>> ObjectEvents.Insert.Before
>>>> ObjectEvents.Insert.After
14 >>>>> TypeInfo(om.contact).Events.LogChange SimpleHandler`2.StartEvent
>>>>> ContinuousIntegrationHandlers.InsertAfter
15 >>> TypeInfo(om.scorecontactrule).Events.GetData SimpleHandler`2.StartEvent
16 >>> SessionEvents.UpdateSessionData.Execute SimpleHandler`2.StartEvent
>>>> DocumentHandlers.UpdateSessionData_Execute
17 RequestEvents.AcquireRequestState.Execute SimpleHandler`2.StartEvent
> HelpersHandlers.InitSessionTimeout
> URLRewritingHandlers.CheckSecurity
> StrandsRecommenderHandlers.BindStrandsToPagePreRender
18 RequestEvents.PostAcquireRequestState.Execute
> MembershipHandlers.UpdateSession
19 >> SessionEvents.UpdateSession SimpleHandler`2.StartEvent
>>> SessionEvents.UpdateSession.Before
>>>> PortalHandlers.UpdateSession_Before
20 >>> TypeInfo(om.contact).Events.GetData SimpleHandler`2.StartEvent
21 >>> SessionEvents.UpdateSessionData.Execute SimpleHandler`2.StartEvent
>>>> DocumentHandlers.UpdateSessionData_Execute
> OutputFilterHandlers.EndRequestByOutputFilter
> WebAnalyticsHandlers.b__0
> WebAnalyticsHandlers.LogPageViewConversion
> WebAnalyticsHandlers.LogUTMParametersAndCampaignConversions
22 >> DocumentEvents.GetData SimpleHandler`2.StartEvent
23 >>> TypeInfo(cms.document).Events.GetData SimpleHandler`2.StartEvent
24 >>>> TypeInfo(cms.versionhistory).Events.GetData SimpleHandler`2.StartEvent
25 >> TypeInfo(om.abvariant).Events.GetData SimpleHandler`2.StartEvent
26 >>> TypeInfo(om.abvariant).Events.GetData SimpleHandler`2.StartEvent
> WebAnalyticsServiceScriptsRenderer.b__0
> ABHandlers.LogABVisit
27 DocumentEvents.GetData PageContext.CurrentPage_InitComplete
28 TypeInfo(cms.document).Events.GetData PageContext.CurrentPage_InitComplete
29 PortalEngineEvents.MVTVariantsEnabled.Execute PageContext.CurrentPage_InitComplete
> MVTHandlers.MVTVariantsEnabled
30 >> DocumentEvents.GetData PageContext.CurrentPage_InitComplete
31 >>> TypeInfo(cms.document.cms.blogpost).Events.GetData PageContext.CurrentPage_InitComplete
32 >> TypeInfo(om.mvtest).Events.GetData PageContext.CurrentPage_InitComplete
33 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
34 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
35 PageInfoEvents.CombinePageTemplateInstance PageContext.CurrentPage_InitComplete
> PageInfoEvents.CombinePageTemplateInstance.After
>> OnlineMarketingHandlers.CombinePageTemplateInstance_After
36 DocumentEvents.GetData BasicRepeater.OnLoad
37 TypeInfo(cms.document.cms.article).Events.GetData BasicRepeater.OnLoad
38 DocumentEvents.GetData BasicRepeater.OnLoad
39 TypeInfo(cms.document.cms.blogpost).Events.GetData BasicRepeater.OnLoad
40 DocumentEvents.GetData BasicRepeater.OnLoad
41 TypeInfo(cms.document.cms.pressrelease).Events.GetData BasicRepeater.OnLoad
42 DocumentEvents.GetData CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender
43 TypeInfo(cms.document.cms.blogpost).Events.GetData CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender
   
File operations performed by this request / thread:
 Action (file access, file mode)
Size (number of accesses)
Size chart
File pathProviderContext
1 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
2 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_HandlersLog.OnPreRender
3 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
4 EXISTS
~/App_Themes/Design/Debug.css Local CMSAdminControls_Debug_FilesLog.OnPreRender
     
Security checks called by this request / thread:
 UserOperationResultResource / Class / IDPermission / UI element / ValueSite / DomainContext
1 This same security check is called more than once within the request. ValidateHash True CurrentDateTime.Hour FIRSTMAC-srvc-kentico CMSWebParts_General_javascript.OnPreRender
2 This same security check is called more than once within the request. ValidateHash True CurrentDateTime.Hour FIRSTMAC-srvc-kentico
3 This same security check is called more than once within the request. ValidateHash True CurrentDateTime.Hour FIRSTMAC-srvc-kentico
4 This same security check is called more than once within the request. ValidateHash True CurrentDateTime.Hour FIRSTMAC-srvc-kentico
        
Cache items accessed by this request / thread:
 AccessCache key
Dependencies
Data
Context
1 ADD pageinfo|www.loans.com.au|/news-hub/october-2014/refinancing-to-upgrade-pick-the-right-agent|en-au|/news-hub/october-2014/refinancing-to-upgrade-pick-the-right-agent|true
template|23462
nodeid|3652
pageinfo
SimpleHandler`2.StartEvent
2 ADD pageinfobyurl|www.loans.com.au|https://www.loans.com.au/news-hub/october-2014/refinancing-to-upgrade-pick-the-right-agent|en-au||true|true
template|23462
nodeid|3652
pageinfo
SimpleHandler`2.StartEvent
3 GET allabtests SimpleHandler`2.StartEvent
4 GET maxmind|172.30.22.250 SimpleHandler`2.StartEvent
5 TOUCH om.contact|all
om.contact|byid|3166254
om.contact|byguid|9a4da1cd-f708-46f1-b168-8647e62b9572
SimpleHandler`2.StartEvent
6 GET cms.searchengine|cachedids|crawlers SimpleHandler`2.StartEvent
7 GET pageinfo|www.loans.com.au|/news-media/news-hub|en-au||false PageContext.CurrentPage_InitComplete
8 ADD pageinfo|www.loans.com.au|/news-media/news-hub/october-2014-(1)|en-au||false
template|23445
nodeid|3587
pageinfo
PageContext.CurrentPage_InitComplete
9 GET pageinfo|www.loans.com.au|/news-media|en-au||false PageContext.CurrentPage_InitComplete
10 ADD pageinfo|www.loans.com.au|/|en-au||false
template|23446
nodeid|1
pageinfo
PageContext.CurrentPage_InitComplete
11 ADD currentdocument|www.loans.com.au|/news-media/news-hub/october-2014-(1)/refinancing-to-upgrade-pick-the-right-agent|en-au
nodes|www.loans.com.au|cms.blogpost|all
node|www.loans.com.au|/news-media/news-hub/october-2014-(1)/refinancing-to-upgrade-pick-the-right-agent
PageContext.CurrentPage_InitComplete
12 GET cmsdatasource||en-au|loans|/news-media/blog/%|en-au|false|cms.blogpost||blogpostdate desc|-1|true|00000000-0000-0000-0000-000000000000|isrelatedto|false|6||false|| BasicRepeater.OnLoad
13 ADD cmsdatasource||en-au|www.loans.com.au|/%|en-au|true|cms.article|||-1|true|4e15da3f-cbc0-41e9-b0db-696b1a06f563|isrelatedto|true|0||false||
webpartinstance|a7695d19-63a2-421c-8272-b6c47da34f52
nodes|www.loans.com.au|cms.article|all
node|www.loans.com.au|/|childnodes
BasicRepeater.OnLoad
14 ADD cmsdatasource||en-au|www.loans.com.au|/%|en-au|true|cms.blogpost|||-1|true|4e15da3f-cbc0-41e9-b0db-696b1a06f563|isrelatedto|true|0||false||
webpartinstance|394f2e77-7a15-44c2-ac8e-6a58bf8640ce
nodes|www.loans.com.au|cms.blogpost|all
node|www.loans.com.au|/|childnodes
15 ADD cmsdatasource||en-au|www.loans.com.au|/%|en-au|true|cms.pressrelease|||-1|true|4e15da3f-cbc0-41e9-b0db-696b1a06f563|isrelatedto|true|0||false||
webpartinstance|36d9cf08-b17c-4f12-ae7d-110df9357271
nodes|www.loans.com.au|cms.pressrelease|all
node|www.loans.com.au|/|childnodes
16 ADD cmsdatasource||en-au|www.loans.com.au|/news-media/news-hub/october-2014-(1)/refinancing-to-upgrade-pick-the-right-agent|en-au|false|cms.blogpost||blogpostdate desc|-1|true|00000000-0000-0000-0000-000000000000||true|0||false||
webpartinstance|8e3fa3b7-068f-478e-b421-d106bafd6ded
nodes|www.loans.com.au|cms.blogpost|all
node|www.loans.com.au|/news-media/news-hub/october-2014-(1)/refinancing-to-upgrade-pick-the-right-agent
CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender
17 GET scriptfile|dialogs/modaldialog.js CMSAdminControls_Debug_CacheLog.OnPreRender
    
Request trace:
 MethodAdditional infoFrom firstDuration
1 RewriteURL /news-hub/october-2014/refinancing-to-upgrade-pick-the-right-agent 0.000
0.031
 
2 PathRewritten ~/CMSPages/PortalTemplate.aspx 0.031
0.063
 
3 > OnPreInit 0.094
0.000
 
4 > OnInit 0.094
0.062
 
5 > OnLoad 0.156
0.016
 
6 > OnPreRender 0.172
N/A
    0.172  
Request cookies:
 NameValue
1 CMSPreferredCultureen-AU
2 ASP.NET_SessionId0b431125kpevyw3fm0njftjx
3 Campaign 
4 Source 
5 CurrentContact9a4da1cd-f708-46f1-b168-8647e62b9572
Response cookies:
 NameValueExpires
1 CMSPreferredCultureen-AU27/04/2018 7:24:37 AM
2 ASP.NET_SessionId0b431125kpevyw3fm0njftjx 
3 Campaign 27/04/2016 7:24:37 AM
4 Source 27/04/2016 7:24:37 AM
5 CurrentContact9a4da1cd-f708-46f1-b168-8647e62b957227/04/2067 7:24:37 AM
Request information:
 NameValue
1 HttpMethodGET
2 UrlReferrer 
3 UserAgentCCBot/2.0 (http://commoncrawl.org/faq/)
4 UserHostAddress172.30.22.250
5 UserName 
6 SessionID0b431125kpevyw3fm0njftjx
7 ServerNameKWFS-A1
SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
new SqlConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
1
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentUrlPath nvarchar(max) = N'/news-hub/october-2014/refinancing-to-upgrade-pick-the-right-agent';
DECLARE @NodeAliasPath nvarchar(max) = N'/news-hub/october-2014/refinancing-to-upgrade-pick-the-right-agent';
DECLARE @DocumentCulture nvarchar(max) = N'en-AU';

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-AU' THEN 2 ELSE 0 END + CASE WHEN [DocumentUrlPath] = N'/news-hub/october-2014/refinancing-to-upgrade-pick-the-right-agent' 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)))
) AS SubData
ORDER BY CMS_P DESC
3.6 kB
 
Table (1 [64], 901 B)
 
SimpleHandler`2.StartEvent 0.000
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
2
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-AU';

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'/News-Media/News-Hub/October-2014-(1)', N'/News-Media/News-Hub', N'/News-Media', N'/')) AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (4 [157], 11.6 kB)
 
SimpleHandler`2.StartEvent 0.000
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
BeginTransaction(ReadCommitted)
SimpleHandler`2.StartEvent N/A
3
(om.contact.generalinsert)
DECLARE @ContactFirstName nvarchar = NULL;
DECLARE @ContactMiddleName nvarchar = NULL;
DECLARE @ContactLastName nvarchar(max) = N'Anonymous - 2017-04-27 07:24:37.324';
DECLARE @ContactSalutation nvarchar = NULL;
DECLARE @ContactTitleBefore nvarchar = NULL;
DECLARE @ContactTitleAfter nvarchar = NULL;
DECLARE @ContactJobTitle nvarchar = NULL;
DECLARE @ContactAddress1 nvarchar = NULL;
DECLARE @ContactAddress2 nvarchar = NULL;
DECLARE @ContactCity nvarchar = NULL;
DECLARE @ContactZIP nvarchar = NULL;
DECLARE @ContactStateID nvarchar = NULL;
DECLARE @ContactCountryID nvarchar = NULL;
DECLARE @ContactMobilePhone nvarchar = NULL;
DECLARE @ContactHomePhone nvarchar = NULL;
DECLARE @ContactBusinessPhone nvarchar = NULL;
DECLARE @ContactEmail nvarchar = NULL;
DECLARE @ContactWebSite nvarchar = NULL;
DECLARE @ContactBirthday nvarchar = NULL;
DECLARE @ContactGender nvarchar = NULL;
DECLARE @ContactStatusID nvarchar = NULL;
DECLARE @ContactNotes nvarchar = NULL;
DECLARE @ContactOwnerUserID nvarchar = NULL;
DECLARE @ContactMonitored bit = 1;
DECLARE @ContactMergedWithContactID nvarchar = NULL;
DECLARE @ContactIsAnonymous bit = 1;
DECLARE @ContactSiteID int = 1;
DECLARE @ContactGUID uniqueidentifier = '9a4da1cd-f708-46f1-b168-8647e62b9572';
DECLARE @ContactLastModified datetime2 = '4/27/2017 7:24:37 AM';
DECLARE @ContactCreated datetime2 = '4/27/2017 7:24:37 AM';
DECLARE @ContactMergedWhen nvarchar = NULL;
DECLARE @ContactGlobalContactID nvarchar = NULL;
DECLARE @ContactBounces nvarchar = NULL;
DECLARE @ContactLastLogon nvarchar = NULL;
DECLARE @ContactCampaign nvarchar = NULL;
DECLARE @ContactSalesForceLeadID nvarchar = NULL;
DECLARE @ContactSalesForceLeadReplicationDisabled nvarchar = NULL;
DECLARE @ContactSalesForceLeadReplicationDateTime nvarchar = NULL;
DECLARE @ContactSalesForceLeadReplicationSuspensionDateTime nvarchar = NULL;
DECLARE @ContactCompanyName nvarchar = NULL;
DECLARE @ContactSalesForceLeadReplicationRequired nvarchar = NULL;
DECLARE @ContactPersonaID nvarchar = NULL;

INSERT INTO OM_Contact ([ContactFirstName], [ContactMiddleName], [ContactLastName], [ContactSalutation], [ContactTitleBefore], [ContactTitleAfter], [ContactJobTitle], [ContactAddress1], [ContactAddress2], [ContactCity], [ContactZIP], [ContactStateID], [ContactCountryID], [ContactMobilePhone], [ContactHomePhone], [ContactBusinessPhone], [ContactEmail], [ContactWebSite], [ContactBirthday], [ContactGender], [ContactStatusID], [ContactNotes], [ContactOwnerUserID], [ContactMonitored], [ContactMergedWithContactID], [ContactIsAnonymous], [ContactSiteID], [ContactGUID], [ContactLastModified], [ContactCreated], [ContactMergedWhen], [ContactGlobalContactID], [ContactBounces], [ContactLastLogon], [ContactCampaign], [ContactSalesForceLeadID], [ContactSalesForceLeadReplicationDisabled], [ContactSalesForceLeadReplicationDateTime], [ContactSalesForceLeadReplicationSuspensionDateTime], [ContactCompanyName], [ContactSalesForceLeadReplicationRequired], [ContactPersonaID])
VALUES (@ContactFirstName, @ContactMiddleName, @ContactLastName, @ContactSalutation, @ContactTitleBefore, @ContactTitleAfter, @ContactJobTitle, @ContactAddress1, @ContactAddress2, @ContactCity, @ContactZIP, @ContactStateID, @ContactCountryID, @ContactMobilePhone, @ContactHomePhone, @ContactBusinessPhone, @ContactEmail, @ContactWebSite, @ContactBirthday, @ContactGender, @ContactStatusID, @ContactNotes, @ContactOwnerUserID, @ContactMonitored, @ContactMergedWithContactID, @ContactIsAnonymous, @ContactSiteID, @ContactGUID, @ContactLastModified, @ContactCreated, @ContactMergedWhen, @ContactGlobalContactID, @ContactBounces, @ContactLastLogon, @ContactCampaign, @ContactSalesForceLeadID, @ContactSalesForceLeadReplicationDisabled, @ContactSalesForceLeadReplicationDateTime, @ContactSalesForceLeadReplicationSuspensionDateTime, @ContactCompanyName, @ContactSalesForceLeadReplicationRequired, @ContactPersonaID);

SELECT SCOPE_IDENTITY() AS [ID]
3.9 kB
 
Table (1 [1], 7 B)
 
SimpleHandler`2.StartEvent 0.000
 
CommitTransaction()
SimpleHandler`2.StartEvent N/A
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
4
(om.scorecontactrule.generalselect)
DECLARE @ContactID int = 3166254;

SELECT DISTINCT [ContactID], [ScoreID], (SUM(Value)) AS [Score]
FROM OM_ScoreContactRule
WHERE ([Expiration] IS NULL OR (DATEDIFF(d, GETDATE(), Expiration) >= 0)) AND [ContactID] = @ContactID
GROUP BY ContactID, ScoreID
SimpleHandler`2.StartEvent 0.000
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
5
(cms.user.updateallsessions)
Proc_CMS_Session_UpdateAll
@SetColumns ("SessionFullName = 'Anonymous - 2017-04-27 07:24:37.324',SessionUserCreated = '4/27/2017 7:24:37 AM'")
@WhereCond ("SessionContactID = 3166254")
151 B
 
SimpleHandler`2.StartEvent 0.000
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
BeginTransaction(ReadCommitted)
N/A
6
(cms.user.updatesession)
Proc_CMS_Session_Update
@SessionIdentifier ("0b431125kpevyw3fm0njftjx")
@SessionUserID ()
@SessionLocation ("/News-Media/News-Hub/October-2014-(1)/Refinancing-to-upgrade-Pick-the-right-agent")
@SessionLastActive (4/27/2017 7:24:37 AM)
@SessionLastLogon (4/27/2017 7:24:37 AM)
@SessionExpires (4/27/2017 7:45:37 AM)
@SessionExpired (False)
@SessionSiteID (1)
@SessionUserIsHidden (True)
@SessionFullName ("Anonymous - 2017-04-27 07:24:37.324")
@SessionEmail ()
@SessionUserName ()
@SessionNickName ()
@SessionUserCreated (4/27/2017 7:24:37 AM)
@SessionContactID (3166254)
221 B
 
Table (1 [1], 4 B)
 
SimpleHandler`2.StartEvent 0.000
 
CommitTransaction()
SimpleHandler`2.StartEvent N/A
CloseConnection()
N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
7
(om.contact.generalselect)
DECLARE @ContactID int = 3166254;

SELECT *
FROM OM_Contact
WHERE [ContactID] = @ContactID
Table (1 [43], 237 B)
 
SimpleHandler`2.StartEvent 0.000
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
BeginTransaction(ReadCommitted)
N/A
8
(cms.user.updatesession)
Proc_CMS_Session_Update
@SessionIdentifier ("0b431125kpevyw3fm0njftjx")
@SessionUserID ()
@SessionLocation ("/News-Media/News-Hub/October-2014-(1)/Refinancing-to-upgrade-Pick-the-right-agent")
@SessionLastActive (4/27/2017 7:24:37 AM)
@SessionLastLogon ()
@SessionExpires (4/27/2017 7:45:37 AM)
@SessionExpired (False)
@SessionSiteID (1)
@SessionUserIsHidden (True)
@SessionFullName ("Anonymous - 2017-04-27 07:24:37.324")
@SessionEmail ()
@SessionUserName ()
@SessionNickName ()
@SessionUserCreated (4/27/2017 7:24:37 AM)
@SessionContactID (3166254)
217 B
 
Table (1 [1], 4 B)
 
SimpleHandler`2.StartEvent 0.016
 
CommitTransaction()
SimpleHandler`2.StartEvent N/A
CloseConnection()
N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
9
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @NodeGUID uniqueidentifier = '4e15da3f-cbc0-41e9-b0db-696b1a06f563';
DECLARE @Now datetime2 = '4/27/2017 7:24:37 AM';

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 [NodeGUID] = @NodeGUID AND ([DocumentCanBePublished] = 1 AND ([DocumentPublishFrom] IS NULL OR [DocumentPublishFrom] <= @Now) AND ([DocumentPublishTo] IS NULL OR [DocumentPublishTo] >= @Now))
522 B
 
Table (1 [157], 1.2 kB)
 
SimpleHandler`2.StartEvent 0.000
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
10
(cms.versionhistory.generalselect)
SELECT *
FROM CMS_VersionHistory
WHERE [VersionHistoryID] = 7453
Table (1 [23], 8.1 kB)
 
SimpleHandler`2.StartEvent 0.016
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
SimpleHandler`2.StartEvent N/A
11
(om.abvariant.generalselect)
DECLARE @ABVariantPath nvarchar(max) = N'/News-Media/News-Hub/October-2014-(1)/Refinancing-to-upgrade-Pick-the-right-agent';
DECLARE @ABVariantSiteID int = 1;

SELECT *
FROM OM_ABVariant
WHERE [ABVariantPath] = @ABVariantPath AND [ABVariantSiteID] = @ABVariantSiteID
SimpleHandler`2.StartEvent 0.000
 
CloseConnection()
SimpleHandler`2.StartEvent N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
12
(.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-AU';
DECLARE @NodeID int = 3587;

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-AU' THEN 2 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 ([DocumentCulture] = @DocumentCulture AND [NodeID] = @NodeID)
) AS SubData
ORDER BY CMS_P DESC
3 kB
 
Table (1 [64], 458 B)
 
PageContext.CurrentPage_InitComplete 0.016
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
13
(cms.document.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @DocumentCulture nvarchar(max) = N'en-AU';

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'/News-Media/News-Hub', N'/News-Media', N'/')) AND [DocumentCulture] = @DocumentCulture
ORDER BY NodeLevel DESC
Table (3 [157], 10.8 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
14
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @NodeAliasPath nvarchar(max) = N'/';
DECLARE @DocumentCulture nvarchar(max) = N'en-AU';

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-AU' THEN 2 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 ([NodeAliasPath] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture))
) AS SubData
ORDER BY CMS_P DESC
3.2 kB
 
Table (1 [64], 5.4 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
15
(cms.blogpost.generalselect)
DECLARE @DocumentCulture nvarchar(max) = N'en-AU';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_BlogPost AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.BlogPostID AND V.ClassName = N'CMS.BlogPost' LEFT OUTER JOIN COM_SKU AS S WITH (NOLOCK) ON V.NodeSKUID = S.SKUID
WHERE (NodeID = 3652) AND [DocumentCulture] = @DocumentCulture
Table (1 [169], 5.6 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
16
(om.mvtest.generalselect)
DECLARE @MVTestPage nvarchar(max) = N'/News-Media/News-Hub/October-2014-(1)/Refinancing-to-upgrade-Pick-the-right-agent';
DECLARE @MVTestSiteID int = 1;

SELECT *
FROM OM_MVTest
WHERE [MVTestPage] = @MVTestPage AND [MVTestSiteID] = @MVTestSiteID
PageContext.CurrentPage_InitComplete 0.000
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
PageContext.CurrentPage_InitComplete N/A
17
(cms.personalization.selectall)
SELECT TOP 1 *
FROM CMS_Personalization
WHERE PersonalizationUserID = 65 AND PersonalizationDocumentID = 3647
PageContext.CurrentPage_InitComplete 0.016
 
CloseConnection()
PageContext.CurrentPage_InitComplete N/A
OpenConnection()
BasicRepeater.OnLoad N/A
18
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/27/2017 7:24:37 AM';
DECLARE @NodeGUID uniqueidentifier = '4e15da3f-cbc0-41e9-b0db-696b1a06f563';
DECLARE @RelationshipName nvarchar(max) = N'isrelatedto';
DECLARE @DocumentCulture nvarchar(max) = N'en-AU';
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_Article AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.ArticleID AND V.ClassName = N'CMS.Article' 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 [NodeID] IN (
SELECT [RightNodeID]
FROM CMS_Relationship LEFT OUTER JOIN CMS_RelationshipName ON CMS_Relationship.RelationshipNameID = CMS_RelationshipName.RelationshipNameID
WHERE [LeftNodeID] IN (
SELECT [NodeID]
FROM CMS_Tree
WHERE [NodeGUID] = @NodeGUID
) AND [RelationshipName] = @RelationshipName
) AND [DocumentCulture] = @DocumentCulture)
) AS SubData
WHERE [CMS_C] = @CMS_C
1.3 kB
 
BasicRepeater.OnLoad 0.000
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
19
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/27/2017 7:24:37 AM';
DECLARE @NodeGUID uniqueidentifier = '4e15da3f-cbc0-41e9-b0db-696b1a06f563';
DECLARE @RelationshipName nvarchar(max) = N'isrelatedto';
DECLARE @DocumentCulture nvarchar(max) = N'en-AU';
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_BlogPost AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.BlogPostID AND V.ClassName = N'CMS.BlogPost' 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 [NodeID] IN (
SELECT [RightNodeID]
FROM CMS_Relationship LEFT OUTER JOIN CMS_RelationshipName ON CMS_Relationship.RelationshipNameID = CMS_RelationshipName.RelationshipNameID
WHERE [LeftNodeID] IN (
SELECT [NodeID]
FROM CMS_Tree
WHERE [NodeGUID] = @NodeGUID
) AND [RelationshipName] = @RelationshipName
) AND [DocumentCulture] = @DocumentCulture)
) AS SubData
WHERE [CMS_C] = @CMS_C
1.3 kB
 
BasicRepeater.OnLoad 0.000
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
N/A
20
(.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/27/2017 7:24:37 AM';
DECLARE @NodeGUID uniqueidentifier = '4e15da3f-cbc0-41e9-b0db-696b1a06f563';
DECLARE @RelationshipName nvarchar(max) = N'isrelatedto';
DECLARE @DocumentCulture nvarchar(max) = N'en-AU';
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_PressRelease AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.PressReleaseID AND V.ClassName = N'CMS.PressRelease' 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 [NodeID] IN (
SELECT [RightNodeID]
FROM CMS_Relationship LEFT OUTER JOIN CMS_RelationshipName ON CMS_Relationship.RelationshipNameID = CMS_RelationshipName.RelationshipNameID
WHERE [LeftNodeID] IN (
SELECT [NodeID]
FROM CMS_Tree
WHERE [NodeGUID] = @NodeGUID
) AND [RelationshipName] = @RelationshipName
) AND [DocumentCulture] = @DocumentCulture)
) AS SubData
WHERE [CMS_C] = @CMS_C
1.3 kB
 
BasicRepeater.OnLoad 0.000
 
CloseConnection()
BasicRepeater.OnLoad N/A
OpenConnection()
CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender N/A
21
(cms.blogpost.generalselect)
DECLARE @NodeSiteID int = 1;
DECLARE @Now datetime2 = '4/27/2017 7:24:37 AM';
DECLARE @NodeAliasPath nvarchar(max) = N'/News-Media/News-Hub/October-2014-(1)/Refinancing-to-upgrade-Pick-the-right-agent';
DECLARE @DocumentCulture nvarchar(max) = N'en-AU';

SELECT *
FROM View_CMS_Tree_Joined AS V WITH (NOLOCK, NOEXPAND) INNER JOIN CONTENT_BlogPost AS C WITH (NOLOCK) ON V.DocumentForeignKeyValue = C.BlogPostID AND V.ClassName = N'CMS.BlogPost' 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] = @NodeAliasPath AND [DocumentCulture] = @DocumentCulture)
ORDER BY BlogPostDate DESC
828 B
 
Table (1 [169], 5.6 kB)
 
CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender 0.000
 
CloseConnection()
CMSWebParts_Viewers_Basic_BasicRepeater.OnPreRender N/A
  21 queries, 22 kB write, 50 kB read   0.062
Macros resolved in the content of this page:
 ExpressionResultUserContextDuration
1 {% CanonicalURL != "" %} False CMSAbstractWebPart.OnInit 0.000
> CanonicalURL != "" False 0.000
2 {% NoFollow %} null 0.000
> NoFollow null 0.000
3 {% IncludeOptimizely %} null 0.000
> IncludeOptimizely null 0.000
4 {% DisclaimerContent %} null PageContext.CurrentPage_InitComplete 0.000
> DisclaimerContent null 0.000
5 {% CanonicalURL != "" %} False CMSAbstractWebPart.OnInit 0.000
> CanonicalURL != "" False 0.000
6 {% NoFollow %} null 0.000
> NoFollow null 0.000
7 {% IncludeOptimizely %} null 0.000
> IncludeOptimizely null 0.000
8 {% DisclaimerContent %} null PageContext.CurrentPage_InitComplete 0.000
> DisclaimerContent null 0.000
9 {% pagetitle_orelse_name %} News - Refinancing to upgrade? Pick the right agent DocumentBase.Load 0.000
> pagetitle_orelse_name News - Refinancing to upgrade? Pick the right agent 0.000
10 {% CurrentDateTime.Hour %} 7 FIRSTMAC-srvc-kentico CMSWebParts_General_javascript.OnPreRender 0.000
> CurrentDateTime.Hour 7 FIRSTMAC-srvc-kentico 0.000
11 {% CurrentDateTime.Hour %} 7 FIRSTMAC-srvc-kentico 0.000
> CurrentDateTime.Hour 7 FIRSTMAC-srvc-kentico 0.000
12 {% CurrentDateTime.Hour %} 7 FIRSTMAC-srvc-kentico 0.000
> CurrentDateTime.Hour 7 FIRSTMAC-srvc-kentico 0.000
13 {% CurrentDateTime.Hour %} 7 FIRSTMAC-srvc-kentico 0.000
> CurrentDateTime.Hour 7 FIRSTMAC-srvc-kentico 0.000
      
Web farm synchronizations done by this page:
 Task typeTargetDataContext
1 DICTIONARYCOMMAND DELETEITEMINT¦om.contact_ContactID¦3166254 SimpleHandler`2.StartEvent
2 DICTIONARYCOMMAND DELETEITEMSTRING¦om.contact_ContactGUID;ContactSiteID¦9a4da1cd-f708-46f1-b168-8647e62b9572|1
3 TOUCHCACHEITEM om.contact|all¦om.contact|byid|3166254¦om.contact|byguid|9a4da1cd-f708-46f1-b168-8647e62b9572 SimpleHandler`2.StartEvent
4 DICTIONARYCOMMAND DELETEITEMINT¦om.contact_ContactID¦3166254 SimpleHandler`2.StartEvent
5 DICTIONARYCOMMAND DELETEITEMSTRING¦om.contact_ContactGUID;ContactSiteID¦9a4da1cd-f708-46f1-b168-8647e62b9572|1
6 INVALIDATEOBJECT om.contact 3166254 SimpleHandler`2.StartEvent
     
ViewState used by the controls of this page:
 Control IDIs dirtyViewStateTotal size
1 form Yes
action = "/news-hub/october-2014/refinancing-to-upgrade-pick-the-right-agent" (66 B)
66 B
 
2 p
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
3 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId1
Yes
Text = "0b431125kpevyw3fm0njftjx" (24 B)
24 B
 
4 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId2
Yes
Text = "0b431125kpevyw3fm0njftjx" (24 B)
24 B
 
5 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId3
Yes
Text = "0b431125kpevyw3fm0njftjx" (24 B)
24 B
 
6 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId4
Yes
Text = "0b431125kpevyw3fm0njftjx" (24 B)
24 B
 
7 pageplaceholder
p
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
8 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId1
Yes
Text = "0b431125kpevyw3fm0njftjx" (24 B)
24 B
 
9 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId2
Yes
Text = "0b431125kpevyw3fm0njftjx" (24 B)
24 B
 
10 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId3
Yes
Text = "0b431125kpevyw3fm0njftjx" (24 B)
24 B
 
11 ScriptWebparts
Firstmac_RetailGTMDataLayer
ctrlSessionId4
Yes
Text = "0b431125kpevyw3fm0njftjx" (24 B)
24 B
 
12 pageplaceholder
p
pnlPage
Yes
CssClass = "PagePlaceholder" (15 B)
15 B
 
13 ZoneA
BlogPostsDataSource
srcDocuments
Yes
IsSelected = True
0 B
 
14 BlogPostsRepeater
plcBasicRepeater
N/A
Yes
Yes
Yes
Yes
Yes
Yes
ZeroRowsText = "No data found" (13 B)
ResolveDynamicControls = True
DataSourceName = "BlogPostsDataSource" (19 B)
HideControlForZeroRows = True
DataBindByDefault = False
_!ItemCount = 1
32 B
 
15 dbg
pnlDebugContainer
No
CssClass = "debug" (5 B)
5 B
 
     Total viewstate size: bytes