select OrgId,TeamId,TeamNa,Sub1RnkCnt,Sub2RnkCnt,CERnkCnt,Sub3RnkCnt,Sub4RnkCnt,Sub5RnkCnt,(Total-Sub3Sum-Sub4Sum-Sub5Sum) as SubSum,(Sub1Rnk1Cnt+Sub2Rnk1Cnt+CERnk1Cnt) as Rnk1Cnt,(Sub1Rnk2Cnt+Sub2Rnk2Cnt+CERnk2Cnt) as Rnk2Cnt,(Sub1Rnk3Cnt+Sub2Rnk3Cnt+CERnk3Cnt) as Rnk3Cnt,(Sub1Rnk4Cnt+Sub2Rnk4Cnt+CERnk4Cnt) as Rnk4Cnt,(Sub1Rnk5Cnt+Sub2Rnk5Cnt+CERnk5Cnt) as Rnk5Cnt,(Sub1Rnk6Cnt+Sub2Rnk6Cnt+CERnk6Cnt) as Rnk6Cnt,(Sub1Rnk7Cnt+Sub2Rnk7Cnt+CERnk7Cnt) as Rnk7Cnt,(Sub1Rnk8Cnt+Sub2Rnk8Cnt+CERnk8Cnt) as Rnk8Cnt,(0+Sub1Rnk1Cnt*1+Sub2Rnk1Cnt*1+CERnk1Cnt*1+Sub1Rnk2Cnt*1+Sub2Rnk2Cnt*1+CERnk2Cnt*1+Sub1Rnk3Cnt*1+Sub2Rnk3Cnt*1+CERnk3Cnt*1+Sub1Rnk4Cnt*1+Sub2Rnk4Cnt*1+CERnk4Cnt*1+Sub1Rnk5Cnt*1+Sub2Rnk5Cnt*1+CERnk5Cnt*1+Sub1Rnk6Cnt*1+Sub2Rnk6Cnt*1+CERnk6Cnt*1+Sub1Rnk7Cnt*1+Sub2Rnk7Cnt*1+CERnk7Cnt*1+Sub1Rnk8Cnt*1+Sub2Rnk8Cnt*1+CERnk8Cnt*1) as RnkCnt,Group_Num from `team21` where Group_Num in () and Total>0 order by (Sub1Rnk1Cnt*1+Sub2Rnk1Cnt*1+CERnk1Cnt*1) DESC,(Sub1Rnk2Cnt*1+Sub2Rnk2Cnt*1+CERnk2Cnt*1) DESC,(Sub1Rnk3Cnt*1+Sub2Rnk3Cnt*1+CERnk3Cnt*1) DESC,(Sub1Rnk4Cnt*1+Sub2Rnk4Cnt*1+CERnk4Cnt*1) DESC,(Sub1Rnk5Cnt*1+Sub2Rnk5Cnt*1+CERnk5Cnt*1) DESC,(Sub1Rnk6Cnt*1+Sub2Rnk6Cnt*1+CERnk6Cnt*1) DESC,(Sub1Rnk7Cnt*1+Sub2Rnk7Cnt*1+CERnk7Cnt*1) DESC,(Sub1Rnk8Cnt*1+Sub2Rnk8Cnt*1+CERnk8Cnt*1) DESC
程式運行錯誤,於《rank_stat.php》程式碼第 1875 行。