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 = 3653
ORDER BY s.name DESC
sportsmanagementModelTeamInfo::getSeasons 344 projectteamid
27719
sportsmanagementModelTeamInfo::getSeasons 345 teamid
3653
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 = 5126 AND pt.id = 72094 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 = 5126 AND pt.id = 72094 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 = 5126 AND pt.id = 72094 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 = 4737 AND pt.id = 65677 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 = 4737 AND pt.id = 65677 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 = 4737 AND pt.id = 65677 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 = 4192 AND pt.id = 56832 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 = 4192 AND pt.id = 56832 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 = 4192 AND pt.id = 56832 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 = 3776 AND pt.id = 51001 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 = 3776 AND pt.id = 51001 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 = 3776 AND pt.id = 51001 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 = 3251 AND pt.id = 43821 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 = 3251 AND pt.id = 43821 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 = 3251 AND pt.id = 43821 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 = 3032 AND pt.id = 40816 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 = 3032 AND pt.id = 40816 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 = 3032 AND pt.id = 40816 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 = 2964 AND pt.id = 39885 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 = 2964 AND pt.id = 39885 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 = 2964 AND pt.id = 39885 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 = 2461 AND pt.id = 33208 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 = 2461 AND pt.id = 33208 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 = 2461 AND pt.id = 33208 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 = 2455 AND pt.id = 33130 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 = 2455 AND pt.id = 33130 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 = 2455 AND pt.id = 33130 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 = 2092 AND pt.id = 28115 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 = 2092 AND pt.id = 28115 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 = 2092 AND pt.id = 28115 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 = 2072 AND pt.id = 27859 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 = 2072 AND pt.id = 27859 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 = 2072 AND pt.id = 27859 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 = 2051 AND pt.id = 27610 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 = 2051 AND pt.id = 27610 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 = 2051 AND pt.id = 27610 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 = 2050 AND pt.id = 27603 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 = 2050 AND pt.id = 27603 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 = 2050 AND pt.id = 27603 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 = 2049 AND pt.id = 27593 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 = 2049 AND pt.id = 27593 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 = 2049 AND pt.id = 27593 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 = 2048 AND pt.id = 27569 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 = 2048 AND pt.id = 27569 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 = 2048 AND pt.id = 27569 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 = 2056 AND pt.id = 27683 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 = 2056 AND pt.id = 27683 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 = 2056 AND pt.id = 27683 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 = 2028 AND pt.id = 27351 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 = 2028 AND pt.id = 27351 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 = 2028 AND pt.id = 27351 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 = 2058 AND pt.id = 27716 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 = 2058 AND pt.id = 27716 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 = 2058 AND pt.id = 27716 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 = 2059 AND pt.id = 27719 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 = 2059 AND pt.id = 27719 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 = 2059 AND pt.id = 27719 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 = 4403 AND pt.id = 60146 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 = 4403 AND pt.id = 60146 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 = 4403 AND pt.id = 60146 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 = 4404 AND pt.id = 60166 AND tp.season_id = 63 AND st.season_id = 63 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 = 4404 AND pt.id = 60166 AND tp.season_id = 63 AND st.season_id = 63 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 = 4404 AND pt.id = 60166 AND st.season_id = 63 AND stp.season_id = 63 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 = 2106 AND pt.id = 28328 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 = 2106 AND pt.id = 28328 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 = 2106 AND pt.id = 28328 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 = 2143 AND pt.id = 28867 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 = 2143 AND pt.id = 28867 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 = 2143 AND pt.id = 28867 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 = 2144 AND pt.id = 28880 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 = 2144 AND pt.id = 28880 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 = 2144 AND pt.id = 28880 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 = 4408 AND pt.id = 60219 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 = 4408 AND pt.id = 60219 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 = 4408 AND pt.id = 60219 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 = 4409 AND pt.id = 60222 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 = 4409 AND pt.id = 60222 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 = 4409 AND pt.id = 60222 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 = 4410 AND pt.id = 60242 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 = 4410 AND pt.id = 60242 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 = 4410 AND pt.id = 60242 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 = 4411 AND pt.id = 60251 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 = 4411 AND pt.id = 60251 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 = 4411 AND pt.id = 60251 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 = 4412 AND pt.id = 60264 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 = 4412 AND pt.id = 60264 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 = 4412 AND pt.id = 60264 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 = 69612 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 = 69612 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 = 69612 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 = 69620 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 = 69620 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 = 69620 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 = 4983 AND pt.id = 69755 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 = 4983 AND pt.id = 69755 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 = 4983 AND pt.id = 69755 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 = 4982 AND pt.id = 69742 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 = 4982 AND pt.id = 69742 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 = 4982 AND pt.id = 69742 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 = 4981 AND pt.id = 69727 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 = 4981 AND pt.id = 69727 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 = 4981 AND pt.id = 69727 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 = 4980 AND pt.id = 69712 AND tp.season_id = 111 AND st.season_id = 111 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 = 4980 AND pt.id = 69712 AND tp.season_id = 111 AND st.season_id = 111 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 = 4980 AND pt.id = 69712 AND st.season_id = 111 AND stp.season_id = 111 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 = 4979 AND pt.id = 69698 AND tp.season_id = 112 AND st.season_id = 112 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 = 4979 AND pt.id = 69698 AND tp.season_id = 112 AND st.season_id = 112 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 = 4979 AND pt.id = 69698 AND st.season_id = 112 AND stp.season_id = 112 AND stp.published = 1

Notice: Trying to get property 'round_slug' of non-object in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/models/teaminfo.php on line 402

Notice: Trying to get property 'round_slug' of non-object in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/models/teaminfo.php on line 402

Notice: Trying to get property 'round_slug' of non-object in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/models/teaminfo.php on line 402
Fußball ST - Unterliga Nord B 2004/05© [ Siegfried Galun ] ST - Unterliga Nord B 2004/05 Print    

Mannschaftsinfo - FC Rot - Weiß Knittelfeld

FC Rot - Weiß Knittelfeld
Adresse: FC Rot - Weiß Knittelfeld,
Ingeringweg 74,
Steiermark,
8720 Knittelfeld,
Österreich
 
eMail: Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!
Vereinsname: FC Rot - Weiß Knittelfeld
Mannschaftsname: FC Rot - Weiß Knittelfeld
Kurzname: FCK

Historie

Saison Liga Ligabild Platz Gespielt Punkte S/U/N Tore Spieler ∅ Alter
2021/22 ÖsterreichST - Gebietsliga Mur
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
4 12 22 6/4/2 22:14 0 0 0
2020/21 ÖsterreichST - Gebietsliga Mur
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
8 9 12 4/0/5 12:16 0 0 0
2019/20 ÖsterreichST - Gebietsliga Mur
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
6 12 18 4/6/2 25:15 0 0 0
2018/19 ÖsterreichST - Gebietsliga Mur
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
7 26 39 12/3/11 54:49 0 0 0
2017/18 ÖsterreichST - Gebietsliga Mur
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
10 22 24 5/9/8 33:36 0 0 0
2016/17 ÖsterreichST - Gebietsliga Mur
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
5 24 35 10/5/9 61:40 1 35 0
2015/16 ÖsterreichST - Unterliga Nord B
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
14 26 3 1/0/25 33:116 0 0 0
2014/15 ÖsterreichST - Unterliga Nord B
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
11 26 24 6/6/14 43:59 0 0 0
2014/15 ÖsterreichFreundschaftsspiele
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
5 0 0 0/0/0 0:0 0 0 0
2013/14 ÖsterreichST - Unterliga Nord A
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
4 26 47 14/5/7 58:39 1 35 0
2012/13 ÖsterreichST - Unterliga Nord B
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
13 26 25 6/7/13 37:52 4 31 0
2011/12 ÖsterreichST - Gebietsliga Mur
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
1 26 60 20/0/6 80:26 0 0 0
2010/11 ÖsterreichST - Gebietsliga Mur
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
8 26 33 14/6/6 75:35 0 0 0
2009/10 ÖsterreichST - Gebietsliga Mur
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
3 26 61 20/2/4 82:26 0 0 0
2008/09 ÖsterreichST - Gebietsliga Mur
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
9 24 26 7/5/12 30:44 0 0 0
2007/08 ÖsterreichST - Unterliga Nord B
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
14 26 8 2/2/22 21:107 0 0 0
2006/07 ÖsterreichST - Oberliga Nord
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
11 26 24 7/3/16 37:67 4 34.5 0
2005/06 ÖsterreichST - Unterliga Nord B
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
1 22 52 16/4/2 66:18 1 35 0
2004/05 ÖsterreichST - Unterliga Nord B
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
2 22 50 16/2/4 62:27 0 0 0
2003/04 ÖsterreichST - 1. Klasse Mur/Mürz A
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
5 26 47 15/2/9 77:63 0 0 0
2002/03 ÖsterreichST - 1. Klasse Mur/Mürz A
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
10 24 25 7/4/13 48:64 0 0 0
2001/02 ÖsterreichST - Landesliga
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
16 30 19 4/7/19 28:72 0 0 0
2000/01 ÖsterreichST - Oberliga Nord
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
1 26 68 22/2/2 83:30 0 0 0
1999/2000 ÖsterreichST - Oberliga Nord
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
13 26 18 5/3/18 28:67 0 0 0
1998/99 ÖsterreichST - Oberliga Nord
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
6 26 40 13/1/12 46:53 0 0 0
1997/98 ÖsterreichST - Oberliga Nord
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
9 26 35 11/2/13 39:41 0 0 0
1996/97 ÖsterreichST - Oberliga Nord
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
10 26 30 8/6/12 39:45 0 0 0
1995/96 ÖsterreichST - Oberliga Nord
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
3 28 44 13/5/10 39:35 0 0 0
1994/95 ÖsterreichST - Oberliga Nord
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
4 28 30 10/10/8 34:31 0 0 0
1993/94 ÖsterreichST - Landesliga
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
16 30 19 6/7/17 33:68 0 0 0
1991/92 ÖsterreichST - Landesliga
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
6 30 29 10/9/11 49:54 0 0 0
1990/91 ÖsterreichST - Unterliga Nord
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
1 26 43 19/5/2 62:15 0 0 0
1989/90 ÖsterreichST - Unterliga Nord
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
2 26 43 19/5/2 57:12 0 0 0
1988/89 ÖsterreichST - Unterliga Nord
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
2 26 37 14/9/3 56:20 0 0 0
1987/88 ÖsterreichST - Unterliga Nord
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
3 26 37 15/7/4 59:24 0 0 0
1986/87 ÖsterreichST - Unterliga Nord
Notice: Undefined index: show_team_hist_picture in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128
FC Rot - Weiß Knittelfeld
3 26 33 12/9/5 44:30 0 0 0

Zusammenfassung Historie nach Liga

Liga Gespielt S/U/N Tore
ST - Gebietsliga Mur 207 102 / 40 / 65 474 : 301
ST - Unterliga Nord B 148 47 / 21 / 80 262 : 379
Freundschaftsspiele 0 0 / 0 / 0 0 : 0
ST - Unterliga Nord A 26 14 / 5 / 7 58 : 39
ST - Oberliga Nord 212 89 / 32 / 91 345 : 369
ST - 1. Klasse Mur/Mürz A 50 22 / 6 / 22 125 : 127
ST - Landesliga 90 20 / 23 / 47 110 : 194
ST - Unterliga Nord 130 79 / 35 / 16 278 : 101



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

JSM - Modul Vereins Icons (Kopie)

FC Fohnsdorf FC Rot - Weiß Knittelfeld St. Peter/Kbg. Murau TSV Raiffeisen Neumarkt ESV Knittelfeld SC St. Peter/Freienstein Niklasdorf Scheifling/St. Lor. Pöls Kobenz SV Unzmarkt-Frauenburg

Wer ist Online

Aktuell sind 4957 Gäste und keine Mitglieder online

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Speichernutzung

Datenbankabfragen