Mannschaftsinfo: TSG Hainewalde

FV Rot-Weiß 93 Olbersdorf

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 joom3_sportsmanagement_project_team AS pt 
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.id = pt.team_id
INNER JOIN joom3_sportsmanagement_team AS t ON t.id = st.team_id 
INNER JOIN joom3_sportsmanagement_project AS p ON p.id = pt.project_id 
INNER JOIN joom3_sportsmanagement_season AS s ON s.id = p.season_id 
INNER JOIN joom3_sportsmanagement_league AS l ON l.id = p.league_id 
WHERE t.id = 118
ORDER BY s.name DESC

sportsmanagementModelTeamInfo::getSeasons 345 projectteamid

sportsmanagementModelTeamInfo::getSeasons 346 teamid

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 93 AND pt.id = 1202 AND tp.season_id = 30 AND st.season_id = 30 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 93 AND pt.id = 1202 AND tp.season_id = 30 AND st.season_id = 30 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 93 AND pt.id = 1202 AND st.season_id = 30 AND stp.season_id = 30 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 97 AND pt.id = 1220 AND tp.season_id = 29 AND st.season_id = 29 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 97 AND pt.id = 1220 AND tp.season_id = 29 AND st.season_id = 29 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 97 AND pt.id = 1220 AND st.season_id = 29 AND stp.season_id = 29 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 73 AND pt.id = 888 AND tp.season_id = 27 AND st.season_id = 27 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 73 AND pt.id = 888 AND tp.season_id = 27 AND st.season_id = 27 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 73 AND pt.id = 888 AND st.season_id = 27 AND stp.season_id = 27 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 70 AND pt.id = 863 AND tp.season_id = 26 AND st.season_id = 26 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 70 AND pt.id = 863 AND tp.season_id = 26 AND st.season_id = 26 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 70 AND pt.id = 863 AND st.season_id = 26 AND stp.season_id = 26 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 60 AND pt.id = 748 AND tp.season_id = 24 AND st.season_id = 24 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 60 AND pt.id = 748 AND tp.season_id = 24 AND st.season_id = 24 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 60 AND pt.id = 748 AND st.season_id = 24 AND stp.season_id = 24 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 49 AND pt.id = 615 AND tp.season_id = 14 AND st.season_id = 14 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 49 AND pt.id = 615 AND tp.season_id = 14 AND st.season_id = 14 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 49 AND pt.id = 615 AND st.season_id = 14 AND stp.season_id = 14 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 36 AND pt.id = 500 AND tp.season_id = 11 AND st.season_id = 11 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 36 AND pt.id = 500 AND tp.season_id = 11 AND st.season_id = 11 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 36 AND pt.id = 500 AND st.season_id = 11 AND stp.season_id = 11 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 19 AND pt.id = 323 AND tp.season_id = 7 AND st.season_id = 7 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 19 AND pt.id = 323 AND tp.season_id = 7 AND st.season_id = 7 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 19 AND pt.id = 323 AND st.season_id = 7 AND stp.season_id = 7 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 13 AND pt.id = 154 AND tp.season_id = 2 AND st.season_id = 2 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 13 AND pt.id = 154 AND tp.season_id = 2 AND st.season_id = 2 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 13 AND pt.id = 154 AND st.season_id = 2 AND stp.season_id = 2 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 85 AND pt.id = 1098 AND tp.season_id = 10 AND st.season_id = 10 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 85 AND pt.id = 1098 AND tp.season_id = 10 AND st.season_id = 10 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 85 AND pt.id = 1098 AND st.season_id = 10 AND stp.season_id = 10 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 45 AND pt.id = 576 AND tp.season_id = 13 AND st.season_id = 13 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 45 AND pt.id = 576 AND tp.season_id = 13 AND st.season_id = 13 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 45 AND pt.id = 576 AND st.season_id = 13 AND stp.season_id = 13 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 52 AND pt.id = 641 AND tp.season_id = 15 AND st.season_id = 15 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 52 AND pt.id = 641 AND tp.season_id = 15 AND st.season_id = 15 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 52 AND pt.id = 641 AND st.season_id = 15 AND stp.season_id = 15 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 53 AND pt.id = 658 AND tp.season_id = 16 AND st.season_id = 16 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 53 AND pt.id = 658 AND tp.season_id = 16 AND st.season_id = 16 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 53 AND pt.id = 658 AND st.season_id = 16 AND stp.season_id = 16 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 51 AND pt.id = 627 AND tp.season_id = 18 AND st.season_id = 18 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 51 AND pt.id = 627 AND tp.season_id = 18 AND st.season_id = 18 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 51 AND pt.id = 627 AND st.season_id = 18 AND stp.season_id = 18 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 54 AND pt.id = 680 AND tp.season_id = 19 AND st.season_id = 19 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 54 AND pt.id = 680 AND tp.season_id = 19 AND st.season_id = 19 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 54 AND pt.id = 680 AND st.season_id = 19 AND stp.season_id = 19 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 55 AND pt.id = 690 AND tp.season_id = 20 AND st.season_id = 20 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 55 AND pt.id = 690 AND tp.season_id = 20 AND st.season_id = 20 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 55 AND pt.id = 690 AND st.season_id = 20 AND stp.season_id = 20 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 data

SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 56 AND pt.id = 712 AND tp.season_id = 21 AND st.season_id = 21 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data

SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 56 AND pt.id = 712 AND tp.season_id = 21 AND st.season_id = 21 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data

SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 56 AND pt.id = 712 AND st.season_id = 21 AND stp.season_id = 21 AND stp.published = 1

Mannschaftsinfo - TSG Hainewalde

TSG Hainewalde

Vereinsname: TSG Hainewalde

Mannschaftsname: TSG Hainewalde

Kurzname: Hainewalde

Zusatzangaben

Erweiterte Optionen

Historie

Saison	Liga	Ligabild	Platz	Gespielt	Punkte	S/U/N	Tore	Spieler	∅ Alter	€
2022/2023	Kreisliga Herren	Warning: Undefined array key "show_team_hist_picture" in /var/www/web23529296/html/rwo/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128	6	24	30	8/6/10	48:46	0	0	0
2021/2022	Kreisliga Herren	Warning: Undefined array key "show_team_hist_picture" in /var/www/web23529296/html/rwo/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128	4	18	30	8/6/4	39:29	0	0	0
2019/2020	Kreisklasse Herren	Warning: Undefined array key "show_team_hist_picture" in /var/www/web23529296/html/rwo/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128	1	10	26	8/2/0	47:10	0	0	0
2018/2019	Kreisklasse Herren	Warning: Undefined array key "show_team_hist_picture" in /var/www/web23529296/html/rwo/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128	1	22	59	19/2/1	90:25	0	0	0
2016/2017	1. Kreisklasse Herren	Warning: Undefined array key "show_team_hist_picture" in /var/www/web23529296/html/rwo/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128	2	26	57	21/3/2	104:25	0	0	0
2015/2016	Kreisklasse Herren	Warning: Undefined array key "show_team_hist_picture" in /var/www/web23529296/html/rwo/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128	1	2	6	2/0/0	4:1	0	0	0
2014/2015	Kreisliga Herren	Warning: Undefined array key "show_team_hist_picture" in /var/www/web23529296/html/rwo/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128	12	26	15	3/6/17	26:62	0	0	0
2011/2012	Kreispokal Herren	Warning: Undefined array key "show_team_hist_picture" in /var/www/web23529296/html/rwo/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128	58	1	0	0/0/1	0:2	0	0	0
2009/2010	Kreispokal Herren	Warning: Undefined array key "show_team_hist_picture" in /var/www/web23529296/html/rwo/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128	25	1	0	0/0/1	0:1	0	0	0
2004/2005	Kreisliga Herren	Warning: Undefined array key "show_team_hist_picture" in /var/www/web23529296/html/rwo/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128	12	1	0	0/0/1	2:3	0	0	0
2002/2003	Kreisliga Herren	Warning: Undefined array key "show_team_hist_picture" in /var/www/web23529296/html/rwo/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128	8	2	6	2/0/0	6:2	0	0	0
2001/2002	Kreisliga Herren	Warning: Undefined array key "show_team_hist_picture" in /var/www/web23529296/html/rwo/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128	1	0	0	0/0/0	0:0	0	0	0
2000/2001	Kreisliga Herren	Warning: Undefined array key "show_team_hist_picture" in /var/www/web23529296/html/rwo/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128	11	23	36	9/9/5	35:32	0	0	0
1998/1999	Kreisliga Herren	Warning: Undefined array key "show_team_hist_picture" in /var/www/web23529296/html/rwo/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128	12	30	46	13/7/10	57:48	0	0	0
1997/1998	Kreisliga Herren	Warning: Undefined array key "show_team_hist_picture" in /var/www/web23529296/html/rwo/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128	1	0	0	0/0/0	0:0	0	0	0
1996/1997	Kreisliga Herren	Warning: Undefined array key "show_team_hist_picture" in /var/www/web23529296/html/rwo/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128	1	0	0	0/0/0	0:0	0	0	0
1995/1996	Kreisliga Herren	Warning: Undefined array key "show_team_hist_picture" in /var/www/web23529296/html/rwo/components/com_sportsmanagement/views/teaminfo/tmpl/default_history.php on line 128	1	0	0	0/0/0	0:0	0	0	0

Zusammenfassung Historie nach Liga

Liga	Gespielt	S/U/N	Tore
Kreisliga Herren	124	43 / 34 / 47	213 : 222
Kreisklasse Herren	34	29 / 4 / 1	141 : 36
1. Kreisklasse Herren	26	21 / 3 / 2	104 : 25
Kreispokal Herren	2	0 / 0 / 2	0 : 3

Trainingszeiten

Tipp: Keine Trainingszeiten vorhanden!

Wochentag	Beginn	Ende	Ort	Hinweis

Eine Komponente für viele Sportarten!

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

Ladezeit der Seite: [ 0.290413 ] Sekunden

Free Joomla templates by Ltheme