brewery-futon

AJAX Navigation

DEU

Warning: Undefined array key "TURNIERE" in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 104

Warning: Trying to access array offset on value of type null in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 104

Warning: foreach() argument must be of type array|object, null given in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/libraries/cms/html/select.php on line 592

Warning: Undefined array key "TURNIERE" in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 122

Warning: Trying to access array offset on value of type null in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 122

Warning: foreach() argument must be of type array|object, null given in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/libraries/cms/html/select.php on line 592

Warning: Undefined array key "TURNIERE" in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 140

Warning: Trying to access array offset on value of type null in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 140

Warning: foreach() argument must be of type array|object, null given in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/libraries/cms/html/select.php on line 592

Warning: Undefined array key "TURNIERE" in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 158

Warning: Trying to access array offset on value of type null in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 158

Warning: foreach() argument must be of type array|object, null given in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/libraries/cms/html/select.php on line 592

Warning: Undefined array key "TURNIERE" in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 176

Warning: Trying to access array offset on value of type null in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 176

Warning: foreach() argument must be of type array|object, null given in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/libraries/cms/html/select.php on line 592

Warning: Undefined array key "TURNIERE" in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 194

Warning: Trying to access array offset on value of type null in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 194

Warning: foreach() argument must be of type array|object, null given in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/libraries/cms/html/select.php on line 592

Warning: Undefined array key "TURNIERE" in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 211

Warning: Trying to access array offset on value of type null in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/modules/mod_sportsmanagement_ajax_top_navigation_menu/tmpl/default.php on line 211

Warning: foreach() argument must be of type array|object, null given in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/libraries/cms/html/select.php on line 592
DEU
×

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 = 6543
ORDER BY s.name DESC

sportsmanagementModelTeamInfo::getSeasons 345 projectteamid

74707

sportsmanagementModelTeamInfo::getSeasons 346 teamid

6543

sportsmanagementModelTeamInfo::getPlayerCount 551 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 = 5527 AND pt.id = 78063 AND tp.season_id = 194 AND st.season_id = 194 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 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 = 5527 AND pt.id = 78063 AND tp.season_id = 194 AND st.season_id = 194 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 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 = 5527 AND pt.id = 78063 AND st.season_id = 194 AND stp.season_id = 194 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 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 = 5292 AND pt.id = 74707 AND tp.season_id = 192 AND st.season_id = 192 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 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 = 5292 AND pt.id = 74707 AND tp.season_id = 192 AND st.season_id = 192 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 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 = 5292 AND pt.id = 74707 AND st.season_id = 192 AND stp.season_id = 192 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 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 = 5129 AND pt.id = 72128 AND tp.season_id = 191 AND st.season_id = 191 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 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 = 5129 AND pt.id = 72128 AND tp.season_id = 191 AND st.season_id = 191 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 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 = 5129 AND pt.id = 72128 AND st.season_id = 191 AND stp.season_id = 191 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 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 = 4825 AND pt.id = 66864 AND tp.season_id = 183 AND st.season_id = 183 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 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 = 4825 AND pt.id = 66864 AND tp.season_id = 183 AND st.season_id = 183 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 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 = 4825 AND pt.id = 66864 AND st.season_id = 183 AND stp.season_id = 183 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 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 = 4186 AND pt.id = 56732 AND tp.season_id = 105 AND st.season_id = 105 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 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 = 4186 AND pt.id = 56732 AND tp.season_id = 105 AND st.season_id = 105 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 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 = 4186 AND pt.id = 56732 AND st.season_id = 105 AND stp.season_id = 105 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 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 = 4318 AND pt.id = 58772 AND tp.season_id = 103 AND st.season_id = 103 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 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 = 4318 AND pt.id = 58772 AND tp.season_id = 103 AND st.season_id = 103 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 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 = 4318 AND pt.id = 58772 AND st.season_id = 103 AND stp.season_id = 103 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 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 = 4319 AND pt.id = 58791 AND tp.season_id = 85 AND st.season_id = 85 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 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 = 4319 AND pt.id = 58791 AND tp.season_id = 85 AND st.season_id = 85 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 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 = 4319 AND pt.id = 58791 AND st.season_id = 85 AND stp.season_id = 85 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 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 = 4320 AND pt.id = 58809 AND tp.season_id = 81 AND st.season_id = 81 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 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 = 4320 AND pt.id = 58809 AND tp.season_id = 81 AND st.season_id = 81 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 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 = 4320 AND pt.id = 58809 AND st.season_id = 81 AND stp.season_id = 81 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 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 = 4321 AND pt.id = 58826 AND tp.season_id = 79 AND st.season_id = 79 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 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 = 4321 AND pt.id = 58826 AND tp.season_id = 79 AND st.season_id = 79 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 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 = 4321 AND pt.id = 58826 AND st.season_id = 79 AND stp.season_id = 79 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 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 = 4322 AND pt.id = 58845 AND tp.season_id = 71 AND st.season_id = 71 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 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 = 4322 AND pt.id = 58845 AND tp.season_id = 71 AND st.season_id = 71 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 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 = 4322 AND pt.id = 58845 AND st.season_id = 71 AND stp.season_id = 71 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 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 = 4323 AND pt.id = 58864 AND tp.season_id = 69 AND st.season_id = 69 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 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 = 4323 AND pt.id = 58864 AND tp.season_id = 69 AND st.season_id = 69 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 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 = 4323 AND pt.id = 58864 AND st.season_id = 69 AND stp.season_id = 69 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 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 = 4324 AND pt.id = 58885 AND tp.season_id = 68 AND st.season_id = 68 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 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 = 4324 AND pt.id = 58885 AND tp.season_id = 68 AND st.season_id = 68 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 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 = 4324 AND pt.id = 58885 AND st.season_id = 68 AND stp.season_id = 68 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 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 = 4325 AND pt.id = 58891 AND tp.season_id = 55 AND st.season_id = 55 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 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 = 4325 AND pt.id = 58891 AND tp.season_id = 55 AND st.season_id = 55 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 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 = 4325 AND pt.id = 58891 AND st.season_id = 55 AND stp.season_id = 55 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 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 = 4326 AND pt.id = 58915 AND tp.season_id = 56 AND st.season_id = 56 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 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 = 4326 AND pt.id = 58915 AND tp.season_id = 56 AND st.season_id = 56 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 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 = 4326 AND pt.id = 58915 AND st.season_id = 56 AND stp.season_id = 56 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 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 = 4327 AND pt.id = 58923 AND tp.season_id = 57 AND st.season_id = 57 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 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 = 4327 AND pt.id = 58923 AND tp.season_id = 57 AND st.season_id = 57 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 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 = 4327 AND pt.id = 58923 AND st.season_id = 57 AND stp.season_id = 57 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 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 = 4391 AND pt.id = 60002 AND tp.season_id = 58 AND st.season_id = 58 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 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 = 4391 AND pt.id = 60002 AND tp.season_id = 58 AND st.season_id = 58 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 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 = 4391 AND pt.id = 60002 AND st.season_id = 58 AND stp.season_id = 58 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 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 = 4333 AND pt.id = 59030 AND tp.season_id = 67 AND st.season_id = 67 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 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 = 4333 AND pt.id = 59030 AND tp.season_id = 67 AND st.season_id = 67 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 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 = 4333 AND pt.id = 59030 AND st.season_id = 67 AND stp.season_id = 67 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 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 = 4334 AND pt.id = 59048 AND tp.season_id = 63 AND st.season_id = 63 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 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 = 4334 AND pt.id = 59048 AND tp.season_id = 63 AND st.season_id = 63 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 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 = 4334 AND pt.id = 59048 AND st.season_id = 63 AND stp.season_id = 63 AND stp.published = 1

sportsmanagementModelTeamInfo::getPlayerCount 551 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 = 4335 AND pt.id = 59082 AND tp.season_id = 64 AND st.season_id = 64 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMeanAge 598 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 = 4335 AND pt.id = 59082 AND tp.season_id = 64 AND st.season_id = 64 AND tp.published = 1 AND ps.published = 1

sportsmanagementModelTeamInfo::getPlayerMarketValue 658 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 = 4335 AND pt.id = 59082 AND st.season_id = 64 AND stp.season_id = 64 AND stp.published = 1

Fußball Deutschland - 1. Bundesliga 2022/23 Deutschland - 1. Bundesliga 2022/23    
1. FC Union Berlin 1966 e.V. I
Adresse: 1. FC Union Berlin 1966 e.V. I,
Hämmerlingstraße 80,
Berlin,
12555 Berlin,
Deutschland
 
Vereinsname: 1. FC Union Berlin 1966 e.V. I
Vereinswebseite: http://www.fc-union-berlin.de/
Mannschaftsname: 1. FC Union Berlin
Kurzname: 1. FC

Zusatzangaben

Tipp:

Historie

Saison Liga Ligabild Platz Gespielt Punkte S/U/N Tore Spieler ∅ Alter
2023/24 Deutschland1. Bundesliga Deutschland 1. FC Union Berlin 1966 e.V. I 17 12 7 2/1/9 12:27 0 0
2022/23 Deutschland1. Bundesliga Deutschland 1. FC Union Berlin 1966 e.V. I 4 34 62 18/8/8 51:38 0 0
2021/22 Deutschland1. Bundesliga Deutschland 1. FC Union Berlin 1966 e.V. I 5 34 57 16/9/9 50:44 0 0
2020/21 Deutschland1. Bundesliga Deutschland 1. FC Union Berlin 1966 e.V. I 7 34 50 12/14/8 50:43 0 0
2019/20 Deutschland1. Bundesliga Deutschland 1. FC Union Berlin 1966 e.V. I 11 34 41 12/5/17 41:58 0 0
2018/19 Deutschland2. Bundesliga Deutschland 1. FC Union Berlin 1966 e.V. I 3 34 57 14/15/5 54:33 0 0
2017/18 Deutschland2. Bundesliga Deutschland 1. FC Union Berlin 1966 e.V. I 8 34 47 12/11/11 54:46 0 0
2016/17 Deutschland2. Bundesliga Deutschland 1. FC Union Berlin 1966 e.V. I 4 34 60 18/6/10 51:39 0 0
2015/16 Deutschland2. Bundesliga Deutschland 1. FC Union Berlin 1966 e.V. I 6 34 49 13/10/11 56:50 0 0
2014/15 Deutschland2. Bundesliga Deutschland 1. FC Union Berlin 1966 e.V. I 7 34 47 12/11/11 46:51 0 0
2013/14 Deutschland2. Bundesliga Deutschland 1. FC Union Berlin 1966 e.V. I 9 34 44 11/11/12 48:47 0 0
2012/13 Deutschland2. Bundesliga Deutschland 1. FC Union Berlin 1966 e.V. I 7 34 49 13/10/11 50:49 0 0
2011/12 Deutschland2. Bundesliga Deutschland 1. FC Union Berlin 1966 e.V. I 7 34 48 14/6/14 55:58 0 0
2010/11 Deutschland2. Bundesliga Deutschland 1. FC Union Berlin 1966 e.V. I 11 34 42 11/9/14 39:45 0 0
2009/10 Deutschland2. Bundesliga Deutschland 1. FC Union Berlin 1966 e.V. I 12 34 44 11/11/12 42:45 0 0
2008/09 Deutschland3. Liga Deutschland 1. FC Union Berlin 1966 e.V. I 1 38 78 22/12/4 59:23 0 0
2003/04 Deutschland2. Bundesliga Deutschland 1. FC Union Berlin 1966 e.V. I 17 34 33 8/9/17 43:53 0 0
2002/03 Deutschland2. Bundesliga Deutschland 1. FC Union Berlin 1966 e.V. I 9 34 45 10/15/9 36:48 0 0
2001/02 Deutschland2. Bundesliga Deutschland 1. FC Union Berlin 1966 e.V. I 6 34 56 16/8/10 61:41 0 0

Zusammenfassung Historie nach Liga

Liga
Gespielt
S/U/N
Tore
1. Bundesliga Deutschland
148
60 / 37 / 51
204 : 210
2. Bundesliga Deutschland
442
163 / 132 / 147
635 : 605
3. Liga Deutschland
38
22 / 12 / 4
59 : 23


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

JSM - Modul Matches result_right_tabless

JSM - Kalendermodul (2)

<< < Dezember 2023 > >>
Mo Di Mi Do Fr Sa So
27 28 29 30 01 02 03
04 05 06 07 08 09 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31
kein Eintrag im Monat Dezember 2023 kein Eintrag im Monat Dezember 2023

JSM - Modul Rangliste (2)

Deutschland - 1. Bundesliga 2022/23

# Mannschaft RD PKT +/-
1 Bayern 34 71 54
2 Dortmund 34 71 39
3 RB Leipzig 34 66 23
4 Union Berlin 34 62 13
5 Freiburg 34 59 7
6 Leverkusen 34 50 8
7 Frankfurt 34 50 6

JSM - Modul Vereins Icons (2)

FC Bayern München Borussia Dortmund RasenBallsport Leipzig 1. FC Union Berlin Sport Club Freiburg Bayer 04 Leverkusen Sportgemeinde Eintracht Frankfurt VfL Wolfsburg 1. FSV Mainz 05 Borussia Mönchengladbach 1. FC Köln TSG 1899 Hoffenheim SV Werder Bremen VfL Bochum FC Augsburg VfB Stuttgart FC Schalke 04 Hertha BSC

JSM - Modul Projekte aktuelle Saison (2)


Warning: Attempt to read property "name" on null in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/modules/mod_sportsmanagement_act_season/tmpl/default.php on line 43

JSM - Modul Matches layout_default


Warning: Undefined array key 5475 in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/modules/mod_sportsmanagement_matches/helper.php on line 445

Warning: Undefined array key 5475 in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/modules/mod_sportsmanagement_matches/helper.php on line 445

Warning: Undefined array key 5475 in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/modules/mod_sportsmanagement_matches/helper.php on line 445

Warning: Undefined array key 5475 in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/modules/mod_sportsmanagement_matches/helper.php on line 445
Sa, 02. Dez. 2023 21.00 Uhr
Newcastle United
Newcastle Unit

Warning: Undefined array key "resultpenalty" in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/modules/mod_sportsmanagement_matches/tmpl/default/match.php on line 78

Warning: Undefined array key "resultovertime" in /var/www/vhosts/jsm-help.de/demo.jsm-help.de/modules/mod_sportsmanagement_matches/tmpl/default/match.php on line 82
-:-
Manchester United
Manchester Uni

JSM - Modul Matches layout_tabless

Neue Projekte

Neue Ligen

Heute gibt es leider keine neuen Ligen!

JSM - Modul Vereinsjubiläum (2)

1 / 1
USK Obertrum
... wird 69 Jahre alt
in 2 Tagen am %05. %000 %2023
(* %05.%12.%1954)


Joomla!-Debug-Konsole