mysql exports question

[wellsoliver]

Is there some way to determine the stint of a player within a year? Meaning if you run the query:

SELECT *
FROM `players_career_batting_stats`
WHERE player_id = 23005
ORDER BY `year` DESC;

You might get multiple entries for the same year if he went through the minors, or was traded among teams. It'd be nice to be able to further order this query to order them by the most recent within the year.

I suppose you could do something with joining the games table and using the date field there, but just wondering if there's an easier way.

[fhomess]

Originally Posted by wellsoliver

Is there some way to determine the stint of a player within a year? Meaning if you run the query:

You might get multiple entries for the same year if he went through the minors, or was traded among teams. It'd be nice to be able to further order this query to order them by the most recent within the year.

I suppose you could do something with joining the games table and using the date field there, but just wondering if there's an easier way.

There's no way to determine stint from the SQL tables other than matching on the games table, which is only maintained for the current season. You will want to filter by split, though. In the career_batting and career_pitching tables, split_id=1 corresponds to regular season games. Obviously, you do have team_id and league_id fields, but there isn't any way to figure out what order they occurred in without the games table.