ػѹѺ ­ҧ ʾ. ࢵ 35 (ӻҧ,Ӿٹ) [ ʾ.ӻҧ 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=52 AND im_school.area_type_id=2 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 حҷԷ 48 27 16 91 86 11 1 1 98
2 ӻҧҳ 37 35 16 88 84 13 1 3 98
3 ش֡ҾѲҡҧ칤 16 6 14 36 42 10 5 6 57
4 ЪѰس 10 10 8 28 34 6 4 1 44
5 Է 8 10 7 25 27 5 5 3 37
6 §žԷҤ 6 2 3 11 12 2 1 0 15
7 ѭӻҧ 5 9 10 24 19 18 1 1 38
8 ҧѵԷ 4 9 13 26 21 5 4 2 30
9 ֡ʧԵ 4 4 2 10 15 11 9 9 35
10 ʴǹҧԷ 3 6 6 15 14 13 2 0 29
11 ѸԷ 3 5 6 14 19 8 1 4 28
12 ʺҧԷ 2 2 1 5 6 2 0 0 8
13 ͹Է 2 1 1 4 4 2 1 2 7
14 ѹԷ 2 1 1 4 4 2 1 1 7
15 1 5 5 11 18 9 2 2 29
16 Ԫҹ 1 2 1 4 5 4 3 0 12
17 ǧԷ Ѫѧɡ 1 1 1 3 5 7 1 1 13
18 Է 1 1 1 3 4 1 2 1 7
19 ЪҪԷ 1 1 0 2 5 1 0 0 6
20 हह 1 1 0 2 3 1 2 0 6
21 ЪԷ 1 0 3 4 4 1 2 2 7
22 طԷҡ 1 0 2 3 4 1 0 0 5
23 ʹͧԷ 1 0 2 3 3 0 0 0 3
24 اԷ (Ѵպحͧ) 1 0 1 2 5 2 2 0 9
25 Ѹʵ 1 0 1 2 1 2 0 0 3
26 Է 1 0 0 1 4 0 1 0 5
27 ͧԷ 0 2 0 2 4 1 0 1 5
28 ԹԨԷ 0 1 1 2 3 5 0 0 8
29 ԰Է (Ѵҧ) 0 0 0 0 3 1 0 0 4
30 ķԷ 0 0 0 0 0 0 0 0 0
162 141 122 425 458 144 51 40 653