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 = 4336
ORDER BY s.name DESC
sportsmanagementModelTeamInfo::getSeasons 344 projectteamid
48488
sportsmanagementModelTeamInfo::getSeasons 345 teamid
4336
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 = 5137 AND pt.id = 72301 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 = 5137 AND pt.id = 72301 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 = 5137 AND pt.id = 72301 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 = 4703 AND pt.id = 65200 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 = 4703 AND pt.id = 65200 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 = 4703 AND pt.id = 65200 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 = 4127 AND pt.id = 55900 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 = 4127 AND pt.id = 55900 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 = 4127 AND pt.id = 55900 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 = 4172 AND pt.id = 56543 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 = 4172 AND pt.id = 56543 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 = 4172 AND pt.id = 56543 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 = 3809 AND pt.id = 51467 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 = 3809 AND pt.id = 51467 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 = 3809 AND pt.id = 51467 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 = 3153 AND pt.id = 42474 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 = 3153 AND pt.id = 42474 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 = 3153 AND pt.id = 42474 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 = 2991 AND pt.id = 40260 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 = 2991 AND pt.id = 40260 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 = 2991 AND pt.id = 40260 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 = 2884 AND pt.id = 38836 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 = 2884 AND pt.id = 38836 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 = 2884 AND pt.id = 38836 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 = 2377 AND pt.id = 32011 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 = 2377 AND pt.id = 32011 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 = 2377 AND pt.id = 32011 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 = 2378 AND pt.id = 32026 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 = 2378 AND pt.id = 32026 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 = 2378 AND pt.id = 32026 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 = 2379 AND pt.id = 32049 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 = 2379 AND pt.id = 32049 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 = 2379 AND pt.id = 32049 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 = 2404 AND pt.id = 32426 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 = 2404 AND pt.id = 32426 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 = 2404 AND pt.id = 32426 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 = 2405 AND pt.id = 32437 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 = 2405 AND pt.id = 32437 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 = 2405 AND pt.id = 32437 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 = 2406 AND pt.id = 32448 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 = 2406 AND pt.id = 32448 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 = 2406 AND pt.id = 32448 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 = 2407 AND pt.id = 32466 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 = 2407 AND pt.id = 32466 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 = 2407 AND pt.id = 32466 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 = 2384 AND pt.id = 32120 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 = 2384 AND pt.id = 32120 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 = 2384 AND pt.id = 32120 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 = 3574 AND pt.id = 48302 AND tp.season_id = 88 AND st.season_id = 88 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 data
SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3574 AND pt.id = 48302 AND tp.season_id = 88 AND st.season_id = 88 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 data
SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 3574 AND pt.id = 48302 AND st.season_id = 88 AND stp.season_id = 88 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 data
SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3575 AND pt.id = 48316 AND tp.season_id = 89 AND st.season_id = 89 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 data
SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3575 AND pt.id = 48316 AND tp.season_id = 89 AND st.season_id = 89 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 data
SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 3575 AND pt.id = 48316 AND st.season_id = 89 AND stp.season_id = 89 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 data
SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3577 AND pt.id = 48344 AND tp.season_id = 91 AND st.season_id = 91 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 data
SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3577 AND pt.id = 48344 AND tp.season_id = 91 AND st.season_id = 91 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 data
SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 3577 AND pt.id = 48344 AND st.season_id = 91 AND stp.season_id = 91 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 data
SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3578 AND pt.id = 48352 AND tp.season_id = 92 AND st.season_id = 92 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 data
SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3578 AND pt.id = 48352 AND tp.season_id = 92 AND st.season_id = 92 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 data
SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 3578 AND pt.id = 48352 AND st.season_id = 92 AND stp.season_id = 92 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 data
SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3579 AND pt.id = 48368 AND tp.season_id = 93 AND st.season_id = 93 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 = 3579 AND pt.id = 48368 AND tp.season_id = 93 AND st.season_id = 93 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 = 3579 AND pt.id = 48368 AND st.season_id = 93 AND stp.season_id = 93 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 = 3582 AND pt.id = 48410 AND tp.season_id = 96 AND st.season_id = 96 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 = 3582 AND pt.id = 48410 AND tp.season_id = 96 AND st.season_id = 96 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 = 3582 AND pt.id = 48410 AND st.season_id = 96 AND stp.season_id = 96 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 = 3583 AND pt.id = 48432 AND tp.season_id = 97 AND st.season_id = 97 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 = 3583 AND pt.id = 48432 AND tp.season_id = 97 AND st.season_id = 97 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 = 3583 AND pt.id = 48432 AND st.season_id = 97 AND stp.season_id = 97 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 data
SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3584 AND pt.id = 48447 AND tp.season_id = 98 AND st.season_id = 98 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 data
SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3584 AND pt.id = 48447 AND tp.season_id = 98 AND st.season_id = 98 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 data
SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 3584 AND pt.id = 48447 AND st.season_id = 98 AND stp.season_id = 98 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 data
SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3585 AND pt.id = 48462 AND tp.season_id = 99 AND st.season_id = 99 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 = 3585 AND pt.id = 48462 AND tp.season_id = 99 AND st.season_id = 99 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 = 3585 AND pt.id = 48462 AND st.season_id = 99 AND stp.season_id = 99 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 data
SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3586 AND pt.id = 48471 AND tp.season_id = 100 AND st.season_id = 100 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 data
SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3586 AND pt.id = 48471 AND tp.season_id = 100 AND st.season_id = 100 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 data
SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 3586 AND pt.id = 48471 AND st.season_id = 100 AND stp.season_id = 100 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 data
SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3587 AND pt.id = 48488 AND tp.season_id = 101 AND st.season_id = 101 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 data
SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3587 AND pt.id = 48488 AND tp.season_id = 101 AND st.season_id = 101 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 data
SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 3587 AND pt.id = 48488 AND st.season_id = 101 AND stp.season_id = 101 AND stp.published = 1
Fußball Regionalliga Mitte 1959/60    

Mannschaftsinfo - Radenthein

WSG Radenthein
Adresse: WSG Radenthein,
Stadionstraße 14,
Kärnten,
9545 Radenthein,
Österreich
 
Vereinsname: WSG Radenthein
Vereinswebseite: http://www.wsg-radenthein.at/
Mannschaftsname: Radenthein
Kurzname: Raden

Zusatzangaben

Erweiterte Optionen

Historie

Saison Liga Ligabild Platz Gespielt Punkte S/U/N Tore Spieler ∅ Alter
2020/21 ÖsterreichK - Unterliga West WSG Radenthein 8 13 20 6/2/5 21:24 0 0 0
2019/20 ÖsterreichK - Unterliga West WSG Radenthein 2 14 24 7/3/4 32:20 0 0 0
2018/19 ÖsterreichK - Unterliga West WSG Radenthein 9 28 37 9/10/9 36:42 0 0 0
2018/19 ÖsterreichT - 2. Klasse Zillertal WSG Radenthein 1 22 55 17/4/1 85:26 0 0 0
2017/18 ÖsterreichK - Unterliga West WSG Radenthein 1 0 0 0/0/0 0:0 0 0 0
2016/17 ÖsterreichK - Unterliga West WSG Radenthein 4 28 45 13/6/9 44:44 0 0 0
2015/16 ÖsterreichK - Unterliga West WSG Radenthein 6 28 42 10/12/6 43:31 0 0 0
2014/15 ÖsterreichK - Unterliga West WSG Radenthein 2 30 53 15/8/7 56:34 0 0 0
2013/14 ÖsterreichK - Unterliga West WSG Radenthein 7 28 41 12/5/11 43:49 0 0 0
2012/13 ÖsterreichK - Unterliga West WSG Radenthein 5 30 46 14/4/12 38:37 0 0 0
2011/12 ÖsterreichK - Unterliga West WSG Radenthein 8 33 49 15/4/14 52:39 0 0 0
2010/11 ÖsterreichK - 1. Klasse B WSG Radenthein 1 26 57 17/6/3 58:25 0 0 0
2009/10 ÖsterreichK - 1. Klasse B WSG Radenthein 9 26 31 9/4/13 38:50 0 0 0
2008/09 ÖsterreichK - 1. Klasse B WSG Radenthein 8 26 35 10/5/11 43:31 0 0 0
2007/08 ÖsterreichK - 1. Klasse B WSG Radenthein 6 26 37 11/4/11 38:32 0 0 0
2006/07 ÖsterreichK - Unterliga West WSG Radenthein 14 30 31 6/13/11 35:45 0 0 0
1972/73 ÖsterreichRegionalliga Mitte WSG Radenthein 1 26 40 19/2/5 74:32 0 0 0
1971/72 ÖsterreichRegionalliga Mitte WSG Radenthein 2 26 34 13/8/5 54:34 0 0 0
1969/70 ÖsterreichRegionalliga Mitte WSG Radenthein 1 26 36 16/4/6 48:24 0 0 0
1968/69 ÖsterreichRegionalliga Mitte WSG Radenthein 3 26 30 13/4/9 52:34 0 0 0
1966/67 ÖsterreichRegionalliga Mitte WSG Radenthein 1 26 41 17/7/2 68:17 0 0 0
1964/65 ÖsterreichRegionalliga Mitte WSG Radenthein 8 26 25 10/5/11 44:46 0 0 0
1963/64 ÖsterreichRegionalliga Mitte WSG Radenthein 11 26 23 8/7/11 42:53 0 0 0
1962/63 ÖsterreichRegionalliga Mitte WSG Radenthein 5 26 30 12/6/8 46:37 0 0 0
1961/62 ÖsterreichRegionalliga Mitte WSG Radenthein 7 26 27 12/3/11 51:40 0 0 0
1960/61 ÖsterreichRegionalliga Mitte WSG Radenthein 4 26 29 13/3/10 44:35 0 0 0
1959/60 ÖsterreichRegionalliga Mitte WSG Radenthein 3 20 24 8/8/4 32:30 0 0 0

Zusammenfassung Historie nach Liga

Liga
Gespielt
S/U/N
Tore
K - Unterliga West
262
107 / 67 / 88
400 : 365
T - 2. Klasse Zillertal
22
17 / 4 / 1
85 : 26
K - 1. Klasse B
104
47 / 19 / 38
177 : 138
Regionalliga Mitte
280
141 / 57 / 82
555 : 382

Trainingszeiten

Tipp: Keine Trainingszeiten vorhanden!

Wochentag Beginn Ende Ort Hinweis




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

JSM - Modul Vereins Icons (Kopie)

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

Wer ist Online

Aktuell sind 5129 Gäste und keine Mitglieder online

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Speichernutzung

Datenbankabfragen