ࢵ鹷֡ ͧ ͧ ͧ Թ ͧᴧ
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 ʾ. ҹ ࢵ 2 16 11 13 40 133 60 23 12 216
2 ʾ. § ࢵ 3 14 13 8 35 118 57 17 13 192
3 ʾ. § ࢵ 3 12 11 11 34 114 50 21 14 185
4 ʾ. § ࢵ 2 10 5 4 19 110 62 33 11 205
5 ʾ. ɳš ࢵ 1 10 3 9 22 91 68 29 14 188
6 ʾ. ɳš ࢵ 2 9 9 7 25 121 69 17 14 207
7 ʾ. ط¸ҹ ࢵ 2 9 7 3 19 109 58 19 12 186
8 ʾ. ä ࢵ 3 9 7 1 17 115 52 28 12 195
9 ʾ. ɳš ࢵ 3 9 6 6 21 104 74 27 13 205
10 ʾ. ࢵ 1 9 6 6 21 93 60 20 11 173
11 ʾ. § ࢵ 4 8 9 12 29 97 70 17 14 184
12 ʾ. ԨԵ ࢵ 2 8 2 5 15 93 54 24 13 171
13 ʾ. § ࢵ 2 7 10 9 26 103 67 16 10 186
14 ʾ. ⢷ ࢵ 2 7 9 12 28 97 67 26 18 190
15 ʾ. ᾧྪ ࢵ 1 7 6 5 18 96 69 22 14 187
16 ʾ. ᾧྪ ࢵ 2 7 6 3 16 106 56 26 18 188
17 ʾ. ࢵ 2 6 11 8 25 112 53 15 15 180
18 ʾ. ҹ ࢵ 1 6 10 8 24 109 57 21 12 187
19 ʾ. ҡ ࢵ 2 6 9 9 24 118 59 18 11 195
20 ʾ. ӻҧ ࢵ 1 6 4 3 13 83 70 32 13 185
21 ʾ. § ࢵ 1 5 9 5 19 98 42 23 11 163
22 ʾ. ྪúó ࢵ 3 5 5 6 16 114 60 23 14 197
23 ʾ. صôԵ ࢵ 1 5 4 6 15 98 67 27 11 192
24 ʾ. ⢷ ࢵ 1 4 9 3 16 98 61 18 11 177
25 ʾ. ä ࢵ 2 4 7 7 18 92 70 27 15 189
26 ʾ. ྪúó ࢵ 2 4 7 1 12 89 66 22 15 177
27 ʾ. § ࢵ 1 4 6 8 18 99 77 25 10 201
28 ʾ. ط¸ҹ ࢵ 1 4 6 1 11 71 44 32 16 147
29 ʾ. ࢵ 2 4 5 5 14 96 56 18 10 170
30 ʾ. ä ࢵ 1 4 2 3 9 90 60 30 14 180
31 ʾ. Ӿٹ ࢵ 2 3 5 5 13 86 59 32 15 177
32 ʾ. ԨԵ ࢵ 1 3 5 5 13 79 75 31 18 185
33 ʾ. § ࢵ 4 3 5 2 10 92 57 25 14 174
34 ʾ. ӻҧ ࢵ 2 3 4 8 15 99 55 22 13 176
35 ʾ. ࢵ 1 3 3 5 11 89 63 30 12 182
36 ʾ. ྪúó ࢵ 1 3 2 7 12 104 57 33 16 194
37 ʾ. ͧ͹ ࢵ 2 3 2 2 7 71 65 27 16 163
38 ʾ. ͧ͹ ࢵ 1 3 2 1 6 67 51 27 21 145
39 ʾ. صôԵ ࢵ 2 3 0 2 5 62 57 38 18 157
40 ʾ. ҡ ࢵ 1 2 6 2 10 104 67 27 16 198
41 ʾ. § ࢵ 5 1 5 2 8 74 65 24 21 163
42 ʾ. ӻҧ ࢵ 3 1 1 3 5 66 51 33 17 150
43 ʾ. § ࢵ 6 1 0 1 2 68 64 28 19 160
44 ʾ. Ӿٹ ࢵ 1 0 4 6 10 74 67 27 13 168
250 258 238 746 4,202 2,688 1,100 620 7,990