|
Symon symon
|
|
Rosa alla 38° giornata
Query fallita :( SELECT ruolo,(
CASE
WHEN (sv=1 AND ruolo=0 AND voto=0) THEN 6
WHEN (politico=1 AND voto=0 AND ruolo=1) THEN 6
WHEN (politico=1 AND voto=0 AND ruolo=0) THEN 6
ELSE voto
END) as voto_calc,sv,politico,cod FROM db_dati WHERE db_dati.stagione=2016 AND db_dati.gg=38 AND cod IN () ORDER BY ruolo ASC,voto_calc DESC You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY ruolo ASC,voto_calc DESC' at line 7