sportsmanagementModelTeamInfo::getSeasons 344 data
SELECT pt.id as ptid, pt.team_id as season_team_id, pt.picture, pt.info, pt.project_id AS projectid,pt.points_finally,pt.neg_points_finally,pt.finaltablerank,pt.champion,pt.matches_finally,pt.won_finally,pt.draws_finally,pt.lost_finally,pt.homegoals_finally,pt.guestgoals_finally,p.name as projectname,p.season_id,p.current_round, pt.division_id,s.name as season,t.id as team_id,st.picture as season_picture,l.name as league, t.extended as teamextended, l.country as leaguecountry,CONCAT_WS( ':', p.id, p.alias ) AS project_slug,CONCAT_WS( ':', t.id, t.alias ) AS team_slug
FROM joom3_sportsmanagement_project_team AS pt
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.id = pt.team_id
INNER JOIN joom3_sportsmanagement_team AS t ON t.id = st.team_id
INNER JOIN joom3_sportsmanagement_project AS p ON p.id = pt.project_id
INNER JOIN joom3_sportsmanagement_season AS s ON s.id = p.season_id
INNER JOIN joom3_sportsmanagement_league AS l ON l.id = p.league_id
WHERE t.id = 2
ORDER BY s.name DESC
sportsmanagementModelTeamInfo::getSeasons 345 projectteamid
1201
sportsmanagementModelTeamInfo::getSeasons 346 teamid
2
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 93 AND pt.id = 1201 AND tp.season_id = 30 AND st.season_id = 30 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 93 AND pt.id = 1201 AND tp.season_id = 30 AND st.season_id = 30 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 93 AND pt.id = 1201 AND st.season_id = 30 AND stp.season_id = 30 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 97 AND pt.id = 1218 AND tp.season_id = 29 AND st.season_id = 29 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 97 AND pt.id = 1218 AND tp.season_id = 29 AND st.season_id = 29 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 97 AND pt.id = 1218 AND st.season_id = 29 AND stp.season_id = 29 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 89 AND pt.id = 1133 AND tp.season_id = 28 AND st.season_id = 28 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 89 AND pt.id = 1133 AND tp.season_id = 28 AND st.season_id = 28 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 89 AND pt.id = 1133 AND st.season_id = 28 AND stp.season_id = 28 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 90 AND pt.id = 1152 AND tp.season_id = 28 AND st.season_id = 28 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 90 AND pt.id = 1152 AND tp.season_id = 28 AND st.season_id = 28 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 90 AND pt.id = 1152 AND st.season_id = 28 AND stp.season_id = 28 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 71 AND pt.id = 867 AND tp.season_id = 27 AND st.season_id = 27 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 71 AND pt.id = 867 AND tp.season_id = 27 AND st.season_id = 27 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 71 AND pt.id = 867 AND st.season_id = 27 AND stp.season_id = 27 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 72 AND pt.id = 881 AND tp.season_id = 27 AND st.season_id = 27 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 72 AND pt.id = 881 AND tp.season_id = 27 AND st.season_id = 27 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 72 AND pt.id = 881 AND st.season_id = 27 AND stp.season_id = 27 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 69 AND pt.id = 851 AND tp.season_id = 26 AND st.season_id = 26 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 69 AND pt.id = 851 AND tp.season_id = 26 AND st.season_id = 26 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 69 AND pt.id = 851 AND st.season_id = 26 AND stp.season_id = 26 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 68 AND pt.id = 847 AND tp.season_id = 26 AND st.season_id = 26 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 68 AND pt.id = 847 AND tp.season_id = 26 AND st.season_id = 26 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 68 AND pt.id = 847 AND st.season_id = 26 AND stp.season_id = 26 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 77 AND pt.id = 941 AND tp.season_id = 25 AND st.season_id = 25 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 77 AND pt.id = 941 AND tp.season_id = 25 AND st.season_id = 25 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 77 AND pt.id = 941 AND st.season_id = 25 AND stp.season_id = 25 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 63 AND pt.id = 777 AND tp.season_id = 25 AND st.season_id = 25 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 63 AND pt.id = 777 AND tp.season_id = 25 AND st.season_id = 25 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 63 AND pt.id = 777 AND st.season_id = 25 AND stp.season_id = 25 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 58 AND pt.id = 724 AND tp.season_id = 24 AND st.season_id = 24 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 58 AND pt.id = 724 AND tp.season_id = 24 AND st.season_id = 24 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 58 AND pt.id = 724 AND st.season_id = 24 AND stp.season_id = 24 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 59 AND pt.id = 732 AND tp.season_id = 24 AND st.season_id = 24 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 59 AND pt.id = 732 AND tp.season_id = 24 AND st.season_id = 24 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 59 AND pt.id = 732 AND st.season_id = 24 AND stp.season_id = 24 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 47 AND pt.id = 583 AND tp.season_id = 14 AND st.season_id = 14 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 47 AND pt.id = 583 AND tp.season_id = 14 AND st.season_id = 14 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 47 AND pt.id = 583 AND st.season_id = 14 AND stp.season_id = 14 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 50 AND pt.id = 603 AND tp.season_id = 14 AND st.season_id = 14 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 50 AND pt.id = 603 AND tp.season_id = 14 AND st.season_id = 14 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 50 AND pt.id = 603 AND st.season_id = 14 AND stp.season_id = 14 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 48 AND pt.id = 592 AND tp.season_id = 14 AND st.season_id = 14 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 48 AND pt.id = 592 AND tp.season_id = 14 AND st.season_id = 14 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 48 AND pt.id = 592 AND st.season_id = 14 AND stp.season_id = 14 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 37 AND pt.id = 492 AND tp.season_id = 11 AND st.season_id = 11 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 37 AND pt.id = 492 AND tp.season_id = 11 AND st.season_id = 11 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 37 AND pt.id = 492 AND st.season_id = 11 AND stp.season_id = 11 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 36 AND pt.id = 507 AND tp.season_id = 11 AND st.season_id = 11 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 36 AND pt.id = 507 AND tp.season_id = 11 AND st.season_id = 11 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 36 AND pt.id = 507 AND st.season_id = 11 AND stp.season_id = 11 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 34 AND pt.id = 477 AND tp.season_id = 9 AND st.season_id = 9 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 34 AND pt.id = 477 AND tp.season_id = 9 AND st.season_id = 9 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 34 AND pt.id = 477 AND st.season_id = 9 AND stp.season_id = 9 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 78 AND pt.id = 957 AND tp.season_id = 9 AND st.season_id = 9 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 78 AND pt.id = 957 AND tp.season_id = 9 AND st.season_id = 9 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 78 AND pt.id = 957 AND st.season_id = 9 AND stp.season_id = 9 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 29 AND pt.id = 423 AND tp.season_id = 8 AND st.season_id = 8 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 29 AND pt.id = 423 AND tp.season_id = 8 AND st.season_id = 8 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 29 AND pt.id = 423 AND st.season_id = 8 AND stp.season_id = 8 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 28 AND pt.id = 413 AND tp.season_id = 8 AND st.season_id = 8 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 28 AND pt.id = 413 AND tp.season_id = 8 AND st.season_id = 8 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 28 AND pt.id = 413 AND st.season_id = 8 AND stp.season_id = 8 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 19 AND pt.id = 311 AND tp.season_id = 7 AND st.season_id = 7 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 19 AND pt.id = 311 AND tp.season_id = 7 AND st.season_id = 7 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 19 AND pt.id = 311 AND st.season_id = 7 AND stp.season_id = 7 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 20 AND pt.id = 290 AND tp.season_id = 7 AND st.season_id = 7 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 20 AND pt.id = 290 AND tp.season_id = 7 AND st.season_id = 7 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 20 AND pt.id = 290 AND st.season_id = 7 AND stp.season_id = 7 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 79 AND pt.id = 973 AND tp.season_id = 1 AND st.season_id = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 79 AND pt.id = 973 AND tp.season_id = 1 AND st.season_id = 1 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 79 AND pt.id = 973 AND st.season_id = 1 AND stp.season_id = 1 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 5 AND pt.id = 61 AND tp.season_id = 1 AND st.season_id = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 5 AND pt.id = 61 AND tp.season_id = 1 AND st.season_id = 1 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 5 AND pt.id = 61 AND st.season_id = 1 AND stp.season_id = 1 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 13 AND pt.id = 148 AND tp.season_id = 2 AND st.season_id = 2 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 13 AND pt.id = 148 AND tp.season_id = 2 AND st.season_id = 2 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 13 AND pt.id = 148 AND st.season_id = 2 AND stp.season_id = 2 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 80 AND pt.id = 990 AND tp.season_id = 2 AND st.season_id = 2 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 80 AND pt.id = 990 AND tp.season_id = 2 AND st.season_id = 2 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 80 AND pt.id = 990 AND st.season_id = 2 AND stp.season_id = 2 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 43 AND pt.id = 560 AND tp.season_id = 3 AND st.season_id = 3 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 43 AND pt.id = 560 AND tp.season_id = 3 AND st.season_id = 3 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 43 AND pt.id = 560 AND st.season_id = 3 AND stp.season_id = 3 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 14 AND pt.id = 172 AND tp.season_id = 3 AND st.season_id = 3 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 14 AND pt.id = 172 AND tp.season_id = 3 AND st.season_id = 3 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 14 AND pt.id = 172 AND st.season_id = 3 AND stp.season_id = 3 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 81 AND pt.id = 1018 AND tp.season_id = 3 AND st.season_id = 3 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 81 AND pt.id = 1018 AND tp.season_id = 3 AND st.season_id = 3 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 81 AND pt.id = 1018 AND st.season_id = 3 AND stp.season_id = 3 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 82 AND pt.id = 1034 AND tp.season_id = 3 AND st.season_id = 3 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 82 AND pt.id = 1034 AND tp.season_id = 3 AND st.season_id = 3 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 82 AND pt.id = 1034 AND st.season_id = 3 AND stp.season_id = 3 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 83 AND pt.id = 1055 AND tp.season_id = 4 AND st.season_id = 4 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 83 AND pt.id = 1055 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 joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 83 AND pt.id = 1055 AND st.season_id = 4 AND stp.season_id = 4 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 41 AND pt.id = 537 AND tp.season_id = 4 AND st.season_id = 4 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 41 AND pt.id = 537 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 joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 41 AND pt.id = 537 AND st.season_id = 4 AND stp.season_id = 4 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 84 AND pt.id = 1081 AND tp.season_id = 6 AND st.season_id = 6 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 84 AND pt.id = 1081 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 joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 84 AND pt.id = 1081 AND st.season_id = 6 AND stp.season_id = 6 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 40 AND pt.id = 533 AND tp.season_id = 6 AND st.season_id = 6 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 40 AND pt.id = 533 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 joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 40 AND pt.id = 533 AND st.season_id = 6 AND stp.season_id = 6 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 17 AND pt.id = 236 AND tp.season_id = 5 AND st.season_id = 5 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 17 AND pt.id = 236 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 joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 17 AND pt.id = 236 AND st.season_id = 5 AND stp.season_id = 5 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 88 AND pt.id = 1130 AND tp.season_id = 5 AND st.season_id = 5 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 88 AND pt.id = 1130 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 joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 88 AND pt.id = 1130 AND st.season_id = 5 AND stp.season_id = 5 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 85 AND pt.id = 1090 AND tp.season_id = 10 AND st.season_id = 10 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 85 AND pt.id = 1090 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 joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 85 AND pt.id = 1090 AND st.season_id = 10 AND stp.season_id = 10 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 44 AND pt.id = 562 AND tp.season_id = 12 AND st.season_id = 12 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 44 AND pt.id = 562 AND tp.season_id = 12 AND st.season_id = 12 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 44 AND pt.id = 562 AND st.season_id = 12 AND stp.season_id = 12 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 42 AND pt.id = 542 AND tp.season_id = 12 AND st.season_id = 12 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 42 AND pt.id = 542 AND tp.season_id = 12 AND st.season_id = 12 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 42 AND pt.id = 542 AND st.season_id = 12 AND stp.season_id = 12 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 46 AND pt.id = 581 AND tp.season_id = 13 AND st.season_id = 13 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 46 AND pt.id = 581 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 joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 46 AND pt.id = 581 AND st.season_id = 13 AND stp.season_id = 13 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 45 AND pt.id = 564 AND tp.season_id = 13 AND st.season_id = 13 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 45 AND pt.id = 564 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 joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 45 AND pt.id = 564 AND st.season_id = 13 AND stp.season_id = 13 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 52 AND pt.id = 649 AND tp.season_id = 15 AND st.season_id = 15 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 52 AND pt.id = 649 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 joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 52 AND pt.id = 649 AND st.season_id = 15 AND stp.season_id = 15 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 53 AND pt.id = 665 AND tp.season_id = 16 AND st.season_id = 16 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 53 AND pt.id = 665 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 joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 53 AND pt.id = 665 AND st.season_id = 16 AND stp.season_id = 16 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 51 AND pt.id = 631 AND tp.season_id = 18 AND st.season_id = 18 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 51 AND pt.id = 631 AND tp.season_id = 18 AND st.season_id = 18 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 51 AND pt.id = 631 AND st.season_id = 18 AND stp.season_id = 18 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 54 AND pt.id = 673 AND tp.season_id = 19 AND st.season_id = 19 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 54 AND pt.id = 673 AND tp.season_id = 19 AND st.season_id = 19 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 54 AND pt.id = 673 AND st.season_id = 19 AND stp.season_id = 19 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 55 AND pt.id = 699 AND tp.season_id = 20 AND st.season_id = 20 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 55 AND pt.id = 699 AND tp.season_id = 20 AND st.season_id = 20 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 55 AND pt.id = 699 AND st.season_id = 20 AND stp.season_id = 20 AND stp.published = 1
sportsmanagementModelTeamInfo::getPlayerCount 551 data
SELECT COUNT(*) AS playercnt
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 56 AND pt.id = 704 AND tp.season_id = 21 AND st.season_id = 21 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMeanAge 598 data
SELECT ps.birthday, ps.deathday
FROM joom3_sportsmanagement_person AS ps
INNER JOIN joom3_sportsmanagement_season_team_person_id AS tp ON tp.person_id = ps.id
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id AND st.season_id = tp.season_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON st.id = pt.team_id
WHERE pt.project_id = 56 AND pt.id = 704 AND tp.season_id = 21 AND st.season_id = 21 AND tp.published = 1 AND ps.published = 1
sportsmanagementModelTeamInfo::getPlayerMarketValue 658 data
SELECT SUM(stp.market_value) AS market_value
FROM joom3_sportsmanagement_season_team_person_id AS stp
INNER JOIN joom3_sportsmanagement_season_team_id AS st ON st.team_id = stp.team_id
INNER JOIN joom3_sportsmanagement_project_team AS pt ON pt.team_id = st.id
WHERE pt.project_id = 56 AND pt.id = 704 AND st.season_id = 21 AND stp.season_id = 21 AND stp.published = 1