ػѹѺ ­ҧ ʾ. Ӿٹ ࢵ 1
ç¹ ͧ ͧ ͧ Թ ͧᴧ
SELECT im_school.school_id AS s_id,im_school.school_name AS s_name, 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_school.province_id=53 AND im_school.area_type_id=1 AND im_school.zone_num=1 AND im_team.confirm_status=1 AND im_school.school_id=im_team.school_id GROUP BY im_team.school_id ORDER BY winner DESC, two_rank DESC, three_rank DESC, gold_medal DESC, silver_medal DESC,bronze_medal DESC,join_medal DESC, NUB DESC, s_name ASC
1 ҹ˹ͧԴ 22 13 8 43 37 19 7 5 63
2 ͹غӾٹ 8 2 8 18 20 10 6 4 36
3 þԹԷ 8 2 4 14 14 2 2 0 18
4 ҪЪҹ 26 7 6 2 15 17 9 3 4 29
5 ҹ 7 1 0 8 7 7 7 1 21
6 ͹غͧӾٹ 6 8 1 15 18 2 1 3 21
7 þԷ 6 6 4 16 15 2 2 0 19
8 ҹؾó 6 3 1 10 10 0 1 2 11
9 Ѵҵ֧Һ 6 1 4 11 9 12 3 1 24
10 ҹͺ 5 4 0 9 10 8 4 0 22
11 Ѵѹ 5 3 6 14 11 5 2 3 18
12 ҹ 5 3 1 9 8 3 1 1 12
13 Ⱥѹҧ˹ 5 2 2 9 10 4 0 3 14
14 ҹ¤ 5 1 2 8 7 2 3 2 12
15 ҹ˹ͧ͡ 4 4 4 12 12 4 7 4 23
16 ҹһѡ 4 4 3 11 8 5 9 3 22
17 ȺŻе 4 2 4 10 9 5 1 1 15
18 ҹ 4 2 2 8 8 4 1 4 13
19 Ѵ 4 2 0 6 4 1 1 0 6
20 ѴӾ 4 0 2 6 4 1 4 0 9
21 Ѵҹͧ 3 4 1 8 7 3 2 0 12
22 ҹ 3 4 0 7 5 5 2 1 12
23 ҹ货 3 3 6 12 8 14 4 7 26
24 سѲ 3 2 1 6 7 2 1 0 10
25 Ѵѡ 3 1 1 5 7 4 0 3 11
26 Ѵ 3 1 1 5 3 1 0 1 4
27 Ѵѭ 3 1 0 4 5 1 1 0 7
28 㺺حӾٹ 2 7 2 11 8 11 1 1 20
29 ҹ˹ͧҧ׹ 2 5 3 10 6 6 3 2 15
30 Ѵѹ 2 4 0 6 7 1 2 0 10
31 ҹ 2 2 1 5 6 6 3 0 15
32 ҹѹ§ 2 2 0 4 9 5 0 2 14
33 Ѵѹ鹸 2 2 0 4 5 0 2 0 7
34 ҹ 2 1 4 7 2 3 3 9 8
35 ҹͧ 2 1 2 5 7 2 1 3 10
36 ˨ԵԷ 2 1 1 4 5 1 0 0 6
37 ҹⷡӡѴ 2 1 0 3 3 0 0 0 3
38 Ѵͧ͡ 2 0 2 4 4 2 0 0 6
39 ҹҧԷҹء 2 0 1 3 4 6 3 8 13
40 ҹӵԹ 2 0 0 2 2 0 0 1 2
41 Ѵպح-ѧ 2 0 0 2 2 0 0 0 2
42 㺺حҫҧ 1 4 3 8 9 2 0 1 11
43 ҹͧǧ 1 3 1 5 6 1 0 0 7
44 Ѵҹ 1 2 5 8 4 7 5 0 16
45 ҹһ 1 2 1 4 4 8 2 2 14
46 Ѵҹ 1 2 0 3 4 5 0 2 9
47 Ѵѹѡ 1 2 0 3 3 3 1 1 7
48 Ѵͧ 1 1 5 7 6 1 3 0 10
49 ҹҫҧ 1 1 4 6 7 2 2 0 11
50 Ѵҡͧ 1 1 1 3 4 0 0 1 4
51 ҹ˹ͧҧ 1 1 1 3 3 7 0 0 10
52 ҹ· 1 1 1 3 2 2 0 1 4
53 ҹͧ֡ 1 0 3 4 4 2 0 1 6
54 Ⱥ 1 1 0 1 2 5 2 1 1 8
55 ҹ鹼 1 0 1 2 2 0 0 0 2
56 Ѵҡ 1 0 0 1 6 2 0 3 8
57 Ѵ਴ 1 0 0 1 3 2 0 1 5
58 ѴӴԺ 1 0 0 1 2 5 1 1 8
59 ҹ˹ͧ 1 0 0 1 2 2 1 1 5
60 ҹ 1 0 0 1 2 1 0 0 3
61 Ѵҹ 1 0 0 1 2 0 0 0 2
62 Ѵҹ 1 0 0 1 1 0 1 0 2
63 Ⱥѹҧǧ 0 3 1 4 2 4 1 2 7
64 Ӻԧ 0 3 0 3 2 5 3 1 10
65 Է 0 2 2 4 4 2 0 0 6
66 Ѵ˹ͧ 0 2 1 3 8 0 1 0 9
67 Ѵ⨧ 0 2 1 3 5 2 1 2 8
68 ѴҺء 0 2 0 2 7 3 1 0 11
69 ҹҵ 0 2 0 2 2 1 0 1 3
70 ҹѹ 0 1 3 4 4 5 1 1 10
71 ҹͧ 0 1 1 2 6 13 3 2 22
72 ѴҺ 0 1 1 2 4 1 0 1 5
73 ҹ͹ͧ 0 1 1 2 3 0 0 1 3
74 ҹ 0 1 1 2 2 4 0 1 6
75 ͧԾ 0 1 1 2 2 0 0 0 2
76 Ѵմ͹ 0 1 0 1 3 1 1 1 5
77 ҹ 0 1 0 1 3 1 0 0 4
78 ҹһҡ 0 1 0 1 2 2 0 0 4
79 ҹҧǹ 0 1 0 1 2 0 1 0 3
80 ҹ˹ͧ˹ 0 1 0 1 2 0 1 0 3
81 Ѵ 0 1 0 1 1 2 3 0 6
82 Ѵҹ͹ 0 1 0 1 1 2 0 1 3
83 ҹջҹ 0 1 0 1 1 1 0 2 2
84 ҹҢԹ 0 1 0 1 1 0 0 1 1
85 ҹӺ͹ 0 1 0 1 1 0 0 0 1
86 ҹҵ 0 1 0 1 1 0 0 0 1
87 ͹غŴسѲ 0 1 0 1 1 0 0 0 1
88 ҹ 0 1 0 1 0 2 3 3 5
89 Ѵʶҹ 0 1 0 1 0 2 1 0 3
90 ҹ 0 1 0 1 0 2 0 0 2
91 Ѵеٻ 0 0 2 2 3 1 1 0 5
92 Ѵҵ 0 0 2 2 2 0 0 0 2
93 ҹ 0 0 1 1 5 1 1 1 7
94 Ѵ˹ͧ 0 0 1 1 3 0 2 0 5
95 Ѵѧ 0 0 1 1 2 2 1 0 5
96 ҹѹй 0 0 1 1 2 1 1 1 4
97 Ѵҹ 0 0 1 1 2 0 1 0 3
98 Ѵҵ֧વѹ 0 0 1 1 1 2 0 0 3
99 Ѵ˹ͧ§ 0 0 1 1 1 1 0 0 2
100 պح׹-ѧͧ 0 0 1 1 1 0 0 0 1
101 ҹ˹ͧҢ 0 0 1 1 0 1 2 1 3
102 ҹ 0 0 0 0 2 1 1 2 4
103 ѵԷ 0 0 0 0 2 0 0 0 2
104 Ѵպѧѹ 0 0 0 0 1 3 0 0 4
105 ҹ 0 0 0 0 1 3 0 0 4
106 Ѵᴴ 0 0 0 0 1 2 0 1 3
107 ȺŨ 0 0 0 0 1 2 0 0 3
108 ѴѹСٴ 0 0 0 0 1 1 0 1 2
109 Ӻźҹ 0 0 0 0 1 1 0 0 2
110 ҹǹǧ-ҹ 0 0 0 0 1 1 0 0 2
111 ҹͧ˹ͧ 0 0 0 0 1 0 0 1 1
112 Ѵ⪤ 0 0 0 0 1 0 0 1 1
113 Ѵҧ 0 0 0 0 1 0 0 1 1
114 ҹҡ 0 0 0 0 1 0 0 0 1
115 Ѵҹ͹ 0 0 0 0 0 5 4 0 9
116 Ѵ˹ͧ 0 0 0 0 0 3 1 4 4
117 ҹ 0 0 0 0 0 3 1 3 4
118 ҹл 0 0 0 0 0 3 0 1 3
119 ѡäآ 0 0 0 0 0 2 1 0 3
120 Ѵͧѡ 0 0 0 0 0 1 1 0 2
121 ҹͧ 0 0 0 0 0 1 0 1 1
122 Ѵҵ鹧 0 0 0 0 0 1 0 0 1
123 Ѵҹ 0 0 0 0 0 1 0 0 1
124 ҹ蹢 0 0 0 0 0 0 2 0 2
125 ѴѹԹ 0 0 0 0 0 0 2 0 2
126 ҸԵ֡ 0 0 0 0 0 0 1 0 1
127 ҹͺ Ң 0 0 0 0 0 0 1 0 1
128 Ѵҧ 0 0 0 0 0 0 1 0 1
129 ҧͺ ҢҢعͧ 0 0 0 0 0 0 0 1 0
130 ҹͧҧ 0 0 0 0 0 0 0 1 0
195 168 137 500 538 330 156 136 1,024