ࢵ鹷֡ ͧ ͧ ͧ Թ ͧᴧ
SELECT im_school.area_type_id AS area_type_id,im_school.province_id AS province_id, im_school.zone_num AS zone_num, im_school.area_sm AS area_sm, COUNT(*) AS NUB , COUNT(IF(im_team.award='ͧ',award,NULL)) AS gold_medal, COUNT(IF(im_team.award='Թ',award,NULL)) AS silver_medal, COUNT(IF(im_team.award='ͧᴧ',award,NULL)) AS bronze_medal, COUNT(IF(im_team.award='',award,NULL)) AS join_medal, COUNT(IF(im_team.rank='',rank,NULL)) AS winner, COUNT(IF(im_team.rank='ͧѹѺ ',rank,NULL)) AS two_rank, COUNT(IF(im_team.rank='ͧѹѺ ',rank,NULL)) AS three_rank FROM im_school,im_team WHERE im_team.confirm_status=1 AND im_school.school_id=im_team.school_id GROUP BY im_school.province_id, im_school.zone_num , im_school.area_sm ORDER BY winner DESC, two_rank DESC, three_rank DESC, gold_medal DESC, silver_medal DESC,bronze_medal DESC,join_medal DESC, NUB DESC
1 ʾ. ࢵ 13 (ѧ,к) [ ʾ.к 1] 21 15 19 55 103 39 18 10 160
2 ʾ. ࢵ 12 (ոҪ,ѷا) [ ʾ.ոҪ 2] 20 16 10 46 96 29 9 10 134
3 ʾ. ࢵ 16 (ʧ,ʵ) [ ʾ.ʧ 2] 13 21 14 48 105 30 20 9 155
4 ʾ. ࢵ 11 (ɮҹ,) [ ʾ.ɮҹ 1] 13 16 13 42 95 42 19 9 156
5 ʾ. ࢵ 16 (ʧ,ʵ) [ ʾ.ʧ 1] 13 16 7 36 83 43 15 10 141
6 ʾ. ࢵ 13 (ѧ,к) [ ʾ.ѧ 1] 13 8 14 35 101 41 17 6 159
7 ʾ. ࢵ 12 (ոҪ,ѷا) [ ʾ.ոҪ 3] 13 6 4 23 67 40 16 6 123
8 ʾ. ࢵ 11 (ɮҹ,) [ ʾ. 1] 12 11 20 43 106 40 15 13 161
9 ʾ. ࢵ 12 (ոҪ,ѷا) [ ʾ.ѷا 1] 12 11 6 29 76 43 21 11 140
10 ʾ. ࢵ 14 (ѧ,,йͧ) [ ʾ. 1] 10 2 7 19 76 48 24 5 148
11 ʾ. ࢵ 12 (ոҪ,ѷا) [ ʾ.ոҪ 1] 9 12 8 29 83 26 16 11 125
12 ʾ. ࢵ 16 (ʧ,ʵ) [ ʾ.ʵ 1] 8 4 4 16 59 34 24 9 117
13 ʾ. ࢵ 11 (ɮҹ,) [ ʾ.ɮҹ 2] 6 8 7 21 67 45 27 20 139
14 ʾ. ࢵ 13 (ѧ,к) [ ʾ.ѧ 2] 6 5 7 18 68 42 21 9 131
15 ʾ. ࢵ 11 (ɮҹ,) [ ʾ.ɮҹ 3] 5 3 9 17 66 51 16 15 133
16 ʾ. ࢵ 14 (ѧ,,йͧ) [ ʾ.ѧ 1] 4 9 8 21 75 43 29 9 147
17 ʾ. ࢵ 12 (ոҪ,ѷا) [ ʾ.ѷا 2] 4 6 4 14 66 39 15 13 120
18 ʾ. ࢵ 12 (ոҪ,ѷا) [ ʾ.ոҪ 4] 4 4 5 13 47 29 26 3 102
19 ʾ. ࢵ 11 (ɮҹ,) [ ʾ. 2] 3 4 4 11 66 48 26 12 140
20 ʾ. ࢵ 16 (ʧ,ʵ) [ ʾ.ʧ 3] 3 4 4 11 49 36 15 8 100
21 ʾ. ࢵ 15 (Ҹ,ѵҹ,) [ ʾ.ѵҹ 1] 3 1 4 8 42 37 26 19 105
22 ʾ. ࢵ 14 (ѧ,,йͧ) [ ʾ.йͧ 1] 2 4 1 7 50 40 24 16 114
23 ʾ. ࢵ 15 (Ҹ,ѵҹ,) [ ʾ. 1] 1 4 1 6 40 30 23 16 93
24 ʾ. ࢵ 15 (Ҹ,ѵҹ,) [ ʾ.Ҹ 3] 1 1 1 3 17 13 13 6 43
25 ʾ. ࢵ 15 (Ҹ,ѵҹ,) [ ʾ. 3] 1 0 0 1 16 20 11 14 47
26 ʾ. ࢵ 15 (Ҹ,ѵҹ,) [ ʾ.Ҹ 1] 0 2 4 6 31 33 26 11 90
27 ʾ. ࢵ 15 (Ҹ,ѵҹ,) [ ʾ.ѵҹ 2] 0 1 1 2 17 17 15 21 49
28 ʾ. ࢵ 15 (Ҹ,ѵҹ,) [ ʾ. 2] 0 1 1 2 11 14 22 6 47
29 ʾ. ࢵ 15 (Ҹ,ѵҹ,) [ ʾ.ѵҹ 3] 0 1 0 1 14 19 22 31 55
30 ʾ. ࢵ 15 (Ҹ,ѵҹ,) [ ʾ.Ҹ 2] 0 0 1 1 19 24 22 18 65
31 No name [ ʾ.ѷا 12] 0 0 0 0 0 0 0 0 0
32 No name [ ʾ.ѵҹ 15] 0 0 0 0 0 0 0 0 0
200 196 188 584 1,811 1,035 593 356 3,439