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 = 3634
ORDER BY s.name DESC
sportsmanagementModelTeamInfo::getSeasons 344 projectteamid
72071
sportsmanagementModelTeamInfo::getSeasons 345 teamid
3634
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 = 5124 AND pt.id = 72071 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 = 5124 AND pt.id = 72071 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 = 5124 AND pt.id = 72071 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 = 4729 AND pt.id = 65562 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 = 4729 AND pt.id = 65562 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 = 4729 AND pt.id = 65562 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 = 4187 AND pt.id = 56750 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 = 4187 AND pt.id = 56750 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 = 4187 AND pt.id = 56750 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 = 3777 AND pt.id = 51016 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 = 3777 AND pt.id = 51016 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 = 3777 AND pt.id = 51016 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 = 3243 AND pt.id = 43706 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 = 3243 AND pt.id = 43706 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 = 3243 AND pt.id = 43706 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 = 3015 AND pt.id = 40580 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 = 40580 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 = 40580 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 = 39903 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 = 39903 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 = 39903 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 = 33233 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 = 33233 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 = 33233 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 = 2089 AND pt.id = 28070 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 = 2089 AND pt.id = 28070 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 = 2089 AND pt.id = 28070 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 = 2075 AND pt.id = 27900 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 = 2075 AND pt.id = 27900 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 = 2075 AND pt.id = 27900 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 = 2213 AND pt.id = 29837 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 = 2213 AND pt.id = 29837 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 = 2213 AND pt.id = 29837 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 = 2212 AND pt.id = 29823 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 = 2212 AND pt.id = 29823 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 = 2212 AND pt.id = 29823 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 = 2211 AND pt.id = 29800 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 = 2211 AND pt.id = 29800 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 = 2211 AND pt.id = 29800 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 = 3074 AND pt.id = 41403 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 = 3074 AND pt.id = 41403 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 = 3074 AND pt.id = 41403 AND st.season_id = 58 AND stp.season_id = 58 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 data
SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3073 AND pt.id = 41395 AND tp.season_id = 59 AND st.season_id = 59 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 data
SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3073 AND pt.id = 41395 AND tp.season_id = 59 AND st.season_id = 59 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 data
SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 3073 AND pt.id = 41395 AND st.season_id = 59 AND stp.season_id = 59 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 data
SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3072 AND pt.id = 41376 AND tp.season_id = 60 AND st.season_id = 60 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 data
SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3072 AND pt.id = 41376 AND tp.season_id = 60 AND st.season_id = 60 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 data
SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 3072 AND pt.id = 41376 AND st.season_id = 60 AND stp.season_id = 60 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 data
SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3071 AND pt.id = 41366 AND tp.season_id = 61 AND st.season_id = 61 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 data
SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3071 AND pt.id = 41366 AND tp.season_id = 61 AND st.season_id = 61 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 data
SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 3071 AND pt.id = 41366 AND st.season_id = 61 AND stp.season_id = 61 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 data
SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3070 AND pt.id = 41360 AND tp.season_id = 62 AND st.season_id = 62 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 data
SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3070 AND pt.id = 41360 AND tp.season_id = 62 AND st.season_id = 62 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 data
SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 3070 AND pt.id = 41360 AND st.season_id = 62 AND stp.season_id = 62 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 data
SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3083 AND pt.id = 41495 AND tp.season_id = 67 AND st.season_id = 67 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 data
SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3083 AND pt.id = 41495 AND tp.season_id = 67 AND st.season_id = 67 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 data
SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 3083 AND pt.id = 41495 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 = 3576 AND pt.id = 48325 AND tp.season_id = 90 AND st.season_id = 90 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 data
SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3576 AND pt.id = 48325 AND tp.season_id = 90 AND st.season_id = 90 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 data
SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 3576 AND pt.id = 48325 AND st.season_id = 90 AND stp.season_id = 90 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 data
SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3577 AND pt.id = 48348 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 = 48348 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 = 48348 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 = 3580 AND pt.id = 48381 AND tp.season_id = 94 AND st.season_id = 94 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 597 data
SELECT ps.birthday, ps.deathday
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3580 AND pt.id = 48381 AND tp.season_id = 94 AND st.season_id = 94 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 657 data
SELECT SUM(stp.market_value) AS market_value
FROM z2o57_sportsmanagement_season_team_person_id AS stp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 3580 AND pt.id = 48381 AND st.season_id = 94 AND stp.season_id = 94 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 550 data
SELECT COUNT(*) AS playercnt
FROM z2o57_sportsmanagement_person AS ps
INNER JOIN z2o57_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 3579 AND pt.id = 48365 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 = 48365 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 = 48365 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 = 3581 AND pt.id = 48395 AND tp.season_id = 95 AND st.season_id = 95 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 = 3581 AND pt.id = 48395 AND tp.season_id = 95 AND st.season_id = 95 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 = 3581 AND pt.id = 48395 AND st.season_id = 95 AND stp.season_id = 95 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 = 48409 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 = 48409 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 = 48409 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 = 48434 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 = 48434 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 = 48434 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 = 48438 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 = 48438 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 = 48438 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 = 48455 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 = 48455 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 = 48455 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 = 48473 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 = 48473 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 = 48473 AND st.season_id = 100 AND stp.season_id = 100 AND stp.published = 1
Fußball ST - Landesliga 2021/22© [ SIGA ] ST - Landesliga 2021/22    

Mannschaftsinfo - DSV Leoben

DSV Leoben
Adresse: DSV Leoben,
Annaberggasse 10,
Steiermark,
8700 Donawitz,
Österreich
 
Telefon: 03842/21391
Fax: 03842/2139130
eMail: Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!
Vereinsname: DSV Leoben
Vereinswebseite: http://www.dsv-leoben.at/
Mannschaftsname: DSV Leoben
Kurzname: DSV L


Zusatzangaben

Historie

Saison Liga Ligabild Platz Gespielt Punkte S/U/N Tore Spieler ∅ Alter
2021/22 ÖsterreichST - Landesliga DSV Leoben 2 15 35 11/2/2 43:9 0 0
2020/21 ÖsterreichST - Landesliga DSV Leoben 11 12 11 2/5/5 19:23 0 0
2019/20 ÖsterreichST - Landesliga DSV Leoben 10 15 18 4/6/5 21:28 0 0
2018/19 ÖsterreichST - Landesliga DSV Leoben 14 30 31 8/7/15 39:50 0 0
2017/18 ÖsterreichST - Landesliga DSV Leoben 12 30 28 6/10/14 47:61 0 0
2016/17 ÖsterreichST - Landesliga DSV Leoben 5 30 50 14/8/8 55:47 0 0
2015/16 ÖsterreichST - Landesliga DSV Leoben 5 28 44 12/8/8 48:36 0 0
2014/15 ÖsterreichST - Landesliga DSV Leoben 13 30 34 9/7/14 45:55 0 0
2013/14 ÖsterreichST - Landesliga DSV Leoben 9 30 39 10/9/11 41:44 0 0
2012/13 ÖsterreichRegionalliga Mitte DSV Leoben 15 30 19 3/10/17 32:61 0 0
2011/12 ÖsterreichRegionalliga Mitte DSV Leoben 5 30 47 14/5/11 43:34 0 0
2010/11 ÖsterreichRegionalliga Mitte DSV Leoben 11 30 37 9/10/11 47:51 0 0
2009/10 ÖsterreichRegionalliga Mitte DSV Leoben 10 30 42 12/6/12 46:46 0 0
2008/09 Österreich2. Liga Österreich DSV Leoben 11 33 32 8/8/17 30:55 0 0
2007/08 Österreich2. Liga Österreich DSV Leoben 8 33 41 11/8/14 44:46 0 0
2006/07 Österreich2. Liga Österreich DSV Leoben 3 33 55 14/13/6 55:36 0 0
2005/06 Österreich2. Liga Österreich DSV Leoben 6 36 51 14/9/13 59:49 0 0
2004/05 Österreich2. Liga Österreich DSV Leoben 5 36 47 12/11/13 43:49 0 0
2003/04 Österreich2. Liga Österreich DSV Leoben 6 36 46 11/13/12 44:44 0 0
1970/71 ÖsterreichRegionalliga Mitte DSV Leoben 1 26 38 13/12/1 50:19 0 0
1969/70 ÖsterreichRegionalliga Mitte DSV Leoben 4 26 31 11/9/6 40:30 0 0
1967/68 ÖsterreichRegionalliga Mitte DSV Leoben 1 26 40 17/6/3 60:29 0 0
1966/67 ÖsterreichRegionalliga Mitte DSV Leoben 6 26 26 11/4/11 52:45 0 0
1965/66 ÖsterreichRegionalliga Mitte DSV Leoben 2 18 21 9/3/6 48:34 0 0
1964/65 ÖsterreichRegionalliga Mitte DSV Leoben 5 26 28 12/4/10 45:35 0 0
1963/64 ÖsterreichRegionalliga Mitte DSV Leoben 4 26 27 11/5/10 56:43 0 0
1962/63 ÖsterreichRegionalliga Mitte DSV Leoben 7 26 26 10/6/10 46:47 0 0
1961/62 ÖsterreichRegionalliga Mitte DSV Leoben 11 26 21 7/7/12 42:53 0 0
1960/61 ÖsterreichRegionalliga Mitte DSV Leoben 10 26 22 9/4/13 47:57 0 0

Zusammenfassung Historie nach Liga

Liga Gespielt S/U/N Tore
ST - Landesliga 220 76 / 62 / 82 358 : 353
Regionalliga Mitte 372 148 / 91 / 133 654 : 584
2. Liga Österreich 207 70 / 62 / 75 275 : 279



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

JSM - Modul Vereins Icons (Kopie)

ASK Voitsberg DSV Leoben Frauental SV Lafnitz Amateure Mettersdorf Fürstenfeld SV Wildon SC Bruck/Mur Gnas Lebring Hlg. Kreuz/W. Rottenmann FC Gamlitz SC Liezen Ilzer SV ESV St. Michael

Wer ist Online

Aktuell sind 4002 Gäste und keine Mitglieder online

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Speichernutzung

Datenbankabfragen