This class is offered at the following Dates/Times:

Please Choose a Date & Time

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'GROUP'.
 
The error occurred in C:/websites/defaultWebsite/rangemanagement/classdetail.cfm: line 88
86 : 	LEFT JOIN 
87 : 	(SELECT BB.CLASS_SESSION_ID, COUNT(*) AS CUSTOMER_COUNT FROM TB_CLASSES AA INNER JOIN TB_CLASS_SESSION BB ON (BB.CLASS_ID = AA.CLASS_ID) INNER JOIN TB_CUST_SESSION CC ON (CC.CLASS_SESSION_ID = BB.CLASS_SESSION_ID) WHERE AA.STYLE_ID = #getclass.style_id#  GROUP BY BB.CLASS_SESSION_ID) D ON (D.CLASS_SESSION_ID = B.CLASS_SESSION_ID)
88 : 	WHERE A.STYLE_ID= #getclass.style_id# and a.IS_ACTIVE='Y' and B.START_DATETIME >= getdate()
89 : 	order by START_DATETIME asc
90 : </cfquery>

SQLSTATE   HY000
DATASOURCE   koalasql
VENDORERRORCODE   156
SQL    SELECT B.CLASS_SESSION_ID, A.CLASS_NAME, C.RESOURCE_NAME, B.START_DATETIME, B.END_DATETIME, A.IS_ACTIVE, ISNULL(D.CUSTOMER_COUNT,0) AS CUSTOMER_COUNT, A.MAX_CAPACITY FROM TB_CLASSES A LEFT JOIN TB_CLASS_SESSION B ON(A.CLASS_ID=B.CLASS_ID) LEFT JOIN TB_CLASS_RESOURCE C ON(C.CLASS_RESOURCE_ID=B.CLASS_RESOURCE_ID) LEFT JOIN (SELECT BB.CLASS_SESSION_ID, COUNT(*) AS CUSTOMER_COUNT FROM TB_CLASSES AA INNER JOIN TB_CLASS_SESSION BB ON (BB.CLASS_ID = AA.CLASS_ID) INNER JOIN TB_CUST_SESSION CC ON (CC.CLASS_SESSION_ID = BB.CLASS_SESSION_ID) WHERE AA.STYLE_ID = GROUP BY BB.CLASS_SESSION_ID) D ON (D.CLASS_SESSION_ID = B.CLASS_SESSION_ID) WHERE A.STYLE_ID= and a.IS_ACTIVE='Y' and B.START_DATETIME >= getdate() order by START_DATETIME asc
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   54.162.118.107
Referrer  
Date/Time   23-Oct-18 02:24 AM
Stack Trace
at cfclassdetail2ecfm1803539560.runPage(C:/websites/defaultWebsite/rangemanagement/classdetail.cfm:88) at cfclassdetail2ecfm1803539560.runPage(C:/websites/defaultWebsite/rangemanagement/classdetail.cfm:88)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'GROUP'.
	at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
	at macromedia.jdbc.sqlserver.dda3.m(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1485)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:816)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
	at cfclassdetail2ecfm1803539560.runPage(C:\websites\defaultWebsite\rangemanagement\classdetail.cfm:88)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	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:58)
	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:219)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)