BB[ 15007 ]) 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=95 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=5 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 17111 [UserInfoId] => 17111 [1] => 95 [RankedSportEventId] => 95 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8328 [RankingDivisionDefinitionId] => 8328 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 5 [DivisionId] => 5 [8] => 95 [SportEventId] => 95 [9] => BCO-4 [DivisionName] => BCO-4 [10] => Breaking - Creative Open * 18+ yrs * Beg/Int/Adv * Female [Description] => Breaking - Creative Open * 18+ yrs * Beg/Int/Adv * Female [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [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] => 5 [Sequence] => 5 ) Array ( [0] => 15007 [UserInfoId] => 15007 [1] => 95 [RankedSportEventId] => 95 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8328 [RankingDivisionDefinitionId] => 8328 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 5 [DivisionId] => 5 [8] => 95 [SportEventId] => 95 [9] => BCO-4 [DivisionName] => BCO-4 [10] => Breaking - Creative Open * 18+ yrs * Beg/Int/Adv * Female [Description] => Breaking - Creative Open * 18+ yrs * Beg/Int/Adv * Female [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [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] => 5 [Sequence] => 5 ) BB[ 15007 ]) 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=15 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15069 [UserInfoId] => 15069 [1] => 97 [RankedSportEventId] => 97 [2] => 110 [sumUPts] => 110 [3] => 10 [cntUPts] => 10 [4] => 8338 [RankingDivisionDefinitionId] => 8338 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 15 [DivisionId] => 15 [8] => 97 [SportEventId] => 97 [9] => BPWE-6 [DivisionName] => BPWE-6 [10] => Breaking - Power Wood Elbow * 18+ yrs * Beg/Int/Adv * Female [Description] => Breaking - Power Wood Elbow * 18+ yrs * Beg/Int/Adv * Female [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [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] => 15 [Sequence] => 15 ) Array ( [0] => 17111 [UserInfoId] => 17111 [1] => 97 [RankedSportEventId] => 97 [2] => 54 [sumUPts] => 54 [3] => 5 [cntUPts] => 5 [4] => 8338 [RankingDivisionDefinitionId] => 8338 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 15 [DivisionId] => 15 [8] => 97 [SportEventId] => 97 [9] => BPWE-6 [DivisionName] => BPWE-6 [10] => Breaking - Power Wood Elbow * 18+ yrs * Beg/Int/Adv * Female [Description] => Breaking - Power Wood Elbow * 18+ yrs * Beg/Int/Adv * Female [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [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] => 15 [Sequence] => 15 ) Array ( [0] => 15007 [UserInfoId] => 15007 [1] => 97 [RankedSportEventId] => 97 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8338 [RankingDivisionDefinitionId] => 8338 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 15 [DivisionId] => 15 [8] => 97 [SportEventId] => 97 [9] => BPWE-6 [DivisionName] => BPWE-6 [10] => Breaking - Power Wood Elbow * 18+ yrs * Beg/Int/Adv * Female [Description] => Breaking - Power Wood Elbow * 18+ yrs * Beg/Int/Adv * Female [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [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] => 15 [Sequence] => 15 ) BB[ 15007 ]) 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=25 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15007 [UserInfoId] => 15007 [1] => 98 [RankedSportEventId] => 98 [2] => 84 [sumUPts] => 84 [3] => 7 [cntUPts] => 7 [4] => 8348 [RankingDivisionDefinitionId] => 8348 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 25 [DivisionId] => 25 [8] => 98 [SportEventId] => 98 [9] => BPWF-6 [DivisionName] => BPWF-6 [10] => Breaking - Power Wood Foot * 18+ yrs * Beg/Int/Adv * Female [Description] => Breaking - Power Wood Foot * 18+ yrs * Beg/Int/Adv * Female [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [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] => 25 [Sequence] => 25 ) BB[ 15007 ]) 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=96 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=35 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 17111 [UserInfoId] => 17111 [1] => 96 [RankedSportEventId] => 96 [2] => 48 [sumUPts] => 48 [3] => 4 [cntUPts] => 4 [4] => 8358 [RankingDivisionDefinitionId] => 8358 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 35 [DivisionId] => 35 [8] => 96 [SportEventId] => 96 [9] => BPWH-6 [DivisionName] => BPWH-6 [10] => Breaking - Power Wood Hand * 18+ yrs * Beg/Int/Adv * Female [Description] => Breaking - Power Wood Hand * 18+ yrs * Beg/Int/Adv * Female [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [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] => 35 [Sequence] => 35 ) Array ( [0] => 15007 [UserInfoId] => 15007 [1] => 96 [RankedSportEventId] => 96 [2] => 36 [sumUPts] => 36 [3] => 3 [cntUPts] => 3 [4] => 8358 [RankingDivisionDefinitionId] => 8358 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 35 [DivisionId] => 35 [8] => 96 [SportEventId] => 96 [9] => BPWH-6 [DivisionName] => BPWH-6 [10] => Breaking - Power Wood Hand * 18+ yrs * Beg/Int/Adv * Female [Description] => Breaking - Power Wood Hand * 18+ yrs * Beg/Int/Adv * Female [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [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] => 35 [Sequence] => 35 ) Standings for Fields, Leslie


Standings for:
Fields, Leslie
Event & Description Skill Level Weight (lbs) Points # Events Rank
BCO-4 Breaking - Creative Open
Female * 18+ yrs
Beginner 1212
BPWE-6 Breaking - Power Wood - Elbow
Mixed * 18+ yrs
Beginner 1223
BPWF-6 Breaking - Power Wood - Foot
Mixed * 18+ yrs
Beginner 8471
BPWH-6 Breaking - Power Wood - Hand
Mixed * 18+ yrs
Beginner 3632
Total144