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 = 7
ORDER BY s.name DESC
sportsmanagementModelTeamInfo::getSeasons 345 projectteamid
779
sportsmanagementModelTeamInfo::getSeasons 346 teamid
7
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 = 779 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 = 779 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 = 779 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 = 756 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 = 756 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 = 756 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 = 732 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 = 732 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 = 732 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 = 63 AND pt.id = 721 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 = 63 AND pt.id = 721 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 = 63 AND pt.id = 721 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 = 269 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 = 269 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 = 269 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 = 347 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 = 347 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 = 347 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 = 710 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 = 710 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 = 710 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 = 61 AND pt.id = 700 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 = 61 AND pt.id = 700 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 = 61 AND pt.id = 700 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 = 692 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 = 692 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 = 692 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 = 57 AND pt.id = 653 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 = 57 AND pt.id = 653 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 = 57 AND pt.id = 653 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 = 56 AND pt.id = 639 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 = 56 AND pt.id = 639 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 = 56 AND pt.id = 639 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 = 52 AND pt.id = 592 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 = 52 AND pt.id = 592 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 = 52 AND pt.id = 592 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 = 53 AND pt.id = 605 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 = 53 AND pt.id = 605 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 = 53 AND pt.id = 605 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 = 51 AND pt.id = 575 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 = 51 AND pt.id = 575 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 = 51 AND pt.id = 575 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 = 553 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 = 553 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 = 553 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 = 47 AND pt.id = 505 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 = 47 AND pt.id = 505 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 = 47 AND pt.id = 505 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 = 45 AND pt.id = 488 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 = 45 AND pt.id = 488 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 = 45 AND pt.id = 488 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 = 35 AND pt.id = 406 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 = 35 AND pt.id = 406 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 = 35 AND pt.id = 406 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 = 42 AND pt.id = 477 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 = 42 AND pt.id = 477 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 = 42 AND pt.id = 477 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 = 28 AND pt.id = 372 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 = 372 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 = 372 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 = 27 AND pt.id = 330 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 = 27 AND pt.id = 330 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 = 27 AND pt.id = 330 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 = 32 AND pt.id = 389 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 = 32 AND pt.id = 389 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 = 32 AND pt.id = 389 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 = 33 AND pt.id = 313 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 = 33 AND pt.id = 313 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 = 33 AND pt.id = 313 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 = 24 AND pt.id = 295 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 = 24 AND pt.id = 295 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 = 24 AND pt.id = 295 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 = 20 AND pt.id = 235 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 = 20 AND pt.id = 235 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 = 20 AND pt.id = 235 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 = 221 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 = 221 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 = 221 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 = 13 AND pt.id = 169 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 = 13 AND pt.id = 169 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 = 13 AND pt.id = 169 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 = 15 AND pt.id = 143 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 = 143 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 = 143 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 = 5 AND pt.id = 59 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 = 5 AND pt.id = 59 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 = 5 AND pt.id = 59 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 = 3 AND pt.id = 29 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 = 3 AND pt.id = 29 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 = 3 AND pt.id = 29 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 = 1 AND pt.id = 5 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 = 1 AND pt.id = 5 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 = 1 AND pt.id = 5 AND st.season_id = 1 AND stp.season_id = 1 AND stp.published = 1

Warnung

Achtung, ungültige Tabellenauswahl:
Fußball Print    

Mannschaftsinfo - SV Lok Schleife

SV Lok Schleife© [ SV Lok Schleife e.V. ]
Mannschaftsname: SV Lok Schleife
Kurzname: LOK

Historie

Saison Liga Ligabild Platz Gespielt Punkte S/U/N Tore Spieler ∅ Alter
2022/2023 Landskron Oberlausitzliga SV Lok Schleife 2 11 24 8/0/3 37:19 26 28.28 0
2021/2022 Landskron Oberlausitzliga SV Lok Schleife 5 8 13 4/1/3 16:17 26 29.46 0
2020/2021 Landskron Oberlausitzliga SV Lok Schleife 5 6 12 4/0/2 19:13 33 29.03 0
2020/2021 Testspiele SV Lok Schleife 1 5 4 1/1/3 14:14 33 29.03 0
2019/2020 Landskron Oberlausitzliga SV Lok Schleife 6 14 20 5/5/4 27:20 33 29.64 0
2019/2020 Testspiele SV Lok Schleife 1 3 7 2/1/0 14:4 33 29.64 0
2018/2019 Landskron Oberlausitzliga SV Lok Schleife 11 30 33 10/3/17 44:61 33 32.94 0
2018/2019 Testspiele SV Lok Schleife 1 1 3 1/0/0 4:2 33 32.94 0
2017/2018 Landskron Oberlausitzliga SV Lok Schleife 8 28 37 11/4/13 50:52 37 32.84 0
2016/2017 Landskron Oberlausitzliga SV Lok Schleife 8 30 41 12/5/13 55:51 36 34.19 0
2016/2017 Testspiele SV Lok Schleife 3 2 1 0/1/1 5:6 36 34.19 0
2015/2016 Testspiele SV Lok Schleife 1 6 9 3/0/3 15:11 39 35.23 0
2015/2016 Landskron Oberlausitzliga SV Lok Schleife 6 30 45 13/6/11 63:74 39 35.23 0
2014/2015 Landskron Oberlausitzliga SV Lok Schleife 11 30 32 8/8/14 46:51 39 34.82 0
2014/2015 Testspiele SV Lok Schleife 1 5 6 2/0/3 13:14 39 34.82 0
2013/2014 Landskron Oberlausitzliga SV Lok Schleife 10 30 38 11/5/14 52:65 54 37.13 0
2013/2014 Testspiele SV Lok Schleife 1 3 4 1/1/1 6:9 54 37.13 0
2012/2013 Landskron Oberlausitzliga SV Lok Schleife 7 26 44 14/2/10 55:44 34 39.03 0
2012/2013 Testspiele SV Lok Schleife 1 5 7 2/1/2 8:8 34 39.03 0
2011/2012 Kreisliga SV Lok Schleife 5 0 0 0/0/0 0:0 55 35.04 0
2011/2012 Testspiele SV Lok Schleife 1 6 10 3/1/2 19:17 55 35.04 0
2011/2012 Kreisliga SV Lok Schleife 3 1 3 1/0/0 3:1 55 35.04 0
2011/2012 Landskron Oberlausitzliga SV Lok Schleife 7 1 1 0/1/0 2:2 55 35.04 0
2010/2011 Kreisliga SV Lok Schleife 6 8 8 2/2/4 24:58 39 39.38 0
2010/2011 Bezirksklasse SV Lok Schleife 5 1 3 1/0/0 1:0 39 39.38 0
2010/2011 Testspiele SV Lok Schleife 1 6 10 3/1/2 6:6 39 39.38 0
2009/2010 Bezirksklasse SV Lok Schleife 11 1 0 0/0/1 0:1 40 39.38 0
2009/2010 Testspiele SV Lok Schleife 1 1 1 0/1/0 1:1 40 39.38 0
2008/2009 Bezirksklasse SV Lok Schleife 3 1 3 1/0/0 4:1 34 39.76 0
2007/2008 Bezirksklasse SV Lok Schleife 6 1 3 1/0/0 1:0 30 40.43 0
2006/2007 Bezirksklasse SV Lok Schleife 9 30 39 10/9/11 51:66 0 0 0

Zusammenfassung Historie nach Liga

Liga Gespielt S/U/N Tore
Landskron Oberlausitzliga 244 100 / 40 / 104 466 : 469
Testspiele 43 18 / 8 / 17 105 : 92
Kreisliga 9 3 / 2 / 4 27 : 59
Bezirksklasse 34 13 / 9 / 12 57 : 68

Trainingszeiten

Wochentag Beginn Ende Ort Hinweis
Dienstag 18:00 20:00 Sportplatz am Jahring *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



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