Mannschaftsinfo: SV Neueibau 2.

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 = 36
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 = 93 AND pt.id = 1182 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 = 93 AND pt.id = 1182 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 = 93 AND pt.id = 1182 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 = 97 AND pt.id = 1219 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 = 97 AND pt.id = 1219 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 = 97 AND pt.id = 1219 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 = 65 AND pt.id = 806 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 = 65 AND pt.id = 806 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 = 65 AND pt.id = 806 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 = 60 AND pt.id = 744 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 = 60 AND pt.id = 744 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 = 60 AND pt.id = 744 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 = 58 AND pt.id = 726 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 = 58 AND pt.id = 726 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 = 58 AND pt.id = 726 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 = 49 AND pt.id = 614 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 = 49 AND pt.id = 614 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 = 49 AND pt.id = 614 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 = 50 AND pt.id = 780 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 = 50 AND pt.id = 780 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 = 50 AND pt.id = 780 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 = 38 AND pt.id = 520 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 = 38 AND pt.id = 520 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 = 38 AND pt.id = 520 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 = 32 AND pt.id = 464 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 = 32 AND pt.id = 464 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 = 32 AND pt.id = 464 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 = 33 AND pt.id = 472 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 = 33 AND pt.id = 472 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 = 33 AND pt.id = 472 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 = 19 AND pt.id = 262 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 = 19 AND pt.id = 262 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 = 19 AND pt.id = 262 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 = 86 AND pt.id = 1106 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 = 86 AND pt.id = 1106 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 = 86 AND pt.id = 1106 AND st.season_id = 1 AND stp.season_id = 1 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 = 13 AND pt.id = 138 AND tp.season_id = 2 AND st.season_id = 2 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 = 13 AND pt.id = 138 AND tp.season_id = 2 AND st.season_id = 2 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 = 13 AND pt.id = 138 AND st.season_id = 2 AND stp.season_id = 2 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 = 82 AND pt.id = 1045 AND tp.season_id = 3 AND st.season_id = 3 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 = 82 AND pt.id = 1045 AND tp.season_id = 3 AND st.season_id = 3 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 = 82 AND pt.id = 1045 AND st.season_id = 3 AND stp.season_id = 3 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 = 14 AND pt.id = 184 AND tp.season_id = 3 AND st.season_id = 3 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 = 14 AND pt.id = 184 AND tp.season_id = 3 AND st.season_id = 3 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 = 14 AND pt.id = 184 AND st.season_id = 3 AND stp.season_id = 3 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 = 42 AND pt.id = 547 AND tp.season_id = 12 AND st.season_id = 12 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 = 42 AND pt.id = 547 AND tp.season_id = 12 AND st.season_id = 12 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 = 42 AND pt.id = 547 AND st.season_id = 12 AND stp.season_id = 12 AND stp.published = 1

Mannschaftsinfo - SV Neueibau 2.

SV Neueibau

Vereinsname: SV Neueibau

Mannschaftsname: SV Neueibau 2.

Kurzname: Neueibau 2.

Zusatzangaben

Erweiterte Optionen

Historie

Saison	Liga	Ligabild	Platz	Gespielt	Punkte	S/U/N	Tore	Spieler	∅ Alter	€
2022/2023	Kreisliga Herren	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	22	27	7/6/9	34:42	0	0	0
2021/2022	Kreisliga Herren	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	5	20	29	8/5/7	45:35	0	0	0
2017/2018	Kreisklasse Herren	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	24	62	20/2/2	76:27	0	0	0
2016/2017	1. Kreisklasse Herren	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	26	38	11/5/10	61:54	0	0	0
2016/2017	Kreispokal Herren	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	1	0	0/0/1	1:5	0	0	0
2015/2016	Kreisklasse Herren	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	2	1	0/1/1	2:3	0	0	0
2015/2016	Freundschaftsspiele	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	5	1	0	0/0/1	4:6	0	0	0
2014/2015	Kreisklasse Herren	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	26	64	21/1/4	88:32	0	0	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	3	0	0	0/0/0	0:0	0	0	0
2012/2013	Kreisklasse Herren	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	Kreispokal Herren	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	20	1	0	0/0/1	1:3	0	0	0
2010/2011	1. Kreisklasse Herren	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	3	1/0/0	4:1	0	0	0
2009/2010	Kreispokal Herren	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	18	1	0	0/0/1	2:3	0	0	0
2008/2009	Kreispokal Herren	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	0	0	0/0/0	0:0	0	0	0
2008/2009	Kreispokal Herren	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	0	0	0/0/0	0:0	0	0	0
2003/2004	1. Kreisklasse Herren	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	30	50	14/8/8	65:53	0	0	0

Zusammenfassung Historie nach Liga

Liga	Gespielt	S/U/N	Tore
Kreisliga Herren	42	15 / 11 / 16	79 : 77
Kreisklasse Herren	52	41 / 4 / 7	166 : 62
1. Kreisklasse Herren	57	26 / 13 / 18	130 : 108
Kreispokal Herren	3	0 / 0 / 3	4 : 11
Freundschaftsspiele	1	0 / 0 / 1	4 : 6
Kreisklasse Senioren	0	0 / 0 / 0	0 : 0

Trainingszeiten

Tipp: Keine Trainingszeiten vorhanden!

Wochentag	Beginn	Ende	Ort	Hinweis

Eine Komponente für viele Sportarten!

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

Ladezeit der Seite: [ 0.236841 ] Sekunden

Free Joomla templates by Ltheme