BB[ 14939 ]) 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=21 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15360 [UserInfoId] => 15360 [1] => 132 [RankedSportEventId] => 132 [2] => 130 [sumUPts] => 130 [3] => 14 [cntUPts] => 14 [4] => 8178 [RankingDivisionDefinitionId] => 8178 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 21 [DivisionId] => 21 [8] => 132 [SportEventId] => 132 [9] => F-19 [DivisionName] => F-19 [10] => Forms * 14-15 * Black * Mixed [Description] => Forms * 14-15 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [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] => 21 [Sequence] => 21 ) Array ( [0] => 17073 [UserInfoId] => 17073 [1] => 132 [RankedSportEventId] => 132 [2] => 121 [sumUPts] => 121 [3] => 16 [cntUPts] => 16 [4] => 8178 [RankingDivisionDefinitionId] => 8178 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 21 [DivisionId] => 21 [8] => 132 [SportEventId] => 132 [9] => F-19 [DivisionName] => F-19 [10] => Forms * 14-15 * Black * Mixed [Description] => Forms * 14-15 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [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] => 21 [Sequence] => 21 ) Array ( [0] => 14939 [UserInfoId] => 14939 [1] => 132 [RankedSportEventId] => 132 [2] => 100 [sumUPts] => 100 [3] => 9 [cntUPts] => 9 [4] => 8178 [RankingDivisionDefinitionId] => 8178 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 21 [DivisionId] => 21 [8] => 132 [SportEventId] => 132 [9] => F-19 [DivisionName] => F-19 [10] => Forms * 14-15 * Black * Mixed [Description] => Forms * 14-15 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [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] => 21 [Sequence] => 21 ) BB[ 14939 ]) 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=277 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] => 14939 [UserInfoId] => 14939 [1] => 277 [RankedSportEventId] => 277 [2] => 97 [sumUPts] => 97 [3] => 9 [cntUPts] => 9 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [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] => 45 [Sequence] => 45 ) BB[ 14939 ]) 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=124 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 17073 [UserInfoId] => 17073 [1] => 110 [RankedSportEventId] => 110 [2] => 145 [sumUPts] => 145 [3] => 17 [cntUPts] => 17 [4] => 8281 [RankingDivisionDefinitionId] => 8281 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 124 [DivisionId] => 124 [8] => 110 [SportEventId] => 110 [9] => S-42 [DivisionName] => S-42 [10] => Sparring - Point * 14-15 * Black * Male [Description] => Sparring - Point * 14-15 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [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] => 124 [Sequence] => 124 ) Array ( [0] => 15282 [UserInfoId] => 15282 [1] => 110 [RankedSportEventId] => 110 [2] => 88 [sumUPts] => 88 [3] => 10 [cntUPts] => 10 [4] => 8281 [RankingDivisionDefinitionId] => 8281 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 124 [DivisionId] => 124 [8] => 110 [SportEventId] => 110 [9] => S-42 [DivisionName] => S-42 [10] => Sparring - Point * 14-15 * Black * Male [Description] => Sparring - Point * 14-15 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [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] => 124 [Sequence] => 124 ) Array ( [0] => 14939 [UserInfoId] => 14939 [1] => 110 [RankedSportEventId] => 110 [2] => 70 [sumUPts] => 70 [3] => 8 [cntUPts] => 8 [4] => 8281 [RankingDivisionDefinitionId] => 8281 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 124 [DivisionId] => 124 [8] => 110 [SportEventId] => 110 [9] => S-42 [DivisionName] => S-42 [10] => Sparring - Point * 14-15 * Black * Male [Description] => Sparring - Point * 14-15 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [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] => 124 [Sequence] => 124 ) Standings for Nowlin, Kamron Dandre


Standings for:
Nowlin, Kamron Dandre
Event & Description Skill Level Weight (lbs) Points # Events Rank
F-19 Forms
Mixed * 14 - 15 yrs
Black Belt 10093
M-8 Forms - Specialty
Mixed * 12 - 17 yrs
Black Belt 9791
S-42 Sparring - Point
Male * 14 - 15 yrs
Black Belt 7083
Total267