Tabelle

Siegfried Galun, Parkstrasse 64, 8720 Knittelfeld, Austria webmaster@esv-knittelfeld.at

TURNIERE
UEFA

Mannschaft Statistiktabelle

Mannschaft Statistiktabelle

DB-Funktion mit Fehlercode 1054 fehlgeschlagen!
Unknown column 'tp.market_text' in 'SELECT'Dateiname: /var/www/vhosts/esv-knittelfeld.at/httpdocs/components/com_sportsmanagement/models/rosteralltime.php
Zeile: 431sportsmanagementModelRosteralltime::getTeamPlayers 432

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.picture AS ppic,CONCAT_WS(':',pr.id,pr.alias) AS person_slug,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.market_text AS market_text,tp.picture,st.id AS season_team_id,pt.project_id AS project_id,pos.name AS position,ppos.position_id,ppos.id as pposid,CONCAT_WS(':',pro.id,pro.alias) AS project_slug,CONCAT_WS(':',t.id,t.alias) AS team_slug
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 and st.season_id = tp.season_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 = st.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.person_id IN ( 905,831,647,832,857,833,830,874,903,826,906,567,690,865,904,902,834,649,643,884,862,835,836,660,896,911,867,856,659,915,912,837,883,854,913,838,839,864,877,843,866,844,908,907,845,846,851,887,638,910,852,914,909,863,885,882,853,886,847,848,849,850 ) AND st.team_id = 3690 AND pr.published = 1 AND tp.published = 1 AND tp.persontype = 1
GROUP BY pr.id
ORDER BY pos.ordering, ppos.position_id, tp.ordering, tp.jerseynumber, pr.lastname, pr.firstname