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 = 6748
ORDER BY s.name DESC, p.name
sportsmanagementModelTeamInfo::getSeasons 345 projectteamid
67373
sportsmanagementModelTeamInfo::getSeasons 346 teamid
6748
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 = 4649 AND pt.id = 64458 AND tp.season_id = 74 AND st.season_id = 74 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 = 4649 AND pt.id = 64458 AND tp.season_id = 74 AND st.season_id = 74 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 = 4649 AND pt.id = 64458 AND st.season_id = 74 AND stp.season_id = 74 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 = 4653 AND pt.id = 64496 AND tp.season_id = 75 AND st.season_id = 75 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 = 4653 AND pt.id = 64496 AND tp.season_id = 75 AND st.season_id = 75 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 = 4653 AND pt.id = 64496 AND st.season_id = 75 AND stp.season_id = 75 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 = 4654 AND pt.id = 64526 AND tp.season_id = 76 AND st.season_id = 76 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 = 4654 AND pt.id = 64526 AND tp.season_id = 76 AND st.season_id = 76 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 = 4654 AND pt.id = 64526 AND st.season_id = 76 AND stp.season_id = 76 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 = 4479 AND pt.id = 61318 AND tp.season_id = 77 AND st.season_id = 77 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 = 4479 AND pt.id = 61318 AND tp.season_id = 77 AND st.season_id = 77 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 = 4479 AND pt.id = 61318 AND st.season_id = 77 AND stp.season_id = 77 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 = 4478 AND pt.id = 61284 AND tp.season_id = 78 AND st.season_id = 78 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 = 4478 AND pt.id = 61284 AND tp.season_id = 78 AND st.season_id = 78 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 = 4478 AND pt.id = 61284 AND st.season_id = 78 AND stp.season_id = 78 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 = 5966 AND pt.id = 85370 AND tp.season_id = 107 AND st.season_id = 107 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 = 5966 AND pt.id = 85370 AND tp.season_id = 107 AND st.season_id = 107 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 = 5966 AND pt.id = 85370 AND st.season_id = 107 AND stp.season_id = 107 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 = 4834 AND pt.id = 67092 AND tp.season_id = 108 AND st.season_id = 108 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 = 4834 AND pt.id = 67092 AND tp.season_id = 108 AND st.season_id = 108 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 = 4834 AND pt.id = 67092 AND st.season_id = 108 AND stp.season_id = 108 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 = 4835 AND pt.id = 67094 AND tp.season_id = 109 AND st.season_id = 109 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 = 4835 AND pt.id = 67094 AND tp.season_id = 109 AND st.season_id = 109 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 = 4835 AND pt.id = 67094 AND st.season_id = 109 AND stp.season_id = 109 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 = 4836 AND pt.id = 67127 AND tp.season_id = 110 AND st.season_id = 110 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 = 4836 AND pt.id = 67127 AND tp.season_id = 110 AND st.season_id = 110 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 = 4836 AND pt.id = 67127 AND st.season_id = 110 AND stp.season_id = 110 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 = 4837 AND pt.id = 67160 AND tp.season_id = 111 AND st.season_id = 111 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 = 4837 AND pt.id = 67160 AND tp.season_id = 111 AND st.season_id = 111 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 = 4837 AND pt.id = 67160 AND st.season_id = 111 AND stp.season_id = 111 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 = 4838 AND pt.id = 67173 AND tp.season_id = 112 AND st.season_id = 112 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 = 4838 AND pt.id = 67173 AND tp.season_id = 112 AND st.season_id = 112 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 = 4838 AND pt.id = 67173 AND st.season_id = 112 AND stp.season_id = 112 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 = 4839 AND pt.id = 67199 AND tp.season_id = 80 AND st.season_id = 80 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 = 4839 AND pt.id = 67199 AND tp.season_id = 80 AND st.season_id = 80 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 = 4839 AND pt.id = 67199 AND st.season_id = 80 AND stp.season_id = 80 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 = 4841 AND pt.id = 67241 AND tp.season_id = 82 AND st.season_id = 82 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 = 4841 AND pt.id = 67241 AND tp.season_id = 82 AND st.season_id = 82 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 = 4841 AND pt.id = 67241 AND st.season_id = 82 AND stp.season_id = 82 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 = 4842 AND pt.id = 67268 AND tp.season_id = 83 AND st.season_id = 83 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 = 4842 AND pt.id = 67268 AND tp.season_id = 83 AND st.season_id = 83 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 = 4842 AND pt.id = 67268 AND st.season_id = 83 AND stp.season_id = 83 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 = 4843 AND pt.id = 67290 AND tp.season_id = 84 AND st.season_id = 84 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 = 4843 AND pt.id = 67290 AND tp.season_id = 84 AND st.season_id = 84 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 = 4843 AND pt.id = 67290 AND st.season_id = 84 AND stp.season_id = 84 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 = 4844 AND pt.id = 67312 AND tp.season_id = 86 AND st.season_id = 86 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 = 4844 AND pt.id = 67312 AND tp.season_id = 86 AND st.season_id = 86 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 = 4844 AND pt.id = 67312 AND st.season_id = 86 AND stp.season_id = 86 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 = 4845 AND pt.id = 67328 AND tp.season_id = 113 AND st.season_id = 113 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 = 4845 AND pt.id = 67328 AND tp.season_id = 113 AND st.season_id = 113 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 = 4845 AND pt.id = 67328 AND st.season_id = 113 AND stp.season_id = 113 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 = 4846 AND pt.id = 67353 AND tp.season_id = 114 AND st.season_id = 114 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 = 4846 AND pt.id = 67353 AND tp.season_id = 114 AND st.season_id = 114 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 = 4846 AND pt.id = 67353 AND st.season_id = 114 AND stp.season_id = 114 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 = 4847 AND pt.id = 67373 AND tp.season_id = 115 AND st.season_id = 115 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 = 4847 AND pt.id = 67373 AND tp.season_id = 115 AND st.season_id = 115 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 = 4847 AND pt.id = 67373 AND st.season_id = 115 AND stp.season_id = 115 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 = 4848 AND pt.id = 67385 AND tp.season_id = 116 AND st.season_id = 116 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 = 4848 AND pt.id = 67385 AND tp.season_id = 116 AND st.season_id = 116 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 = 4848 AND pt.id = 67385 AND st.season_id = 116 AND stp.season_id = 116 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 = 4849 AND pt.id = 67422 AND tp.season_id = 117 AND st.season_id = 117 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 = 4849 AND pt.id = 67422 AND tp.season_id = 117 AND st.season_id = 117 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 = 4849 AND pt.id = 67422 AND st.season_id = 117 AND stp.season_id = 117 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 = 4850 AND pt.id = 67442 AND tp.season_id = 118 AND st.season_id = 118 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 = 4850 AND pt.id = 67442 AND tp.season_id = 118 AND st.season_id = 118 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 = 4850 AND pt.id = 67442 AND st.season_id = 118 AND stp.season_id = 118 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 = 4851 AND pt.id = 67464 AND tp.season_id = 119 AND st.season_id = 119 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 = 4851 AND pt.id = 67464 AND tp.season_id = 119 AND st.season_id = 119 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 = 4851 AND pt.id = 67464 AND st.season_id = 119 AND stp.season_id = 119 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 = 4872 AND pt.id = 67919 AND tp.season_id = 127 AND st.season_id = 127 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 = 4872 AND pt.id = 67919 AND tp.season_id = 127 AND st.season_id = 127 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 = 4872 AND pt.id = 67919 AND st.season_id = 127 AND stp.season_id = 127 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 = 4884 AND pt.id = 68190 AND tp.season_id = 138 AND st.season_id = 138 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 = 4884 AND pt.id = 68190 AND tp.season_id = 138 AND st.season_id = 138 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 = 4884 AND pt.id = 68190 AND st.season_id = 138 AND stp.season_id = 138 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 = 4885 AND pt.id = 68210 AND tp.season_id = 140 AND st.season_id = 140 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 = 4885 AND pt.id = 68210 AND tp.season_id = 140 AND st.season_id = 140 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 = 4885 AND pt.id = 68210 AND st.season_id = 140 AND stp.season_id = 140 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 = 4886 AND pt.id = 68232 AND tp.season_id = 139 AND st.season_id = 139 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 = 4886 AND pt.id = 68232 AND tp.season_id = 139 AND st.season_id = 139 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 = 4886 AND pt.id = 68232 AND st.season_id = 139 AND stp.season_id = 139 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 = 4887 AND pt.id = 68252 AND tp.season_id = 141 AND st.season_id = 141 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 = 4887 AND pt.id = 68252 AND tp.season_id = 141 AND st.season_id = 141 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 = 4887 AND pt.id = 68252 AND st.season_id = 141 AND stp.season_id = 141 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 = 4888 AND pt.id = 68272 AND tp.season_id = 142 AND st.season_id = 142 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 = 4888 AND pt.id = 68272 AND tp.season_id = 142 AND st.season_id = 142 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 = 4888 AND pt.id = 68272 AND st.season_id = 142 AND stp.season_id = 142 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 = 4889 AND pt.id = 68293 AND tp.season_id = 143 AND st.season_id = 143 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 = 4889 AND pt.id = 68293 AND tp.season_id = 143 AND st.season_id = 143 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 = 4889 AND pt.id = 68293 AND st.season_id = 143 AND stp.season_id = 143 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 = 4890 AND pt.id = 68327 AND tp.season_id = 144 AND st.season_id = 144 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 = 4890 AND pt.id = 68327 AND tp.season_id = 144 AND st.season_id = 144 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 = 4890 AND pt.id = 68327 AND st.season_id = 144 AND stp.season_id = 144 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 = 4891 AND pt.id = 68340 AND tp.season_id = 145 AND st.season_id = 145 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 = 4891 AND pt.id = 68340 AND tp.season_id = 145 AND st.season_id = 145 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 = 4891 AND pt.id = 68340 AND st.season_id = 145 AND stp.season_id = 145 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 = 4892 AND pt.id = 68359 AND tp.season_id = 146 AND st.season_id = 146 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 = 4892 AND pt.id = 68359 AND tp.season_id = 146 AND st.season_id = 146 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 = 4892 AND pt.id = 68359 AND st.season_id = 146 AND stp.season_id = 146 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 = 4893 AND pt.id = 68384 AND tp.season_id = 147 AND st.season_id = 147 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 = 4893 AND pt.id = 68384 AND tp.season_id = 147 AND st.season_id = 147 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 = 4893 AND pt.id = 68384 AND st.season_id = 147 AND stp.season_id = 147 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 = 4894 AND pt.id = 68415 AND tp.season_id = 148 AND st.season_id = 148 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 = 4894 AND pt.id = 68415 AND tp.season_id = 148 AND st.season_id = 148 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 = 4894 AND pt.id = 68415 AND st.season_id = 148 AND stp.season_id = 148 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 = 4895 AND pt.id = 68419 AND tp.season_id = 149 AND st.season_id = 149 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 = 4895 AND pt.id = 68419 AND tp.season_id = 149 AND st.season_id = 149 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 = 4895 AND pt.id = 68419 AND st.season_id = 149 AND stp.season_id = 149 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 = 4593 AND pt.id = 63325 AND tp.season_id = 150 AND st.season_id = 150 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 = 4593 AND pt.id = 63325 AND tp.season_id = 150 AND st.season_id = 150 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 = 4593 AND pt.id = 63325 AND st.season_id = 150 AND stp.season_id = 150 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 = 4594 AND pt.id = 63349 AND tp.season_id = 151 AND st.season_id = 151 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 = 4594 AND pt.id = 63349 AND tp.season_id = 151 AND st.season_id = 151 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 = 4594 AND pt.id = 63349 AND st.season_id = 151 AND stp.season_id = 151 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 = 4596 AND pt.id = 63389 AND tp.season_id = 152 AND st.season_id = 152 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 = 4596 AND pt.id = 63389 AND tp.season_id = 152 AND st.season_id = 152 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 = 4596 AND pt.id = 63389 AND st.season_id = 152 AND stp.season_id = 152 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 = 4597 AND pt.id = 63419 AND tp.season_id = 153 AND st.season_id = 153 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 = 4597 AND pt.id = 63419 AND tp.season_id = 153 AND st.season_id = 153 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 = 4597 AND pt.id = 63419 AND st.season_id = 153 AND stp.season_id = 153 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 = 4598 AND pt.id = 63427 AND tp.season_id = 154 AND st.season_id = 154 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 = 4598 AND pt.id = 63427 AND tp.season_id = 154 AND st.season_id = 154 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 = 4598 AND pt.id = 63427 AND st.season_id = 154 AND stp.season_id = 154 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 = 4599 AND pt.id = 63459 AND tp.season_id = 155 AND st.season_id = 155 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 = 4599 AND pt.id = 63459 AND tp.season_id = 155 AND st.season_id = 155 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 = 4599 AND pt.id = 63459 AND st.season_id = 155 AND stp.season_id = 155 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 = 4600 AND pt.id = 63469 AND tp.season_id = 156 AND st.season_id = 156 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 = 4600 AND pt.id = 63469 AND tp.season_id = 156 AND st.season_id = 156 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 = 4600 AND pt.id = 63469 AND st.season_id = 156 AND stp.season_id = 156 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 = 4601 AND pt.id = 63492 AND tp.season_id = 157 AND st.season_id = 157 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 = 4601 AND pt.id = 63492 AND tp.season_id = 157 AND st.season_id = 157 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 = 4601 AND pt.id = 63492 AND st.season_id = 157 AND stp.season_id = 157 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 = 4602 AND pt.id = 63501 AND tp.season_id = 158 AND st.season_id = 158 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 = 4602 AND pt.id = 63501 AND tp.season_id = 158 AND st.season_id = 158 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 = 4602 AND pt.id = 63501 AND st.season_id = 158 AND stp.season_id = 158 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 = 4905 AND pt.id = 68643 AND tp.season_id = 159 AND st.season_id = 159 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 = 4905 AND pt.id = 68643 AND tp.season_id = 159 AND st.season_id = 159 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 = 4905 AND pt.id = 68643 AND st.season_id = 159 AND stp.season_id = 159 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 = 4906 AND pt.id = 68666 AND tp.season_id = 160 AND st.season_id = 160 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 = 4906 AND pt.id = 68666 AND tp.season_id = 160 AND st.season_id = 160 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 = 4906 AND pt.id = 68666 AND st.season_id = 160 AND stp.season_id = 160 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 = 4907 AND pt.id = 68686 AND tp.season_id = 161 AND st.season_id = 161 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 = 4907 AND pt.id = 68686 AND tp.season_id = 161 AND st.season_id = 161 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 = 4907 AND pt.id = 68686 AND st.season_id = 161 AND stp.season_id = 161 AND stp.published = 1 AND stp.persontype = 1
England 
Copyright : ©
Fussball in Europa
Projekte: 
Spielorte: 
Vereine 
Spieler 
Gruppen 
Spieltage 
Spiele 
SPSK
Fr, 29. Mai. 2026
18.30 Uhr
200
