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 = 4896
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 = 5800 AND pt.id = 82565 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 = 5800 AND pt.id = 82565 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 = 5800 AND pt.id = 82565 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 = 5544 AND pt.id = 78377 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 = 5544 AND pt.id = 78377 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 = 5544 AND pt.id = 78377 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 = 5411 AND pt.id = 76453 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 = 5411 AND pt.id = 76453 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 = 5411 AND pt.id = 76453 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 = 5168 AND pt.id = 72735 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 = 5168 AND pt.id = 72735 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 = 5168 AND pt.id = 72735 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 = 4800 AND pt.id = 66524 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 = 4800 AND pt.id = 66524 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 = 4800 AND pt.id = 66524 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 = 4163 AND pt.id = 56424 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 = 4163 AND pt.id = 56424 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 = 4163 AND pt.id = 56424 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 = 3764 AND pt.id = 50853 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 = 3764 AND pt.id = 50853 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 = 3764 AND pt.id = 50853 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 = 3187 AND pt.id = 42946 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 = 3187 AND pt.id = 42946 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 = 3187 AND pt.id = 42946 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 = 3023 AND pt.id = 40686 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 = 3023 AND pt.id = 40686 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 = 3023 AND pt.id = 40686 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 = 5554 AND pt.id = 78496 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 = 5554 AND pt.id = 78496 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 = 5554 AND pt.id = 78496 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 = 2747 AND pt.id = 36981 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 = 2747 AND pt.id = 36981 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 = 2747 AND pt.id = 36981 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 = 2757 AND pt.id = 37113 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 = 2757 AND pt.id = 37113 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 = 2757 AND pt.id = 37113 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 = 2745 AND pt.id = 36967 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 = 2745 AND pt.id = 36967 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 = 2745 AND pt.id = 36967 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 = 2744 AND pt.id = 36954 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 = 2744 AND pt.id = 36954 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 = 2744 AND pt.id = 36954 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 = 2743 AND pt.id = 36935 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 = 2743 AND pt.id = 36935 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 = 2743 AND pt.id = 36935 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 = 2742 AND pt.id = 36926 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 = 2742 AND pt.id = 36926 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 = 2742 AND pt.id = 36926 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 = 2741 AND pt.id = 36915 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 = 2741 AND pt.id = 36915 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 = 2741 AND pt.id = 36915 AND st.season_id = 59 AND stp.season_id = 59 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 = 3045 AND pt.id = 41011 AND tp.season_id = 60 AND st.season_id = 60 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 = 3045 AND pt.id = 41011 AND tp.season_id = 60 AND st.season_id = 60 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 = 3045 AND pt.id = 41011 AND st.season_id = 60 AND stp.season_id = 60 AND stp.published = 1 AND stp.persontype = 1

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 = 36967
ORDER BY s.name DESC, p.name

sportsmanagementModelTeamInfo::getSeasons 345 projectteamid

sportsmanagementModelTeamInfo::getSeasons 346 teamid

Fehler: Team-ID wurde in der URL nicht übermittelt oder der Verein wurde in der Datenbank nicht gefunden

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 "projectteamid" on null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/models/teaminfo.php on line 219

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

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

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

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

England
		Football League Second Division 1922/23

Zusatzangaben

Tipp:

Erweiterte Optionen

repeat

Historie

Saison	Liga	Ligabild	Platz	Gespielt	Punkte	S/U/N	Tore	Spieler	∅ Alter

Zusammenfassung Historie nach Liga

Liga

Gespielt

S/U/N

Tore

Zurück

Eine Komponente für viele Sportarten!

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

Ladezeit der Seite: [ 0.008037 ] 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 - 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 - 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 - 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 -:-

Wir benutzen Cookies

Wir nutzen Cookies auf unserer Website. Einige von ihnen sind essenziell für den Betrieb der Seite, während andere uns helfen, diese Website und die Nutzererfahrung zu verbessern (Tracking Cookies). Sie können selbst entscheiden, ob Sie die Cookies zulassen möchten. Bitte beachten Sie, dass bei einer Ablehnung womöglich nicht mehr alle Funktionalitäten der Seite zur Verfügung stehen.

Akzeptieren Ablehnen

Weitere Informationen | Impressum