No module Published on Offcanvas position
Jahnring 15, 02959 Schleife +49 035773 73890 webmaster@svlokschleife.de

Startseite

×

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 jomkas_sportsmanagement_project_team AS pt 
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.id = pt.team_id
INNER JOIN jomkas_sportsmanagement_team AS t ON t.id = st.team_id 
INNER JOIN jomkas_sportsmanagement_project AS p ON p.id = pt.project_id 
INNER JOIN jomkas_sportsmanagement_season AS s ON s.id = p.season_id 
INNER JOIN jomkas_sportsmanagement_league AS l ON l.id = p.league_id 
WHERE t.id = 25
ORDER BY s.name DESC
sportsmanagementModelTeamInfo::getSeasons 345 projectteamid 
180
sportsmanagementModelTeamInfo::getSeasons 346 teamid 
25
sportsmanagementModelTeamInfo::getPlayerCount 551 data 
SELECT COUNT(*) AS playercnt
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 68 AND pt.id = 785 AND tp.season_id = 17 AND st.season_id = 17 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data 
SELECT ps.birthday, ps.deathday
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 68 AND pt.id = 785 AND tp.season_id = 17 AND st.season_id = 17 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data 
SELECT SUM(stp.market_value) AS market_value
FROM jomkas_sportsmanagement_season_team_person_id AS stp
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 68 AND pt.id = 785 AND st.season_id = 17 AND stp.season_id = 17 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data 
SELECT COUNT(*) AS playercnt
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 66 AND pt.id = 753 AND tp.season_id = 16 AND st.season_id = 16 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data 
SELECT ps.birthday, ps.deathday
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 66 AND pt.id = 753 AND tp.season_id = 16 AND st.season_id = 16 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data 
SELECT SUM(stp.market_value) AS market_value
FROM jomkas_sportsmanagement_season_team_person_id AS stp
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 66 AND pt.id = 753 AND st.season_id = 16 AND stp.season_id = 16 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data 
SELECT COUNT(*) AS playercnt
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 65 AND pt.id = 734 AND tp.season_id = 15 AND st.season_id = 15 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data 
SELECT ps.birthday, ps.deathday
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 65 AND pt.id = 734 AND tp.season_id = 15 AND st.season_id = 15 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data 
SELECT SUM(stp.market_value) AS market_value
FROM jomkas_sportsmanagement_season_team_person_id AS stp
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 65 AND pt.id = 734 AND st.season_id = 15 AND stp.season_id = 15 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data 
SELECT COUNT(*) AS playercnt
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 7 AND pt.id = 180 AND tp.season_id = 3 AND st.season_id = 3 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data 
SELECT ps.birthday, ps.deathday
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 7 AND pt.id = 180 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 jomkas_sportsmanagement_season_team_person_id AS stp
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 7 AND pt.id = 180 AND st.season_id = 3 AND stp.season_id = 3 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data 
SELECT COUNT(*) AS playercnt
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 62 AND pt.id = 707 AND tp.season_id = 14 AND st.season_id = 14 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data 
SELECT ps.birthday, ps.deathday
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 62 AND pt.id = 707 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 jomkas_sportsmanagement_season_team_person_id AS stp
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 62 AND pt.id = 707 AND st.season_id = 14 AND stp.season_id = 14 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data 
SELECT COUNT(*) AS playercnt
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 60 AND pt.id = 695 AND tp.season_id = 13 AND st.season_id = 13 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data 
SELECT ps.birthday, ps.deathday
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 60 AND pt.id = 695 AND tp.season_id = 13 AND st.season_id = 13 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data 
SELECT SUM(stp.market_value) AS market_value
FROM jomkas_sportsmanagement_season_team_person_id AS stp
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 60 AND pt.id = 695 AND st.season_id = 13 AND stp.season_id = 13 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data 
SELECT COUNT(*) AS playercnt
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 54 AND pt.id = 618 AND tp.season_id = 11 AND st.season_id = 11 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data 
SELECT ps.birthday, ps.deathday
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 54 AND pt.id = 618 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 jomkas_sportsmanagement_season_team_person_id AS stp
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 54 AND pt.id = 618 AND st.season_id = 11 AND stp.season_id = 11 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data 
SELECT COUNT(*) AS playercnt
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 48 AND pt.id = 511 AND tp.season_id = 9 AND st.season_id = 9 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data 
SELECT ps.birthday, ps.deathday
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 48 AND pt.id = 511 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 jomkas_sportsmanagement_season_team_person_id AS stp
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 48 AND pt.id = 511 AND st.season_id = 9 AND stp.season_id = 9 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data 
SELECT COUNT(*) AS playercnt
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 36 AND pt.id = 417 AND tp.season_id = 8 AND st.season_id = 8 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data 
SELECT ps.birthday, ps.deathday
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 36 AND pt.id = 417 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 jomkas_sportsmanagement_season_team_person_id AS stp
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 36 AND pt.id = 417 AND st.season_id = 8 AND stp.season_id = 8 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data 
SELECT COUNT(*) AS playercnt
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 29 AND pt.id = 376 AND tp.season_id = 7 AND st.season_id = 7 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data 
SELECT ps.birthday, ps.deathday
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 29 AND pt.id = 376 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 jomkas_sportsmanagement_season_team_person_id AS stp
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 29 AND pt.id = 376 AND st.season_id = 7 AND stp.season_id = 7 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data 
SELECT COUNT(*) AS playercnt
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 28 AND pt.id = 367 AND tp.season_id = 7 AND st.season_id = 7 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data 
SELECT ps.birthday, ps.deathday
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 28 AND pt.id = 367 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 jomkas_sportsmanagement_season_team_person_id AS stp
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 28 AND pt.id = 367 AND st.season_id = 7 AND stp.season_id = 7 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data 
SELECT COUNT(*) AS playercnt
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 30 AND pt.id = 317 AND tp.season_id = 7 AND st.season_id = 7 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data 
SELECT ps.birthday, ps.deathday
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 30 AND pt.id = 317 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 jomkas_sportsmanagement_season_team_person_id AS stp
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 30 AND pt.id = 317 AND st.season_id = 7 AND stp.season_id = 7 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data 
SELECT COUNT(*) AS playercnt
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 26 AND pt.id = 248 AND tp.season_id = 6 AND st.season_id = 6 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data 
SELECT ps.birthday, ps.deathday
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 26 AND pt.id = 248 AND tp.season_id = 6 AND st.season_id = 6 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data 
SELECT SUM(stp.market_value) AS market_value
FROM jomkas_sportsmanagement_season_team_person_id AS stp
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 26 AND pt.id = 248 AND st.season_id = 6 AND stp.season_id = 6 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data 
SELECT COUNT(*) AS playercnt
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 17 AND pt.id = 198 AND tp.season_id = 5 AND st.season_id = 5 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data 
SELECT ps.birthday, ps.deathday
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 17 AND pt.id = 198 AND tp.season_id = 5 AND st.season_id = 5 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data 
SELECT SUM(stp.market_value) AS market_value
FROM jomkas_sportsmanagement_season_team_person_id AS stp
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 17 AND pt.id = 198 AND st.season_id = 5 AND stp.season_id = 5 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data 
SELECT COUNT(*) AS playercnt
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 11 AND pt.id = 105 AND tp.season_id = 4 AND st.season_id = 4 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data 
SELECT ps.birthday, ps.deathday
FROM jomkas_sportsmanagement_person AS ps
INNER JOIN jomkas_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 11 AND pt.id = 105 AND tp.season_id = 4 AND st.season_id = 4 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data 
SELECT SUM(stp.market_value) AS market_value
FROM jomkas_sportsmanagement_season_team_person_id AS stp
INNER JOIN jomkas_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN jomkas_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 11 AND pt.id = 105 AND st.season_id = 4 AND stp.season_id = 4 AND stp.published = 1
Fußball Staffel-ID [637400]    

Mannschaftsinfo - FV Eintracht Niesky 2

FV Eintracht Niesky
Adresse: FV Eintracht Niesky,
Fichtestraße 18,
Sachsen,
02906 Niesky,
Deutschland
 
Vereinsname: FV Eintracht Niesky
Vereinswebseite: http://www.fv-eintracht-ny.de/
Mannschaftsname: FV Eintracht Niesky 2
Kurzname: NY2

Zusatzangaben

Erweiterte Optionen

Historie

Saison Liga Ligabild Platz Gespielt Punkte S/U/N Tore Spieler ∅ Alter €
2022/2023 Landskron Oberlausitzliga FV Eintracht Niesky 5 15 22 6/4/5 24:19 0 0 0
2021/2022 Landskron Oberlausitzliga FV Eintracht Niesky 2 8 18 6/0/2 24:9 0 0 0
2020/2021 Landskron Oberlausitzliga FV Eintracht Niesky 4 5 12 4/0/1 14:7 0 0 0
2019/2020 Landskron Oberlausitzliga FV Eintracht Niesky 5 13 20 6/2/5 27:29 0 0 0
2018/2019 Landskron Oberlausitzliga FV Eintracht Niesky 8 30 40 11/7/12 40:51 0 0 0
2017/2018 Landskron Oberlausitzliga FV Eintracht Niesky 7 28 40 11/7/10 51:55 0 0 0
2015/2016 Kreisliga FV Eintracht Niesky 4 30 62 19/5/6 80:50 0 0 0
2013/2014 Kreisliga FV Eintracht Niesky 5 26 43 13/4/9 65:54 0 0 0
2012/2013 Kreisliga FV Eintracht Niesky 7 24 33 10/3/11 45:66 0 0 0
2011/2012 Kreisliga FV Eintracht Niesky 4 1 3 1/0/0 2:1 0 0 0
2011/2012 Kreisliga FV Eintracht Niesky 3 1 3 1/0/0 5:3 0 0 0
2011/2012 Kreisliga FV Eintracht Niesky 7 1 1 0/1/0 1:1 0 0 0
2010/2011 Kreisliga FV Eintracht Niesky 10 1 0 0/0/1 2:3 0 0 0
2009/2010 Kreisliga FV Eintracht Niesky 5 0 0 0/0/0 0:0 0 0 0
2008/2009 1. Kreisklasse FV Eintracht Niesky 7 9 9 3/0/6 12:26 0 0 0

Zusammenfassung Historie nach Liga

Liga Gespielt S/U/N Tore
Landskron Oberlausitzliga 99 44 / 20 / 35 180 : 170
Kreisliga 84 44 / 13 / 27 200 : 178
1. Kreisklasse 9 3 / 0 / 6 12 : 26

Trainingszeiten

Tipp: Keine Trainingszeiten vorhanden!

Wochentag Beginn Ende Ort Hinweis



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