brewery-futon Roster: TSV 1860 München

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

sportsmanagementModelRoster::getTeamPlayers 329 projectteam 

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

Germany Germany
Soccer Deutschland - 3. Liga 2021/22 Deutschland - 3. Liga 2021/22    
 Roster - TSV 1860 München [1860]

TSV 1860 München TSV 1860 München


Back

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

JSM - Modul Vereins Icons (2)

1. FC Magdeburg Eintracht Braunschweig 1. FC Kaiserslautern TSV 1860 München Waldhof Mannheim VfL Osnabrück 1. FC Saarbrücken Sportverein Wehen Wiesbaden Borussia Dortmund II FSV Zwickau SC Freiburg II SV Meppen SC Viktoria 04 Köln Hallescher FC MSV Duisburg SC Verl FC Viktoria 1889 Berlin Würzburger Kickers
TSV Havelse Türkgücü München
 
 
 

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries