ࢵ鹷֡ ͧ ͧ ͧ Թ ͧᴧ
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 ʾ. ࢵ 39 (ɳš,صôԵ) [ ʾ.ɳš 1] 18 24 9 51 114 35 15 5 164
2 ʾ. ࢵ 36 (§,) [ ʾ.§ 1] 12 8 6 26 104 39 19 5 162
3 ʾ. ࢵ 37 (,ҹ) [ ʾ.ҹ 1] 12 3 5 20 112 41 12 5 165
4 ʾ. ࢵ 37 (,ҹ) [ ʾ. 1] 11 10 7 28 93 46 22 5 161
5 ʾ. ࢵ 42 (ä,ط¸ҹ) [ ʾ.ä 1] 10 9 12 31 117 40 18 4 175
6 ʾ. ࢵ 38 (⢷,ҡ) [ ʾ.⢷ 2] 10 5 8 23 102 42 19 11 163
7 ʾ. ࢵ 34 (§,ͧ͹) [ ʾ.§ 1] 9 13 13 35 101 41 15 2 157
8 ʾ. ࢵ 37 (,ҹ) [ ʾ.ҹ 2] 9 9 9 27 100 35 19 6 154
9 ʾ. ࢵ 39 (ɳš,صôԵ) [ ʾ.صôԵ 1] 9 5 7 21 95 42 21 8 158
10 ʾ. ࢵ 42 (ä,ط¸ҹ) [ ʾ.ä 3] 8 7 6 21 93 47 28 11 168
11 ʾ. ࢵ 35 (ӻҧ,Ӿٹ) [ ʾ.ӻҧ 1] 8 6 6 20 92 39 13 6 144
12 ʾ. ࢵ 36 (§,) [ ʾ. 1] 7 4 7 18 76 57 23 9 156
13 ʾ. ࢵ 42 (ä,ط¸ҹ) [ ʾ.ط¸ҹ 2] 6 7 4 17 85 44 31 10 160
14 ʾ. ࢵ 37 (,ҹ) [ ʾ. 2] 6 3 4 13 66 47 20 14 133
15 ʾ. ࢵ 38 (⢷,ҡ) [ ʾ.ҡ 2] 6 2 3 11 69 49 27 10 145
16 ʾ. ࢵ 41 (ᾧྪ,ԨԵ) [ ʾ.ᾧྪ 1] 5 4 5 14 94 46 19 6 159
17 ʾ. ࢵ 36 (§,) [ ʾ. 2] 5 4 4 13 70 49 19 13 138
18 ʾ. ࢵ 41 (ᾧྪ,ԨԵ) [ ʾ.ᾧྪ 2] 5 3 6 14 75 31 16 8 122
19 ʾ. ࢵ 35 (ӻҧ,Ӿٹ) [ ʾ.Ӿٹ 1] 4 5 12 21 92 49 21 8 162
20 ʾ. ࢵ 41 (ᾧྪ,ԨԵ) [ ʾ.ԨԵ 1] 3 8 5 16 76 53 21 9 150
21 ʾ. ࢵ 42 (ä,ط¸ҹ) [ ʾ.ط¸ҹ 1] 3 7 2 12 74 46 27 9 147
22 ʾ. ࢵ 38 (⢷,ҡ) [ ʾ.ҡ 1] 3 5 4 12 64 37 30 8 131
23 ʾ. ࢵ 36 (§,) [ ʾ.§ 2] 3 4 1 8 57 52 21 10 130
24 ʾ. ࢵ 34 (§,ͧ͹) [ ʾ.§ 4] 3 3 5 11 59 51 26 9 136
25 ʾ. ࢵ 40 (ྪúó) [ ʾ.ྪúó 2] 3 3 3 9 65 52 26 9 143
26 ʾ. ࢵ 40 (ྪúó) [ ʾ.ྪúó 1] 3 2 5 10 84 40 17 9 141
27 ʾ. ࢵ 36 (§,) [ ʾ.§ 3] 3 2 1 6 67 39 19 9 125
28 ʾ. ࢵ 40 (ྪúó) [ ʾ.ྪúó 3] 2 7 1 10 81 46 22 14 149
29 ʾ. ࢵ 34 (§,ͧ͹) [ ʾ.§ 2] 2 4 2 8 70 35 25 10 130
30 ʾ. ࢵ 39 (ɳš,صôԵ) [ ʾ.ɳš 3] 2 4 2 8 62 47 24 20 133
31 ʾ. ࢵ 35 (ӻҧ,Ӿٹ) [ ʾ.Ӿٹ 2] 2 3 2 7 63 33 29 17 125
32 ʾ. ࢵ 34 (§,ͧ͹) [ ʾ.§ 6] 2 1 1 4 35 58 23 15 116
33 ʾ. ࢵ 34 (§,ͧ͹) [ ʾ.ͧ͹ 1] 2 1 0 3 42 29 18 11 89
34 ʾ. ࢵ 42 (ä,ط¸ҹ) [ ʾ.ä 2] 2 0 3 5 58 51 27 12 136
35 ʾ. ࢵ 38 (⢷,ҡ) [ ʾ.⢷ 1] 1 5 4 10 89 37 20 8 146
36 ʾ. ࢵ 41 (ᾧྪ,ԨԵ) [ ʾ.ԨԵ 2] 1 4 4 9 68 45 17 11 130
37 ʾ. ࢵ 36 (§,) [ ʾ.§ 4] 1 4 2 7 65 49 18 8 132
38 ʾ. ࢵ 39 (ɳš,صôԵ) [ ʾ.ɳš 2] 1 2 4 7 50 45 15 16 110
39 ʾ. ࢵ 35 (ӻҧ,Ӿٹ) [ ʾ.ӻҧ 3] 1 0 5 6 49 52 30 17 131
40 ʾ. ࢵ 35 (ӻҧ,Ӿٹ) [ ʾ.ӻҧ 2] 0 3 3 6 60 47 23 14 130
41 ʾ. ࢵ 34 (§,ͧ͹) [ ʾ.§ 3] 0 1 2 3 57 51 23 13 131
42 ʾ. ࢵ 34 (§,ͧ͹) [ ʾ.§ 5] 0 1 1 2 34 40 37 13 111
43 ʾ. ࢵ 39 (ɳš,صôԵ) [ ʾ.صôԵ 2] 0 1 1 2 24 43 36 15 103
44 ʾ. ࢵ 34 (§,ͧ͹) [ ʾ.ͧ͹ 2] 0 1 0 1 24 23 20 12 67
203 207 196 606 3,227 1,920 971 444 6,118