Off Canvas sidebar is empty
Würzburger Str 13, 63811 Stockstadt support@example.com
×

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 vbtce_sportsmanagement_project_team AS pt 
INNER JOIN vbtce_sportsmanagement_season_team_id AS st ON st.id = pt.team_id
INNER JOIN vbtce_sportsmanagement_team AS t ON t.id = st.team_id 
INNER JOIN vbtce_sportsmanagement_project AS p ON p.id = pt.project_id 
INNER JOIN vbtce_sportsmanagement_season AS s ON s.id = p.season_id 
INNER JOIN vbtce_sportsmanagement_league AS l ON l.id = p.league_id 
WHERE t.id = 5
ORDER BY s.name DESC
sportsmanagementModelTeamInfo::getSeasons 345 projectteamid
5
sportsmanagementModelTeamInfo::getSeasons 346 teamid
5
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM vbtce_sportsmanagement_person AS ps
INNER JOIN vbtce_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN vbtce_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN vbtce_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 1 AND pt.id = 5 AND tp.season_id = 1 AND st.season_id = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM vbtce_sportsmanagement_person AS ps
INNER JOIN vbtce_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN vbtce_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN vbtce_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 1 AND pt.id = 5 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 vbtce_sportsmanagement_season_team_person_id AS stp
INNER JOIN vbtce_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN vbtce_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 1 AND pt.id = 5 AND st.season_id = 1 AND stp.season_id = 1 AND stp.published = 1
Fußball Staffel-ID [] Print    

Mannschaftsinfo - FC Tarp-Oeversee

FC Tarp-Oeversee
Vereinsname: FC Tarp-Oeversee
Mannschaftsname: FC Tarp-Oeversee
Kurzname: FC Tarp-Oevers

Zusatzangaben

Erweiterte Optionen

Historie

Saison Liga Ligabild Platz Gespielt Punkte S/U/N Tore Spieler ∅ Alter
19/20 Verbandsliga Nord FC Tarp-Oeversee 13 1 0 0/0/1 1:4 0 0 0

Zusammenfassung Historie nach Liga

Liga Gespielt S/U/N Tore
Verbandsliga Nord 1 0 / 0 / 1 1 : 4

Trainingszeiten

Tipp: Keine Trainingszeiten vorhanden!

Wochentag Beginn Ende Ort Hinweis



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