Exception in onRequest

The action home:pages.contact failed.

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server. (Application)

Exception - struct
Detail [Macromedia][SQLServer JDBC Driver]A problem occurred when attempting to contact the server (Server returned: Connection reset). Please ensure that the server parameters passed to the driver are correct and that the server is running. Also ensure that the maximum number of connections have not been exceeded for this server.
ErrorCode [empty string]
ExtendedInfo SELECT TOP 1 [pages].[id] , [pages].[parentID] , [pages].[siteID] , [pages].[pageContainerID] , [pages].[refCode] , [pages].[orderBy] , [pages].[isActive] , [pages].[createdAt] , [pages].[createdBy] , [pages].[isMenuItem] , [pages].[isChildAllowed] , [pages].[isDeleted] , ( SELECT TOP 1 a.name FROM pageDetails a WHERE a.pageID = pages.id AND a.isPublished=1 ORDER BY createdAt DESC ) AS [name] , ( SELECT TOP 1 a.url FROM aliases a WHERE a.parentID = pages.id AND tableName='pages' ORDER BY createdAt DESC ) AS [aliasURL] , ( SELECT MAX(a.createdAt) FROM pageDetails a WHERE a.pageID = pages.id ) AS [updatedAt] , ( SELECT CASE WHEN isPublished = 0 THEN 'Draft' ELSE 'Published' END FROM pageDetails WHERE isDeleted = 0 AND id = (SELECT MIN(id) FROM pageDetails WHERE isDeleted = 0 AND pageID = pages.id AND propertyHash = (SELECT TOP 1 propertyHash FROM pageDetails WHERE isDeleted = 0 AND pageID=pages.id ORDER BY createdAt DESC)) ) AS [status] FROM [pages] WHERE 1 = 1 AND [pages].[id] = (2) AND ([pages].[isDeleted] = 0 OR [pages].[isDeleted] IS NULL) ORDER BY [pages].[id]
Message Error Executing Database Query.
StackTrace coldfusion.runtime.CustomException: Error Executing Database Query. at coldfusion.tagext.lang.ThrowTag.doStartTag(ThrowTag.java:87) at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:4319) at cfDataMgrEngine_cf82ecfc1738440619$funcRUNSQLARRAY.runFunction(C:\home\falconindustries.com\wwwroot\includes\com\dataMgr\DataMgrEngine_cf8.cfc:99) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4116) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4097) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:570) at cf_DataMgr2ecfc1553734714$funcGETRECORDS.runFunction(C:\home\falconindustries.com\wwwroot\includes\com\dataMgr\_DataMgr.cfc:1102) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3549) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3524) at cfobjectFactory2ecfc1694878509$funcGET.runFunction(C:\home\falconindustries.com\wwwroot\model\objectFactory.cfc:252) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3549) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3524) at cfobjectFactory2ecfc1694878509$funcGETDETAILED.runFunction(C:\home\falconindustries.com\wwwroot\model\objectFactory.cfc:276) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3549) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3524) at cfpages2ecfc1448909837$funcGET.runFunction(C:\home\falconindustries.com\wwwroot\model\pages.cfc:11) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3627) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3604) at cfpages2ecfc1687038933$funcDEFAULT.runFunction(C:\home\falconindustries.com\wwwroot\home\controllers\pages.cfc:20) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3549) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3524) at Statement162.evaluate(<generated>:1) at coldfusion.compiler.ExprClassLoader.evaluate(ExprClassLoader.java:149) at coldfusion.runtime.CFPage.Evaluate(CFPage.java:3487) at cfframework2ecfc1158523585$funcRUNEVENT.runFunction(C:\home\falconindustries.com\wwwroot\includes\com\fw1\framework.cfc:410) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:485) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3627) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3604) at cfpages2ecfc1687038933$funcCONTACT.runFunction(C:\home\falconindustries.com\wwwroot\home\controllers\pages.cfc:54) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:609) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:835) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:641) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3549) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3524) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:479) at cffw12ecfc1338815456$funcDOCONTROLLER.runFunction(C:\home\falconindustries.com\wwwroot\includes\com\fw1\fw1.cfc:1328) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4175) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4155) at cffw12ecfc1338815456$funcONREQUEST.runFunction(C:\home\falconindustries.com\wwwroot\includes\com\fw1\fw1.cfc:525) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:554) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:448) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:399) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:372) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:288) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:551) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:226) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) at jdk.internal.reflect.GeneratedMethodAccessor97.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:772) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:344) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:207) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:809) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at jdk.internal.reflect.GeneratedMethodAccessor104.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at jdk.internal.reflect.GeneratedMethodAccessor101.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:42) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Thread.java:834)
Suppressed
Exception - array[empty]
TagContext
Exception - array
1
Exception - struct
COLUMN 0
ID CFTHROW
LINE 99
RAW_TRACE at cfDataMgrEngine_cf82ecfc1738440619$funcRUNSQLARRAY.runFunction(C:\home\falconindustries.com\wwwroot\includes\com\dataMgr\DataMgrEngine_cf8.cfc:99)
TEMPLATE C:\home\falconindustries.com\wwwroot\includes\com\dataMgr\DataMgrEngine_cf8.cfc
TYPE CFML
2
Exception - struct
COLUMN 0
ID CFINVOKE
LINE 1102
RAW_TRACE at cf_DataMgr2ecfc1553734714$funcGETRECORDS.runFunction(C:\home\falconindustries.com\wwwroot\includes\com\dataMgr\_DataMgr.cfc:1102)
TEMPLATE C:\home\falconindustries.com\wwwroot\includes\com\dataMgr\_DataMgr.cfc
TYPE CFML
3
Exception - struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 252
RAW_TRACE at cfobjectFactory2ecfc1694878509$funcGET.runFunction(C:\home\falconindustries.com\wwwroot\model\objectFactory.cfc:252)
TEMPLATE C:\home\falconindustries.com\wwwroot\model\objectFactory.cfc
TYPE CFML
4
Exception - struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 276
RAW_TRACE at cfobjectFactory2ecfc1694878509$funcGETDETAILED.runFunction(C:\home\falconindustries.com\wwwroot\model\objectFactory.cfc:276)
TEMPLATE C:\home\falconindustries.com\wwwroot\model\objectFactory.cfc
TYPE CFML
5
Exception - struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 11
RAW_TRACE at cfpages2ecfc1448909837$funcGET.runFunction(C:\home\falconindustries.com\wwwroot\model\pages.cfc:11)
TEMPLATE C:\home\falconindustries.com\wwwroot\model\pages.cfc
TYPE CFML
6
Exception - struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 20
RAW_TRACE at cfpages2ecfc1687038933$funcDEFAULT.runFunction(C:\home\falconindustries.com\wwwroot\home\controllers\pages.cfc:20)
TEMPLATE C:\home\falconindustries.com\wwwroot\home\controllers\pages.cfc
TYPE CFML
7
Exception - struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 1
RAW_TRACE at Statement162.evaluate(<generated>:1)
TEMPLATE <generated>
TYPE CFML
8
Exception - struct
COLUMN 0
ID CF_CFPAGE
LINE 410
RAW_TRACE at cfframework2ecfc1158523585$funcRUNEVENT.runFunction(C:\home\falconindustries.com\wwwroot\includes\com\fw1\framework.cfc:410)
TEMPLATE C:\home\falconindustries.com\wwwroot\includes\com\fw1\framework.cfc
TYPE CFML
9
Exception - struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 54
RAW_TRACE at cfpages2ecfc1687038933$funcCONTACT.runFunction(C:\home\falconindustries.com\wwwroot\home\controllers\pages.cfc:54)
TEMPLATE C:\home\falconindustries.com\wwwroot\home\controllers\pages.cfc
TYPE CFML
10
Exception - struct
COLUMN 0
ID CFINVOKE
LINE 1328
RAW_TRACE at cffw12ecfc1338815456$funcDOCONTROLLER.runFunction(C:\home\falconindustries.com\wwwroot\includes\com\fw1\fw1.cfc:1328)
TEMPLATE C:\home\falconindustries.com\wwwroot\includes\com\fw1\fw1.cfc
TYPE CFML
11
Exception - struct
COLUMN 0
ID CF_UDFMETHOD
LINE 525
RAW_TRACE at cffw12ecfc1338815456$funcONREQUEST.runFunction(C:\home\falconindustries.com\wwwroot\includes\com\fw1\fw1.cfc:525)
TEMPLATE C:\home\falconindustries.com\wwwroot\includes\com\fw1\fw1.cfc
TYPE CFML
Type Application
code [empty string]
extended_info SELECT TOP 1 [pages].[id] , [pages].[parentID] , [pages].[siteID] , [pages].[pageContainerID] , [pages].[refCode] , [pages].[orderBy] , [pages].[isActive] , [pages].[createdAt] , [pages].[createdBy] , [pages].[isMenuItem] , [pages].[isChildAllowed] , [pages].[isDeleted] , ( SELECT TOP 1 a.name FROM pageDetails a WHERE a.pageID = pages.id AND a.isPublished=1 ORDER BY createdAt DESC ) AS [name] , ( SELECT TOP 1 a.url FROM aliases a WHERE a.parentID = pages.id AND tableName='pages' ORDER BY createdAt DESC ) AS [aliasURL] , ( SELECT MAX(a.createdAt) FROM pageDetails a WHERE a.pageID = pages.id ) AS [updatedAt] , ( SELECT CASE WHEN isPublished = 0 THEN 'Draft' ELSE 'Published' END FROM pageDetails WHERE isDeleted = 0 AND id = (SELECT MIN(id) FROM pageDetails WHERE isDeleted = 0 AND pageID = pages.id AND propertyHash = (SELECT TOP 1 propertyHash FROM pageDetails WHERE isDeleted = 0 AND pageID=pages.id ORDER BY createdAt DESC)) ) AS [status] FROM [pages] WHERE 1 = 1 AND [pages].[id] = (2) AND ([pages].[isDeleted] = 0 OR [pages].[isDeleted] IS NULL) ORDER BY [pages].[id]