sportsmanagementModelTeamInfo::getSeasons 344 data

SELECT pt.id as ptid, pt.team_id as season_team_id, pt.picture, pt.info, pt.project_id AS projectid,pt.points_finally,pt.neg_points_finally,pt.finaltablerank,pt.champion,pt.matches_finally,pt.won_finally,pt.draws_finally,pt.lost_finally,pt.homegoals_finally,pt.guestgoals_finally,p.name as projectname,p.season_id,p.current_round, pt.division_id,s.name as season,t.id as team_id,st.picture as season_picture,l.name as league, t.extended as teamextended, l.country as leaguecountry,CONCAT_WS( ':', p.id, p.alias ) AS project_slug,CONCAT_WS( ':', t.id, t.alias ) AS team_slug
FROM z2o57_sportsmanagement_project_team AS pt 
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.id = pt.team_id
INNER JOIN z2o57_sportsmanagement_team AS t ON t.id = st.team_id 
INNER JOIN z2o57_sportsmanagement_project AS p ON p.id = pt.project_id 
INNER JOIN z2o57_sportsmanagement_season AS s ON s.id = p.season_id 
INNER JOIN z2o57_sportsmanagement_league AS l ON l.id = p.league_id 
WHERE t.id = 3572
ORDER BY s.name DESC

sportsmanagementModelTeamInfo::getSeasons 345 projectteamid

74703

sportsmanagementModelTeamInfo::getSeasons 346 teamid

3572

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 5527 AND pt.id = 78069 AND tp.season_id = 194 AND st.season_id = 194 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 5527 AND pt.id = 78069 AND tp.season_id = 194 AND st.season_id = 194 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 5527 AND pt.id = 78069 AND st.season_id = 194 AND stp.season_id = 194 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 5292 AND pt.id = 74703 AND tp.season_id = 192 AND st.season_id = 192 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 5292 AND pt.id = 74703 AND tp.season_id = 192 AND st.season_id = 192 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 5292 AND pt.id = 74703 AND st.season_id = 192 AND stp.season_id = 192 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 5129 AND pt.id = 72139 AND tp.season_id = 191 AND st.season_id = 191 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 5129 AND pt.id = 72139 AND tp.season_id = 191 AND st.season_id = 191 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 5129 AND pt.id = 72139 AND st.season_id = 191 AND stp.season_id = 191 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4825 AND pt.id = 66866 AND tp.season_id = 183 AND st.season_id = 183 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4825 AND pt.id = 66866 AND tp.season_id = 183 AND st.season_id = 183 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4825 AND pt.id = 66866 AND st.season_id = 183 AND stp.season_id = 183 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4186 AND pt.id = 56740 AND tp.season_id = 105 AND st.season_id = 105 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4186 AND pt.id = 56740 AND tp.season_id = 105 AND st.season_id = 105 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4186 AND pt.id = 56740 AND st.season_id = 105 AND stp.season_id = 105 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3772 AND pt.id = 50965 AND tp.season_id = 103 AND st.season_id = 103 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3772 AND pt.id = 50965 AND tp.season_id = 103 AND st.season_id = 103 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 3772 AND pt.id = 50965 AND st.season_id = 103 AND stp.season_id = 103 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3239 AND pt.id = 43663 AND tp.season_id = 85 AND st.season_id = 85 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3239 AND pt.id = 43663 AND tp.season_id = 85 AND st.season_id = 85 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 3239 AND pt.id = 43663 AND st.season_id = 85 AND stp.season_id = 85 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3040 AND pt.id = 40948 AND tp.season_id = 81 AND st.season_id = 81 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3040 AND pt.id = 40948 AND tp.season_id = 81 AND st.season_id = 81 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 3040 AND pt.id = 40948 AND st.season_id = 81 AND stp.season_id = 81 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4264 AND pt.id = 57807 AND tp.season_id = 79 AND st.season_id = 79 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4264 AND pt.id = 57807 AND tp.season_id = 79 AND st.season_id = 79 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4264 AND pt.id = 57807 AND st.season_id = 79 AND stp.season_id = 79 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4265 AND pt.id = 57821 AND tp.season_id = 71 AND st.season_id = 71 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4265 AND pt.id = 57821 AND tp.season_id = 71 AND st.season_id = 71 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4265 AND pt.id = 57821 AND st.season_id = 71 AND stp.season_id = 71 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4266 AND pt.id = 57837 AND tp.season_id = 69 AND st.season_id = 69 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4266 AND pt.id = 57837 AND tp.season_id = 69 AND st.season_id = 69 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4266 AND pt.id = 57837 AND st.season_id = 69 AND stp.season_id = 69 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4268 AND pt.id = 57876 AND tp.season_id = 68 AND st.season_id = 68 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4268 AND pt.id = 57876 AND tp.season_id = 68 AND st.season_id = 68 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4268 AND pt.id = 57876 AND st.season_id = 68 AND stp.season_id = 68 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4325 AND pt.id = 58899 AND tp.season_id = 55 AND st.season_id = 55 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4325 AND pt.id = 58899 AND tp.season_id = 55 AND st.season_id = 55 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4325 AND pt.id = 58899 AND st.season_id = 55 AND stp.season_id = 55 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4269 AND pt.id = 57889 AND tp.season_id = 56 AND st.season_id = 56 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4269 AND pt.id = 57889 AND tp.season_id = 56 AND st.season_id = 56 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4269 AND pt.id = 57889 AND st.season_id = 56 AND stp.season_id = 56 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4270 AND pt.id = 57904 AND tp.season_id = 57 AND st.season_id = 57 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4270 AND pt.id = 57904 AND tp.season_id = 57 AND st.season_id = 57 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4270 AND pt.id = 57904 AND st.season_id = 57 AND stp.season_id = 57 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4271 AND pt.id = 57922 AND tp.season_id = 58 AND st.season_id = 58 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4271 AND pt.id = 57922 AND tp.season_id = 58 AND st.season_id = 58 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4271 AND pt.id = 57922 AND st.season_id = 58 AND stp.season_id = 58 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4272 AND pt.id = 57948 AND tp.season_id = 59 AND st.season_id = 59 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4272 AND pt.id = 57948 AND tp.season_id = 59 AND st.season_id = 59 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4272 AND pt.id = 57948 AND st.season_id = 59 AND stp.season_id = 59 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4273 AND pt.id = 57957 AND tp.season_id = 60 AND st.season_id = 60 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4273 AND pt.id = 57957 AND tp.season_id = 60 AND st.season_id = 60 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4273 AND pt.id = 57957 AND st.season_id = 60 AND stp.season_id = 60 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4274 AND pt.id = 57982 AND tp.season_id = 61 AND st.season_id = 61 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4274 AND pt.id = 57982 AND tp.season_id = 61 AND st.season_id = 61 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4274 AND pt.id = 57982 AND st.season_id = 61 AND stp.season_id = 61 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4332 AND pt.id = 59029 AND tp.season_id = 62 AND st.season_id = 62 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4332 AND pt.id = 59029 AND tp.season_id = 62 AND st.season_id = 62 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4332 AND pt.id = 59029 AND st.season_id = 62 AND stp.season_id = 62 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4276 AND pt.id = 58011 AND tp.season_id = 67 AND st.season_id = 67 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4276 AND pt.id = 58011 AND tp.season_id = 67 AND st.season_id = 67 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4276 AND pt.id = 58011 AND st.season_id = 67 AND stp.season_id = 67 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4334 AND pt.id = 59050 AND tp.season_id = 63 AND st.season_id = 63 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4334 AND pt.id = 59050 AND tp.season_id = 63 AND st.season_id = 63 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4334 AND pt.id = 59050 AND st.season_id = 63 AND stp.season_id = 63 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4335 AND pt.id = 59074 AND tp.season_id = 64 AND st.season_id = 64 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4335 AND pt.id = 59074 AND tp.season_id = 64 AND st.season_id = 64 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4335 AND pt.id = 59074 AND st.season_id = 64 AND stp.season_id = 64 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4280 AND pt.id = 58092 AND tp.season_id = 65 AND st.season_id = 65 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4280 AND pt.id = 58092 AND tp.season_id = 65 AND st.season_id = 65 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4280 AND pt.id = 58092 AND st.season_id = 65 AND stp.season_id = 65 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4281 AND pt.id = 58104 AND tp.season_id = 66 AND st.season_id = 66 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4281 AND pt.id = 58104 AND tp.season_id = 66 AND st.season_id = 66 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4281 AND pt.id = 58104 AND st.season_id = 66 AND stp.season_id = 66 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4282 AND pt.id = 58115 AND tp.season_id = 72 AND st.season_id = 72 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4282 AND pt.id = 58115 AND tp.season_id = 72 AND st.season_id = 72 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4282 AND pt.id = 58115 AND st.season_id = 72 AND stp.season_id = 72 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4339 AND pt.id = 59138 AND tp.season_id = 73 AND st.season_id = 73 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4339 AND pt.id = 59138 AND tp.season_id = 73 AND st.season_id = 73 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4339 AND pt.id = 59138 AND st.season_id = 73 AND stp.season_id = 73 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4340 AND pt.id = 59162 AND tp.season_id = 74 AND st.season_id = 74 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4340 AND pt.id = 59162 AND tp.season_id = 74 AND st.season_id = 74 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4340 AND pt.id = 59162 AND st.season_id = 74 AND stp.season_id = 74 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4285 AND pt.id = 58178 AND tp.season_id = 75 AND st.season_id = 75 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4285 AND pt.id = 58178 AND tp.season_id = 75 AND st.season_id = 75 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4285 AND pt.id = 58178 AND st.season_id = 75 AND stp.season_id = 75 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4286 AND pt.id = 58200 AND tp.season_id = 76 AND st.season_id = 76 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4286 AND pt.id = 58200 AND tp.season_id = 76 AND st.season_id = 76 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4286 AND pt.id = 58200 AND st.season_id = 76 AND stp.season_id = 76 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4287 AND pt.id = 58205 AND tp.season_id = 77 AND st.season_id = 77 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4287 AND pt.id = 58205 AND tp.season_id = 77 AND st.season_id = 77 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4287 AND pt.id = 58205 AND st.season_id = 77 AND stp.season_id = 77 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4288 AND pt.id = 58230 AND tp.season_id = 78 AND st.season_id = 78 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4288 AND pt.id = 58230 AND tp.season_id = 78 AND st.season_id = 78 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4288 AND pt.id = 58230 AND st.season_id = 78 AND stp.season_id = 78 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4289 AND pt.id = 58251 AND tp.season_id = 107 AND st.season_id = 107 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4289 AND pt.id = 58251 AND tp.season_id = 107 AND st.season_id = 107 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4289 AND pt.id = 58251 AND st.season_id = 107 AND stp.season_id = 107 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4290 AND pt.id = 58272 AND tp.season_id = 108 AND st.season_id = 108 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4290 AND pt.id = 58272 AND tp.season_id = 108 AND st.season_id = 108 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4290 AND pt.id = 58272 AND st.season_id = 108 AND stp.season_id = 108 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4291 AND pt.id = 58286 AND tp.season_id = 109 AND st.season_id = 109 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4291 AND pt.id = 58286 AND tp.season_id = 109 AND st.season_id = 109 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4291 AND pt.id = 58286 AND st.season_id = 109 AND stp.season_id = 109 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4292 AND pt.id = 58303 AND tp.season_id = 110 AND st.season_id = 110 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4292 AND pt.id = 58303 AND tp.season_id = 110 AND st.season_id = 110 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4292 AND pt.id = 58303 AND st.season_id = 110 AND stp.season_id = 110 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4293 AND pt.id = 58315 AND tp.season_id = 111 AND st.season_id = 111 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4293 AND pt.id = 58315 AND tp.season_id = 111 AND st.season_id = 111 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4293 AND pt.id = 58315 AND st.season_id = 111 AND stp.season_id = 111 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4294 AND pt.id = 58342 AND tp.season_id = 112 AND st.season_id = 112 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4294 AND pt.id = 58342 AND tp.season_id = 112 AND st.season_id = 112 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4294 AND pt.id = 58342 AND st.season_id = 112 AND stp.season_id = 112 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4295 AND pt.id = 58353 AND tp.season_id = 80 AND st.season_id = 80 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4295 AND pt.id = 58353 AND tp.season_id = 80 AND st.season_id = 80 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4295 AND pt.id = 58353 AND st.season_id = 80 AND stp.season_id = 80 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4296 AND pt.id = 58371 AND tp.season_id = 82 AND st.season_id = 82 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4296 AND pt.id = 58371 AND tp.season_id = 82 AND st.season_id = 82 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4296 AND pt.id = 58371 AND st.season_id = 82 AND stp.season_id = 82 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4297 AND pt.id = 58386 AND tp.season_id = 83 AND st.season_id = 83 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4297 AND pt.id = 58386 AND tp.season_id = 83 AND st.season_id = 83 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4297 AND pt.id = 58386 AND st.season_id = 83 AND stp.season_id = 83 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4298 AND pt.id = 58417 AND tp.season_id = 84 AND st.season_id = 84 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4298 AND pt.id = 58417 AND tp.season_id = 84 AND st.season_id = 84 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4298 AND pt.id = 58417 AND st.season_id = 84 AND stp.season_id = 84 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4299 AND pt.id = 58430 AND tp.season_id = 86 AND st.season_id = 86 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4299 AND pt.id = 58430 AND tp.season_id = 86 AND st.season_id = 86 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4299 AND pt.id = 58430 AND st.season_id = 86 AND stp.season_id = 86 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4300 AND pt.id = 58447 AND tp.season_id = 113 AND st.season_id = 113 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4300 AND pt.id = 58447 AND tp.season_id = 113 AND st.season_id = 113 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4300 AND pt.id = 58447 AND st.season_id = 113 AND stp.season_id = 113 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4301 AND pt.id = 58466 AND tp.season_id = 114 AND st.season_id = 114 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4301 AND pt.id = 58466 AND tp.season_id = 114 AND st.season_id = 114 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4301 AND pt.id = 58466 AND st.season_id = 114 AND stp.season_id = 114 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4302 AND pt.id = 58487 AND tp.season_id = 115 AND st.season_id = 115 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4302 AND pt.id = 58487 AND tp.season_id = 115 AND st.season_id = 115 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4302 AND pt.id = 58487 AND st.season_id = 115 AND stp.season_id = 115 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4303 AND pt.id = 58496 AND tp.season_id = 116 AND st.season_id = 116 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4303 AND pt.id = 58496 AND tp.season_id = 116 AND st.season_id = 116 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4303 AND pt.id = 58496 AND st.season_id = 116 AND stp.season_id = 116 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4304 AND pt.id = 58521 AND tp.season_id = 117 AND st.season_id = 117 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4304 AND pt.id = 58521 AND tp.season_id = 117 AND st.season_id = 117 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4304 AND pt.id = 58521 AND st.season_id = 117 AND stp.season_id = 117 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4305 AND pt.id = 58534 AND tp.season_id = 118 AND st.season_id = 118 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4305 AND pt.id = 58534 AND tp.season_id = 118 AND st.season_id = 118 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4305 AND pt.id = 58534 AND st.season_id = 118 AND stp.season_id = 118 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4306 AND pt.id = 58563 AND tp.season_id = 119 AND st.season_id = 119 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4306 AND pt.id = 58563 AND tp.season_id = 119 AND st.season_id = 119 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4306 AND pt.id = 58563 AND st.season_id = 119 AND stp.season_id = 119 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4307 AND pt.id = 58569 AND tp.season_id = 87 AND st.season_id = 87 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4307 AND pt.id = 58569 AND tp.season_id = 87 AND st.season_id = 87 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4307 AND pt.id = 58569 AND st.season_id = 87 AND stp.season_id = 87 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4308 AND pt.id = 58588 AND tp.season_id = 88 AND st.season_id = 88 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4308 AND pt.id = 58588 AND tp.season_id = 88 AND st.season_id = 88 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4308 AND pt.id = 58588 AND st.season_id = 88 AND stp.season_id = 88 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4309 AND pt.id = 58611 AND tp.season_id = 89 AND st.season_id = 89 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4309 AND pt.id = 58611 AND tp.season_id = 89 AND st.season_id = 89 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4309 AND pt.id = 58611 AND st.season_id = 89 AND stp.season_id = 89 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4310 AND pt.id = 58626 AND tp.season_id = 90 AND st.season_id = 90 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4310 AND pt.id = 58626 AND tp.season_id = 90 AND st.season_id = 90 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4310 AND pt.id = 58626 AND st.season_id = 90 AND stp.season_id = 90 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4311 AND pt.id = 58653 AND tp.season_id = 91 AND st.season_id = 91 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4311 AND pt.id = 58653 AND tp.season_id = 91 AND st.season_id = 91 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4311 AND pt.id = 58653 AND st.season_id = 91 AND stp.season_id = 91 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4312 AND pt.id = 58666 AND tp.season_id = 92 AND st.season_id = 92 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4312 AND pt.id = 58666 AND tp.season_id = 92 AND st.season_id = 92 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4312 AND pt.id = 58666 AND st.season_id = 92 AND stp.season_id = 92 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4313 AND pt.id = 58689 AND tp.season_id = 94 AND st.season_id = 94 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4313 AND pt.id = 58689 AND tp.season_id = 94 AND st.season_id = 94 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4313 AND pt.id = 58689 AND st.season_id = 94 AND stp.season_id = 94 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4314 AND pt.id = 58697 AND tp.season_id = 93 AND st.season_id = 93 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4314 AND pt.id = 58697 AND tp.season_id = 93 AND st.season_id = 93 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4314 AND pt.id = 58697 AND st.season_id = 93 AND stp.season_id = 93 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4315 AND pt.id = 58716 AND tp.season_id = 95 AND st.season_id = 95 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4315 AND pt.id = 58716 AND tp.season_id = 95 AND st.season_id = 95 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4315 AND pt.id = 58716 AND st.season_id = 95 AND stp.season_id = 95 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4316 AND pt.id = 58738 AND tp.season_id = 96 AND st.season_id = 96 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4316 AND pt.id = 58738 AND tp.season_id = 96 AND st.season_id = 96 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4316 AND pt.id = 58738 AND st.season_id = 96 AND stp.season_id = 96 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4317 AND pt.id = 58748 AND tp.season_id = 97 AND st.season_id = 97 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 4317 AND pt.id = 58748 AND tp.season_id = 97 AND st.season_id = 97 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 4317 AND pt.id = 58748 AND st.season_id = 97 AND stp.season_id = 97 AND stp.published = 1