Mannschaftsinfo

Siegfried Galun, Parkstrasse 64, 8720 Knittelfeld, Austria webmaster@esv-knittelfeld.at

sportsmanagementModelTeamInfo::getSeasons 344 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.champion,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 = 6295
ORDER BY s.name DESC, p.name

sportsmanagementModelTeamInfo::getSeasons 345 projectteamid

sportsmanagementModelTeamInfo::getSeasons 346 teamid

sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 5783 AND pt.id = 82306 AND tp.season_id = 194 AND st.season_id = 194 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 5783 AND pt.id = 82306 AND tp.season_id = 194 AND st.season_id = 194 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 5783 AND pt.id = 82306 AND st.season_id = 194 AND stp.season_id = 194 AND stp.published = 1 AND stp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 5503 AND pt.id = 77746 AND tp.season_id = 192 AND st.season_id = 192 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 5503 AND pt.id = 77746 AND tp.season_id = 192 AND st.season_id = 192 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 5503 AND pt.id = 77746 AND st.season_id = 192 AND stp.season_id = 192 AND stp.published = 1 AND stp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 5302 AND pt.id = 74835 AND tp.season_id = 191 AND st.season_id = 191 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 5302 AND pt.id = 74835 AND tp.season_id = 191 AND st.season_id = 191 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 5302 AND pt.id = 74835 AND st.season_id = 191 AND stp.season_id = 191 AND stp.published = 1 AND stp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 5304 AND pt.id = 74858 AND tp.season_id = 191 AND st.season_id = 191 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 5304 AND pt.id = 74858 AND tp.season_id = 191 AND st.season_id = 191 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 5304 AND pt.id = 74858 AND st.season_id = 191 AND stp.season_id = 191 AND stp.published = 1 AND stp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 5098 AND pt.id = 71731 AND tp.season_id = 183 AND st.season_id = 183 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 5098 AND pt.id = 71731 AND tp.season_id = 183 AND st.season_id = 183 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 5098 AND pt.id = 71731 AND st.season_id = 183 AND stp.season_id = 183 AND stp.published = 1 AND stp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 4698 AND pt.id = 65130 AND tp.season_id = 105 AND st.season_id = 105 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 4698 AND pt.id = 65130 AND tp.season_id = 105 AND st.season_id = 105 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 4698 AND pt.id = 65130 AND st.season_id = 105 AND stp.season_id = 105 AND stp.published = 1 AND stp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 4122 AND pt.id = 55831 AND tp.season_id = 103 AND st.season_id = 103 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 4122 AND pt.id = 55831 AND tp.season_id = 103 AND st.season_id = 103 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 4122 AND pt.id = 55831 AND st.season_id = 103 AND stp.season_id = 103 AND stp.published = 1 AND stp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 4033 AND pt.id = 54604 AND tp.season_id = 85 AND st.season_id = 85 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 4033 AND pt.id = 54604 AND tp.season_id = 85 AND st.season_id = 85 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 4033 AND pt.id = 54604 AND st.season_id = 85 AND stp.season_id = 85 AND stp.published = 1 AND stp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 4032 AND pt.id = 54589 AND tp.season_id = 81 AND st.season_id = 81 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 4032 AND pt.id = 54589 AND tp.season_id = 81 AND st.season_id = 81 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 4032 AND pt.id = 54589 AND st.season_id = 81 AND stp.season_id = 81 AND stp.published = 1 AND stp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 4031 AND pt.id = 54571 AND tp.season_id = 79 AND st.season_id = 79 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 4031 AND pt.id = 54571 AND tp.season_id = 79 AND st.season_id = 79 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 4031 AND pt.id = 54571 AND st.season_id = 79 AND stp.season_id = 79 AND stp.published = 1 AND stp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 4030 AND pt.id = 54558 AND tp.season_id = 71 AND st.season_id = 71 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 4030 AND pt.id = 54558 AND tp.season_id = 71 AND st.season_id = 71 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 4030 AND pt.id = 54558 AND st.season_id = 71 AND stp.season_id = 71 AND stp.published = 1 AND stp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 4029 AND pt.id = 54545 AND tp.season_id = 69 AND st.season_id = 69 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 4029 AND pt.id = 54545 AND tp.season_id = 69 AND st.season_id = 69 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 4029 AND pt.id = 54545 AND st.season_id = 69 AND stp.season_id = 69 AND stp.published = 1 AND stp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 3967 AND pt.id = 53704 AND tp.season_id = 68 AND st.season_id = 68 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 3967 AND pt.id = 53704 AND tp.season_id = 68 AND st.season_id = 68 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 3967 AND pt.id = 53704 AND st.season_id = 68 AND stp.season_id = 68 AND stp.published = 1 AND stp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 4027 AND pt.id = 54519 AND tp.season_id = 55 AND st.season_id = 55 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 4027 AND pt.id = 54519 AND tp.season_id = 55 AND st.season_id = 55 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 4027 AND pt.id = 54519 AND st.season_id = 55 AND stp.season_id = 55 AND stp.published = 1 AND stp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 4026 AND pt.id = 54503 AND tp.season_id = 56 AND st.season_id = 56 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 4026 AND pt.id = 54503 AND tp.season_id = 56 AND st.season_id = 56 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 4026 AND pt.id = 54503 AND st.season_id = 56 AND stp.season_id = 56 AND stp.published = 1 AND stp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 4025 AND pt.id = 54499 AND tp.season_id = 57 AND st.season_id = 57 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 4025 AND pt.id = 54499 AND tp.season_id = 57 AND st.season_id = 57 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 4025 AND pt.id = 54499 AND st.season_id = 57 AND stp.season_id = 57 AND stp.published = 1 AND stp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 4024 AND pt.id = 54478 AND tp.season_id = 58 AND st.season_id = 58 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 4024 AND pt.id = 54478 AND tp.season_id = 58 AND st.season_id = 58 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 4024 AND pt.id = 54478 AND st.season_id = 58 AND stp.season_id = 58 AND stp.published = 1 AND stp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerCount 556 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 = 4023 AND pt.id = 54462 AND tp.season_id = 59 AND st.season_id = 59 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 608 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 = 4023 AND pt.id = 54462 AND tp.season_id = 59 AND st.season_id = 59 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 707 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 = 4023 AND pt.id = 54462 AND st.season_id = 59 AND stp.season_id = 59 AND stp.published = 1 AND stp.persontype = 1

Warning: Attempt to read property "league_id" on null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/models/project.php on line 329

Warning: Attempt to read property "season_id" on null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/models/project.php on line 330

Warning: Attempt to read property "league_id" on null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/models/project.php on line 329

Warning: Attempt to read property "season_id" on null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/models/project.php on line 330

Warning: Attempt to read property "league_id" on null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/models/project.php on line 329

Warning: Attempt to read property "season_id" on null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/models/project.php on line 330

Warning: Undefined array key "show_button_download_pdf" in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/libraries/sportsmanagement/view.php on line 338

Warning: Undefined array key "show_button_download_excel" in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/libraries/sportsmanagement/view.php on line 574

Warning: Attempt to read property "id" on null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/view.html.php on line 41

Warning: Undefined property: sportsmanagementViewTeamInfo::$team in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/view.html.php on line 78

Warning: Attempt to read property "teamextended" on null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/view.html.php on line 78

Warning: Undefined array key "show_projectheader" in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default.php on line 26

Warning: Undefined array key "show_sectionheader" in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default.php on line 31

Warning: Undefined array key "show_teaminfo" in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default.php on line 42

Warning: Undefined array key "show_description" in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default.php on line 47

Warning: Undefined array key "show_extra_fields" in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default.php on line 52

Warning: Undefined array key "show_extended" in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default.php on line 57

Warning: Undefined array key "show_history" in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default.php on line 62

Warning: Undefined array key "show_history_leagues" in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default.php on line 67

Warning: Undefined array key "show_training" in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/teaminfo/tmpl/default.php on line 72

/var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/globalviews/tmpl/default_no_tabs.php on line 20
col-sm-
Warning: Undefined array key "extended_cols" in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/globalviews/tmpl/default_no_tabs.php on line 20
col-md-
Warning: Undefined array key "extended_cols" in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/globalviews/tmpl/default_no_tabs.php on line 20
col-lg-
Warning: Undefined array key "extended_cols" in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/views/globalviews/tmpl/default_no_tabs.php on line 20
">

Eine Komponente für viele Sportarten!

Copyright : © Fussball in Europa
Version : 4.24.00 (diddipoeler)

Ladezeit der Seite: [ 0.005182 ] Sekunden

jDownloads Latest

Frankreich - Ligue 1 2024/25

17.12.2024

Frankreich - Ligue 1 2023/24

13.08.2024

Deutschland - 2. Bundesliga 2024/25

11.08.2024

Deutschland - 1. Bundesliga 2024/25

10.08.2024

England- Premier League 2024/25

10.08.2024

England Championship 2024/25

10.08.2024

Statistik der Sportart

Fußball

Projekte: 3880
Spielorte: 908
Vereine 2872
Spieler 427
Gruppen 91
Spieltage 103882
Spiele 807627

Nächste Meisterschaftsspiele

Deprecated: strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in /var/www/vhosts/esv-knittelfeld.at/httpdocs/administrator/components/com_sportsmanagement/helpers/sportsmanagement.php on line 712

Deprecated: strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in /var/www/vhosts/esv-knittelfeld.at/httpdocs/administrator/components/com_sportsmanagement/helpers/sportsmanagement.php on line 712

Deprecated: strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in /var/www/vhosts/esv-knittelfeld.at/httpdocs/administrator/components/com_sportsmanagement/helpers/sportsmanagement.php on line 712

Deprecated: strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in /var/www/vhosts/esv-knittelfeld.at/httpdocs/administrator/components/com_sportsmanagement/helpers/sportsmanagement.php on line 712

Deprecated: strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in /var/www/vhosts/esv-knittelfeld.at/httpdocs/administrator/components/com_sportsmanagement/helpers/sportsmanagement.php on line 712

Deprecated: strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in /var/www/vhosts/esv-knittelfeld.at/httpdocs/administrator/components/com_sportsmanagement/helpers/sportsmanagement.php on line 712

Deprecated: strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in /var/www/vhosts/esv-knittelfeld.at/httpdocs/administrator/components/com_sportsmanagement/helpers/sportsmanagement.php on line 712

Deprecated: strtotime(): Passing null to parameter #1 ($datetime) of type string is deprecated in /var/www/vhosts/esv-knittelfeld.at/httpdocs/administrator/components/com_sportsmanagement/helpers/sportsmanagement.php on line 712

ST - Oberliga Nord 2024/25 - 21. Spieltag

SPSK

Fr, 02. Mai. 2025

19.00 Uhr

ESV Knittelfeld

ESV Knittelfeld ATV Irdning

ATV Irdning

Irdning 3:1

(1:0)

350

Steirische Frauenlandesliga 2024/25 - 19. Spieltag

SPS

Sa, 03. Mai. 2025

14.30 Uhr

USV Signal Girls Seckau

USV Signal Girls Seckau FC Oberes Feistritztal KM-FR

FC Oberes Feistritztal KM-FR

FC Oberes Feistritztal 1:6

(1:4)

200

ST - Unterliga Nord B 2024/25 - 21. Spieltag

STLE

Sa, 03. Mai. 2025

17.00 Uhr

DSV Leoben II

DSV Juniors II SV St. Lorenzen/Kn.

SV St. Lorenzen/Kn.

St. Lorenzen 0:1

(0:1)

100

ST - Gebietsliga Mur 2024/25 - 21. Spieltag

FCRW

Sa, 03. Mai. 2025

17.00 Uhr

ESV Knittelfeld Juniors II

ESV Knittelfeld Juniors

Spielberg

Spielberg 4:2

(4:0)

100

ST - Oberliga Nord 2024/25 - 22. Spieltag

SPLA

Fr, 09. Mai. 2025

19.00 Uhr

Lassing

Lassing

ESV Knittelfeld

ESV Knittelfeld -:-

ST - Unterliga Nord B 2024/25 - 22. Spieltag

BSSL

Sa, 10. Mai. 2025

13.30 Uhr

SV St. Lorenzen/Kn.

St. Lorenzen Murau

Murau

Murau -:-

ST - Gebietsliga Mur 2024/25 - 22. Spieltag

JLSL

Sa, 10. Mai. 2025

17.00 Uhr

St. Peter/K. II ESV Knittelfeld Juniors II

ESV Knittelfeld Juniors II

ESV Knittelfeld Juniors -:-

Steirische Frauenlandesliga 2024/25 - 20. Spieltag

SPSVS

So, 11. Mai. 2025

14.30 Uhr

SV Stallhofen Damen

Stallhofen Damen

USV Signal Girls Seckau

USV Signal Girls Seckau -:-