ࢵ鹷֡ ͧ ͧ ͧ Թ ͧᴧ
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 ʾ. к 41 24 32 97 168 28 10 7 206
2 ʾ. ࢵ 1 23 16 16 55 129 59 23 9 211
3 ʾ. ɮҹ ࢵ 3 19 20 13 52 128 55 23 19 206
4 ʾ. ոҪ ࢵ 3 15 9 7 31 94 56 21 17 171
5 ʾ. ɮҹ ࢵ 1 12 9 11 32 101 40 25 11 166
6 ʾ. ոҪ ࢵ 2 12 5 8 25 118 59 25 23 202
7 ʾ. ѧ ࢵ 1 11 17 8 36 109 44 19 10 172
8 ʾ. ѧ 11 12 8 31 93 46 18 15 157
9 ʾ. ѷا ࢵ 1 10 11 15 36 124 55 19 10 198
10 ʾ. ɮҹ ࢵ 2 10 11 9 30 108 58 22 23 188
11 ʾ. 9 13 5 27 93 45 32 10 170
12 ʾ. ʧ ࢵ 3 9 11 12 32 109 44 33 18 186
13 ʾ. йͧ 9 7 9 25 107 40 31 28 178
14 ʾ. ʧ ࢵ 1 8 5 8 21 87 42 27 19 156
15 ʾ. ࢵ 2 7 15 6 28 105 53 21 14 179
16 ʾ. ʵ 7 11 4 22 74 56 27 14 157
17 ʾ. ѧ ࢵ 2 6 5 7 18 85 62 34 21 181
18 ʾ. ѷا ࢵ 2 5 6 5 16 69 51 25 27 145
19 ʾ. ոҪ ࢵ 4 5 5 7 17 99 58 25 18 182
20 ʾ. ʧ ࢵ 2 4 14 12 30 98 60 22 20 180
21 ʾ. ոҪ ࢵ 1 4 6 14 24 92 57 24 10 173
22 ʾ. ࢵ 1 3 5 3 11 58 23 16 15 97
23 ʾ. ѵҹ ࢵ 1 3 4 3 10 54 27 19 20 100
24 ʾ. Ҹ ࢵ 2 2 1 3 6 47 37 17 15 101
25 ʾ. Ҹ ࢵ 1 1 0 2 3 38 38 22 15 98
26 ʾ. ѵҹ ࢵ 3 1 0 0 1 34 33 13 20 80
27 ʾ. ࢵ 3 0 2 3 5 41 39 21 14 101
28 ʾ. ѵҹ ࢵ 2 0 2 2 4 40 29 16 11 85
29 ʾ. Ҹ ࢵ 3 0 1 3 4 48 42 28 24 118
30 ʾ. ࢵ 2 0 1 1 2 42 36 22 23 100
247 248 236 731 2,592 1,372 680 500 4,644