Notice: Trying to get property 'alias' of non-object in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 49

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 77

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

Notice: Trying to access array offset on value of type null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/templates/sports_nation/vertex/parameters.php on line 93

  • Register

Ligen Top Navigation

AUT
AUT
×

sportsmanagementModelTeamInfo::getSeasons 343 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.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 = 3836
ORDER BY s.name DESC
sportsmanagementModelTeamInfo::getSeasons 344 projectteamid
48487
sportsmanagementModelTeamInfo::getSeasons 345 teamid
3836
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 5128 AND pt.id = 72114 AND tp.season_id = 191 AND st.season_id = 191 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 5128 AND pt.id = 72114 AND tp.season_id = 191 AND st.season_id = 191 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 5128 AND pt.id = 72114 AND st.season_id = 191 AND stp.season_id = 191 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 72258 AND tp.season_id = 191 AND st.season_id = 191 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 72258 AND tp.season_id = 191 AND st.season_id = 191 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 72258 AND st.season_id = 191 AND stp.season_id = 191 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 4832 AND pt.id = 67029 AND tp.season_id = 183 AND st.season_id = 183 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 4832 AND pt.id = 67029 AND tp.season_id = 183 AND st.season_id = 183 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 4832 AND pt.id = 67029 AND st.season_id = 183 AND stp.season_id = 183 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 66939 AND tp.season_id = 183 AND st.season_id = 183 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 66939 AND tp.season_id = 183 AND st.season_id = 183 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 66939 AND st.season_id = 183 AND stp.season_id = 183 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 4189 AND pt.id = 56779 AND tp.season_id = 105 AND st.season_id = 105 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 4189 AND pt.id = 56779 AND tp.season_id = 105 AND st.season_id = 105 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 4189 AND pt.id = 56779 AND st.season_id = 105 AND stp.season_id = 105 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 4146 AND pt.id = 56169 AND tp.season_id = 103 AND st.season_id = 103 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 4146 AND pt.id = 56169 AND tp.season_id = 103 AND st.season_id = 103 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 4146 AND pt.id = 56169 AND st.season_id = 103 AND stp.season_id = 103 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3758 AND pt.id = 50772 AND tp.season_id = 85 AND st.season_id = 85 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3758 AND pt.id = 50772 AND tp.season_id = 85 AND st.season_id = 85 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3758 AND pt.id = 50772 AND st.season_id = 85 AND stp.season_id = 85 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3082 AND pt.id = 41490 AND tp.season_id = 81 AND st.season_id = 81 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3082 AND pt.id = 41490 AND tp.season_id = 81 AND st.season_id = 81 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3082 AND pt.id = 41490 AND st.season_id = 81 AND stp.season_id = 81 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3081 AND pt.id = 41477 AND tp.season_id = 79 AND st.season_id = 79 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3081 AND pt.id = 41477 AND tp.season_id = 79 AND st.season_id = 79 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3081 AND pt.id = 41477 AND st.season_id = 79 AND stp.season_id = 79 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3080 AND pt.id = 41465 AND tp.season_id = 71 AND st.season_id = 71 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3080 AND pt.id = 41465 AND tp.season_id = 71 AND st.season_id = 71 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3080 AND pt.id = 41465 AND st.season_id = 71 AND stp.season_id = 71 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3079 AND pt.id = 41459 AND tp.season_id = 69 AND st.season_id = 69 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3079 AND pt.id = 41459 AND tp.season_id = 69 AND st.season_id = 69 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3079 AND pt.id = 41459 AND st.season_id = 69 AND stp.season_id = 69 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3078 AND pt.id = 41447 AND tp.season_id = 68 AND st.season_id = 68 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3078 AND pt.id = 41447 AND tp.season_id = 68 AND st.season_id = 68 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3078 AND pt.id = 41447 AND st.season_id = 68 AND stp.season_id = 68 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 2519 AND pt.id = 34083 AND tp.season_id = 55 AND st.season_id = 55 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 2519 AND pt.id = 34083 AND tp.season_id = 55 AND st.season_id = 55 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 2519 AND pt.id = 34083 AND st.season_id = 55 AND stp.season_id = 55 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 2520 AND pt.id = 34097 AND tp.season_id = 56 AND st.season_id = 56 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 2520 AND pt.id = 34097 AND tp.season_id = 56 AND st.season_id = 56 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 2520 AND pt.id = 34097 AND st.season_id = 56 AND stp.season_id = 56 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 2521 AND pt.id = 34107 AND tp.season_id = 57 AND st.season_id = 57 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 2521 AND pt.id = 34107 AND tp.season_id = 57 AND st.season_id = 57 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 2521 AND pt.id = 34107 AND st.season_id = 57 AND stp.season_id = 57 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 2522 AND pt.id = 34121 AND tp.season_id = 58 AND st.season_id = 58 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 2522 AND pt.id = 34121 AND tp.season_id = 58 AND st.season_id = 58 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 2522 AND pt.id = 34121 AND st.season_id = 58 AND stp.season_id = 58 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3073 AND pt.id = 41398 AND tp.season_id = 59 AND st.season_id = 59 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3073 AND pt.id = 41398 AND tp.season_id = 59 AND st.season_id = 59 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3073 AND pt.id = 41398 AND st.season_id = 59 AND stp.season_id = 59 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3072 AND pt.id = 41379 AND tp.season_id = 60 AND st.season_id = 60 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3072 AND pt.id = 41379 AND tp.season_id = 60 AND st.season_id = 60 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3072 AND pt.id = 41379 AND st.season_id = 60 AND stp.season_id = 60 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3071 AND pt.id = 41371 AND tp.season_id = 61 AND st.season_id = 61 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3071 AND pt.id = 41371 AND tp.season_id = 61 AND st.season_id = 61 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3071 AND pt.id = 41371 AND st.season_id = 61 AND stp.season_id = 61 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3070 AND pt.id = 41364 AND tp.season_id = 62 AND st.season_id = 62 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3070 AND pt.id = 41364 AND tp.season_id = 62 AND st.season_id = 62 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3070 AND pt.id = 41364 AND st.season_id = 62 AND stp.season_id = 62 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3083 AND pt.id = 41499 AND tp.season_id = 67 AND st.season_id = 67 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3083 AND pt.id = 41499 AND tp.season_id = 67 AND st.season_id = 67 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3083 AND pt.id = 41499 AND st.season_id = 67 AND stp.season_id = 67 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3545 AND pt.id = 47926 AND tp.season_id = 64 AND st.season_id = 64 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3545 AND pt.id = 47926 AND tp.season_id = 64 AND st.season_id = 64 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3545 AND pt.id = 47926 AND st.season_id = 64 AND stp.season_id = 64 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3547 AND pt.id = 47958 AND tp.season_id = 65 AND st.season_id = 65 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3547 AND pt.id = 47958 AND tp.season_id = 65 AND st.season_id = 65 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3547 AND pt.id = 47958 AND st.season_id = 65 AND stp.season_id = 65 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 2108 AND pt.id = 28365 AND tp.season_id = 66 AND st.season_id = 66 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 2108 AND pt.id = 28365 AND tp.season_id = 66 AND st.season_id = 66 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 2108 AND pt.id = 28365 AND st.season_id = 66 AND stp.season_id = 66 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 4968 AND pt.id = 69518 AND tp.season_id = 72 AND st.season_id = 72 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 4968 AND pt.id = 69518 AND tp.season_id = 72 AND st.season_id = 72 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 4968 AND pt.id = 69518 AND st.season_id = 72 AND stp.season_id = 72 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 4969 AND pt.id = 69535 AND tp.season_id = 73 AND st.season_id = 73 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 4969 AND pt.id = 69535 AND tp.season_id = 73 AND st.season_id = 73 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 4969 AND pt.id = 69535 AND st.season_id = 73 AND stp.season_id = 73 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 4970 AND pt.id = 69555 AND tp.season_id = 74 AND st.season_id = 74 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 4970 AND pt.id = 69555 AND tp.season_id = 74 AND st.season_id = 74 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 4970 AND pt.id = 69555 AND st.season_id = 74 AND stp.season_id = 74 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 4971 AND pt.id = 69569 AND tp.season_id = 75 AND st.season_id = 75 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 4971 AND pt.id = 69569 AND tp.season_id = 75 AND st.season_id = 75 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 4971 AND pt.id = 69569 AND st.season_id = 75 AND stp.season_id = 75 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 4972 AND pt.id = 69583 AND tp.season_id = 76 AND st.season_id = 76 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 4972 AND pt.id = 69583 AND tp.season_id = 76 AND st.season_id = 76 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 4972 AND pt.id = 69583 AND st.season_id = 76 AND stp.season_id = 76 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 4973 AND pt.id = 69606 AND tp.season_id = 77 AND st.season_id = 77 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 4973 AND pt.id = 69606 AND tp.season_id = 77 AND st.season_id = 77 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 4973 AND pt.id = 69606 AND st.season_id = 77 AND stp.season_id = 77 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 4974 AND pt.id = 69617 AND tp.season_id = 107 AND st.season_id = 107 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 4974 AND pt.id = 69617 AND tp.season_id = 107 AND st.season_id = 107 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 4974 AND pt.id = 69617 AND st.season_id = 107 AND stp.season_id = 107 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 4975 AND pt.id = 69631 AND tp.season_id = 108 AND st.season_id = 108 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 4975 AND pt.id = 69631 AND tp.season_id = 108 AND st.season_id = 108 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 4975 AND pt.id = 69631 AND st.season_id = 108 AND stp.season_id = 108 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 4976 AND pt.id = 69649 AND tp.season_id = 109 AND st.season_id = 109 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 4976 AND pt.id = 69649 AND tp.season_id = 109 AND st.season_id = 109 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 4976 AND pt.id = 69649 AND st.season_id = 109 AND stp.season_id = 109 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 4977 AND pt.id = 69666 AND tp.season_id = 110 AND st.season_id = 110 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 4977 AND pt.id = 69666 AND tp.season_id = 110 AND st.season_id = 110 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 4977 AND pt.id = 69666 AND st.season_id = 110 AND stp.season_id = 110 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3573 AND pt.id = 48284 AND tp.season_id = 87 AND st.season_id = 87 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3573 AND pt.id = 48284 AND tp.season_id = 87 AND st.season_id = 87 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3573 AND pt.id = 48284 AND st.season_id = 87 AND stp.season_id = 87 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3574 AND pt.id = 48304 AND tp.season_id = 88 AND st.season_id = 88 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3574 AND pt.id = 48304 AND tp.season_id = 88 AND st.season_id = 88 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3574 AND pt.id = 48304 AND st.season_id = 88 AND stp.season_id = 88 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3575 AND pt.id = 48315 AND tp.season_id = 89 AND st.season_id = 89 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3575 AND pt.id = 48315 AND tp.season_id = 89 AND st.season_id = 89 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3575 AND pt.id = 48315 AND st.season_id = 89 AND stp.season_id = 89 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3576 AND pt.id = 48328 AND tp.season_id = 90 AND st.season_id = 90 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3576 AND pt.id = 48328 AND tp.season_id = 90 AND st.season_id = 90 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3576 AND pt.id = 48328 AND st.season_id = 90 AND stp.season_id = 90 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3577 AND pt.id = 48346 AND tp.season_id = 91 AND st.season_id = 91 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3577 AND pt.id = 48346 AND tp.season_id = 91 AND st.season_id = 91 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3577 AND pt.id = 48346 AND st.season_id = 91 AND stp.season_id = 91 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3578 AND pt.id = 48353 AND tp.season_id = 92 AND st.season_id = 92 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3578 AND pt.id = 48353 AND tp.season_id = 92 AND st.season_id = 92 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3578 AND pt.id = 48353 AND st.season_id = 92 AND stp.season_id = 92 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3580 AND pt.id = 48380 AND tp.season_id = 94 AND st.season_id = 94 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3580 AND pt.id = 48380 AND tp.season_id = 94 AND st.season_id = 94 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3580 AND pt.id = 48380 AND st.season_id = 94 AND stp.season_id = 94 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3584 AND pt.id = 48440 AND tp.season_id = 98 AND st.season_id = 98 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3584 AND pt.id = 48440 AND tp.season_id = 98 AND st.season_id = 98 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3584 AND pt.id = 48440 AND st.season_id = 98 AND stp.season_id = 98 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3586 AND pt.id = 48466 AND tp.season_id = 100 AND st.season_id = 100 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3586 AND pt.id = 48466 AND tp.season_id = 100 AND st.season_id = 100 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3586 AND pt.id = 48466 AND st.season_id = 100 AND stp.season_id = 100 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 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 = 3587 AND pt.id = 48487 AND tp.season_id = 101 AND st.season_id = 101 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 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 = 3587 AND pt.id = 48487 AND tp.season_id = 101 AND st.season_id = 101 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 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 = 3587 AND pt.id = 48487 AND st.season_id = 101 AND stp.season_id = 101 AND stp.published = 1
Fußball Regionalliga Mitte 1959/60    

Mannschaftsinfo - KSV 1919

KSV 1919
Adresse: KSV 1919,
Johann-Brandl-Gasse 25,
Steiermark,
8605 Kapfenberg,
Österreich
 
Telefon: 03862/22 0 70
Fax: 03862/28 1 75
eMail: Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!
Vereinsname: KSV 1919
Vereinswebseite: http://www.ksv1919.at/
Mannschaftsname: KSV 1919
Kurzname: KSV

Zusatzangaben

Erweiterte Optionen

Historie

Saison Liga Ligabild Platz Gespielt Punkte S/U/N Tore Spieler ∅ Alter
2021/22 Österreich2. Liga Österreich KSV 1919 10 14 16 5/1/8 15:26 0 0 0
2021/22 ÖsterreichUNIQA ÖFB Cup KSV 1919 14 3 6 1/0/0 12:11 0 0 0
2020/21 Österreich2. Liga Österreich KSV 1919 10 30 33 9/6/15 34:51 0 0 0
2020/21 ÖsterreichUNIQA ÖFB Cup KSV 1919 7 4 9 2/0/0 12:6 0 0 0
2019/20 Österreich2. Liga Österreich KSV 1919 16 29 22 6/4/19 34:66 0 0 0
2018/19 Österreich2. Liga Österreich KSV 1919 4 30 46 13/7/10 44:40 0 0 0
2017/18 Österreich2. Liga Österreich KSV 1919 8 36 35 9/8/19 40:68 0 0 0
2016/17 Österreich2. Liga Österreich KSV 1919 6 36 41 12/9/15 47:57 0 0 0
2015/16 Österreich2. Liga Österreich KSV 1919 6 36 50 14/8/14 63:62 0 0 0
2014/15 Österreich2. Liga Österreich KSV 1919 4 36 49 12/13/11 52:45 0 0 0
2013/14 Österreich2. Liga Österreich KSV 1919 5 36 52 16/4/16 55:48 0 0 0
2012/13 Österreich2. Liga Österreich KSV 1919 5 36 53 14/11/11 56:50 0 0 0
2011/12 ÖsterreichBundesliga Österreich KSV 1919 10 36 23 5/8/23 20:63 0 0 0
2010/11 ÖsterreichBundesliga Österreich KSV 1919 8 36 38 9/11/16 42:61 0 0 0
2009/10 ÖsterreichBundesliga Österreich KSV 1919 9 36 33 8/9/19 43:67 0 0 0
2008/09 ÖsterreichBundesliga Österreich KSV 1919 8 36 36 10/6/20 48:81 0 0 0
2007/08 Österreich2. Liga Österreich KSV 1919 1 33 66 19/9/5 79:45 0 0 0
2006/07 Österreich2. Liga Österreich KSV 1919 11 33 32 8/8/17 41:60 0 0 0
2005/06 Österreich2. Liga Österreich KSV 1919 8 36 39 10/9/17 51:69 0 0 0
2004/05 Österreich2. Liga Österreich KSV 1919 2 36 71 21/8/7 64:37 0 0 0
2003/04 Österreich2. Liga Österreich KSV 1919 4 36 60 18/6/12 68:55 0 0 0
2001/02 ÖsterreichRegionalliga Mitte KSV 1919 1 30 66 21/3/6 79:29 0 0 0
2000/01 ÖsterreichRegionalliga Mitte KSV 1919 2 30 51 15/6/9 50:35 0 0 0
1999/2000 ÖsterreichST - Landesliga KSV 1919 1 30 66 20/6/4 53:22 0 0 0
1998/99 ÖsterreichST - Landesliga KSV 1919 4 34 67 21/4/9 77:34 0 0 0
1997/98 ÖsterreichST - Landesliga KSV 1919 3 30 58 17/7/6 57:35 0 0 0
1996/97 ÖsterreichST - Landesliga KSV 1919 7 30 46 14/4/12 60:45 0 0 0
1995/96 ÖsterreichST - Landesliga KSV 1919 5 30 60 17/9/4 65:34 0 0 0
1994/95 ÖsterreichST - Landesliga KSV 1919 3 30 35 13/9/8 48:33 0 0 0
1993/94 ÖsterreichST - Landesliga KSV 1919 10 30 27 11/5/14 54:54 0 0 0
1991/92 ÖsterreichST - Landesliga KSV 1919 8 30 28 8/12/10 45:48 0 0 0
1990/91 ÖsterreichST - Landesliga KSV 1919 2 34 50 22/6/6 72:28 0 0 0
1989/90 ÖsterreichST - Landesliga KSV 1919 2 30 44 20/4/6 75:27 0 0 0
1988/89 ÖsterreichST - Landesliga KSV 1919 3 30 37 15/7/8 53:36 0 0 0
1973/74 ÖsterreichRegionalliga Mitte KSV 1919 1 24 37 16/5/3 58:17 0 0 0
1972/73 ÖsterreichRegionalliga Mitte KSV 1919 2 26 32 13/6/7 51:27 0 0 0
1971/72 ÖsterreichRegionalliga Mitte KSV 1919 5 26 30 12/6/8 35:27 0 0 0
1970/71 ÖsterreichRegionalliga Mitte KSV 1919 2 26 36 13/10/3 48:19 0 0 0
1969/70 ÖsterreichRegionalliga Mitte KSV 1919 3 26 32 13/6/7 53:29 0 0 0
1968/69 ÖsterreichRegionalliga Mitte KSV 1919 2 26 35 15/5/6 40:24 0 0 0
1967/68 ÖsterreichRegionalliga Mitte KSV 1919 4 26 30 13/4/9 47:38 0 0 0
1962/63 ÖsterreichRegionalliga Mitte KSV 1919 1 26 40 16/8/2 67:21 0 0 0
1960/61 ÖsterreichRegionalliga Mitte KSV 1919 1 26 41 20/1/5 57:26 0 0 0
1959/60 ÖsterreichRegionalliga Mitte KSV 1919 2 20 24 10/4/6 47:32 0 0 0

Zusammenfassung Historie nach Liga

Liga
Gespielt
S/U/N
Tore
2. Liga Österreich
493
186 / 111 / 196
743 : 779
UNIQA ÖFB Cup
7
3 / 0 / 0
24 : 17
Bundesliga Österreich
144
32 / 34 / 78
153 : 272
Regionalliga Mitte
312
177 / 64 / 71
632 : 324
ST - Landesliga
338
178 / 73 / 87
659 : 396

Trainingszeiten

Tipp: Keine Trainingszeiten vorhanden!

Wochentag Beginn Ende Ort Hinweis




Eine Komponente für viele Sportarten!
Copyright : © Fussball in Europa
Version : 3.9.20 (diddipoeler)
Ladezeit der Seite: [ 7.724183 ] Sekunden

JSM - Modul Vereins Icons (Kopie)

SV Chemie Linz KSV 1919 Radenthein FK Austria Asv Puch SK Sturm Graz FC Fohnsdorf SC Bruck/Mur Hertha Wels SK Vorwärts Steyr Ranshofen 1. FC Leoben

Wer ist Online

Aktuell sind 5397 Gäste und keine Mitglieder online

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Speichernutzung

Datenbankabfragen