Mannschaftsinfo: FV Rot-Weiß 93 Olbersdorf

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 = 4
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 = 94 AND pt.id = 1190 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 = 94 AND pt.id = 1190 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 = 94 AND pt.id = 1190 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 = 96 AND pt.id = 1214 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 = 96 AND pt.id = 1214 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 = 96 AND pt.id = 1214 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 = 92 AND pt.id = 1172 AND tp.season_id = 28 AND st.season_id = 28 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 = 92 AND pt.id = 1172 AND tp.season_id = 28 AND st.season_id = 28 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 = 92 AND pt.id = 1172 AND st.season_id = 28 AND stp.season_id = 28 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 = 74 AND pt.id = 902 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 = 74 AND pt.id = 902 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 = 74 AND pt.id = 902 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 = 76 AND pt.id = 940 AND tp.season_id = 25 AND st.season_id = 25 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 = 76 AND pt.id = 940 AND tp.season_id = 25 AND st.season_id = 25 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 = 76 AND pt.id = 940 AND st.season_id = 25 AND stp.season_id = 25 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 = 67 AND pt.id = 822 AND tp.season_id = 25 AND st.season_id = 25 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 = 67 AND pt.id = 822 AND tp.season_id = 25 AND st.season_id = 25 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 = 67 AND pt.id = 822 AND st.season_id = 25 AND stp.season_id = 25 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 = 66 AND pt.id = 815 AND tp.season_id = 25 AND st.season_id = 25 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 = 66 AND pt.id = 815 AND tp.season_id = 25 AND st.season_id = 25 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 = 66 AND pt.id = 815 AND st.season_id = 25 AND stp.season_id = 25 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 = 62 AND pt.id = 770 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 = 62 AND pt.id = 770 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 = 62 AND pt.id = 770 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 = 57 AND pt.id = 721 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 = 57 AND pt.id = 721 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 = 57 AND pt.id = 721 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 = 39 AND pt.id = 526 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 = 39 AND pt.id = 526 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 = 39 AND pt.id = 526 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 = 35 AND pt.id = 489 AND tp.season_id = 9 AND st.season_id = 9 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 = 35 AND pt.id = 489 AND tp.season_id = 9 AND st.season_id = 9 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 = 35 AND pt.id = 489 AND st.season_id = 9 AND stp.season_id = 9 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 = 61 AND pt.id = 758 AND tp.season_id = 8 AND st.season_id = 8 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 = 61 AND pt.id = 758 AND tp.season_id = 8 AND st.season_id = 8 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 = 61 AND pt.id = 758 AND st.season_id = 8 AND stp.season_id = 8 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 = 21 AND pt.id = 301 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 = 21 AND pt.id = 301 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 = 21 AND pt.id = 301 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 = 87 AND pt.id = 1124 AND tp.season_id = 1 AND st.season_id = 1 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 = 87 AND pt.id = 1124 AND tp.season_id = 1 AND st.season_id = 1 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 = 87 AND pt.id = 1124 AND st.season_id = 1 AND stp.season_id = 1 AND stp.published = 1

Mannschaftsinfo - FV Rot-Weiß 93 Olbersdorf

FV Rot-Weiß 93 Olbersdorf

Adresse: FV Rot-Weiß 93 Olbersdorf,

Ludwig-Jahn-Str. 65,
Sachsen,
02785 Olbersdorf,
Deutschland

Vereinsname: FV Rot-Weiß 93 Olbersdorf

Mannschaftsname: FV Rot-Weiß 93 Olbersdorf

Kurzname: RWO AH

Zusatzangaben

Erweiterte Optionen

Historie

Saison	Liga	Ligabild	Platz	Gespielt	Punkte	S/U/N	Tore	Spieler	∅ Alter	€
2022/2023	Kreisliga Senioren	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	7	10	12	4/0/6	26:34	27	44.3	0
2021/2022	Kreisklasse Senioren	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	11	12	4/0/7	20:23	24	46.13	0
2020/2021	Kreisliga Senioren	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	9	3	4	1/1/1	8:7	19	48	0
2019/2020	Kreisliga Senioren	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	9	7	2/1/6	13:34	32	49.25	0
2017/2018	Kreisliga Senioren	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	25	50.88	0
2017/2018	Kreisliga Senioren	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	25	50.88	0
2017/2018	Kreisliga Senioren	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	6	1	0/1/5	7:16	25	50.88	0
2016/2017	Kreisklasse Senioren	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	9	14	4/2/3	18:11	27	52.5	0
2015/2016	Kreisklasse Senioren	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	3	15	20	5/5/5	32:36	29	51.61	0
2014/2015	Kreisklasse Senioren	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	3	1	0	0/0/1	1:4	26	52.83	0
2013/2014	Kreisklasse Senioren	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	12	14	4/2/6	26:29	27	53.85	0
2012/2013	Kreisklasse Senioren	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
2011/2012	Kreisklasse Senioren	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	3	18	21	6/3/9	41:52	30	53.32	0
2010/2011	Kreisliga Senioren	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	1	0	0/0/1	0:1	23	53.39	0

Zusammenfassung Historie nach Liga

Liga	Gespielt	S/U/N	Tore
Kreisliga Senioren	29	7 / 3 / 19	54 : 92
Kreisklasse Senioren	66	23 / 12 / 31	138 : 155

Trainingszeiten

Wochentag	Beginn	Ende	Ort	Hinweis
Mittwoch	18:30	20:00	Sportplatz Olbersdorf

Zurück

Eine Komponente für viele Sportarten!

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

Ladezeit der Seite: [ 0.212336 ] Sekunden

Free Joomla templates by Ltheme