ػѹѺ ­ҧ ʾ. ࢵ 11 (ɮҹ,)
ç¹ ͧ ͧ ͧ Թ ͧᴧ
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=67 AND im_school.area_type_id=2 AND im_school.zone_num=11 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 عԹԷҤ 38 18 17 73 68 22 6 9 96
2 ҭɡԷɮҹ 37 23 13 73 68 23 6 7 97
3 Ҫ 18 26 11 55 49 26 6 10 81
4 Է 14 5 14 33 31 25 11 15 67
5 ҹҢعԷ 10 10 9 29 30 26 11 15 67
6 ֡ 10 9 6 25 29 7 16 11 52
7 ѸǴ 6 4 6 16 17 16 10 18 43
8 Ѹҹº 6 3 4 13 11 19 14 14 44
9 ػԷҾ 5 8 9 22 17 12 6 8 35
10 ѰԷҤ 5 7 3 15 14 20 2 16 36
11 ѴԪ 5 4 6 15 9 9 14 9 32
12 ҹͧʧ 5 2 5 12 11 9 6 8 26
13 ѹ֡ 4 1 2 7 6 6 1 6 13
14 Сء֡ 2 3 1 6 7 6 2 7 15
15 ´ԷѪѧɡ 2 2 0 4 6 10 7 8 23
16 ͺԷ 2 1 4 7 3 8 3 5 14
17 Ҫ 2 0 1 3 3 2 1 0 6
18 ѴԪ 2 0 0 2 2 0 0 0 2
19 عԹ 1 1 3 5 4 4 7 1 15
20 ҭɡԷ ɮҹ 1 0 1 2 4 2 0 0 6
21 Է 1 0 0 1 4 2 0 0 6
22 ҹҢعԷ 1 0 0 1 2 3 3 0 8
23 ʧԷҹó(ҧѡػ) 1 0 0 1 2 3 0 3 5
24 ѰԷҤ 1 0 0 1 1 5 0 0 6
25 ҩҧԷҤ 0 4 2 6 3 11 8 4 22
26 ѪԷҤ 0 3 0 3 5 6 3 8 14
27 ҹҹ 0 2 3 5 5 10 6 13 21
28 з͹Է 0 2 3 5 4 13 5 8 22
29 ѸطԤ 0 1 5 6 4 13 8 12 25
30 عԹԷҤ 0 1 4 5 5 1 0 0 6
31 ҧ͹ʶԵԷҤ 0 1 1 2 4 1 2 4 7
32 ѸǴ 0 1 0 1 1 5 1 1 7
33 Ҿạ֡ 0 0 1 1 2 2 3 8 7
34 ֡ 0 0 0 0 3 1 0 0 4
35 з͹Է 0 0 0 0 2 3 2 0 7
36 ѲʹԷ 0 0 0 0 1 3 3 12 7
37 Ѹҹº 0 0 0 0 1 2 0 0 3
38 ػԷҾ 0 0 0 0 1 0 0 0 1
39 ´ԷѪѧɡ 0 0 0 0 0 2 2 0 4
40 ѪԷҤ 0 0 0 0 0 1 1 0 2
41 Ҿạ֡ 0 0 0 0 0 1 0 0 1
42 ҹҧ͹ʶԵԷҤ 0 0 0 0 0 0 1 0 1
179 142 134 455 439 340 177 240 956