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 = 11
ORDER BY s.name DESC
sportsmanagementModelTeamInfo::getSeasons 345 projectteamid 
796
sportsmanagementModelTeamInfo::getSeasons 346 teamid 
11
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 = 69 AND pt.id = 796 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 = 69 AND pt.id = 796 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 = 69 AND pt.id = 796 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 = 67 AND pt.id = 767 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 = 67 AND pt.id = 767 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 = 67 AND pt.id = 767 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 = 64 AND pt.id = 748 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 = 64 AND pt.id = 748 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 = 64 AND pt.id = 748 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 = 44 AND pt.id = 345 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 = 44 AND pt.id = 345 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 = 44 AND pt.id = 345 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 = 21 AND pt.id = 350 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 = 21 AND pt.id = 350 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 = 21 AND pt.id = 350 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 = 16 AND pt.id = 191 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 = 16 AND pt.id = 191 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 = 16 AND pt.id = 191 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 = 59 AND pt.id = 672 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 = 59 AND pt.id = 672 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 = 59 AND pt.id = 672 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 = 58 AND pt.id = 661 AND tp.season_id = 12 AND st.season_id = 12 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 = 58 AND pt.id = 661 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 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 = 58 AND pt.id = 661 AND st.season_id = 12 AND stp.season_id = 12 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 = 611 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 = 611 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 = 611 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 = 46 AND pt.id = 559 AND tp.season_id = 10 AND st.season_id = 10 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 = 46 AND pt.id = 559 AND tp.season_id = 10 AND st.season_id = 10 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 = 46 AND pt.id = 559 AND st.season_id = 10 AND stp.season_id = 10 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 = 50 AND pt.id = 587 AND tp.season_id = 10 AND st.season_id = 10 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 = 50 AND pt.id = 587 AND tp.season_id = 10 AND st.season_id = 10 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 = 50 AND pt.id = 587 AND st.season_id = 10 AND stp.season_id = 10 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 = 550 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 = 550 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 = 550 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 = 424 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 = 424 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 = 424 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 = 30 AND pt.id = 324 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 = 324 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 = 324 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 = 256 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 = 256 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 = 256 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 = 22 AND pt.id = 225 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 = 22 AND pt.id = 225 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 = 22 AND pt.id = 225 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 = 15 AND pt.id = 144 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 = 15 AND pt.id = 144 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 = 15 AND pt.id = 144 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 = 14 AND pt.id = 173 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 = 14 AND pt.id = 173 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 = 14 AND pt.id = 173 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 = 12 AND pt.id = 141 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 = 12 AND pt.id = 141 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 = 12 AND pt.id = 141 AND st.season_id = 4 AND stp.season_id = 4 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 = 6 AND pt.id = 74 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 = 6 AND pt.id = 74 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 = 6 AND pt.id = 74 AND st.season_id = 4 AND stp.season_id = 4 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 = 4 AND pt.id = 50 AND tp.season_id = 2 AND st.season_id = 2 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 = 4 AND pt.id = 50 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 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 = 4 AND pt.id = 50 AND st.season_id = 2 AND stp.season_id = 2 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 = 2 AND pt.id = 33 AND tp.season_id = 1 AND st.season_id = 1 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 = 2 AND pt.id = 33 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 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 = 2 AND pt.id = 33 AND st.season_id = 1 AND stp.season_id = 1 AND stp.published = 1
×

Warnung

Achtung, ungültige Tabellenauswahl:
Fußball Kreisklasse Staffel 1 22/23 Print    

Mannschaftsinfo - SV Lok Schleife 2.

SV Lok Schleife© [ SV Lok Schleife e.V. ]
Adresse: SV Lok Schleife,
Jahnring 15,
Sachsen,
02959 Schleife,
Deutschland
 
eMail: Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!
Vereinsname: SV Lok Schleife
Vereinswebseite: http://www.svlokschleife.de/
Mannschaftsname: SV Lok Schleife 2.
Kurzname: LOK

Zusatzangaben

Erweiterte Optionen

Historie

Saison Liga Ligabild Platz Gespielt Punkte S/U/N Tore Spieler ∅ Alter €
2022/2023 1. Kreisklasse SV Lok Schleife 4 16 26 8/2/6 41:27 30 30.64 0
2021/2022 1. Kreisklasse SV Lok Schleife 2 8 14 4/2/2 26:17 34 29.23 0
2020/2021 1. Kreisklasse SV Lok Schleife 1 7 17 5/2/0 26:13 40 29.85 0
2019/2020 1. Kreisklasse SV Lok Schleife 4 12 18 5/3/4 32:26 49 34.29 0
2019/2020 Testspiele SV Lok Schleife 6 1 0 0/0/1 1:9 49 34.29 0
2018/2019 1. Kreisklasse SV Lok Schleife 4 22 38 11/5/6 74:48 44 34.59 0
2017/2018 1. Kreisklasse SV Lok Schleife 9 24 28 7/7/10 52:59 51 35.37 0
2016/2017 1. Kreisklasse SV Lok Schleife 12 1 0 0/0/1 0:2 41 33.73 0
2015/2016 Kreisliga SV Lok Schleife 15 30 20 5/5/20 28:91 50 35.96 0
2014/2015 Kreisliga SV Lok Schleife 2 26 45 13/6/7 47:40 43 36.37 0
2014/2015 Testspiele SV Lok Schleife 5 0 0 0/0/0 0:0 43 36.37 0
2013/2014 Kreisliga SV Lok Schleife 13 26 21 6/3/17 31:69 45 38.44 0
2012/2013 Kreisliga SV Lok Schleife 12 24 23 7/2/15 39:82 36 40.11 0
2011/2012 Kreisliga SV Lok Schleife 1 1 3 1/0/0 4:0 34 40 0
2010/2011 Kreisliga SV Lok Schleife 11 1 0 0/0/1 1:3 40 39.78 0
2010/2011 Testspiele SV Lok Schleife 5 2 3 1/0/1 5:5 40 39.78 0
2009/2010 Testspiele SV Lok Schleife 3 0 0 0/0/0 0:0 37 40.35 0
2009/2010 1. Kreisklasse SV Lok Schleife 1 1 3 1/0/0 5:0 37 40.35 0
2008/2009 Pokal SV Lok Schleife 11 2 3 1/0/1 4:6 42 39.07 0
2008/2009 1. Kreisklasse SV Lok Schleife 12 1 0 0/0/1 2:5 42 39.07 0
2007/2008 1. Kreisklasse SV Lok Schleife 10 1 0 0/0/1 0:6 28 38.86 0
2006/2007 1. Kreisklasse SV Lok Schleife 12 1 0 0/0/1 0:2 0 0 0

Zusammenfassung Historie nach Liga

Liga Gespielt S/U/N Tore
1. Kreisklasse 94 41 / 21 / 32 258 : 205
Testspiele 3 1 / 0 / 2 6 : 14
Kreisliga 108 32 / 16 / 60 150 : 285
Pokal 2 1 / 0 / 1 4 : 6

Trainingszeiten

Wochentag Beginn Ende Ort Hinweis
Dienstag 18:00 20:00 Sportplatz am Jahnring *1
Freitag 18:00 20:00 Sportplatz am Jahnring *2
*1 Bei schlechtem Wetter und im Winter auf dem Schulkomplex
*2 Bei schlechtem Wetter und im Winter auf dem Schulkomplex


Zurück

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