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