|
|
|
Single Player Results:
database error: invalid sql: SELECT
r.id,
r.uid,
r.name,
r.lastname,
r.nickname,
r.city,
r.cid,
tr.place,
tr.points,
r.points as singlepoints,
r.p_victory AS p_vic,
r.p_army AS p_amy,
r.p_paint AS p_pnt,
r.p_quiz AS p_qiz,
r.p_fairplay AS p_fpl,
r.p_unkown AS p_unk,
a.name_en AS army,
t.name AS team,
r.name LIKE 'unbekannt' OR r.lastname LIKE 'unbekannt' AS unkown,
IFNULL(b.id,0) AS private,
IF(tr.place=0,10000,tr.place) AS placement
FROM tournament_results r
LEFT JOIN xtr_blacklist b ON b.name=r.name AND b.lastname=r.lastname AND b.pic=r.pic
LEFT JOIN tournament_armies a ON a.id=r.army
LEFT JOIN tournament_teams t ON t.id=r.team
LEFT JOIN tournament_result_teams tr ON tr.team=r.team
WHERE r.tid=30975
ORDER BY a.army, placement, tr.points DESC, r.team, r.points DESC
mysql error: 1054 (Unknown column 'a.army' in 'order clause')
There was an error with the database. Please try again or contact an admin if the problem doesn't vanish in a couple of minutes. |