·Õè
âçàÃÕ¹
ª¹ÐàÅÔÈ
Ãͧ ñ
Ãͧ ò
ÃÇÁ
·Í§
à§Ô¹
·Í§á´§
à¢éÒÃèÇÁ
ÃÇÁ
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
ÃÇÁ
0
0
0
0
0
0
0
0
0