Page 1 of 1
Dropped third
Posted: Mon Apr 22, 2013 6:47 pm
by Gleneste1
Is there a stat somewhere it shows how many dropped 3 strikes safe or out at first.
Re: Dropped third
Posted: Mon Apr 22, 2013 7:45 pm
by FTMSupport
No, there is not a stat specifically for this. It will appear on the scorecard, in the pitch by pitch, and in the iScorecast.
Re: Dropped third
Posted: Mon Apr 22, 2013 8:13 pm
by elcray
You can do this in the API (Team web page) but it's pretty complicated. I use the gamedata.php and store all of the pitch events in a database table. Then I have 2 queries that sort out EVENTS and RESULTS. From this I can calculate how many innings each player played in a position, how many errors in that position, and also the dropped 3rd; both safe and out for catchers, as well as passed balls.
So, for what you are looking for, I use 4 tables in my process:
tblLeague = A table that includes all of the leagues
tblLeagueGameXref = A table that cross references league ID's to Game ID's
tblEvent = A table that lists each event for each pitch by game.
tblPOSByPitch = for each Pitch ID, this has a field for all positions. Each player ID is stored in that position
Here is the SQL statement to find "Dropped Third Strike Out". To find "Dropped Third Strike Safe", change the DTRO to DTRS below:
SELECT tblPOSByPitch.Pos2 AS PlayerID, tblLeague.Name AS LeagueName, COUNT(tblEVENT.eType) AS TypeCount
FROM dbo.tblLeague AS tblLeague RIGHT OUTER JOIN
dbo.tblLeagueGameXref AS tblLeagueGameXref ON tblLeague.LID = tblLeagueGameXref.LID RIGHT OUTER JOIN
dbo.tblEVENT AS tblEVENT ON tblLeagueGameXref.GameID = tblEVENT.GameID LEFT OUTER JOIN
dbo.tblPOSByPitch AS tblPOSByPitch ON tblEVENT.GameID = tblPOSByPitch.GameID AND tblEVENT.PitchID = tblPOSByPitch.PitchID
WHERE (tblEVENT.eType = N'DRTO')
GROUP BY tblPOSByPitch.Pos2, tblLeague.Name
Re: Dropped third
Posted: Mon Apr 22, 2013 8:21 pm
by FTMSupport
fyi... the innings in position and errors in position are part of the standard stats as of v4.0.
Re: Dropped third
Posted: Mon Apr 22, 2013 8:40 pm
by elcray
Yea, I have seen that, but I don't import the stats from the API at this point, so I still use my tool. Trying to slowly integrate your new changes in our website, but you guys are faster than me...and I may or may not be a monkey.
