Mannschaftsinfo: FC Großklein II

TURNIERE
UEFA

Warning: Undefined array key "TURNIERE" in /var/www/vhosts/esv-knittelfeld.at/httpdocs/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 268

Warning: Trying to access array offset on null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 268

Warning: foreach() argument must be of type array|object, null given in /var/www/vhosts/esv-knittelfeld.at/httpdocs/libraries/src/HTML/Helpers/Select.php on line 481

Warning: Undefined array key "TURNIERE" in /var/www/vhosts/esv-knittelfeld.at/httpdocs/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 286

Warning: Trying to access array offset on null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 286

Warning: foreach() argument must be of type array|object, null given in /var/www/vhosts/esv-knittelfeld.at/httpdocs/libraries/src/HTML/Helpers/Select.php on line 481

Warning: Undefined array key "TURNIERE" in /var/www/vhosts/esv-knittelfeld.at/httpdocs/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 304

Warning: Trying to access array offset on null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 304

Warning: foreach() argument must be of type array|object, null given in /var/www/vhosts/esv-knittelfeld.at/httpdocs/libraries/src/HTML/Helpers/Select.php on line 481

Warning: Undefined array key "TURNIERE" in /var/www/vhosts/esv-knittelfeld.at/httpdocs/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 322

Warning: Trying to access array offset on null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 322

Warning: foreach() argument must be of type array|object, null given in /var/www/vhosts/esv-knittelfeld.at/httpdocs/libraries/src/HTML/Helpers/Select.php on line 481

Warning: Undefined array key "TURNIERE" in /var/www/vhosts/esv-knittelfeld.at/httpdocs/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 340

Warning: Trying to access array offset on null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 340

Warning: foreach() argument must be of type array|object, null given in /var/www/vhosts/esv-knittelfeld.at/httpdocs/libraries/src/HTML/Helpers/Select.php on line 481

Warning: Undefined array key "TURNIERE" in /var/www/vhosts/esv-knittelfeld.at/httpdocs/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 358

Warning: Trying to access array offset on null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 358

Warning: foreach() argument must be of type array|object, null given in /var/www/vhosts/esv-knittelfeld.at/httpdocs/libraries/src/HTML/Helpers/Select.php on line 481

Warning: Undefined array key "TURNIERE" in /var/www/vhosts/esv-knittelfeld.at/httpdocs/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 375

Warning: Trying to access array offset on null in /var/www/vhosts/esv-knittelfeld.at/httpdocs/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 375

Warning: foreach() argument must be of type array|object, null given in /var/www/vhosts/esv-knittelfeld.at/httpdocs/libraries/src/HTML/Helpers/Select.php on line 481

Mannschaft Statistiktabelle

Mannschaft Statistiktabelle

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 = 5178
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 = 5999 AND pt.id = 85798 AND tp.season_id = 200 AND st.season_id = 200 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 = 5999 AND pt.id = 85798 AND tp.season_id = 200 AND st.season_id = 200 AND tp.published = 1 AND ps.published = 1 AND tp.persontype = 1