Statistik » Fodbold

Liga-statistik

Statistik

SELECT l.name, sp.rank AS rank, MIN(IF(sd.code = 'points', sd.value, NULL)) AS points, MIN(IF(sd.code = 'percentage', sd.value, NULL)) AS percentage, MIN(IF(sd.code = 'played', sd.value, NULL)) AS played, sp.participantFK AS team_fk FROM standing AS s INNER JOIN standing_participants AS sp ON s.id = sp.standingFK INNER JOIN standing_data AS sd ON sp.id = sd.standing_participantsFK INNER JOIN participant AS p ON sp.participantFK = p.id LEFT JOIN language as l on l.objectFK=p.id WHERE l.language_typeFK=1 AND s.object = 'tournament_stage' AND s.objectFK = '835962' AND s.name = 'Ligatable' GROUP BY sp.id ORDER BY rank
  KP
1.Dijon917
2.Troyes916
3.GFCO Ajaccio916
4.Nancy914
5.Le Havre914
6.Brest914
7.Niort913
8.Angers912
9.Laval912
10.Auxerre912
11.Sochaux912
12.Creteil911
13.Nimes911
13.Luzenac00
14.Orléans911
15.Valenciennes911
16.Ajaccio910
17.Clermont Foot99
18.Tours99
19.Arles-Avignon97
20.Chateauroux97
Fuld stilling