Aviso

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,ppos.id as pposid,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 bd_sportsmanagement_season_team_person_id AS tp 
INNER JOIN bd_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id 
INNER JOIN bd_sportsmanagement_project_team AS pt ON pt.team_id = st.id
INNER JOIN bd_sportsmanagement_person AS pr ON tp.person_id = pr.id
INNER JOIN bd_sportsmanagement_project AS pro ON pro.id = pt.project_id and pro.season_id = tp.season_id
INNER JOIN bd_sportsmanagement_team AS t ON t.id = st.team_id
LEFT JOIN bd_sportsmanagement_person_project_position AS perpos ON perpos.project_id = pro.id AND perpos.person_id = pr.id
LEFT JOIN bd_sportsmanagement_project_position AS ppos ON ppos.id = perpos.project_position_id
LEFT JOIN bd_sportsmanagement_position AS pos ON pos.id = ppos.position_id
WHERE tp.persontype = 1 AND tp.season_id = 1 AND tp.team_id = 4 AND pr.show_on_frontend = 1 AND pro.id = 1
ORDER BY pos.ordering, ppos.position_id, tp.ordering, tp.jerseynumber, pr.lastname, pr.firstname

sportsmanagementModelRoster::getTeamPlayers 329 projectteam

stdClass Object
(
    [project_id] => 1
    [id] => 1
    [season_team_id] => 4
    [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,ppos.id as pposid,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 bd_sportsmanagement_season_team_person_id AS tp 
INNER JOIN bd_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id 
INNER JOIN bd_sportsmanagement_project_team AS pt ON pt.team_id = st.id
INNER JOIN bd_sportsmanagement_person AS pr ON tp.person_id = pr.id
INNER JOIN bd_sportsmanagement_project AS pro ON pro.id = pt.project_id and pro.season_id = tp.season_id
INNER JOIN bd_sportsmanagement_team AS t ON t.id = st.team_id
LEFT JOIN bd_sportsmanagement_person_project_position AS perpos ON perpos.project_id = pro.id AND perpos.person_id = pr.id
LEFT JOIN bd_sportsmanagement_project_position AS ppos ON ppos.id = perpos.project_position_id
LEFT JOIN bd_sportsmanagement_position AS pos ON pos.id = ppos.position_id
LEFT JOIN bd_sportsmanagement_position AS posparent ON pos.parent_id = posparent.id
WHERE tp.persontype = 2 AND tp.season_id = 1 AND tp.team_id = 4 AND pr.show_on_frontend = 1 AND pro.id = 1
ORDER BY pos.ordering, ppos.position_id, tp.ordering, tp.jerseynumber, pr.lastname, pr.firstname