brewery-futon Roster: Eintracht Braunschweig

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

sportsmanagementModelRoster::getTeamPlayers 329 projectteam 

stdClass Object
(
    [project_id] => 4330
    [id] => 58990
    [season_team_id] => 6560
    [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 = 60 AND tp.team_id = 6560 AND pr.show_on_frontend = 1 AND pro.id = 4330
ORDER BY pos.ordering, ppos.position_id, tp.ordering, tp.jerseynumber, pr.lastname, pr.firstname

Germany Germany
Soccer Deutschland - 2. Bundesliga 2006/07 Deutschland - 2. Bundesliga 2006/07    
 Roster - Eintracht Braunschweig [Eintr]

Eintracht Braunschweig Eintracht Braunschweig

 Team information


Back

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

JSM - Modul Vereins Icons (2)

Karlsruher SC FC Hansa Rostock MSV Duisburg Sport Club Freiburg SpVgg Greuther Fürth GmbH & Co. KGaA 1. FC Kaiserslautern FC Augsburg TSV 1860 München 1. FC Köln Erzgebirge Aue SC Paderborn 07 TuS Koblenz 1911 e.V. FC Carl Zeiss Jena Kickers Offenbach Rot-Weiss Essen SpVgg Unterhaching Wacker Burghausen Eintracht Braunschweig
 
 
 

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries