BB[ 17564 ]) 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=25 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 13275 [UserInfoId] => 13275 [1] => 132 [RankedSportEventId] => 132 [2] => 109 [sumUPts] => 109 [3] => 14 [cntUPts] => 14 [4] => 8182 [RankingDivisionDefinitionId] => 8182 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 25 [DivisionId] => 25 [8] => 132 [SportEventId] => 132 [9] => F-23 [DivisionName] => F-23 [10] => Forms * 16-17 * Black * Mixed [Description] => Forms * 16-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 16 [AgeLow] => 16 [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] => 25 [Sequence] => 25 ) Array ( [0] => 17564 [UserInfoId] => 17564 [1] => 132 [RankedSportEventId] => 132 [2] => 66 [sumUPts] => 66 [3] => 6 [cntUPts] => 6 [4] => 8182 [RankingDivisionDefinitionId] => 8182 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 25 [DivisionId] => 25 [8] => 132 [SportEventId] => 132 [9] => F-23 [DivisionName] => F-23 [10] => Forms * 16-17 * Black * Mixed [Description] => Forms * 16-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 16 [AgeLow] => 16 [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] => 25 [Sequence] => 25 ) BB[ 17564 ]) 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=341 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=67 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15044 [UserInfoId] => 15044 [1] => 341 [RankedSportEventId] => 341 [2] => 54 [sumUPts] => 54 [3] => 5 [cntUPts] => 5 [4] => 8224 [RankingDivisionDefinitionId] => 8224 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 67 [DivisionId] => 67 [8] => 341 [SportEventId] => 341 [9] => FS-6 [DivisionName] => FS-6 [10] => Forms - Traditional Soft Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Soft Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 67 [Sequence] => 67 ) Array ( [0] => 17564 [UserInfoId] => 17564 [1] => 341 [RankedSportEventId] => 341 [2] => 48 [sumUPts] => 48 [3] => 4 [cntUPts] => 4 [4] => 8224 [RankingDivisionDefinitionId] => 8224 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 67 [DivisionId] => 67 [8] => 341 [SportEventId] => 341 [9] => FS-6 [DivisionName] => FS-6 [10] => Forms - Traditional Soft Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Soft Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 67 [Sequence] => 67 ) BB[ 17564 ]) 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=128 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15629 [UserInfoId] => 15629 [1] => 110 [RankedSportEventId] => 110 [2] => 84 [sumUPts] => 84 [3] => 7 [cntUPts] => 7 [4] => 8285 [RankingDivisionDefinitionId] => 8285 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 128 [DivisionId] => 128 [8] => 110 [SportEventId] => 110 [9] => S-46 [DivisionName] => S-46 [10] => Sparring - Point * 16-17 * Black * Male [Description] => Sparring - Point * 16-17 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 16 [AgeLow] => 16 [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] => 128 [Sequence] => 128 ) Array ( [0] => 17564 [UserInfoId] => 17564 [1] => 110 [RankedSportEventId] => 110 [2] => 60 [sumUPts] => 60 [3] => 6 [cntUPts] => 6 [4] => 8285 [RankingDivisionDefinitionId] => 8285 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 128 [DivisionId] => 128 [8] => 110 [SportEventId] => 110 [9] => S-46 [DivisionName] => S-46 [10] => Sparring - Point * 16-17 * Black * Male [Description] => Sparring - Point * 16-17 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 16 [AgeLow] => 16 [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] => 128 [Sequence] => 128 ) Standings for Maddox, Jayden


Standings for:
Maddox, Jayden
Event & Description Skill Level Weight (lbs) Points # Events Rank
F-23 Forms
Mixed * 16 - 17 yrs
Black Belt 6662
FS-6 Forms - Traditional Soft Style
Mixed * 12 - 17 yrs
Advanced 4842
S-46 Sparring - Point
Male * 16 - 17 yrs
Black Belt 6062
Total174