ࢵ鹷֡ ͧ ͧ ͧ Թ ͧᴧ
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 ʾ. ࢵ 1 (ا෾ҹ) 17 16 11 44 113 38 10 10 161
2 ʾ. ࢵ 1 (ا෾ҹ) [ ʾ.ا෾ҹ 2] 17 11 8 36 109 45 12 10 166
3 ʾ. ࢵ 3 (,йظ) [ ʾ. 1] 10 4 9 23 93 59 12 13 164
4 ʾ. ࢵ 2 (ا෾ҹ) 8 10 6 24 101 49 14 9 164
5 ʾ. ࢵ 9 (ؾó,û) [ ʾ.û 2] 8 4 7 19 99 57 14 11 170
6 ʾ. ࢵ 18 (ź,ͧ) [ ʾ.ź 2] 8 3 3 14 70 63 14 18 147
7 ʾ. ࢵ 3 (,йظ) [ ʾ. 2] 7 9 11 27 99 42 16 10 157
8 ʾ. ࢵ 10 (ྪú,ШǺբѹ,طʧ,طҤ) [ ʾ.ྪú 1] 7 6 12 25 92 60 10 6 162
9 ʾ. ࢵ 4 (ҹ,к) [ ʾ.ҹ 2] 7 5 13 25 85 50 23 19 158
10 ʾ. ࢵ 18 (ź,ͧ) [ ʾ.ź 1] 7 4 4 15 78 62 22 11 162
11 ʾ. ࢵ 8 (Ҫ,ҭ) [ ʾ.Ҫ 1] 7 4 2 13 64 48 12 18 124
12 ʾ. ࢵ 9 (ؾó,û) [ ʾ.û 1] 7 2 7 16 87 53 12 19 152
13 ʾ. ࢵ 3 (,йظ) [ ʾ.йظ 1] 6 6 4 16 92 48 12 18 152
14 ʾ. ࢵ 5 (ԧ,ž,¹ҷ,ҧͧ) [ ʾ.ž 1] 5 7 6 18 82 53 21 15 156
15 ʾ. ࢵ 9 (ؾó,û) [ ʾ.ؾó 1] 5 5 2 12 65 56 18 15 139
16 ʾ. ࢵ 6 (ԧ,طûҡ) [ ʾ.ԧ 1] 5 4 3 12 90 46 17 12 153
17 ʾ. ࢵ 8 (Ҫ,ҭ) [ ʾ.Ҫ 2] 5 2 7 14 68 45 13 16 126
18 ʾ. ࢵ 10 (ྪú,ШǺբѹ,طʧ,طҤ) [ ʾ.طҤ 1] 5 2 4 11 69 43 17 19 129
19 ʾ. ࢵ 5 (ԧ,ž,¹ҷ,ҧͧ) [ ʾ.ҧͧ 1] 4 8 3 15 77 51 19 21 147
20 ʾ. ࢵ 18 (ź,ͧ) [ ʾ.ͧ 1] 4 5 6 15 84 57 11 12 152
21 ʾ. ࢵ 4 (ҹ,к) [ ʾ.к 2] 4 3 2 9 67 46 25 19 138
22 ʾ. ࢵ 4 (ҹ,к) [ ʾ.ҹ 1] 4 2 3 9 87 49 18 11 154
23 ʾ. ࢵ 17 (ѹ,Ҵ) [ ʾ.Ҵ 1] 4 2 2 8 79 53 13 16 145
24 ʾ. ࢵ 6 (ԧ,طûҡ) [ ʾ.طûҡ 2] 4 1 2 7 66 72 13 18 151
25 ʾ. ࢵ 7 (Ҩչ,ù¡,) [ ʾ. 2] 4 0 2 6 50 48 19 20 117
26 ʾ. ࢵ 8 (Ҫ,ҭ) [ ʾ.ҭ 1] 3 7 5 15 84 50 16 13 150
27 ʾ. ࢵ 9 (ؾó,û) [ ʾ.ؾó 2] 3 3 1 7 59 67 26 21 152
28 ʾ. ࢵ 6 (ԧ,طûҡ) [ ʾ.ԧ 2] 3 1 3 7 51 52 24 18 127
29 ʾ. ࢵ 7 (Ҩչ,ù¡,) [ ʾ.Ҩչ 1] 3 1 2 6 58 64 15 17 137
30 ʾ. ࢵ 2 (ا෾ҹ) [ ʾ.ا෾ҹ 1] 2 11 3 16 92 48 10 16 150
31 ʾ. ࢵ 17 (ѹ,Ҵ) [ ʾ.ѹ 1] 2 7 4 13 80 51 14 14 145
32 ʾ. ࢵ 10 (ྪú,ШǺբѹ,طʧ,طҤ) [ ʾ.ШǺբѹ 2] 2 4 2 8 50 52 19 20 121
33 ʾ. ࢵ 3 (,йظ) [ ʾ.йظ 2] 2 3 3 8 62 47 18 14 127
34 ʾ. ࢵ 5 (ԧ,ž,¹ҷ,ҧͧ) [ ʾ.ԧ 1] 2 2 3 7 60 56 17 21 133
35 ʾ. ࢵ 17 (ѹ,Ҵ) [ ʾ.ѹ 2] 2 1 2 5 48 43 14 17 105
36 ʾ. ࢵ 8 (Ҫ,ҭ) [ ʾ.ҭ 2] 2 0 2 4 54 52 13 14 119
37 ʾ. ࢵ 5 (ԧ,ž,¹ҷ,ҧͧ) [ ʾ.ž 2] 2 0 1 3 60 64 22 19 146
38 ʾ. ࢵ 5 (ԧ,ž,¹ҷ,ҧͧ) [ ʾ.¹ҷ 1] 1 6 1 8 63 50 20 18 133
39 ʾ. ࢵ 18 (ź,ͧ) [ ʾ.ź 3] 1 5 2 8 73 53 19 11 145
40 ʾ. ࢵ 6 (ԧ,طûҡ) [ ʾ.طûҡ 1] 1 4 4 9 79 58 16 16 153
41 ʾ. ࢵ 7 (Ҩչ,ù¡,) [ ʾ. 1] 1 3 3 7 66 52 19 22 137
42 ʾ. ࢵ 18 (ź,ͧ) [ ʾ.ͧ 2] 1 2 2 5 50 63 16 20 129
43 ʾ. ࢵ 10 (ྪú,ШǺբѹ,طʧ,طҤ) [ ʾ.ྪú 2] 1 1 3 5 44 48 17 14 109
44 ʾ. ࢵ 4 (ҹ,к) [ ʾ.к 1] 1 1 2 4 62 73 17 14 152
45 ʾ. ࢵ 8 (Ҫ,ҭ) [ ʾ.ҭ 3] 1 1 2 4 42 48 11 14 101
46 ʾ. ࢵ 9 (ؾó,û) [ ʾ.ؾó 3] 0 6 4 10 61 55 18 23 134
47 ʾ. ࢵ 10 (ྪú,ШǺբѹ,طʧ,طҤ) [ ʾ.طʧ 1] 0 4 0 4 45 53 16 19 114
48 ʾ. ࢵ 7 (Ҩչ,ù¡,) [ ʾ.Ҩչ 2] 0 2 2 4 43 54 21 23 118
49 ʾ. ࢵ 7 (Ҩչ,ù¡,) [ ʾ.ù¡ 1] 0 1 1 2 56 54 23 19 133
50 ʾ. ࢵ 10 (ྪú,ШǺբѹ,طʧ,طҤ) [ ʾ.ШǺբѹ 1] 0 0 1 1 49 45 28 12 122
51 ʾ. ࢵ 8 (Ҫ,ҭ) [ ʾ.ҭ 4] 0 0 1 1 35 50 16 14 101
205 201 198 604 3,592 2,695 852 809 7,139