brewery-futon Roster: SV Hinterberg
×

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

sportsmanagementModelRoster::getTeamPlayers 329 projectteam 

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

Soccer ST - Gebietsliga Mürz 2005/06 ST - Gebietsliga Mürz 2005/06 Print    
 Roster - SV Hinterberg [SVH]

SV Hinterberg SV Hinterberg


Back

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

JSM - Modul Vereins Icons (2)

Proleb Phönix Mürzzuschlag Wartberg SV Hinterberg SV Oberaich Kindberg II SC Tragöß - St. Katharein EKRO Tus Krieglach Atus Langenwang Rapid Kapfenberg SV Breitenau Parschlug SC Gußwerk Wsv Eisenerz
 
 
 

Joomla! Debug Console

Session

Profile Information

Memory Usage

Database Queries