??sportsmanagementModelRoster::getTeamPlayers 328
SELECT pr.firstname,pr.nickname,pr.lastname,pr.country,pr.birthday,pr.deathday,pr.id AS pid,pr.id AS person_id,pr.picture AS ppic,pr.suspension AS suspension,pr.away AS away,pr.injury AS injury,pr.id AS pid,pr.picture AS ppic,CONCAT_WS(':',pr.id,pr.alias) AS person_slug,ppos.position_id as position_id,pos.name AS position,st.id AS season_team_id,pt.project_id AS project_id,pt.id AS projectteam_id,tp.id AS playerid,tp.id AS season_team_person_id,tp.jerseynumber AS position_number,tp.notes AS description,tp.market_value AS market_value,tp.picture
FROM joscw_sportsmanagement_season_team_person_id AS tp
INNER JOIN joscw_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id
INNER JOIN joscw_sportsmanagement_project_team AS pt ON pt.team_id = st.id
INNER JOIN joscw_sportsmanagement_person AS pr ON tp.person_id = pr.id
INNER JOIN joscw_sportsmanagement_project AS pro ON pro.id = pt.project_id and pro.season_id = tp.season_id
INNER JOIN joscw_sportsmanagement_team AS t ON t.id = st.team_id
LEFT JOIN joscw_sportsmanagement_person_project_position AS perpos ON perpos.project_id = pro.id AND perpos.person_id = pr.id
LEFT JOIN joscw_sportsmanagement_project_position AS ppos ON ppos.id = perpos.project_position_id
LEFT JOIN joscw_sportsmanagement_position AS pos ON pos.id = ppos.position_id
WHERE tp.persontype = 1 AND tp.season_id = 10 AND tp.team_id = 24 AND pr.show_on_frontend = 1 AND pro.id = 22
ORDER BY pos.ordering, ppos.position_id, tp.ordering, tp.jerseynumber, pr.lastname, pr.firstname????sportsmanagementModelRoster::getTeamPlayers 329 projectteam
stdClass Object
(
[project_id] => 22
[id] => 280
[season_team_id] => 24
[notes] =>
[picture] =>
)
????sportsmanagementModelRoster::getTeamPlayers 330 players
Array
(
)
????sportsmanagementModelRoster::getTeamPlayers 328
SELECT pr.firstname,pr.nickname,pr.lastname,pr.country,pr.birthday,pr.deathday,pr.id AS pid,pr.id AS person_id,pr.picture AS ppic,pr.suspension AS suspension,pr.away AS away,pr.injury AS injury,pr.id AS pid,pr.picture AS ppic,CONCAT_WS(':',pr.id,pr.alias) AS person_slug,ppos.position_id as position_id,pos.name AS position,st.id AS season_team_id,pt.project_id AS project_id,pt.id AS projectteam_id,tp.id AS playerid,tp.id AS season_team_person_id,tp.jerseynumber AS position_number,tp.notes AS description,tp.market_value AS market_value,tp.picture,posparent.name AS parentname
FROM joscw_sportsmanagement_season_team_person_id AS tp
INNER JOIN joscw_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id
INNER JOIN joscw_sportsmanagement_project_team AS pt ON pt.team_id = st.id
INNER JOIN joscw_sportsmanagement_person AS pr ON tp.person_id = pr.id
INNER JOIN joscw_sportsmanagement_project AS pro ON pro.id = pt.project_id and pro.season_id = tp.season_id
INNER JOIN joscw_sportsmanagement_team AS t ON t.id = st.team_id
LEFT JOIN joscw_sportsmanagement_person_project_position AS perpos ON perpos.project_id = pro.id AND perpos.person_id = pr.id
LEFT JOIN joscw_sportsmanagement_project_position AS ppos ON ppos.id = perpos.project_position_id
LEFT JOIN joscw_sportsmanagement_position AS pos ON pos.id = ppos.position_id
LEFT JOIN joscw_sportsmanagement_position AS posparent ON pos.parent_id = posparent.id
WHERE tp.persontype = 2 AND tp.season_id = 10 AND tp.team_id = 24 AND pr.show_on_frontend = 1 AND pro.id = 22
ORDER BY pos.ordering, ppos.position_id, tp.ordering, tp.jerseynumber, pr.lastname, pr.firstname??
??COM_SPORTSMANAGEMENT_COPYRIGHT?? : ©
Fussball in Europa