brewery-futon Roster: 1. FC Nürnberg

AJAX Navigation
DEU
×

Notice

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 = 194 AND tp.team_id = 3570 AND pr.show_on_frontend = 1 AND pro.id = 5528
ORDER BY pos.ordering, ppos.position_id, tp.ordering, tp.jerseynumber, pr.lastname, pr.firstname

sportsmanagementModelRoster::getTeamPlayers 329 projectteam 

stdClass Object
(
    [project_id] => 5528
    [id] => 78096
    [season_team_id] => 3570
    [notes] => 
    [picture] => images/com_sportsmanagement/database/placeholders/placeholder_450_2.png
)

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 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 = 194 AND tp.team_id = 3570 AND pr.show_on_frontend = 1 AND pro.id = 5528
ORDER BY pos.ordering, ppos.position_id, tp.ordering, tp.jerseynumber, pr.lastname, pr.firstname

Germany Germany
Soccer Deutschland - 2. Bundesliga 2023/24 Deutschland - 2. Bundesliga 2023/24    
 Roster - 1. FC Nürnberg [FCN]

1. FC Nürnberg 1. FC Nürnberg


Back

A component for many sports!
Copyright : © Fussball in Europa
Version : 4.21.00 (diddipoeler)
Page load time: [ 0.196154 ] seconds

JSM - Modul Vereins Icons (2)

Fußball-Club St. Pauli v. 1910 e.V. Holstein Kiel Fortuna Düsseldorf Hamburger SV Karlsruher SC Hannover 96 SC Paderborn 07 SpVgg Greuther Fürth GmbH & Co. KGaA Hertha BSC SV 07 Elversberg FC Schalke 04 1. FC Nürnberg 1. FC Kaiserslautern 1. FC Magdeburg Eintracht Braunschweig Sportverein Wehen Wiesbaden FC Hansa Rostock VfL Osnabrück
 
 
 

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries