brewery-futon

AJAX Navigation

AUT

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
AUT
×

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

sportsmanagementModelTeamInfo::getSeasons 345 projectteamid

27841

sportsmanagementModelTeamInfo::getSeasons 346 teamid

3633

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 = 5317 AND pt.id = 75100 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 = 5317 AND pt.id = 75100 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 = 5317 AND pt.id = 75100 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 = 5112 AND pt.id = 71905 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 = 5112 AND pt.id = 71905 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 = 5112 AND pt.id = 71905 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 = 4679 AND pt.id = 64856 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 = 4679 AND pt.id = 64856 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 = 4679 AND pt.id = 64856 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 = 4143 AND pt.id = 56127 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 = 4143 AND pt.id = 56127 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 = 4143 AND pt.id = 56127 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 = 3730 AND pt.id = 50399 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 = 3730 AND pt.id = 50399 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 = 3730 AND pt.id = 50399 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 = 3127 AND pt.id = 42112 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 = 3127 AND pt.id = 42112 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 = 3127 AND pt.id = 42112 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 = 2978 AND pt.id = 40090 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 = 2978 AND pt.id = 40090 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 = 2978 AND pt.id = 40090 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 = 2461 AND pt.id = 33206 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 = 2461 AND pt.id = 33206 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 = 2461 AND pt.id = 33206 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 = 2088 AND pt.id = 28055 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 = 2088 AND pt.id = 28055 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 = 2088 AND pt.id = 28055 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 = 2070 AND pt.id = 27841 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 = 2070 AND pt.id = 27841 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 = 2070 AND pt.id = 27841 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 = 2041 AND pt.id = 27492 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 = 2041 AND pt.id = 27492 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 = 2041 AND pt.id = 27492 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 = 2036 AND pt.id = 27418 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 = 2036 AND pt.id = 27418 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 = 2036 AND pt.id = 27418 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 = 2030 AND pt.id = 27397 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 = 2030 AND pt.id = 27397 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 = 2030 AND pt.id = 27397 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 = 2031 AND pt.id = 27391 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 = 2031 AND pt.id = 27391 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 = 2031 AND pt.id = 27391 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 = 2029 AND pt.id = 27370 AND tp.season_id = 59 AND st.season_id = 59 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 = 2029 AND pt.id = 27370 AND tp.season_id = 59 AND st.season_id = 59 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 = 2029 AND pt.id = 27370 AND st.season_id = 59 AND stp.season_id = 59 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 = 2028 AND pt.id = 27355 AND tp.season_id = 60 AND st.season_id = 60 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 = 2028 AND pt.id = 27355 AND tp.season_id = 60 AND st.season_id = 60 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 = 2028 AND pt.id = 27355 AND st.season_id = 60 AND stp.season_id = 60 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 = 2032 AND pt.id = 27350 AND tp.season_id = 61 AND st.season_id = 61 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 = 2032 AND pt.id = 27350 AND tp.season_id = 61 AND st.season_id = 61 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 = 2032 AND pt.id = 27350 AND st.season_id = 61 AND stp.season_id = 61 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 = 2034 AND pt.id = 27330 AND tp.season_id = 62 AND st.season_id = 62 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 = 2034 AND pt.id = 27330 AND tp.season_id = 62 AND st.season_id = 62 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 = 2034 AND pt.id = 27330 AND st.season_id = 62 AND stp.season_id = 62 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 = 2140 AND pt.id = 28813 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 = 2140 AND pt.id = 28813 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 = 2140 AND pt.id = 28813 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 = 2061 AND pt.id = 27753 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 = 2061 AND pt.id = 27753 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 = 2061 AND pt.id = 27753 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 = 4936 AND pt.id = 69089 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 = 4936 AND pt.id = 69089 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 = 4936 AND pt.id = 69089 AND st.season_id = 64 AND stp.season_id = 64 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 = 4937 AND pt.id = 69102 AND tp.season_id = 65 AND st.season_id = 65 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 = 4937 AND pt.id = 69102 AND tp.season_id = 65 AND st.season_id = 65 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 = 4937 AND pt.id = 69102 AND st.season_id = 65 AND stp.season_id = 65 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 = 4938 AND pt.id = 69115 AND tp.season_id = 66 AND st.season_id = 66 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 = 4938 AND pt.id = 69115 AND tp.season_id = 66 AND st.season_id = 66 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 = 4938 AND pt.id = 69115 AND st.season_id = 66 AND stp.season_id = 66 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 = 5133 AND pt.id = 72195 AND tp.season_id = 72 AND st.season_id = 72 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 = 5133 AND pt.id = 72195 AND tp.season_id = 72 AND st.season_id = 72 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 = 5133 AND pt.id = 72195 AND st.season_id = 72 AND stp.season_id = 72 AND stp.published = 1

Fußball ST - Oberliga Nord 2012/13© [ SIGA ] ST - Oberliga Nord 2012/13    

Mannschaftsinfo - DSV Juniors II

DSV Leoben
Adresse: DSV Leoben,
Annaberggasse 10,
Steiermark,
8700 Donawitz,
Österreich
 
Telefon: 03842/21391
Fax: 03842/2139130
eMail: Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!
Vereinsname: DSV Leoben
Vereinswebseite: http://www.dsv-leoben.at/
Mannschaftsname: DSV Juniors II
Kurzname: DSV

Beschreibung Projektteam

Beschreibung Stammdaten Team


Zusatzangaben

Tipp:

Historie

Saison Liga Ligabild Platz Gespielt Punkte S/U/N Tore Spieler ∅ Alter
2022/23 ÖsterreichST - 1. Klasse Mur/Mürz A DSV Leoben 1 22 66 22/0/0 188:5 0 0
2020/21 ÖsterreichST - Gebietsliga Mürz DSV Leoben 11 10 5 1/2/7 18:35 0 0
2019/20 ÖsterreichST - Gebietsliga Mürz DSV Leoben 11 11 9 2/3/6 14:26 0 0
2018/19 ÖsterreichST - Gebietsliga Mürz DSV Leoben 10 24 26 8/2/14 45:69 0 0
2017/18 ÖsterreichST - Gebietsliga Mürz DSV Leoben 3 22 43 13/4/5 59:30 0 0
2016/17 ÖsterreichST - Gebietsliga Mürz DSV Leoben 6 22 27 9/0/13 33:44 0 0
2015/16 ÖsterreichST - Gebietsliga Mürz DSV Leoben 7 22 29 8/5/9 33:49 0 0
2014/15 ÖsterreichST - Unterliga Nord B DSV Leoben 14 26 10 2/4/20 28:78 0 0
2013/14 ÖsterreichST - Unterliga Nord B DSV Leoben 6 26 38 11/5/10 67:64 0 0
2012/13 ÖsterreichST - Oberliga Nord DSV Leoben 13 26 22 5/7/14 36:59 0 0
2011/12 ÖsterreichST - Oberliga Nord DSV Leoben 4 26 47 14/5/7 53:38 0 0
2010/11 ÖsterreichST - Oberliga Nord DSV Leoben 9 26 30 8/6/12 54:62 0 0
2009/10 ÖsterreichST - Oberliga Nord DSV Leoben 11 26 24 7/3/16 43:64 0 0
2008/09 ÖsterreichST - Oberliga Nord DSV Leoben 6 26 42 12/6/8 58:35 0 0
2007/08 ÖsterreichST - Oberliga Nord DSV Leoben 4 26 44 13/5/8 45:41 0 0
2006/07 ÖsterreichST - Oberliga Nord DSV Leoben 3 26 50 14/8/4 63:29 0 0
2005/06 ÖsterreichST - Oberliga Nord DSV Leoben 3 26 50 15/5/6 68:38 0 0
2004/05 ÖsterreichST - Oberliga Nord DSV Leoben 2 26 51 15/6/5 71:31 0 0
2003/04 ÖsterreichST - Oberliga Nord DSV Leoben 2 26 50 15/5/6 66:31 0 0
2002/03 ÖsterreichST - Unterliga Nord B DSV Leoben 1 22 57 18/3/1 70:20 0 0
2001/02 ÖsterreichST - Gebietsliga Mürz DSV Leoben 1 22 56 18/2/2 65:21 0 0
2000/01 ÖsterreichST - Gebietsliga Mürz DSV Leoben 2 22 50 16/2/4 74:22 0 0
1999/2000 ÖsterreichST - Gebietsliga Mürz DSV Leoben 2 22 42 12/6/4 57:22 0 0
1998/99 ÖsterreichST - Gebietsliga Mürz DSV Leoben 10 24 22 5/7/12 26:43 0 0

Zusammenfassung Historie nach Liga

Liga Gespielt S/U/N Tore
ST - 1. Klasse Mur/Mürz A 22 22 / 0 / 0 188 : 5
ST - Gebietsliga Mürz 201 92 / 33 / 76 424 : 361
ST - Unterliga Nord B 74 31 / 12 / 31 165 : 162
ST - Oberliga Nord 260 118 / 56 / 86 557 : 428


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

JSM - Modul Vereins Icons (2)

ATV Irdning SC Bruck/Mur ESV Knittelfeld Rottenmann Bad Mitterndorf FC Trofaiach SC Raiffeisen Mürzhofen/Allerh. SV Union Haus/E. Fc Obdach Rapid Kapfenberg EKRO Tus Krieglach Proleb DSV Juniors II WSV Liezen
 
 
 

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Speichernutzung

Datenbankabfragen