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 z2o57_sportsmanagement_season_team_person_id AS tp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
INNER JOIN z2o57_sportsmanagement_person AS pr ON tp.person_id = pr.id
INNER JOIN z2o57_sportsmanagement_project AS pro ON pro.id = pt.project_id and pro.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_team AS t ON t.id = st.team_id
LEFT JOIN z2o57_sportsmanagement_person_project_position AS perpos ON perpos.project_id = pro.id AND perpos.person_id = pr.id
LEFT JOIN z2o57_sportsmanagement_project_position AS ppos ON ppos.id = perpos.project_position_id
LEFT JOIN z2o57_sportsmanagement_position AS pos ON pos.id = ppos.position_id
WHERE tp.persontype = 1 AND tp.season_id = 85 AND tp.team_id = 3661 AND pr.show_on_frontend = 1 AND pro.id = 3240
ORDER BY pos.ordering, ppos.position_id, tp.ordering, tp.jerseynumber, pr.lastname, pr.firstname
sportsmanagementModelRoster::getTeamPlayers 329 projectteam
stdClass Object
(
[project_id] => 3240
[id] => 43667
[season_team_id] => 3661
[notes] =>
[picture] => images/com_sportsmanagement/database/placeholders/placeholder_450_3.png
)
sportsmanagementModelRoster::getTeamPlayers 330 players
Array
(
[0] => stdClass Object
(
[firstname] => Michael
[nickname] => Kauti
[lastname] => Kautschitz
[country] => AUT
[birthday] => 1986-06-11
[deathday] => 0000-00-00
[pid] => 646
[person_id] => 646
[ppic] => images/com_sportsmanagement/database/persons/m-kautschitz.jpg
[suspension] => 0
[away] => 0
[injury] => 0
[person_slug] => 646:michael-kautschitz
[position_id] => 196
[pposid] => 11669
[position] => COM_SPORTSMANAGEMENT_SOCCER_P_GOALKEEPER
[season_team_id] => 29535
[project_id] => 3240
[projectteam_id] => 43667
[playerid] => 531
[season_team_person_id] => 531
[position_number] => 1
[description] =>
[market_value] => 0
[picture] => images/com_sportsmanagement/database/persons/m-kautschitz.jpg
)
[1] => stdClass Object
(
[firstname] => Marco
[nickname] =>
[lastname] => Hopf
[country] => AUT
[birthday] => 0000-00-00
[deathday] => 0000-00-00
[pid] => 811
[person_id] => 811
[ppic] => images/com_sportsmanagement/database/persons/670725461856634215_751996739128362653-0-110-mwxdeq0v_1423085665.jpg
[suspension] => 0
[away] => 0
[injury] => 0
[person_slug] => 811:marco-hopf
[position_id] => 196
[pposid] => 11669
[position] => COM_SPORTSMANAGEMENT_SOCCER_P_GOALKEEPER
[season_team_id] => 29535
[project_id] => 3240
[projectteam_id] => 43667
[playerid] => 530
[season_team_person_id] => 530
[position_number] => 5
[description] =>
[market_value] => 0
[picture] => images/com_sportsmanagement/database/persons/670725461856634215_751996739128362653-0-110-mwxdeq0v_1423085665.jpg
)
[2] => stdClass Object
(
[firstname] => Andreas
[nickname] =>
[lastname] => Stocker
[country] => AUT
[birthday] => 0000-00-00
[deathday] => 0000-00-00
[pid] => 824
[person_id] => 824
[ppic] => images/com_sportsmanagement/database/persons/a-stocker.jpg
[suspension] => 0
[away] => 0
[injury] => 0
[person_slug] => 824:andreas-stocker
[position_id] => 197
[pposid] => 11670
[position] => COM_SPORTSMANAGEMENT_SOCCER_P_DEFENDER
[season_team_id] => 29535
[project_id] => 3240
[projectteam_id] => 43667
[playerid] => 542
[season_team_person_id] => 542
[position_number] => 4
[description] =>
[market_value] => 0
[picture] => images/com_sportsmanagement/database/persons/a-stocker.jpg
)
[3] => stdClass Object
(
[firstname] => Michael
[nickname] =>
[lastname] => Wolf
[country] => AUT
[birthday] => 1987-07-27
[deathday] => 0000-00-00
[pid] => 645
[person_id] => 645
[ppic] => images/com_sportsmanagement/database/persons/m-wolf.jpg
[suspension] => 0
[away] => 0
[injury] => 0
[person_slug] => 645:michael-wolf
[position_id] => 197
[pposid] => 11670
[position] => COM_SPORTSMANAGEMENT_SOCCER_P_DEFENDER
[season_team_id] => 29535
[project_id] => 3240
[projectteam_id] => 43667
[playerid] => 538
[season_team_person_id] => 538
[position_number] => 8
[description] =>
[market_value] => 0
[picture] => images/com_sportsmanagement/database/persons/m-wolf.jpg
)
[4] => stdClass Object
(
[firstname] => Mario
[nickname] =>
[lastname] => Mucek
[country] => AUT
[birthday] => 1986-06-03
[deathday] => 0000-00-00
[pid] => 650
[person_id] => 650
[ppic] => images/com_sportsmanagement/database/persons/m-mucek.jpg
[suspension] => 0
[away] => 0
[injury] => 0
[person_slug] => 650:mario-mucek
[position_id] => 197
[pposid] => 11670
[position] => COM_SPORTSMANAGEMENT_SOCCER_P_DEFENDER
[season_team_id] => 29535
[project_id] => 3240
[projectteam_id] => 43667
[playerid] => 532
[season_team_person_id] => 532
[position_number] => 13
[description] =>
[market_value] => 0
[picture] => images/com_sportsmanagement/database/persons/m-mucek.jpg
)
[5] => stdClass Object
(
[firstname] => Patrick
[nickname] =>
[lastname] => Berner
[country] => AUT
[birthday] => 0000-00-00
[deathday] => 0000-00-00
[pid] => 822
[person_id] => 822
[ppic] => images/com_sportsmanagement/database/persons/p-berner.jpg
[suspension] => 0
[away] => 0
[injury] => 0
[person_slug] => 822:patrick-berner
[position_id] => 197
[pposid] => 11670
[position] => COM_SPORTSMANAGEMENT_SOCCER_P_DEFENDER
[season_team_id] => 29535
[project_id] => 3240
[projectteam_id] => 43667
[playerid] => 549
[season_team_person_id] => 549
[position_number] => 15
[description] =>
[market_value] => 0
[picture] => images/com_sportsmanagement/database/persons/p-berner.jpg
)
[6] => stdClass Object
(
[firstname] => Titus
[nickname] =>
[lastname] => Dragu
[country] => ROU
[birthday] => 0000-00-00
[deathday] => 0000-00-00
[pid] => 827
[person_id] => 827
[ppic] => images/com_sportsmanagement/database/persons/t-dragu.jpg
[suspension] => 0
[away] => 0
[injury] => 0
[person_slug] => 827:titus-dragu
[position_id] => 197
[pposid] => 11670
[position] => COM_SPORTSMANAGEMENT_SOCCER_P_DEFENDER
[season_team_id] => 29535
[project_id] => 3240
[projectteam_id] => 43667
[playerid] => 545
[season_team_person_id] => 545
[position_number] => 16
[description] =>
[market_value] => 0
[picture] => images/com_sportsmanagement/database/persons/t-dragu.jpg
)
[7] => stdClass Object
(
[firstname] => Manuel
[nickname] =>
[lastname] => Spitzer
[country] => AUT
[birthday] => 1992-03-08
[deathday] => 0000-00-00
[pid] => 654
[person_id] => 654
[ppic] => images/com_sportsmanagement/database/persons/m-spitzer.jpg
[suspension] => 0
[away] => 0
[injury] => 0
[person_slug] => 654:manuel-spitzer
[position_id] => 197
[pposid] => 11670
[position] => COM_SPORTSMANAGEMENT_SOCCER_P_DEFENDER
[season_team_id] => 29535
[project_id] => 3240
[projectteam_id] => 43667
[playerid] => 535
[season_team_person_id] => 535
[position_number] => 17
[description] =>
[market_value] => 0
[picture] => images/com_sportsmanagement/database/persons/m-spitzer.jpg
)
[8] => stdClass Object
(
[firstname] => Dominik
[nickname] =>
[lastname] => Wenninger
[country] => AUT
[birthday] => 0000-00-00
[deathday] => 0000-00-00
[pid] => 828
[person_id] => 828
[ppic] => images/com_sportsmanagement/database/persons/d-wenninger.jpg
[suspension] => 0
[away] => 0
[injury] => 0
[person_slug] => 828:dominik-wenninger
[position_id] => 198
[pposid] => 11671
[position] => COM_SPORTSMANAGEMENT_SOCCER_P_MIDFIELDER
[season_team_id] => 29535
[project_id] => 3240
[projectteam_id] => 43667
[playerid] => 546
[season_team_person_id] => 546
[position_number] => 5
[description] =>
[market_value] => 0
[picture] => images/com_sportsmanagement/database/persons/d-wenninger.jpg
)
[9] => stdClass Object
(
[firstname] => David
[nickname] =>
[lastname] => Leeb
[country] => AUT
[birthday] => 0000-00-00
[deathday] => 0000-00-00
[pid] => 825
[person_id] => 825
[ppic] => images/com_sportsmanagement/database/persons/d-leeb.jpg
[suspension] => 0
[away] => 0
[injury] => 0
[person_slug] => 825:david-leeb
[position_id] => 198
[pposid] => 11671
[position] => COM_SPORTSMANAGEMENT_SOCCER_P_MIDFIELDER
[season_team_id] => 29535
[project_id] => 3240
[projectteam_id] => 43667
[playerid] => 543
[season_team_person_id] => 543
[position_number] => 6
[description] =>
[market_value] => 0
[picture] => images/com_sportsmanagement/database/persons/d-leeb.jpg
)
[10] => stdClass Object
(
[firstname] => Christian
[nickname] =>
[lastname] => Zachorjansky
[country] => AUT
[birthday] => 1990-01-28
[deathday] => 0000-00-00
[pid] => 634
[person_id] => 634
[ppic] => images/com_sportsmanagement/database/persons/c-zac_1437780904.jpg
[suspension] => 0
[away] => 0
[injury] => 0
[person_slug] => 634:christian-zachorjansky
[position_id] => 198
[pposid] => 11671
[position] => COM_SPORTSMANAGEMENT_SOCCER_P_MIDFIELDER
[season_team_id] => 29535
[project_id] => 3240
[projectteam_id] => 43667
[playerid] => 539
[season_team_person_id] => 539
[position_number] => 7
[description] =>
[market_value] => 0
[picture] => images/com_sportsmanagement/database/persons/c-zac_1437780904.jpg
)
[11] => stdClass Object
(
[firstname] => Michael
[nickname] =>
[lastname] => Wenninger
[country] => AUT
[birthday] => 1996-11-05
[deathday] => 0000-00-00
[pid] => 657
[person_id] => 657
[ppic] => images/com_sportsmanagement/database/persons/m-wenninger.jpg
[suspension] => 0
[away] => 0
[injury] => 0
[person_slug] => 657:michael-wenninger
[position_id] => 198
[pposid] => 11671
[position] => COM_SPORTSMANAGEMENT_SOCCER_P_MIDFIELDER
[season_team_id] => 29535
[project_id] => 3240
[projectteam_id] => 43667
[playerid] => 537
[season_team_person_id] => 537
[position_number] => 9
[description] =>
[market_value] => 0
[picture] => images/com_sportsmanagement/database/persons/m-wenninger.jpg
)
[12] => stdClass Object
(
[firstname] => Claudio
[nickname] =>
[lastname] => Früstük
[country] => AUT
[birthday] => 0000-00-00
[deathday] => 0000-00-00
[pid] => 826
[person_id] => 826
[ppic] => images/com_sportsmanagement/database/persons/c-frstck.jpg
[suspension] => 0
[away] => 0
[injury] => 0
[person_slug] => 826:claudio-fruestuek
[position_id] => 198
[pposid] => 11671
[position] => COM_SPORTSMANAGEMENT_SOCCER_P_MIDFIELDER
[season_team_id] => 29535
[project_id] => 3240
[projectteam_id] => 43667
[playerid] => 544
[season_team_person_id] => 544
[position_number] => 10
[description] =>
[market_value] => 0
[picture] => images/com_sportsmanagement/database/persons/c-frstck.jpg
)
[13] => stdClass Object
(
[firstname] => Kevin
[nickname] =>
[lastname] => Mühlberger
[country] => AUT
[birthday] => 0000-00-00
[deathday] => 0000-00-00
[pid] => 818
[person_id] => 818
[ppic] => images/com_sportsmanagement/database/persons/k-muehlberger.jpg
[suspension] => 0
[away] => 0
[injury] => 0
[person_slug] => 818:kevin-muehlberger
[position_id] => 198
[pposid] => 11671
[position] => COM_SPORTSMANAGEMENT_SOCCER_P_MIDFIELDER
[season_team_id] => 29535
[project_id] => 3240
[projectteam_id] => 43667
[playerid] => 533
[season_team_person_id] => 533
[position_number] => 14
[description] =>
[market_value] => 0
[picture] => images/com_sportsmanagement/database/persons/k-muehlberger.jpg
)
[14] => stdClass Object
(
[firstname] => Justin
[nickname] =>
[lastname] => Geigl
[country] => AUT
[birthday] => 0000-00-00
[deathday] => 0000-00-00
[pid] => 840
[person_id] => 840
[ppic] => images/com_sportsmanagement/database/persons/geigl-j.jpg
[suspension] => 0
[away] => 0
[injury] => 0
[person_slug] => 840:justin-geigl
[position_id] => 198
[pposid] => 11671
[position] => COM_SPORTSMANAGEMENT_SOCCER_P_MIDFIELDER
[season_team_id] => 29535
[project_id] => 3240
[projectteam_id] => 43667
[playerid] => 563
[season_team_person_id] => 563
[position_number] => 16
[description] =>
[market_value] => 0
[picture] => images/com_sportsmanagement/database/persons/geigl-j.jpg
)
[15] => stdClass Object
(
[firstname] => Florian
[nickname] =>
[lastname] => Freigassner
[country] => AUT
[birthday] => 0000-00-00
[deathday] => 0000-00-00
[pid] => 813
[person_id] => 813
[ppic] => images/com_sportsmanagement/database/persons/670725461856634215_670253181886602946-0-110-h9t9hvu_1423086544.jpg
[suspension] => 0
[away] => 0
[injury] => 0
[person_slug] => 813:florian-freigassner
[position_id] => 198
[pposid] => 11671
[position] => COM_SPORTSMANAGEMENT_SOCCER_P_MIDFIELDER
[season_team_id] => 29535
[project_id] => 3240
[projectteam_id] => 43667
[playerid] => 547
[season_team_person_id] => 547
[position_number] => 18
[description] =>
[market_value] => 0
[picture] => images/com_sportsmanagement/database/persons/670725461856634215_670253181886602946-0-110-h9t9hvu_1423086544.jpg
)
[16] => stdClass Object
(
[firstname] => Alexander
[nickname] =>
[lastname] => Laab
[country] => AUT
[birthday] => 0000-00-00
[deathday] => 0000-00-00
[pid] => 829
[person_id] => 829
[ppic] => images/com_sportsmanagement/database/persons/a-laab.jpg
[suspension] => 0
[away] => 0
[injury] => 0
[person_slug] => 829:alexander-laab
[position_id] => 198
[pposid] => 11671
[position] => COM_SPORTSMANAGEMENT_SOCCER_P_MIDFIELDER
[season_team_id] => 29535
[project_id] => 3240
[projectteam_id] => 43667
[playerid] => 548
[season_team_person_id] => 548
[position_number] => 19
[description] =>
[market_value] => 0
[picture] => images/com_sportsmanagement/database/persons/a-laab.jpg
)
[17] => stdClass Object
(
[firstname] => Michael
[nickname] =>
[lastname] => Platzer
[country] => AUT
[birthday] => 0000-00-00
[deathday] => 0000-00-00
[pid] => 821
[person_id] => 821
[ppic] => images/com_sportsmanagement/database/persons/m-platzer.jpg
[suspension] => 0
[away] => 0
[injury] => 0
[person_slug] => 821:michael-platzer
[position_id] => 199
[pposid] => 11672
[position] => COM_SPORTSMANAGEMENT_SOCCER_P_FORWARD
[season_team_id] => 29535
[project_id] => 3240
[projectteam_id] => 43667
[playerid] => 534
[season_team_person_id] => 534
[position_number] => 11
[description] =>
[market_value] => 0
[picture] => images/com_sportsmanagement/database/persons/m-platzer.jpg
)
[18] => stdClass Object
(
[firstname] => Andreas
[nickname] =>
[lastname] => Toih
[country] => AUT
[birthday] => 0000-00-00
[deathday] => 0000-00-00
[pid] => 823
[person_id] => 823
[ppic] => images/com_sportsmanagement/database/persons/a-toih.jpg
[suspension] => 0
[away] => 0
[injury] => 0
[person_slug] => 823:andreas-toih
[position_id] => 199
[pposid] => 11672
[position] => COM_SPORTSMANAGEMENT_SOCCER_P_FORWARD
[season_team_id] => 29535
[project_id] => 3240
[projectteam_id] => 43667
[playerid] => 536
[season_team_person_id] => 536
[position_number] => 20
[description] =>
[market_value] => 0
[picture] => images/com_sportsmanagement/database/persons/a-toih.jpg
)
)
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 z2o57_sportsmanagement_season_team_person_id AS tp
INNER JOIN z2o57_sportsmanagement_season_team_id AS st ON st.team_id = tp.team_id
INNER JOIN z2o57_sportsmanagement_project_team AS pt ON pt.team_id = st.id
INNER JOIN z2o57_sportsmanagement_person AS pr ON tp.person_id = pr.id
INNER JOIN z2o57_sportsmanagement_project AS pro ON pro.id = pt.project_id and pro.season_id = tp.season_id
INNER JOIN z2o57_sportsmanagement_team AS t ON t.id = st.team_id
LEFT JOIN z2o57_sportsmanagement_person_project_position AS perpos ON perpos.project_id = pro.id AND perpos.person_id = pr.id
LEFT JOIN z2o57_sportsmanagement_project_position AS ppos ON ppos.id = perpos.project_position_id
LEFT JOIN z2o57_sportsmanagement_position AS pos ON pos.id = ppos.position_id
LEFT JOIN z2o57_sportsmanagement_position AS posparent ON pos.parent_id = posparent.id
WHERE tp.persontype = 2 AND tp.season_id = 85 AND tp.team_id = 3661 AND pr.show_on_frontend = 1 AND pro.id = 3240
ORDER BY pos.ordering, ppos.position_id, tp.ordering, tp.jerseynumber, pr.lastname, pr.firstname
sportsmanagementModelRoster::getTeamPlayers 330 players
Array
(
)