ػѹѺ ­ҧ ʾ. ࢵ 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=24 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 Ѵ輴اࢵ 27 0 0 27 27 0 0 0 27
2 ͹ҪԷ 26 0 0 26 26 0 0 0 26
3 ͹غŹ 20 0 0 20 20 0 0 0 20
4 Ъػ 12 0 0 12 12 0 0 0 12
5 Ѵ˹ѡ 12 0 0 12 12 0 0 0 12
6 ʴ 10 0 0 10 10 0 0 0 10
7 ʧԷ 8 0 0 8 8 0 0 0 8
8 Ѵ 7 0 0 7 7 0 0 0 7
9 ùԷ 5 ҹķ 7 0 0 7 7 0 0 0 7
10 ѴزԻҧ 7 0 0 7 7 0 0 0 7
11 Ѵõ 7 0 0 7 7 0 0 0 7
12 Ѵҧ˧ 6 0 0 6 6 0 0 0 6
13 ط 5 0 0 5 5 0 0 0 5
14 ҹķԷ 4 0 0 4 4 0 0 0 4
15 Ѵѹ 4 0 0 4 4 0 0 0 4
16 Ѵ⪵ԡ 4 0 0 4 4 0 0 0 4
17 Ѵ⡮ 3 0 0 3 3 0 0 0 3
18 Ѵҡ 3 0 0 3 3 0 0 0 3
19 ͹غźҧ 3 0 0 3 3 0 0 0 3
20 ѭ֡ 2 0 0 2 2 0 0 0 2
21 ҷ»Ъػ 2 0 0 2 2 0 0 0 2
22 ѴǢѭ 2 0 0 2 2 0 0 0 2
23 Ѵҧù͡ 2 0 0 2 2 0 0 0 2
24 ѰԷ 55 2 0 0 2 2 0 0 0 2
25 Ѵҧ 1 0 0 1 1 0 0 0 1
26 ùԷ 1 Ѵͧ 1 0 0 1 1 0 0 0 1
27 Ѵѹ 1 0 0 1 1 0 0 0 1
28 ѴЪѧä 1 0 0 1 1 0 0 0 1
29 Ѵҧ 1 0 0 1 1 0 0 0 1
30 ѴҹҺح 1 0 0 1 1 0 0 0 1
191 0 0 191 191 0 0 0 191