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 = 2 AND tp.team_id = 11 AND pr.show_on_frontend = 1 AND pro.id = 2 ORDER BY pos.ordering, ppos.position_id, tp.ordering, tp.jerseynumber, pr.lastname, pr.firstname
sportsmanagementModelRoster::getTeamPlayers 329 projectteam
stdClass Object ( [project_id] => 2 [id] => 16 [season_team_id] => 11 [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 = 2 AND tp.team_id = 11 AND pr.show_on_frontend = 1 AND pro.id = 2 ORDER BY pos.ordering, ppos.position_id, tp.ordering, tp.jerseynumber, pr.lastname, pr.firstname
Roster - Pedreiros HC [PED] |
A component for many sports!
![](/components/com_sportsmanagement/assets/images/fussballineuropa.png)
Version : 4.21.00 (diddipoeler)
Page load time: [ 0.025234 ] seconds