BB[ 15374 ]) 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=8 AND rem.RankedSportEventId=132 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=33 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 16917 [UserInfoId] => 16917 [1] => 132 [RankedSportEventId] => 132 [2] => 45 [sumUPts] => 45 [3] => 4 [cntUPts] => 4 [4] => 8190 [RankingDivisionDefinitionId] => 8190 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 33 [DivisionId] => 33 [8] => 132 [SportEventId] => 132 [9] => F-31 [DivisionName] => F-31 [10] => Forms * 32+ * Black * Female [Description] => Forms * 32+ * Black * Female [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [13] => 32 [AgeLow] => 32 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 33 [Sequence] => 33 ) Array ( [0] => 15368 [UserInfoId] => 15368 [1] => 132 [RankedSportEventId] => 132 [2] => 39 [sumUPts] => 39 [3] => 4 [cntUPts] => 4 [4] => 8190 [RankingDivisionDefinitionId] => 8190 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 33 [DivisionId] => 33 [8] => 132 [SportEventId] => 132 [9] => F-31 [DivisionName] => F-31 [10] => Forms * 32+ * Black * Female [Description] => Forms * 32+ * Black * Female [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [13] => 32 [AgeLow] => 32 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 33 [Sequence] => 33 ) Array ( [0] => 19064 [UserInfoId] => 19064 [1] => 132 [RankedSportEventId] => 132 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8190 [RankingDivisionDefinitionId] => 8190 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 33 [DivisionId] => 33 [8] => 132 [SportEventId] => 132 [9] => F-31 [DivisionName] => F-31 [10] => Forms * 32+ * Black * Female [Description] => Forms * 32+ * Black * Female [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [13] => 32 [AgeLow] => 32 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 33 [Sequence] => 33 ) Array ( [0] => 17336 [UserInfoId] => 17336 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8190 [RankingDivisionDefinitionId] => 8190 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 33 [DivisionId] => 33 [8] => 132 [SportEventId] => 132 [9] => F-31 [DivisionName] => F-31 [10] => Forms * 32+ * Black * Female [Description] => Forms * 32+ * Black * Female [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [13] => 32 [AgeLow] => 32 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 33 [Sequence] => 33 ) Array ( [0] => 20320 [UserInfoId] => 20320 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8190 [RankingDivisionDefinitionId] => 8190 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 33 [DivisionId] => 33 [8] => 132 [SportEventId] => 132 [9] => F-31 [DivisionName] => F-31 [10] => Forms * 32+ * Black * Female [Description] => Forms * 32+ * Black * Female [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [13] => 32 [AgeLow] => 32 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 33 [Sequence] => 33 ) Array ( [0] => 12587 [UserInfoId] => 12587 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8190 [RankingDivisionDefinitionId] => 8190 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 33 [DivisionId] => 33 [8] => 132 [SportEventId] => 132 [9] => F-31 [DivisionName] => F-31 [10] => Forms * 32+ * Black * Female [Description] => Forms * 32+ * Black * Female [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [13] => 32 [AgeLow] => 32 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 33 [Sequence] => 33 ) Array ( [0] => 15374 [UserInfoId] => 15374 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8190 [RankingDivisionDefinitionId] => 8190 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 33 [DivisionId] => 33 [8] => 132 [SportEventId] => 132 [9] => F-31 [DivisionName] => F-31 [10] => Forms * 32+ * Black * Female [Description] => Forms * 32+ * Black * Female [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [13] => 32 [AgeLow] => 32 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 33 [Sequence] => 33 ) BB[ 15374 ]) 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=8 AND rem.RankedSportEventId=132 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=36 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15374 [UserInfoId] => 15374 [1] => 132 [RankedSportEventId] => 132 [2] => 147 [sumUPts] => 147 [3] => 15 [cntUPts] => 15 [4] => 8193 [RankingDivisionDefinitionId] => 8193 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 36 [DivisionId] => 36 [8] => 132 [SportEventId] => 132 [9] => F-34 [DivisionName] => F-34 [10] => Forms * 42+ * Black * Female [Description] => Forms * 42+ * Black * Female [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [13] => 42 [AgeLow] => 42 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 36 [Sequence] => 36 ) BB[ 15374 ]) 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=8 AND rem.RankedSportEventId=110 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=146 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15374 [UserInfoId] => 15374 [1] => 110 [RankedSportEventId] => 110 [2] => 167 [sumUPts] => 167 [3] => 16 [cntUPts] => 16 [4] => 8303 [RankingDivisionDefinitionId] => 8303 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 146 [DivisionId] => 146 [8] => 110 [SportEventId] => 110 [9] => S-64 [DivisionName] => S-64 [10] => Sparring - Point * 32+ * Black * Female * Fly (-61.19) [Description] => Sparring - Point * 32+ * Black * Female * Fly (-61.19) [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [13] => 32 [AgeLow] => 32 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => 2 [WeightClass] => 2 [19] => -1 [WeightLow] => -1 [20] => 61.189998626708984 [WeightHigh] => 61.189998626708984 [21] => 146 [Sequence] => 146 ) Standings for Voorhies, Alma


Standings for:
Voorhies, Alma
Event & Description Skill Level Weight (lbs) Points # Events Rank
F-31 Forms
Female * 32+ yrs
Black Belt 1217
F-34 Forms
Female * 42+ yrs
Black Belt 147151
S-64 Sparring - Point
Female * 32+ yrs
Black Belt≤ 134 167161
Total326