BB[ 16009 ]) SELECT UserInfoId, rem.RankedSportEventId, sum(Points) as sumUPts, count(Points) as cntUPts, rdd.* FROM UserRankingPoints urp, RankingEventMappings rem, RankingDivisionDefinitions rdd WHERE urp.SportEventId=rem.SportEventId AND urp.RankingSystemId=9 AND rem.RankedSportEventId=275 AND urp.RankingSystemId=rdd.RankingSystemDefinitionId AND urp.TournamentId in ( 145,146,147,148,149,150,151,152,153,154,155,156,157,159,161,162,163,164,165,166,167,168,169,170,171 ) AND urp.RankingDivisionId=rdd.DivisionId AND urp.RankingDivisionId=45 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 13726 [UserInfoId] => 13726 [1] => 275 [RankedSportEventId] => 275 [2] => 63 [sumUPts] => 63 [3] => 7 [cntUPts] => 7 [4] => 8368 [RankingDivisionDefinitionId] => 8368 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 275 [SportEventId] => 275 [9] => BPCE-6 [DivisionName] => BPCE-6 [10] => Breaking - Power Concrete Elbow * 18+ yrs * Black * Male [Description] => Breaking - Power Concrete Elbow * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 14749 [UserInfoId] => 14749 [1] => 275 [RankedSportEventId] => 275 [2] => 59 [sumUPts] => 59 [3] => 6 [cntUPts] => 6 [4] => 8368 [RankingDivisionDefinitionId] => 8368 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 275 [SportEventId] => 275 [9] => BPCE-6 [DivisionName] => BPCE-6 [10] => Breaking - Power Concrete Elbow * 18+ yrs * Black * Male [Description] => Breaking - Power Concrete Elbow * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 16009 [UserInfoId] => 16009 [1] => 275 [RankedSportEventId] => 275 [2] => 33 [sumUPts] => 33 [3] => 3 [cntUPts] => 3 [4] => 8368 [RankingDivisionDefinitionId] => 8368 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 275 [SportEventId] => 275 [9] => BPCE-6 [DivisionName] => BPCE-6 [10] => Breaking - Power Concrete Elbow * 18+ yrs * Black * Male [Description] => Breaking - Power Concrete Elbow * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) BB[ 16009 ]) SELECT UserInfoId, rem.RankedSportEventId, sum(Points) as sumUPts, count(Points) as cntUPts, rdd.* FROM UserRankingPoints urp, RankingEventMappings rem, RankingDivisionDefinitions rdd WHERE urp.SportEventId=rem.SportEventId AND urp.RankingSystemId=9 AND rem.RankedSportEventId=97 AND urp.RankingSystemId=rdd.RankingSystemDefinitionId AND urp.TournamentId in ( 145,146,147,148,149,150,151,152,153,154,155,156,157,159,161,162,163,164,165,166,167,168,169,170,171 ) AND urp.RankingDivisionId=rdd.DivisionId AND urp.RankingDivisionId=18 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19068 [UserInfoId] => 19068 [1] => 97 [RankedSportEventId] => 97 [2] => 51 [sumUPts] => 51 [3] => 5 [cntUPts] => 5 [4] => 8341 [RankingDivisionDefinitionId] => 8341 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 18 [DivisionId] => 18 [8] => 97 [SportEventId] => 97 [9] => BPWE-9 [DivisionName] => BPWE-9 [10] => Breaking - Power Wood Elbow * 18+ yrs * Black * Male [Description] => Breaking - Power Wood Elbow * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 18 [Sequence] => 18 ) Array ( [0] => 16009 [UserInfoId] => 16009 [1] => 97 [RankedSportEventId] => 97 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8341 [RankingDivisionDefinitionId] => 8341 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 18 [DivisionId] => 18 [8] => 97 [SportEventId] => 97 [9] => BPWE-9 [DivisionName] => BPWE-9 [10] => Breaking - Power Wood Elbow * 18+ yrs * Black * Male [Description] => Breaking - Power Wood Elbow * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 18 [Sequence] => 18 ) Standings for Wells, Sion Maurice


Standings for:
Wells, Sion Maurice
Event & Description Skill Level Weight (lbs) Points # Events Rank
BPCE-6 Breaking - Power Concrete - Elbow
Mixed * 18+ yrs
Black Belt 3333
BPWE-9 Breaking - Power Wood - Elbow
Mixed * 18+ yrs
Black Belt 1212
Total45