x= division winner    y= playoff berth    z= eliminated

Eastern Division					Average				High Game			Records
Team	W	L	T	Win%	Off	Def	Total	Opposing	Off	Def	Total	Home	Away	Streak

Central Division					Average				High Game			Records
Team	W	L	T	Win%	Off	Def	Total	Opposing	Off	Def	Total	Home	Away	Streak

Western Division					Average				High Game			Records
Team	W	L	T	Win%	Off	Def	Total	Opposing	Off	Def	Total	Home	Away	Streak

Wildcard Standings					Average				High Game			Records
Team	W	L	T	Win%	Off	Def	Total	Opposing	Off	Def	Total	Home	Away	Streak

Scope Arguments
exception	1	Catch Entries: 18 additional Struct (ordered) SQL string SELECT games.team, won=isnull(SUM(win),0), loss=isnull(SUM(loss),0), tie=isnull(SUM(tie),0), opposing=isnull(sum(opp_points),0), tothgh=isnull(MAX(total_points),0), offhgh=isnull(MAX(offense_points),0), defhgh=isnull(MAX(defense_points),0), totavg=isnull(SUM(total_points),0), offavg=isnull(SUM(offense_points),0), defavg=isnull(SUM(defense_points),0),name ,getavg=isnull((SUM(win) + (SUM(tie)*.5)),0) FROM games inner join teams on games.team=teams.team WHERE games.league = '' and games.team in (select team from games where period='202400' and games.league='' and team not in (select team from games where period='202411' and (division='Z')) and team not in ()) AND period BETWEEN '202401' AND '202411' GROUP BY games.team,teams.name ORDER BY getavg DESC, totavg DESC DatabaseName string Microsoft SQL Server DatabaseVersion string 11.00.7507 DriverName string Microsoft JDBC Driver 12.2 for SQL Server DriverVersion string 12.2.0.0 Datasource string football Cause Struct Entries: 15 additional Struct (ordered) SQL string SELECT games.team, won=isnull(SUM(win),0), loss=isnull(SUM(loss),0), tie=isnull(SUM(tie),0), opposing=isnull(sum(opp_points),0), tothgh=isnull(MAX(total_points),0), offhgh=isnull(MAX(offense_points),0), defhgh=isnull(MAX(defense_points),0), totavg=isnull(SUM(total_points),0), offavg=isnull(SUM(offense_points),0), defavg=isnull(SUM(defense_points),0),name ,getavg=isnull((SUM(win) + (SUM(tie)*.5)),0) FROM games inner join teams on games.team=teams.team WHERE games.league = '' and games.team in (select team from games where period='202400' and games.league='' and team not in (select team from games where period='202411' and (division='Z')) and team not in ()) AND period BETWEEN '202401' AND '202411' GROUP BY games.team,teams.name ORDER BY getavg DESC, totavg DESC DatabaseName string Microsoft SQL Server DatabaseVersion string 11.00.7507 DriverName string Microsoft JDBC Driver 12.2 for SQL Server DriverVersion string 12.2.0.0 Datasource string football DataSource string football Detail string ErrorCode string 0 Extended_Info string ExtendedInfo string Message string Incorrect syntax near ')'. NativeErrorCode number 102 queryError string SELECT games.team, won=isnull(SUM(win),0), loss=isnull(SUM(loss),0), tie=isnull(SUM(tie),0), opposing=isnull(sum(opp_points),0), tothgh=isnull(MAX(total_points),0), offhgh=isnull(MAX(offense_points),0), defhgh=isnull(MAX(defense_points),0), totavg=isnull(SUM(total_points),0), offavg=isnull(SUM(offense_points),0), defavg=isnull(SUM(defense_points),0),name ,getavg=isnull((SUM(win) + (SUM(tie)*.5)),0) FROM games inner join teams on games.team=teams.team WHERE games.league = '' and games.team in (select team from games where period='202400' and games.league='' and team not in (select team from games where period='202411' and (division='Z')) and team not in ()) AND period BETWEEN '202401' AND '202411' GROUP BY games.team,teams.name ORDER BY getavg DESC, totavg DESC Sql string SELECT games.team, won=isnull(SUM(win),0), loss=isnull(SUM(loss),0), tie=isnull(SUM(tie),0), opposing=isnull(sum(opp_points),0), tothgh=isnull(MAX(total_points),0), offhgh=isnull(MAX(offense_points),0), defhgh=isnull(MAX(defense_points),0), totavg=isnull(SUM(total_points),0), offavg=isnull(SUM(offense_points),0), defavg=isnull(SUM(defense_points),0),name ,getavg=isnull((SUM(win) + (SUM(tie)*.5)),0) FROM games inner join teams on games.team=teams.team WHERE games.league = '' and games.team in (select team from games where period='202400' and games.league='' and team not in (select team from games where period='202411' and (division='Z')) and team not in ()) AND period BETWEEN '202401' AND '202411' GROUP BY games.team,teams.name ORDER BY getavg DESC, totavg DESC SQLState string S0001 StackTrace string lucee.runtime.exp.DatabaseException: Incorrect syntax near ')'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1695) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:920) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:814) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7685) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4048) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:272) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:246) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:787) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:320) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:287) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1135) at lucee.runtime.tag.Query._doEndTag(Query.java:700) at lucee.runtime.tag.Query.doEndTag(Query.java:566) at football.league.standing_wildcard_cfm405$cf$pqg.call(/football/league/standing-wildcard.cfm:23) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1025) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at football.league.standings_cfm$cf$pqd.call(/football/league/standings.cfm:299) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1025) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at application_cfc$cf$q6c.udfCall1(/application.cfc:791) at application_cfc$cf$q6c.udfCall(/application.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:664) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:444) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:218) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1216) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1162) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:422) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) 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(Unknown Source) TagContext Array 1 Struct codePrintHTML string 21: ORDER BY<br> 22: getavg DESC, totavg DESC<br> <b>23: &lt;/cfquery&gt;</b><br> 24: &lt;/cfsilent&gt;<br> 25: &lt;cfoutput&gt;<br> codePrintPlain string 21: ORDER BY 22: getavg DESC, totavg DESC 23: </cfquery> 24: </cfsilent> 25: <cfoutput> column number 0 id string ?? line number 23 Raw_Trace string football.league.standing_wildcard_cfm405$cf$pqg.call(/football/league/standing-wildcard.cfm:23) template string C:\Websites\www.mrsports.com\football\league\standing-wildcard.cfm type string cfml 2 Struct codePrintHTML string 297: &lt;/tr&gt;<br> 298: &lt;/thead&gt;<br> <b>299: &lt;cfinclude template=&quot;standing-wildcard.cfm&quot;&gt;</b><br> 300: &lt;/table&gt;<br> 301: &lt;/cfif&gt;<br> codePrintPlain string 297: </tr> 298: </thead> 299: <cfinclude template="standing-wildcard.cfm"> 300: </table> 301: </cfif> column number 0 id string ?? line number 299 Raw_Trace string football.league.standings_cfm$cf$pqd.call(/football/league/standings.cfm:299) template string C:\Websites\www.mrsports.com\football\league\standings.cfm type string cfml 3 Struct codePrintHTML string 789: <br> 790: &lt;!--- Include the requested page. ---&gt;<br> <b>791: &lt;cfinclude template=&quot;#arguments.TargetPage#&quot; /&gt;</b><br> 792: <br> 793: &lt;/cffunction&gt;<br> codePrintPlain string 789: 790: <!--- Include the requested page. ---> 791: <cfinclude template="#arguments.TargetPage#" /> 792: 793: </cffunction> column number 0 id string ?? line number 791 Raw_Trace string application_cfc$cf$q6c.udfCall1(/application.cfc:791) template string C:\Websites\www.mrsports.com\application.cfc type string cfml type string database where string DataSource string football Detail string ErrorCode string 0 Extended_Info string ExtendedInfo string Message string Incorrect syntax near ')'. name string onRequest NativeErrorCode number 102 queryError string SELECT games.team, won=isnull(SUM(win),0), loss=isnull(SUM(loss),0), tie=isnull(SUM(tie),0), opposing=isnull(sum(opp_points),0), tothgh=isnull(MAX(total_points),0), offhgh=isnull(MAX(offense_points),0), defhgh=isnull(MAX(defense_points),0), totavg=isnull(SUM(total_points),0), offavg=isnull(SUM(offense_points),0), defavg=isnull(SUM(defense_points),0),name ,getavg=isnull((SUM(win) + (SUM(tie)*.5)),0) FROM games inner join teams on games.team=teams.team WHERE games.league = '' and games.team in (select team from games where period='202400' and games.league='' and team not in (select team from games where period='202411' and (division='Z')) and team not in ()) AND period BETWEEN '202401' AND '202411' GROUP BY games.team,teams.name ORDER BY getavg DESC, totavg DESC rootCause Struct Entries: 15 additional Struct (ordered) SQL string SELECT games.team, won=isnull(SUM(win),0), loss=isnull(SUM(loss),0), tie=isnull(SUM(tie),0), opposing=isnull(sum(opp_points),0), tothgh=isnull(MAX(total_points),0), offhgh=isnull(MAX(offense_points),0), defhgh=isnull(MAX(defense_points),0), totavg=isnull(SUM(total_points),0), offavg=isnull(SUM(offense_points),0), defavg=isnull(SUM(defense_points),0),name ,getavg=isnull((SUM(win) + (SUM(tie)*.5)),0) FROM games inner join teams on games.team=teams.team WHERE games.league = '' and games.team in (select team from games where period='202400' and games.league='' and team not in (select team from games where period='202411' and (division='Z')) and team not in ()) AND period BETWEEN '202401' AND '202411' GROUP BY games.team,teams.name ORDER BY getavg DESC, totavg DESC DatabaseName string Microsoft SQL Server DatabaseVersion string 11.00.7507 DriverName string Microsoft JDBC Driver 12.2 for SQL Server DriverVersion string 12.2.0.0 Datasource string football DataSource string football Detail string ErrorCode string 0 Extended_Info string ExtendedInfo string Message string Incorrect syntax near ')'. NativeErrorCode number 102 queryError string SELECT games.team, won=isnull(SUM(win),0), loss=isnull(SUM(loss),0), tie=isnull(SUM(tie),0), opposing=isnull(sum(opp_points),0), tothgh=isnull(MAX(total_points),0), offhgh=isnull(MAX(offense_points),0), defhgh=isnull(MAX(defense_points),0), totavg=isnull(SUM(total_points),0), offavg=isnull(SUM(offense_points),0), defavg=isnull(SUM(defense_points),0),name ,getavg=isnull((SUM(win) + (SUM(tie)*.5)),0) FROM games inner join teams on games.team=teams.team WHERE games.league = '' and games.team in (select team from games where period='202400' and games.league='' and team not in (select team from games where period='202411' and (division='Z')) and team not in ()) AND period BETWEEN '202401' AND '202411' GROUP BY games.team,teams.name ORDER BY getavg DESC, totavg DESC Sql string SELECT games.team, won=isnull(SUM(win),0), loss=isnull(SUM(loss),0), tie=isnull(SUM(tie),0), opposing=isnull(sum(opp_points),0), tothgh=isnull(MAX(total_points),0), offhgh=isnull(MAX(offense_points),0), defhgh=isnull(MAX(defense_points),0), totavg=isnull(SUM(total_points),0), offavg=isnull(SUM(offense_points),0), defavg=isnull(SUM(defense_points),0),name ,getavg=isnull((SUM(win) + (SUM(tie)*.5)),0) FROM games inner join teams on games.team=teams.team WHERE games.league = '' and games.team in (select team from games where period='202400' and games.league='' and team not in (select team from games where period='202411' and (division='Z')) and team not in ()) AND period BETWEEN '202401' AND '202411' GROUP BY games.team,teams.name ORDER BY getavg DESC, totavg DESC SQLState string S0001 StackTrace string lucee.runtime.exp.DatabaseException: Incorrect syntax near ')'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1695) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:920) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:814) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7685) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4048) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:272) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:246) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:787) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:320) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:287) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1135) at lucee.runtime.tag.Query._doEndTag(Query.java:700) at lucee.runtime.tag.Query.doEndTag(Query.java:566) at football.league.standing_wildcard_cfm405$cf$pqg.call(/football/league/standing-wildcard.cfm:23) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1025) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at football.league.standings_cfm$cf$pqd.call(/football/league/standings.cfm:299) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1025) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at application_cfc$cf$q6c.udfCall1(/application.cfc:791) at application_cfc$cf$q6c.udfCall(/application.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:664) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:444) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:218) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1216) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1162) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:422) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) 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(Unknown Source) TagContext Array 1 Struct codePrintHTML string 21: ORDER BY<br> 22: getavg DESC, totavg DESC<br> <b>23: &lt;/cfquery&gt;</b><br> 24: &lt;/cfsilent&gt;<br> 25: &lt;cfoutput&gt;<br> codePrintPlain string 21: ORDER BY 22: getavg DESC, totavg DESC 23: </cfquery> 24: </cfsilent> 25: <cfoutput> column number 0 id string ?? line number 23 Raw_Trace string football.league.standing_wildcard_cfm405$cf$pqg.call(/football/league/standing-wildcard.cfm:23) template string C:\Websites\www.mrsports.com\football\league\standing-wildcard.cfm type string cfml 2 Struct codePrintHTML string 297: &lt;/tr&gt;<br> 298: &lt;/thead&gt;<br> <b>299: &lt;cfinclude template=&quot;standing-wildcard.cfm&quot;&gt;</b><br> 300: &lt;/table&gt;<br> 301: &lt;/cfif&gt;<br> codePrintPlain string 297: </tr> 298: </thead> 299: <cfinclude template="standing-wildcard.cfm"> 300: </table> 301: </cfif> column number 0 id string ?? line number 299 Raw_Trace string football.league.standings_cfm$cf$pqd.call(/football/league/standings.cfm:299) template string C:\Websites\www.mrsports.com\football\league\standings.cfm type string cfml 3 Struct codePrintHTML string 789: <br> 790: &lt;!--- Include the requested page. ---&gt;<br> <b>791: &lt;cfinclude template=&quot;#arguments.TargetPage#&quot; /&gt;</b><br> 792: <br> 793: &lt;/cffunction&gt;<br> codePrintPlain string 789: 790: <!--- Include the requested page. ---> 791: <cfinclude template="#arguments.TargetPage#" /> 792: 793: </cffunction> column number 0 id string ?? line number 791 Raw_Trace string application_cfc$cf$q6c.udfCall1(/application.cfc:791) template string C:\Websites\www.mrsports.com\application.cfc type string cfml type string database where string Sql string SELECT games.team, won=isnull(SUM(win),0), loss=isnull(SUM(loss),0), tie=isnull(SUM(tie),0), opposing=isnull(sum(opp_points),0), tothgh=isnull(MAX(total_points),0), offhgh=isnull(MAX(offense_points),0), defhgh=isnull(MAX(defense_points),0), totavg=isnull(SUM(total_points),0), offavg=isnull(SUM(offense_points),0), defavg=isnull(SUM(defense_points),0),name ,getavg=isnull((SUM(win) + (SUM(tie)*.5)),0) FROM games inner join teams on games.team=teams.team WHERE games.league = '' and games.team in (select team from games where period='202400' and games.league='' and team not in (select team from games where period='202411' and (division='Z')) and team not in ()) AND period BETWEEN '202401' AND '202411' GROUP BY games.team,teams.name ORDER BY getavg DESC, totavg DESC SQLState string S0001 StackTrace string lucee.runtime.exp.DatabaseException: Incorrect syntax near ')'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1695) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:920) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:814) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7685) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4048) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:272) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:246) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:787) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:320) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:287) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1135) at lucee.runtime.tag.Query._doEndTag(Query.java:700) at lucee.runtime.tag.Query.doEndTag(Query.java:566) at football.league.standing_wildcard_cfm405$cf$pqg.call(/football/league/standing-wildcard.cfm:23) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1025) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at football.league.standings_cfm$cf$pqd.call(/football/league/standings.cfm:299) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1025) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at application_cfc$cf$q6c.udfCall1(/application.cfc:791) at application_cfc$cf$q6c.udfCall(/application.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:664) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:444) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:218) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1216) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1162) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:422) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) 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(Unknown Source) TagContext Array 1 Struct codePrintHTML string 21: ORDER BY<br> 22: getavg DESC, totavg DESC<br> <b>23: &lt;/cfquery&gt;</b><br> 24: &lt;/cfsilent&gt;<br> 25: &lt;cfoutput&gt;<br> codePrintPlain string 21: ORDER BY 22: getavg DESC, totavg DESC 23: </cfquery> 24: </cfsilent> 25: <cfoutput> column number 0 id string ?? line number 23 Raw_Trace string football.league.standing_wildcard_cfm405$cf$pqg.call(/football/league/standing-wildcard.cfm:23) template string C:\Websites\www.mrsports.com\football\league\standing-wildcard.cfm type string cfml 2 Struct codePrintHTML string 297: &lt;/tr&gt;<br> 298: &lt;/thead&gt;<br> <b>299: &lt;cfinclude template=&quot;standing-wildcard.cfm&quot;&gt;</b><br> 300: &lt;/table&gt;<br> 301: &lt;/cfif&gt;<br> codePrintPlain string 297: </tr> 298: </thead> 299: <cfinclude template="standing-wildcard.cfm"> 300: </table> 301: </cfif> column number 0 id string ?? line number 299 Raw_Trace string football.league.standings_cfm$cf$pqd.call(/football/league/standings.cfm:299) template string C:\Websites\www.mrsports.com\football\league\standings.cfm type string cfml 3 Struct codePrintHTML string 789: <br> 790: &lt;!--- Include the requested page. ---&gt;<br> <b>791: &lt;cfinclude template=&quot;#arguments.TargetPage#&quot; /&gt;</b><br> 792: <br> 793: &lt;/cffunction&gt;<br> codePrintPlain string 789: 790: <!--- Include the requested page. ---> 791: <cfinclude template="#arguments.TargetPage#" /> 792: 793: </cffunction> column number 0 id string ?? line number 791 Raw_Trace string application_cfc$cf$q6c.udfCall1(/application.cfc:791) template string C:\Websites\www.mrsports.com\application.cfc type string cfml type string database where string
eventName	2	string onRequest