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 = 3640
ORDER BY s.name DESC
sportsmanagementModelTeamInfo::getSeasons 344 projectteamid
71624
sportsmanagementModelTeamInfo::getSeasons 345 teamid
3640
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 = 5090 AND pt.id = 71624 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 = 5090 AND pt.id = 71624 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 = 5090 AND pt.id = 71624 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 = 4735 AND pt.id = 65642 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 = 4735 AND pt.id = 65642 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 = 4735 AND pt.id = 65642 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 = 4190 AND pt.id = 56793 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 = 4190 AND pt.id = 56793 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 = 4190 AND pt.id = 56793 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 = 3759 AND pt.id = 50781 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 = 3759 AND pt.id = 50781 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 = 3759 AND pt.id = 50781 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 = 3015 AND pt.id = 40583 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 = 3015 AND pt.id = 40583 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 = 3015 AND pt.id = 40583 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 = 2965 AND pt.id = 39897 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 = 2965 AND pt.id = 39897 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 = 2965 AND pt.id = 39897 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 = 2462 AND pt.id = 33221 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 = 2462 AND pt.id = 33221 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 = 2462 AND pt.id = 33221 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 = 2096 AND pt.id = 28168 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 = 2096 AND pt.id = 28168 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 = 2096 AND pt.id = 28168 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 = 2097 AND pt.id = 28190 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 = 2097 AND pt.id = 28190 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 = 2097 AND pt.id = 28190 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 = 2098 AND pt.id = 28200 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 = 2098 AND pt.id = 28200 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 = 2098 AND pt.id = 28200 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 = 2099 AND pt.id = 28221 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 = 2099 AND pt.id = 28221 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 = 2099 AND pt.id = 28221 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 = 27362 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 = 27362 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 = 27362 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 = 2032 AND pt.id = 27347 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 = 2032 AND pt.id = 27347 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 = 2032 AND pt.id = 27347 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 = 2034 AND pt.id = 27325 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 = 2034 AND pt.id = 27325 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 = 2034 AND pt.id = 27325 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 = 4933 AND pt.id = 69052 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 = 4933 AND pt.id = 69052 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 = 4933 AND pt.id = 69052 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 = 2140 AND pt.id = 28818 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 = 2140 AND pt.id = 28818 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 = 2140 AND pt.id = 28818 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 = 4935 AND pt.id = 69085 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 = 4935 AND pt.id = 69085 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 = 4935 AND pt.id = 69085 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 = 2141 AND pt.id = 28832 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 = 2141 AND pt.id = 28832 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 = 2141 AND pt.id = 28832 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 = 4936 AND pt.id = 69087 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 = 4936 AND pt.id = 69087 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 = 4936 AND pt.id = 69087 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 = 4937 AND pt.id = 69099 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 = 4937 AND pt.id = 69099 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 = 4937 AND pt.id = 69099 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 = 4938 AND pt.id = 69111 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 = 4938 AND pt.id = 69111 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 = 4938 AND pt.id = 69111 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 = 4934 AND pt.id = 69074 AND tp.season_id = 120 AND st.season_id = 120 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 = 4934 AND pt.id = 69074 AND tp.season_id = 120 AND st.season_id = 120 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 = 4934 AND pt.id = 69074 AND st.season_id = 120 AND stp.season_id = 120 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 = 5131 AND pt.id = 72165 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 = 5131 AND pt.id = 72165 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 = 5131 AND pt.id = 72165 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 = 2961 AND pt.id = 39850 AND tp.season_id = 80 AND st.season_id = 80 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 = 2961 AND pt.id = 39850 AND tp.season_id = 80 AND st.season_id = 80 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 = 2961 AND pt.id = 39850 AND st.season_id = 80 AND stp.season_id = 80 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 = 3046 AND pt.id = 41026 AND tp.season_id = 82 AND st.season_id = 82 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 = 3046 AND pt.id = 41026 AND tp.season_id = 82 AND st.season_id = 82 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 = 3046 AND pt.id = 41026 AND st.season_id = 82 AND stp.season_id = 82 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 = 3047 AND pt.id = 41040 AND tp.season_id = 83 AND st.season_id = 83 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 = 3047 AND pt.id = 41040 AND tp.season_id = 83 AND st.season_id = 83 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 = 3047 AND pt.id = 41040 AND st.season_id = 83 AND stp.season_id = 83 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 = 3048 AND pt.id = 41057 AND tp.season_id = 84 AND st.season_id = 84 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 = 3048 AND pt.id = 41057 AND tp.season_id = 84 AND st.season_id = 84 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 = 3048 AND pt.id = 41057 AND st.season_id = 84 AND stp.season_id = 84 AND stp.published = 1
Fußball ST - Oberliga Nord 2021/22© [ SIGA ] ST - Oberliga Nord 2021/22    

Mannschaftsinfo - Kapfenberger SV Amateure

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: Kapfenberger SV Amateure
Kurzname: KAPFE


Zusatzangaben

Historie

Saison Liga Ligabild Platz Gespielt Punkte S/U/N Tore Spieler ∅ Alter
2021/22 ÖsterreichST - Oberliga Nord KSV 1919 2 13 30 10/0/3 40:15 2 0
2020/21 ÖsterreichST - Oberliga Nord KSV 1919 5 10 18 5/3/2 23:14 2 0
2019/20 ÖsterreichST - Oberliga Nord KSV 1919 10 13 14 4/2/7 42:34 1 0
2018/19 ÖsterreichST - Oberliga Nord KSV 1919 7 26 34 10/4/12 49:47 0 0
2016/17 ÖsterreichST - Landesliga KSV 1919 13 30 30 8/6/16 47:69 0 0
2015/16 ÖsterreichST - Landesliga KSV 1919 13 28 28 8/4/16 39:48 0 0
2014/15 ÖsterreichST - Landesliga KSV 1919 8 30 44 12/8/10 52:48 0 0
2010/11 ÖsterreichST - Landesliga KSV 1919 1 30 62 19/5/6 69:35 0 0
2009/10 ÖsterreichST - Landesliga KSV 1919 2 30 56 16/8/6 54:34 0 0
2008/09 ÖsterreichST - Landesliga KSV 1919 12 30 37 10/7/13 47:53 0 0
2007/08 ÖsterreichST - Landesliga KSV 1919 14 30 34 8/10/12 37:43 0 0
2006/07 ÖsterreichST - Oberliga Nord KSV 1919 1 26 62 19/5/2 69:12 0 0
2005/06 ÖsterreichST - Oberliga Nord KSV 1919 9 26 30 8/6/12 49:58 0 0
2004/05 ÖsterreichST - Oberliga Nord KSV 1919 4 26 48 14/6/6 59:42 0 0
2003/04 ÖsterreichST - Gebietsliga Mürz KSV 1919 3 22 41 12/5/5 51:34 0 0
2003/04 ÖsterreichST - Oberliga Nord KSV 1919 8 26 40 11/7/8 55:43 0 0
2002/03 ÖsterreichST - Gebietsliga Mürz KSV 1919 7 22 29 8/5/9 41:49 0 0
2002/03 ÖsterreichST - Oberliga Nord KSV 1919 3 26 44 14/2/10 59:49 0 0
2001/02 ÖsterreichST - Gebietsliga Mürz KSV 1919 9 22 25 7/4/11 31:47 0 0
2000/01 ÖsterreichST - Gebietsliga Mürz KSV 1919 11 22 17 4/5/13 35:58 0 0
1999/2000 ÖsterreichST - Gebietsliga Mürz KSV 1919 5 22 37 10/7/5 62:48 0 0
1999/00 ÖsterreichST - 1. Klasse Mur/Mürz B KSV 1919 4 19 32 10/2/7 67:50 0 0
1998/99 ÖsterreichST - 1. Klasse Mur/Mürz B KSV 1919 4 22 43 13/4/5 75:35 0 0
1985/86 ÖsterreichST - Unterliga Nord KSV 1919 3 26 31 10/11/5 38:27 0 0
1984/85 ÖsterreichST - Unterliga Nord KSV 1919 9 26 23 9/5/12 28:37 0 0
1983/84 ÖsterreichST - Unterliga Nord KSV 1919 10 26 23 8/7/11 29:37 0 0
1982/83 ÖsterreichST - Unterliga Nord KSV 1919 6 26 29 10/9/7 30:25 0 0

Zusammenfassung Historie nach Liga

Liga Gespielt S/U/N Tore
ST - Oberliga Nord 192 95 / 35 / 62 445 : 314
ST - Landesliga 208 81 / 48 / 79 345 : 330
ST - Gebietsliga Mürz 110 41 / 26 / 43 220 : 236
ST - 1. Klasse Mur/Mürz B 41 23 / 6 / 12 142 : 85
ST - Unterliga Nord 104 37 / 32 / 35 125 : 126



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

JSM - Modul Vereins Icons (Kopie)

FC Judenburg Kapfenberger SV Amateure EKRO Tus Krieglach Fc Obdach FC Trofaiach FC Kindberg-Mürzhofen Bad Mitterndorf ESV Knittelfeld Murau ATV Irdning Schladming SV Unzmarkt-Frauenburg SV Hinterberg St. Lorenzen/Kn.

Wer ist Online

Aktuell sind 4748 Gäste und keine Mitglieder online

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Speichernutzung

Datenbankabfragen