BB[ 15008 ]) 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=13 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 20163 [UserInfoId] => 20163 [1] => 97 [RankedSportEventId] => 97 [2] => 75 [sumUPts] => 75 [3] => 7 [cntUPts] => 7 [4] => 8336 [RankingDivisionDefinitionId] => 8336 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 13 [DivisionId] => 13 [8] => 97 [SportEventId] => 97 [9] => BPWE-4 [DivisionName] => BPWE-4 [10] => Breaking - Power Wood Elbow * 13-17 yrs * Beg/Int/Adv * Mixed [Description] => Breaking - Power Wood Elbow * 13-17 yrs * Beg/Int/Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 13 [AgeLow] => 13 [14] => 17 [AgeHigh] => 17 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 13 [Sequence] => 13 ) Array ( [0] => 16945 [UserInfoId] => 16945 [1] => 97 [RankedSportEventId] => 97 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [4] => 8336 [RankingDivisionDefinitionId] => 8336 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 13 [DivisionId] => 13 [8] => 97 [SportEventId] => 97 [9] => BPWE-4 [DivisionName] => BPWE-4 [10] => Breaking - Power Wood Elbow * 13-17 yrs * Beg/Int/Adv * Mixed [Description] => Breaking - Power Wood Elbow * 13-17 yrs * Beg/Int/Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 13 [AgeLow] => 13 [14] => 17 [AgeHigh] => 17 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 13 [Sequence] => 13 ) Array ( [0] => 13276 [UserInfoId] => 13276 [1] => 97 [RankedSportEventId] => 97 [2] => 16 [sumUPts] => 16 [3] => 2 [cntUPts] => 2 [4] => 8336 [RankingDivisionDefinitionId] => 8336 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 13 [DivisionId] => 13 [8] => 97 [SportEventId] => 97 [9] => BPWE-4 [DivisionName] => BPWE-4 [10] => Breaking - Power Wood Elbow * 13-17 yrs * Beg/Int/Adv * Mixed [Description] => Breaking - Power Wood Elbow * 13-17 yrs * Beg/Int/Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 13 [AgeLow] => 13 [14] => 17 [AgeHigh] => 17 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 13 [Sequence] => 13 ) Array ( [0] => 15008 [UserInfoId] => 15008 [1] => 97 [RankedSportEventId] => 97 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8336 [RankingDivisionDefinitionId] => 8336 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 13 [DivisionId] => 13 [8] => 97 [SportEventId] => 97 [9] => BPWE-4 [DivisionName] => BPWE-4 [10] => Breaking - Power Wood Elbow * 13-17 yrs * Beg/Int/Adv * Mixed [Description] => Breaking - Power Wood Elbow * 13-17 yrs * Beg/Int/Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 13 [AgeLow] => 13 [14] => 17 [AgeHigh] => 17 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 13 [Sequence] => 13 ) BB[ 15008 ]) 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=98 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=23 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15008 [UserInfoId] => 15008 [1] => 98 [RankedSportEventId] => 98 [2] => 106 [sumUPts] => 106 [3] => 12 [cntUPts] => 12 [4] => 8346 [RankingDivisionDefinitionId] => 8346 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 23 [DivisionId] => 23 [8] => 98 [SportEventId] => 98 [9] => BPWF-4 [DivisionName] => BPWF-4 [10] => Breaking - Power Wood Foot * 13-17 yrs * Beg/Int/Adv * Mixed [Description] => Breaking - Power Wood Foot * 13-17 yrs * Beg/Int/Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 13 [AgeLow] => 13 [14] => 17 [AgeHigh] => 17 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 23 [Sequence] => 23 ) Standings for Newcomb, Anna


Standings for:
Newcomb, Anna
Event & Description Skill Level Weight (lbs) Points # Events Rank
BPWE-4 Breaking - Power Wood - Elbow
Mixed * 13 - 17 yrs
Beginner 1524
BPWF-4 Breaking - Power Wood - Foot
Mixed * 13 - 17 yrs
Beginner 106121
Total121