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 = 3619
ORDER BY s.name DESC, p.name
sportsmanagementModelTeamInfo::getSeasons 345 projectteamid
66921
sportsmanagementModelTeamInfo::getSeasons 346 teamid
3619
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 6074 AND pt.id = 86812 AND tp.season_id = 202 AND st.season_id = 202 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 6074 AND pt.id = 86812 AND tp.season_id = 202 AND st.season_id = 202 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 6074 AND pt.id = 86812 AND st.season_id = 202 AND stp.season_id = 202 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 6268 AND pt.id = 89621 AND tp.season_id = 202 AND st.season_id = 202 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 6268 AND pt.id = 89621 AND tp.season_id = 202 AND st.season_id = 202 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 6268 AND pt.id = 89621 AND st.season_id = 202 AND stp.season_id = 202 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 6098 AND pt.id = 87333 AND tp.season_id = 202 AND st.season_id = 202 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 6098 AND pt.id = 87333 AND tp.season_id = 202 AND st.season_id = 202 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 6098 AND pt.id = 87333 AND st.season_id = 202 AND stp.season_id = 202 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 5786 AND pt.id = 82341 AND tp.season_id = 200 AND st.season_id = 200 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 5786 AND pt.id = 82341 AND tp.season_id = 200 AND st.season_id = 200 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 5786 AND pt.id = 82341 AND st.season_id = 200 AND stp.season_id = 200 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 5927 AND pt.id = 84691 AND tp.season_id = 200 AND st.season_id = 200 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 5927 AND pt.id = 84691 AND tp.season_id = 200 AND st.season_id = 200 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 5927 AND pt.id = 84691 AND st.season_id = 200 AND stp.season_id = 200 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 5802 AND pt.id = 82606 AND tp.season_id = 200 AND st.season_id = 200 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 5802 AND pt.id = 82606 AND tp.season_id = 200 AND st.season_id = 200 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 5802 AND pt.id = 82606 AND st.season_id = 200 AND stp.season_id = 200 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 5529 AND pt.id = 78105 AND tp.season_id = 194 AND st.season_id = 194 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 5529 AND pt.id = 78105 AND tp.season_id = 194 AND st.season_id = 194 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 5529 AND pt.id = 78105 AND st.season_id = 194 AND stp.season_id = 194 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 5681 AND pt.id = 80658 AND tp.season_id = 194 AND st.season_id = 194 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 5681 AND pt.id = 80658 AND tp.season_id = 194 AND st.season_id = 194 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 5681 AND pt.id = 80658 AND st.season_id = 194 AND stp.season_id = 194 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 5533 AND pt.id = 78214 AND tp.season_id = 194 AND st.season_id = 194 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 5533 AND pt.id = 78214 AND tp.season_id = 194 AND st.season_id = 194 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 5533 AND pt.id = 78214 AND st.season_id = 194 AND stp.season_id = 194 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 5303 AND pt.id = 74848 AND tp.season_id = 192 AND st.season_id = 192 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 5303 AND pt.id = 74848 AND tp.season_id = 192 AND st.season_id = 192 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 5303 AND pt.id = 74848 AND st.season_id = 192 AND stp.season_id = 192 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 5459 AND pt.id = 77146 AND tp.season_id = 192 AND st.season_id = 192 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 5459 AND pt.id = 77146 AND tp.season_id = 192 AND st.season_id = 192 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 5459 AND pt.id = 77146 AND st.season_id = 192 AND stp.season_id = 192 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 5307 AND pt.id = 74958 AND tp.season_id = 192 AND st.season_id = 192 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 5307 AND pt.id = 74958 AND tp.season_id = 192 AND st.season_id = 192 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 5307 AND pt.id = 74958 AND st.season_id = 192 AND stp.season_id = 192 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 5088 AND pt.id = 71596 AND tp.season_id = 191 AND st.season_id = 191 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 5088 AND pt.id = 71596 AND tp.season_id = 191 AND st.season_id = 191 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 5088 AND pt.id = 71596 AND st.season_id = 191 AND stp.season_id = 191 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 5276 AND pt.id = 74517 AND tp.season_id = 191 AND st.season_id = 191 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 5276 AND pt.id = 74517 AND tp.season_id = 191 AND st.season_id = 191 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 5276 AND pt.id = 74517 AND st.season_id = 191 AND stp.season_id = 191 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 5134 AND pt.id = 72226 AND tp.season_id = 191 AND st.season_id = 191 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 5134 AND pt.id = 72226 AND tp.season_id = 191 AND st.season_id = 191 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 5134 AND pt.id = 72226 AND st.season_id = 191 AND stp.season_id = 191 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 4828 AND pt.id = 66919 AND tp.season_id = 183 AND st.season_id = 183 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 4828 AND pt.id = 66919 AND tp.season_id = 183 AND st.season_id = 183 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 4828 AND pt.id = 66919 AND st.season_id = 183 AND stp.season_id = 183 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 5277 AND pt.id = 74522 AND tp.season_id = 183 AND st.season_id = 183 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 5277 AND pt.id = 74522 AND tp.season_id = 183 AND st.season_id = 183 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 5277 AND pt.id = 74522 AND st.season_id = 183 AND stp.season_id = 183 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 4829 AND pt.id = 66921 AND tp.season_id = 183 AND st.season_id = 183 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 4829 AND pt.id = 66921 AND tp.season_id = 183 AND st.season_id = 183 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 4829 AND pt.id = 66921 AND st.season_id = 183 AND stp.season_id = 183 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 4188 AND pt.id = 56765 AND tp.season_id = 105 AND st.season_id = 105 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 4188 AND pt.id = 56765 AND tp.season_id = 105 AND st.season_id = 105 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 4188 AND pt.id = 56765 AND st.season_id = 105 AND stp.season_id = 105 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 4647 AND pt.id = 64421 AND tp.season_id = 105 AND st.season_id = 105 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 4647 AND pt.id = 64421 AND tp.season_id = 105 AND st.season_id = 105 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 4647 AND pt.id = 64421 AND st.season_id = 105 AND stp.season_id = 105 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 4104 AND pt.id = 55601 AND tp.season_id = 103 AND st.season_id = 103 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 4104 AND pt.id = 55601 AND tp.season_id = 103 AND st.season_id = 103 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 4104 AND pt.id = 55601 AND st.season_id = 103 AND stp.season_id = 103 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 4651 AND pt.id = 64478 AND tp.season_id = 103 AND st.season_id = 103 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 4651 AND pt.id = 64478 AND tp.season_id = 103 AND st.season_id = 103 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 4651 AND pt.id = 64478 AND st.season_id = 103 AND stp.season_id = 103 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 3734 AND pt.id = 50446 AND tp.season_id = 85 AND st.season_id = 85 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 3734 AND pt.id = 50446 AND tp.season_id = 85 AND st.season_id = 85 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 3734 AND pt.id = 50446 AND st.season_id = 85 AND stp.season_id = 85 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 3141 AND pt.id = 42304 AND tp.season_id = 81 AND st.season_id = 81 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 3141 AND pt.id = 42304 AND tp.season_id = 81 AND st.season_id = 81 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 3141 AND pt.id = 42304 AND st.season_id = 81 AND stp.season_id = 81 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 3004 AND pt.id = 40438 AND tp.season_id = 79 AND st.season_id = 79 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 3004 AND pt.id = 40438 AND tp.season_id = 79 AND st.season_id = 79 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 3004 AND pt.id = 40438 AND st.season_id = 79 AND stp.season_id = 79 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 2859 AND pt.id = 38517 AND tp.season_id = 71 AND st.season_id = 71 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 2859 AND pt.id = 38517 AND tp.season_id = 71 AND st.season_id = 71 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 2859 AND pt.id = 38517 AND st.season_id = 71 AND stp.season_id = 71 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 2517 AND pt.id = 34065 AND tp.season_id = 69 AND st.season_id = 69 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 2517 AND pt.id = 34065 AND tp.season_id = 69 AND st.season_id = 69 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 2517 AND pt.id = 34065 AND st.season_id = 69 AND stp.season_id = 69 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 2518 AND pt.id = 34075 AND tp.season_id = 68 AND st.season_id = 68 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 2518 AND pt.id = 34075 AND tp.season_id = 68 AND st.season_id = 68 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 2518 AND pt.id = 34075 AND st.season_id = 68 AND stp.season_id = 68 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 3077 AND pt.id = 41443 AND tp.season_id = 55 AND st.season_id = 55 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 3077 AND pt.id = 41443 AND tp.season_id = 55 AND st.season_id = 55 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 3077 AND pt.id = 41443 AND st.season_id = 55 AND stp.season_id = 55 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 2363 AND pt.id = 31797 AND tp.season_id = 55 AND st.season_id = 55 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 2363 AND pt.id = 31797 AND tp.season_id = 55 AND st.season_id = 55 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 2363 AND pt.id = 31797 AND st.season_id = 55 AND stp.season_id = 55 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 3076 AND pt.id = 41432 AND tp.season_id = 56 AND st.season_id = 56 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 3076 AND pt.id = 41432 AND tp.season_id = 56 AND st.season_id = 56 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 3076 AND pt.id = 41432 AND st.season_id = 56 AND stp.season_id = 56 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 2211 AND pt.id = 29803 AND tp.season_id = 57 AND st.season_id = 57 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 2211 AND pt.id = 29803 AND tp.season_id = 57 AND st.season_id = 57 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 2211 AND pt.id = 29803 AND st.season_id = 57 AND stp.season_id = 57 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 2366 AND pt.id = 31847 AND tp.season_id = 58 AND st.season_id = 58 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 2366 AND pt.id = 31847 AND tp.season_id = 58 AND st.season_id = 58 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 2366 AND pt.id = 31847 AND st.season_id = 58 AND stp.season_id = 58 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 2210 AND pt.id = 29787 AND tp.season_id = 58 AND st.season_id = 58 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 2210 AND pt.id = 29787 AND tp.season_id = 58 AND st.season_id = 58 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 2210 AND pt.id = 29787 AND st.season_id = 58 AND stp.season_id = 58 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 2367 AND pt.id = 31849 AND tp.season_id = 59 AND st.season_id = 59 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 2367 AND pt.id = 31849 AND tp.season_id = 59 AND st.season_id = 59 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 2367 AND pt.id = 31849 AND st.season_id = 59 AND stp.season_id = 59 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 2209 AND pt.id = 29776 AND tp.season_id = 59 AND st.season_id = 59 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 2209 AND pt.id = 29776 AND tp.season_id = 59 AND st.season_id = 59 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 2209 AND pt.id = 29776 AND st.season_id = 59 AND stp.season_id = 59 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 2368 AND pt.id = 31878 AND tp.season_id = 60 AND st.season_id = 60 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 2368 AND pt.id = 31878 AND tp.season_id = 60 AND st.season_id = 60 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 2368 AND pt.id = 31878 AND st.season_id = 60 AND stp.season_id = 60 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 2208 AND pt.id = 29761 AND tp.season_id = 60 AND st.season_id = 60 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 2208 AND pt.id = 29761 AND tp.season_id = 60 AND st.season_id = 60 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 2208 AND pt.id = 29761 AND st.season_id = 60 AND stp.season_id = 60 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 2207 AND pt.id = 29748 AND tp.season_id = 61 AND st.season_id = 61 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 2207 AND pt.id = 29748 AND tp.season_id = 61 AND st.season_id = 61 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 2207 AND pt.id = 29748 AND st.season_id = 61 AND stp.season_id = 61 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 2033 AND pt.id = 27307 AND tp.season_id = 62 AND st.season_id = 62 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 2033 AND pt.id = 27307 AND tp.season_id = 62 AND st.season_id = 62 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 2033 AND pt.id = 27307 AND st.season_id = 62 AND stp.season_id = 62 AND stp.published = 1 AND stp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 3084 AND pt.id = 41514 AND tp.season_id = 67 AND st.season_id = 67 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 3084 AND pt.id = 41514 AND tp.season_id = 67 AND st.season_id = 67 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 3084 AND pt.id = 41514 AND st.season_id = 67 AND stp.season_id = 67 AND stp.published = 1 AND stp.persontype = 1
Bundesliga Österreich
Copyright : ©
Fussball in Europa
Projekte: 
Spielorte: 
Vereine 
Spieler 
Gruppen 
Spieltage 
Spiele 
ESVM
Fr, 29. Mai. 2026
18.30 Uhr
300
