ࢵ鹷֡ ͧ ͧ ͧ Թ ͧᴧ
SELECT im_school.area_type_id AS area_type_id,im_school.province_id AS province_id, im_school.zone_num AS zone_num, im_school.area_sm AS area_sm, 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_team.confirm_status=1 AND im_school.school_id=im_team.school_id GROUP BY im_school.province_id, im_school.zone_num , im_school.area_sm ORDER BY winner DESC, two_rank DESC, three_rank DESC, gold_medal DESC, silver_medal DESC,bronze_medal DESC,join_medal DESC, NUB DESC
1 ʾ. ࢵ 2 2 1 0 3 4 1 2 1 7
2 ʾ. صôԵ ࢵ 1 2 1 0 3 4 1 2 0 7
3 ʾ. ᾧྪ ࢵ 1 1 2 1 4 6 0 2 0 8
4 ʾ. § ࢵ 3 1 0 1 2 4 1 1 1 6
5 ʾ. ط¸ҹ ࢵ 2 1 0 0 1 2 4 1 0 7
6 ʾ. ӻҧ ࢵ 1 1 0 0 1 1 1 0 0 2
7 ʾ. ⢷ ࢵ 2 0 2 0 2 3 1 2 0 6
8 ʾ. ᾧྪ ࢵ 2 0 1 0 1 4 2 1 0 7
9 ʾ. ä ࢵ 2 0 1 0 1 2 2 1 1 5
10 ʾ. ҹ ࢵ 2 0 0 2 2 3 2 3 0 8
11 ʾ. § ࢵ 3 0 0 1 1 4 1 3 0 8
12 ʾ. Ӿٹ ࢵ 1 0 0 1 1 3 0 3 1 6
13 ʾ. ҹ ࢵ 1 0 0 1 1 2 1 3 1 6
14 ʾ. § ࢵ 2 0 0 1 1 2 1 0 0 3
15 ʾ. § ࢵ 5 0 0 0 0 2 1 4 1 7
16 ʾ. ԨԵ ࢵ 1 0 0 0 0 2 1 3 2 6
17 ʾ. صôԵ ࢵ 2 0 0 0 0 1 2 2 0 5
18 ʾ. § ࢵ 2 0 0 0 0 1 2 1 0 4
19 ʾ. Ӿٹ ࢵ 2 0 0 0 0 1 2 0 0 3
20 ʾ. ࢵ 1 0 0 0 0 1 1 2 0 4
21 ʾ. ҡ ࢵ 1 0 0 0 0 1 1 0 0 2
22 ʾ. ࢵ 2 0 0 0 0 1 0 0 0 1
23 ʾ. ɳš ࢵ 3 0 0 0 0 0 4 2 2 6
24 ʾ. ҡ ࢵ 2 0 0 0 0 0 4 0 2 4
25 ʾ. ɳš ࢵ 2 0 0 0 0 0 2 4 0 6
26 ʾ. § ࢵ 6 0 0 0 0 0 2 2 1 4
27 ʾ. ྪúó ࢵ 2 0 0 0 0 0 1 5 0 6
28 ʾ. ä ࢵ 3 0 0 0 0 0 1 4 2 5
29 ʾ. § ࢵ 4 0 0 0 0 0 1 0 0 1
30 ʾ. ӻҧ ࢵ 2 0 0 0 0 0 0 3 0 3
8 8 8 24 54 43 56 15 153