Query
Template: /baseball/players/yearly-stats.cfm:74
Execution Time: 25.9 ms
Record Count: 14
Cached: No
Lazy: No
SQL:
SELECT ptsR=SUM(feeds.scored_points),
gmsR=SUM(feeds.games),
ppgR=(convert(real,SUM(feeds.scored_points)) / convert(real,SUM(feeds.games))),
tbR=SUM(feeds.total_bases),
rbiR=SUM(feeds.rbi),
runR=SUM(feeds.runs),
sbR=SUM(feeds.stolen_bases),
bbR=SUM(feeds.bb),
cR=SUM(feeds.c_games),
b1R=SUM(feeds.fb_games),
b2R=SUM(feeds.sb_games),
ssR=SUM(feeds.ss_games),
b3R=SUM(feeds.tb_games),
outR=SUM(feeds.of_games),
dhR=SUM(feeds.dh_games),
(select sum(dailystats.doubles) from dailystats where player=feeds.player and date like CONCAT(substring(feeds.period,1,4), '%')) as doubler,
(select sum(dailystats.triples) from dailystats where player=feeds.player and date like CONCAT(substring(feeds.period,1,4), '%')) as tripler,
(select sum(dailystats.hr) from dailystats where player=feeds.player and date like CONCAT(substring(feeds.period,1,4), '%')) as hrr,
proteam,year=substring(period,1,4)
from feeds
WHERE player = '9526' and proteam <> 'F/A' and proteam <> 'Ret'
group by substring(period,1,4),proteam,feeds.player
order by substring(period,1,4) asc
ptsRgmsRppgRtbRrbiRrunRsbRbbRcRb1Rb2RssRb3RoutRdhRdoublertriplerhrrproteamyear
131132.38461541554250000000300Ari2013
2202872.32183912224338150016600001566Ari2014
341231.7826087177110600141500022432015
42431132.1504424134344713150098140002243Ari2015
53211182.7203391804852212000170049025105Ari2016
6281962.927083316051411217002254026025112Ari2017
71671001.6781223210220090135601504Ari2018
810525021200002401504KC2018
927191.421052612531600117111613Bos2019
1060401.53099480014312140613KC2019
1136152.41859130081260102Col2020
1250212.38095242759270031171431Col2021
132525180611000118210200Bal2022
14480.54000000010010000Pit2023
Mr. Sports

Chris Owings

Outfielder
Los Angeles Dodgers
Birthday: August 12, 1991   Age: 32
Yearly Stats
General Info Hitting Breakdown Games by Position Breakdown
Year Proteam Points Games PPG Doubles Triples HR Total Bases RBI Run SB BB C 1B 2B SS 3B OF DH
2013 Ari 31 13 2.38 3 0 0 15 5 4 2 5 0 0 0 0 0 0 0
2014 Ari 202 87 2.32 15 6 6 122 24 33 8 15 0 0 16 60 0 0 0
2015 Ari 41 23 1.78 22 4 3 17 7 11 0 6 0 0 14 15 0 0 0
Scope Arguments
exception1
Catch
Entries: 13
additional
Struct (ordered)
pattern
stringlistgetat(list:string, position:number, [delimiters:string, [includeEmptyFields:boolean]]):string
Cause
Struct
additional
Struct (ordered)
pattern
stringlistgetat(list:string, position:number, [delimiters:string, [includeEmptyFields:boolean]]):string
Detail
string
ErrNumber
number0
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringinvalid call of the function listGetAt, second Argument (posNumber) is invalid, invalid string list index [2]
StackTrace
stringlucee.runtime.exp.FunctionException: invalid call of the function listGetAt, second Argument (posNumber) is invalid, invalid string list index [2] at lucee.runtime.functions.list.ListGetAt.call(ListGetAt.java:46) at lucee.runtime.functions.list.ListGetAt.call(ListGetAt.java:40) at baseball.players.yearly_stats_cfm315$cf$r2c.call(/baseball/players/yearly-stats.cfm:346) 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$r25.udfCall1(/application.cfc:783) at application_cfc$cf$r25.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
string344: &lt;/td&gt;<br> 345: &lt;td class=&quot;text-center&quot;&gt;<br> <b>346: #listgetat(proteamlist,yearcount,&quot;-&quot;)#</b><br> 347: &lt;/td&gt;<br> 348: &lt;td class=&quot;text-center&quot;&gt;<br>
codePrintPlain
string344: </td> 345: <td class="text-center"> 346: #listgetat(proteamlist,yearcount,"-")# 347: </td> 348: <td class="text-center">
column
number0
id
string??
line
number346
Raw_Trace
stringbaseball.players.yearly_stats_cfm315$cf$r2c.call(/baseball/players/yearly-stats.cfm:346)
template
stringC:\Websites\www.mrsports.com\baseball\players\yearly-stats.cfm
type
stringcfml
2
Struct
codePrintHTML
string781: <br> 782: &lt;!--- Include the requested page. ---&gt;<br> <b>783: &lt;cfinclude template=&quot;#arguments.TargetPage#&quot; /&gt;</b><br> 784: <br> 785: &lt;/cffunction&gt;<br>
codePrintPlain
string781: 782: <!--- Include the requested page. ---> 783: <cfinclude template="#arguments.TargetPage#" /> 784: 785: </cffunction>
column
number0
id
string??
line
number783
Raw_Trace
stringapplication_cfc$cf$r25.udfCall1(/application.cfc:783)
template
stringC:\Websites\www.mrsports.com\application.cfc
type
stringcfml
type
stringexpression
Detail
string
ErrNumber
number0
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringinvalid call of the function listGetAt, second Argument (posNumber) is invalid, invalid string list index [2]
name
stringonRequest
rootCause
Struct
additional
Struct (ordered)
pattern
stringlistgetat(list:string, position:number, [delimiters:string, [includeEmptyFields:boolean]]):string
Detail
string
ErrNumber
number0
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringinvalid call of the function listGetAt, second Argument (posNumber) is invalid, invalid string list index [2]
StackTrace
stringlucee.runtime.exp.FunctionException: invalid call of the function listGetAt, second Argument (posNumber) is invalid, invalid string list index [2] at lucee.runtime.functions.list.ListGetAt.call(ListGetAt.java:46) at lucee.runtime.functions.list.ListGetAt.call(ListGetAt.java:40) at baseball.players.yearly_stats_cfm315$cf$r2c.call(/baseball/players/yearly-stats.cfm:346) 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$r25.udfCall1(/application.cfc:783) at application_cfc$cf$r25.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
string344: &lt;/td&gt;<br> 345: &lt;td class=&quot;text-center&quot;&gt;<br> <b>346: #listgetat(proteamlist,yearcount,&quot;-&quot;)#</b><br> 347: &lt;/td&gt;<br> 348: &lt;td class=&quot;text-center&quot;&gt;<br>
codePrintPlain
string344: </td> 345: <td class="text-center"> 346: #listgetat(proteamlist,yearcount,"-")# 347: </td> 348: <td class="text-center">
column
number0
id
string??
line
number346
Raw_Trace
stringbaseball.players.yearly_stats_cfm315$cf$r2c.call(/baseball/players/yearly-stats.cfm:346)
template
stringC:\Websites\www.mrsports.com\baseball\players\yearly-stats.cfm
type
stringcfml
2
Struct
codePrintHTML
string781: <br> 782: &lt;!--- Include the requested page. ---&gt;<br> <b>783: &lt;cfinclude template=&quot;#arguments.TargetPage#&quot; /&gt;</b><br> 784: <br> 785: &lt;/cffunction&gt;<br>
codePrintPlain
string781: 782: <!--- Include the requested page. ---> 783: <cfinclude template="#arguments.TargetPage#" /> 784: 785: </cffunction>
column
number0
id
string??
line
number783
Raw_Trace
stringapplication_cfc$cf$r25.udfCall1(/application.cfc:783)
template
stringC:\Websites\www.mrsports.com\application.cfc
type
stringcfml
type
stringexpression
StackTrace
stringlucee.runtime.exp.FunctionException: invalid call of the function listGetAt, second Argument (posNumber) is invalid, invalid string list index [2] at lucee.runtime.functions.list.ListGetAt.call(ListGetAt.java:46) at lucee.runtime.functions.list.ListGetAt.call(ListGetAt.java:40) at baseball.players.yearly_stats_cfm315$cf$r2c.call(/baseball/players/yearly-stats.cfm:346) 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$r25.udfCall1(/application.cfc:783) at application_cfc$cf$r25.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
string344: &lt;/td&gt;<br> 345: &lt;td class=&quot;text-center&quot;&gt;<br> <b>346: #listgetat(proteamlist,yearcount,&quot;-&quot;)#</b><br> 347: &lt;/td&gt;<br> 348: &lt;td class=&quot;text-center&quot;&gt;<br>
codePrintPlain
string344: </td> 345: <td class="text-center"> 346: #listgetat(proteamlist,yearcount,"-")# 347: </td> 348: <td class="text-center">
column
number0
id
string??
line
number346
Raw_Trace
stringbaseball.players.yearly_stats_cfm315$cf$r2c.call(/baseball/players/yearly-stats.cfm:346)
template
stringC:\Websites\www.mrsports.com\baseball\players\yearly-stats.cfm
type
stringcfml
2
Struct
codePrintHTML
string781: <br> 782: &lt;!--- Include the requested page. ---&gt;<br> <b>783: &lt;cfinclude template=&quot;#arguments.TargetPage#&quot; /&gt;</b><br> 784: <br> 785: &lt;/cffunction&gt;<br>
codePrintPlain
string781: 782: <!--- Include the requested page. ---> 783: <cfinclude template="#arguments.TargetPage#" /> 784: 785: </cffunction>
column
number0
id
string??
line
number783
Raw_Trace
stringapplication_cfc$cf$r25.udfCall1(/application.cfc:783)
template
stringC:\Websites\www.mrsports.com\application.cfc
type
stringcfml
type
stringexpression
eventName2
stringonRequest