Standings thru Week 16, 2024

x= division winner    y= playoff berth    z= eliminated

Eastern DivisionAverageHigh GameRecords

Team
W L Win% GB Hit Pit Total Hit Pit Total vs East vs Cent. vs West
Central DivisionAverageHigh GameRecords

Team
W L Win% GB Hit Pit Total Hit Pit Total vs East vs Cent. vs West
Western DivisionAverageHigh GameRecords

Team
W L Win% GB Hit Pit Total Hit Pit Total vs East vs Cent. vs West
Wildcard StandingsAverageHigh GameRecords

Team
W L Win% GB Hit Pit Total Hit Pit Total vs East vs Cent. vs West
Scope Arguments
exception1
Catch
Entries: 18
additional
Struct (ordered)
SQL
stringSELECT games.team, won=SUM(won), loss=SUM(loss), eastwon=SUM(east_won), eastloss=SUM(east_loss), centwon=SUM(central_won), centloss=SUM(central_loss), westwon=SUM(west_won), westloss=SUM(west_loss), tot=SUM(total_points), hit=SUM(hitting_points), pit=SUM(pitching_points), maxtot=MAX(total_points), maxhit=MAX(hitting_points), maxpit=MAX(pitching_points),name 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='202416' and (division='Z' or alivewild=1)) and team not in ()) AND period BETWEEN '202401' AND '202416' GROUP BY games.team,teams.name ORDER BY won DESC, tot DESC
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string11.00.7507
DriverName
stringMicrosoft JDBC Driver 12.2 for SQL Server
DriverVersion
string12.2.0.0
Datasource
stringbaseball
Cause
Struct
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT games.team, won=SUM(won), loss=SUM(loss), eastwon=SUM(east_won), eastloss=SUM(east_loss), centwon=SUM(central_won), centloss=SUM(central_loss), westwon=SUM(west_won), westloss=SUM(west_loss), tot=SUM(total_points), hit=SUM(hitting_points), pit=SUM(pitching_points), maxtot=MAX(total_points), maxhit=MAX(hitting_points), maxpit=MAX(pitching_points),name 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='202416' and (division='Z' or alivewild=1)) and team not in ()) AND period BETWEEN '202401' AND '202416' GROUP BY games.team,teams.name ORDER BY won DESC, tot DESC
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string11.00.7507
DriverName
stringMicrosoft JDBC Driver 12.2 for SQL Server
DriverVersion
string12.2.0.0
Datasource
stringbaseball
DataSource
stringbaseball
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringIncorrect syntax near ')'.
NativeErrorCode
number102
queryError
stringSELECT games.team, won=SUM(won), loss=SUM(loss), eastwon=SUM(east_won), eastloss=SUM(east_loss), centwon=SUM(central_won), centloss=SUM(central_loss), westwon=SUM(west_won), westloss=SUM(west_loss), tot=SUM(total_points), hit=SUM(hitting_points), pit=SUM(pitching_points), maxtot=MAX(total_points), maxhit=MAX(hitting_points), maxpit=MAX(pitching_points),name 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='202416' and (division='Z' or alivewild=1)) and team not in ()) AND period BETWEEN '202401' AND '202416' GROUP BY games.team,teams.name ORDER BY won DESC, tot DESC
Sql
stringSELECT games.team, won=SUM(won), loss=SUM(loss), eastwon=SUM(east_won), eastloss=SUM(east_loss), centwon=SUM(central_won), centloss=SUM(central_loss), westwon=SUM(west_won), westloss=SUM(west_loss), tot=SUM(total_points), hit=SUM(hitting_points), pit=SUM(pitching_points), maxtot=MAX(total_points), maxhit=MAX(hitting_points), maxpit=MAX(pitching_points),name 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='202416' and (division='Z' or alivewild=1)) and team not in ()) AND period BETWEEN '202401' AND '202416' GROUP BY games.team,teams.name ORDER BY won DESC, tot DESC
SQLState
stringS0001
StackTrace
stringlucee.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 baseball.league.standing_wildcard_cfm405$cf$8dp.call(/baseball/league/standing-wildcard.cfm:26) 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 baseball.league.standings_cfm$cf$8dm.call(/baseball/league/standings.cfm:298) 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.udfCall1(/application.cfc:792) at application_cfc$cf.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
string24: ORDER BY<br> 25: won DESC, tot DESC<br> <b>26: &lt;/cfquery&gt;</b><br> 27: &lt;/cfsilent&gt;<br> 28: <br>
codePrintPlain
string24: ORDER BY 25: won DESC, tot DESC 26: </cfquery> 27: </cfsilent> 28:
column
number0
id
string??
line
number26
Raw_Trace
stringbaseball.league.standing_wildcard_cfm405$cf$8dp.call(/baseball/league/standing-wildcard.cfm:26)
template
stringC:\Websites\www.mrsports.com\baseball\league\standing-wildcard.cfm
type
stringcfml
2
Struct
codePrintHTML
string296: &lt;/tr&gt;<br> 297: &lt;/thead&gt;<br> <b>298: &lt;cfinclude template=&quot;standing-wildcard.cfm&quot;&gt;</b><br> 299: &lt;/table&gt;<br> 300: &lt;/div&gt;<br>
codePrintPlain
string296: </tr> 297: </thead> 298: <cfinclude template="standing-wildcard.cfm"> 299: </table> 300: </div>
column
number0
id
string??
line
number298
Raw_Trace
stringbaseball.league.standings_cfm$cf$8dm.call(/baseball/league/standings.cfm:298)
template
stringC:\Websites\www.mrsports.com\baseball\league\standings.cfm
type
stringcfml
3
Struct
codePrintHTML
string790: <br> 791: &lt;!--- Include the requested page. ---&gt;<br> <b>792: &lt;cfinclude template=&quot;#arguments.TargetPage#&quot; /&gt;</b><br> 793: <br> 794: &lt;/cffunction&gt;<br>
codePrintPlain
string790: 791: <!--- Include the requested page. ---> 792: <cfinclude template="#arguments.TargetPage#" /> 793: 794: </cffunction>
column
number0
id
string??
line
number792
Raw_Trace
stringapplication_cfc$cf.udfCall1(/application.cfc:792)
template
stringC:\Websites\www.mrsports.com\application.cfc
type
stringcfml
type
stringdatabase
where
string
DataSource
stringbaseball
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringIncorrect syntax near ')'.
name
stringonRequest
NativeErrorCode
number102
queryError
stringSELECT games.team, won=SUM(won), loss=SUM(loss), eastwon=SUM(east_won), eastloss=SUM(east_loss), centwon=SUM(central_won), centloss=SUM(central_loss), westwon=SUM(west_won), westloss=SUM(west_loss), tot=SUM(total_points), hit=SUM(hitting_points), pit=SUM(pitching_points), maxtot=MAX(total_points), maxhit=MAX(hitting_points), maxpit=MAX(pitching_points),name 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='202416' and (division='Z' or alivewild=1)) and team not in ()) AND period BETWEEN '202401' AND '202416' GROUP BY games.team,teams.name ORDER BY won DESC, tot DESC
rootCause
Struct
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT games.team, won=SUM(won), loss=SUM(loss), eastwon=SUM(east_won), eastloss=SUM(east_loss), centwon=SUM(central_won), centloss=SUM(central_loss), westwon=SUM(west_won), westloss=SUM(west_loss), tot=SUM(total_points), hit=SUM(hitting_points), pit=SUM(pitching_points), maxtot=MAX(total_points), maxhit=MAX(hitting_points), maxpit=MAX(pitching_points),name 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='202416' and (division='Z' or alivewild=1)) and team not in ()) AND period BETWEEN '202401' AND '202416' GROUP BY games.team,teams.name ORDER BY won DESC, tot DESC
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string11.00.7507
DriverName
stringMicrosoft JDBC Driver 12.2 for SQL Server
DriverVersion
string12.2.0.0
Datasource
stringbaseball
DataSource
stringbaseball
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringIncorrect syntax near ')'.
NativeErrorCode
number102
queryError
stringSELECT games.team, won=SUM(won), loss=SUM(loss), eastwon=SUM(east_won), eastloss=SUM(east_loss), centwon=SUM(central_won), centloss=SUM(central_loss), westwon=SUM(west_won), westloss=SUM(west_loss), tot=SUM(total_points), hit=SUM(hitting_points), pit=SUM(pitching_points), maxtot=MAX(total_points), maxhit=MAX(hitting_points), maxpit=MAX(pitching_points),name 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='202416' and (division='Z' or alivewild=1)) and team not in ()) AND period BETWEEN '202401' AND '202416' GROUP BY games.team,teams.name ORDER BY won DESC, tot DESC
Sql
stringSELECT games.team, won=SUM(won), loss=SUM(loss), eastwon=SUM(east_won), eastloss=SUM(east_loss), centwon=SUM(central_won), centloss=SUM(central_loss), westwon=SUM(west_won), westloss=SUM(west_loss), tot=SUM(total_points), hit=SUM(hitting_points), pit=SUM(pitching_points), maxtot=MAX(total_points), maxhit=MAX(hitting_points), maxpit=MAX(pitching_points),name 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='202416' and (division='Z' or alivewild=1)) and team not in ()) AND period BETWEEN '202401' AND '202416' GROUP BY games.team,teams.name ORDER BY won DESC, tot DESC
SQLState
stringS0001
StackTrace
stringlucee.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 baseball.league.standing_wildcard_cfm405$cf$8dp.call(/baseball/league/standing-wildcard.cfm:26) 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 baseball.league.standings_cfm$cf$8dm.call(/baseball/league/standings.cfm:298) 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.udfCall1(/application.cfc:792) at application_cfc$cf.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
string24: ORDER BY<br> 25: won DESC, tot DESC<br> <b>26: &lt;/cfquery&gt;</b><br> 27: &lt;/cfsilent&gt;<br> 28: <br>
codePrintPlain
string24: ORDER BY 25: won DESC, tot DESC 26: </cfquery> 27: </cfsilent> 28:
column
number0
id
string??
line
number26
Raw_Trace
stringbaseball.league.standing_wildcard_cfm405$cf$8dp.call(/baseball/league/standing-wildcard.cfm:26)
template
stringC:\Websites\www.mrsports.com\baseball\league\standing-wildcard.cfm
type
stringcfml
2
Struct
codePrintHTML
string296: &lt;/tr&gt;<br> 297: &lt;/thead&gt;<br> <b>298: &lt;cfinclude template=&quot;standing-wildcard.cfm&quot;&gt;</b><br> 299: &lt;/table&gt;<br> 300: &lt;/div&gt;<br>
codePrintPlain
string296: </tr> 297: </thead> 298: <cfinclude template="standing-wildcard.cfm"> 299: </table> 300: </div>
column
number0
id
string??
line
number298
Raw_Trace
stringbaseball.league.standings_cfm$cf$8dm.call(/baseball/league/standings.cfm:298)
template
stringC:\Websites\www.mrsports.com\baseball\league\standings.cfm
type
stringcfml
3
Struct
codePrintHTML
string790: <br> 791: &lt;!--- Include the requested page. ---&gt;<br> <b>792: &lt;cfinclude template=&quot;#arguments.TargetPage#&quot; /&gt;</b><br> 793: <br> 794: &lt;/cffunction&gt;<br>
codePrintPlain
string790: 791: <!--- Include the requested page. ---> 792: <cfinclude template="#arguments.TargetPage#" /> 793: 794: </cffunction>
column
number0
id
string??
line
number792
Raw_Trace
stringapplication_cfc$cf.udfCall1(/application.cfc:792)
template
stringC:\Websites\www.mrsports.com\application.cfc
type
stringcfml
type
stringdatabase
where
string
Sql
stringSELECT games.team, won=SUM(won), loss=SUM(loss), eastwon=SUM(east_won), eastloss=SUM(east_loss), centwon=SUM(central_won), centloss=SUM(central_loss), westwon=SUM(west_won), westloss=SUM(west_loss), tot=SUM(total_points), hit=SUM(hitting_points), pit=SUM(pitching_points), maxtot=MAX(total_points), maxhit=MAX(hitting_points), maxpit=MAX(pitching_points),name 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='202416' and (division='Z' or alivewild=1)) and team not in ()) AND period BETWEEN '202401' AND '202416' GROUP BY games.team,teams.name ORDER BY won DESC, tot DESC
SQLState
stringS0001
StackTrace
stringlucee.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 baseball.league.standing_wildcard_cfm405$cf$8dp.call(/baseball/league/standing-wildcard.cfm:26) 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 baseball.league.standings_cfm$cf$8dm.call(/baseball/league/standings.cfm:298) 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.udfCall1(/application.cfc:792) at application_cfc$cf.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
string24: ORDER BY<br> 25: won DESC, tot DESC<br> <b>26: &lt;/cfquery&gt;</b><br> 27: &lt;/cfsilent&gt;<br> 28: <br>
codePrintPlain
string24: ORDER BY 25: won DESC, tot DESC 26: </cfquery> 27: </cfsilent> 28:
column
number0
id
string??
line
number26
Raw_Trace
stringbaseball.league.standing_wildcard_cfm405$cf$8dp.call(/baseball/league/standing-wildcard.cfm:26)
template
stringC:\Websites\www.mrsports.com\baseball\league\standing-wildcard.cfm
type
stringcfml
2
Struct
codePrintHTML
string296: &lt;/tr&gt;<br> 297: &lt;/thead&gt;<br> <b>298: &lt;cfinclude template=&quot;standing-wildcard.cfm&quot;&gt;</b><br> 299: &lt;/table&gt;<br> 300: &lt;/div&gt;<br>
codePrintPlain
string296: </tr> 297: </thead> 298: <cfinclude template="standing-wildcard.cfm"> 299: </table> 300: </div>
column
number0
id
string??
line
number298
Raw_Trace
stringbaseball.league.standings_cfm$cf$8dm.call(/baseball/league/standings.cfm:298)
template
stringC:\Websites\www.mrsports.com\baseball\league\standings.cfm
type
stringcfml
3
Struct
codePrintHTML
string790: <br> 791: &lt;!--- Include the requested page. ---&gt;<br> <b>792: &lt;cfinclude template=&quot;#arguments.TargetPage#&quot; /&gt;</b><br> 793: <br> 794: &lt;/cffunction&gt;<br>
codePrintPlain
string790: 791: <!--- Include the requested page. ---> 792: <cfinclude template="#arguments.TargetPage#" /> 793: 794: </cffunction>
column
number0
id
string??
line
number792
Raw_Trace
stringapplication_cfc$cf.udfCall1(/application.cfc:792)
template
stringC:\Websites\www.mrsports.com\application.cfc
type
stringcfml
type
stringdatabase
where
string
eventName2
stringonRequest