ػѹѺ ­ҧ ʾ. ҧͧ
ç¹ ͧ ͧ ͧ Թ ͧᴧ
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=71 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 ͹غѴҧͧ 33 16 12 61 66 13 2 4 81
2 ѴպǷͧ 12 8 2 22 25 4 1 1 30
3 ѴТ 11 5 3 19 28 17 5 4 50
4 ͹غѴҧ 10 12 7 29 28 8 2 4 38
5 ѴŢѹ(ԷҤ) 9 8 8 25 26 7 4 6 37
6 Ѵҷ 8 4 2 14 12 7 5 2 24
7 Ѵǧѹ 8 1 1 10 11 6 3 1 20
8 Ѵҹ 7 4 2 13 18 7 6 2 31
9 Ѵ˹ͧҧ 6 6 6 18 16 8 5 7 29
10 ѴóҪ˧ 6 5 2 13 16 7 2 2 25
11 ѴҺ 6 3 5 14 12 5 1 4 18
12 Ѵ⾸͹ 6 2 4 12 18 12 2 2 32
13 Ѵ 5 4 5 14 24 6 7 9 37
14 ҹ¤ 5 1 0 6 6 2 1 1 9
15 Ѵҧ 5 0 0 5 5 0 0 0 5
16 ҹ˹ͧ 4 6 3 13 16 11 5 6 32
17 ѴǡШҧ 4 3 0 7 10 3 2 3 15
18 Ѵѧ 4 3 0 7 4 2 1 3 7
19 Ѵͺ 3 11 3 17 16 5 2 1 23
20 Ѵ 3 5 3 11 12 3 2 4 17
21 ѴԷ 3 2 4 9 8 6 3 5 17
22 Ѵ԰ 3 1 5 9 10 3 0 0 13
23 ͹غǧ 3 1 3 7 8 1 2 1 11
24 ǧͧػ 3 1 1 5 6 2 2 2 10
25 Ѵҧ (ǹЪä) 2 4 2 8 7 7 3 2 17
26 ѴҪ 2 3 3 8 9 7 4 3 20
27 ѴҴ 2 3 3 8 4 3 3 5 10
28 ԷԷ 2 3 2 7 7 1 0 0 8
29 Է 2 3 1 6 11 4 3 2 18
30 Ⱥ 3 Ѵ 2 1 2 5 7 8 0 5 15
31 Ѵҧ 2 1 1 4 5 2 3 1 10
32 Ѵԧ 2 1 1 4 3 3 2 0 8
33 ѴЪ 2 0 1 3 6 3 3 1 12
34 Ѵ⤡ط 2 0 0 2 2 1 1 0 4
35 Ѵ紪 2 0 0 2 2 0 0 2 2
36 ѴҪѡ 2 0 0 2 2 0 0 0 2
37 Ѵѡ 1 2 5 8 10 6 3 3 19
38 Ѵ⾸ǧ 1 2 1 4 3 4 5 2 12
39 Ѵ⾸º 1 2 0 3 3 0 0 0 3
40 Ѵ 1 1 3 5 7 6 1 3 14
41 ͹غǧʴԷ 1 1 1 3 4 0 0 0 4
42 Ѵᡵ 1 1 1 3 3 2 1 0 6
43 Ѵ 1 1 1 3 1 1 2 4 4
44 Ѵ·ͧ 1 1 0 2 4 1 0 0 5
45 Ѵҧ 1 1 0 2 2 2 3 1 7
46 Ѵ 1 1 0 2 2 2 0 1 4
47 Ѵ 1 1 0 2 2 1 0 0 3
48 ѴԨó 1 1 0 2 2 0 2 0 4
49 ѴӾ 1 0 5 6 8 4 3 3 15
50 ѴҵҴ 1 0 3 4 4 1 1 2 6
51 ѴԷ 1 0 1 2 7 1 0 0 8
52 Ѵҧͧ 1 0 1 2 4 0 1 2 5
53 Ѵѹ 1 0 1 2 4 0 0 3 4
54 Ѵҹ 1 0 1 2 3 0 0 0 3
55 ѰԷ 6 1 0 1 2 2 0 1 2 3
56 Ѵش 1 0 0 1 1 1 1 2 3
57 ѴҴ 1 0 0 1 1 1 0 2 2
58 ͹غŻ 1 0 0 1 1 0 1 2 2
59 з 1 0 0 1 1 0 0 0 1
60 Ѵ 0 4 1 5 3 3 5 4 11
61 Ѵҧ 0 3 0 3 9 1 2 2 12
62 ҹӼ 0 3 0 3 5 3 0 0 8
63 Ѵ(è츹ػ) 0 2 3 5 8 2 2 1 12
64 Ѵѹط 0 2 2 4 6 4 3 0 13
65 Ѵ鹷ͧ 0 2 0 2 2 3 2 1 7
66 Ѵҹҹ 0 1 3 4 8 2 1 1 11
67 Ѵʶ(ԷҤ) 0 1 2 3 6 6 1 0 13
68 ʹԷԷ 0 1 1 2 1 3 2 1 6
69 ѴҴ 0 1 1 2 1 2 1 1 4
70 Ѵͧ͹ 0 1 0 1 4 2 0 0 6
71 Ѵҹྪ 0 1 0 1 2 2 1 2 5
72 ҹ 0 1 0 1 2 1 2 4 5
73 Ѵǵоҹ 0 1 0 1 1 1 1 2 3
74 Ѵŧ 0 1 0 1 1 1 1 1 3
75 Ѵç 0 1 0 1 1 1 0 0 2
76 Ѵع 0 1 0 1 1 0 0 1 1
77 Ѵͧ 0 1 0 1 1 0 0 0 1
78 Ѵҹ԰ 0 1 0 1 1 0 0 0 1
79 Ѵ 0 1 0 1 1 0 0 0 1
80 ʹԷó 0 0 2 2 4 2 2 5 8
81 Ѵͧҧ 0 0 2 2 3 0 2 0 5
82 Ѵʶ (ɮѧɮ) 0 0 1 1 4 2 0 3 6
83 Ѵǧȹ 0 0 1 1 3 0 0 0 3
84 ѴѤ 0 0 1 1 2 0 1 0 3
85 ôԵԷһٷ 0 0 1 1 2 0 0 1 2
86 Ѵ鹷ͧ 0 0 1 1 1 1 1 0 3
87 ѴŸԵ 0 0 1 1 1 1 1 0 3
88 ͹غѴ 0 0 1 1 1 0 1 0 2
89 ҹ͹ҧ 0 0 1 1 0 2 2 1 4
90 Ѵҧ 0 0 1 1 0 2 0 0 2
91 ѴҪʡس 0 0 0 0 3 0 1 2 4
92 Ѵҹ 0 0 0 0 3 0 1 0 4
93 Ѵӻ 0 0 0 0 2 2 1 0 5
94 Ѵ⾸ɮ 0 0 0 0 2 1 1 2 4
95 ɮԷ 0 0 0 0 2 1 1 0 4
96 ͹غźҹʹ 0 0 0 0 2 1 0 4 3
97 Ѵǧ 0 0 0 0 2 0 0 2 2
98 ͹غ⾸ͧ 0 0 0 0 2 0 0 0 2
99 Ѵ͡Ҫ 0 0 0 0 1 2 2 3 5
100 Ѵͧ 0 0 0 0 1 2 1 2 4
101 ҹ͹ǧ 0 0 0 0 1 2 1 1 4
102 Ѵ 0 0 0 0 1 1 0 0 2
103 Ѵ 0 0 0 0 1 0 1 2 2
104 ѴѹԵ 0 0 0 0 1 0 1 1 2
105 ѴʹԸ 0 0 0 0 1 0 0 2 1
106 ͹غͧҧͧ 0 0 0 0 1 0 0 0 1
107 Ѵҧѡ 0 0 0 0 1 0 0 0 1
108 ѴŴѵ 0 0 0 0 1 0 0 0 1
109 Ѵйҹ 0 0 0 0 1 0 0 0 1
110 ѴҪ 0 0 0 0 1 0 0 0 1
111 ͹غžٹآ 0 0 0 0 1 0 0 0 1
112 Ѵ 0 0 0 0 0 2 0 2 2
113 ѴҴ 0 0 0 0 0 2 0 0 2
114 Ѵҧ 0 0 0 0 0 1 1 2 2
115 Ѵҧ 0 0 0 0 0 1 1 1 2
116 Ѵͧç 0 0 0 0 0 1 0 0 1
117 ѴحԷ 0 0 0 0 0 1 0 0 1
118 ѴحԴ 0 0 0 0 0 1 0 0 1
119 ѴỴ 0 0 0 0 0 1 0 0 1
120 Ѵɪªҭ 0 0 0 0 0 0 2 2 2
121 Ѵѵ 0 0 0 0 0 0 1 1 1
122 Ѵᾧ 0 0 0 0 0 0 1 0 1
123 ҹ٢Դ 0 0 0 0 0 0 1 0 1
124 Ѵӹ 0 0 0 0 0 0 1 0 1
125 Ѵҧǹ 0 0 0 0 0 0 1 0 1
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 0 3 0
129 Ѵ⾸ͧ 0 0 0 0 0 0 0 2 0
130 Ѵͧ 0 0 0 0 0 0 0 1 0
131 Ѵѹ 0 0 0 0 0 0 0 1 0
132 Ѵѭԡ 0 0 0 0 0 0 0 1 0
133 ѴҴԹ 0 0 0 0 0 0 0 0 0
134 Ѵաح 0 0 0 0 0 0 0 0 0
214 176 148 538 661 286 168 195 1,115