BB[ 15468 ]) 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=34 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 13315 [UserInfoId] => 13315 [1] => 132 [RankedSportEventId] => 132 [2] => 36 [sumUPts] => 36 [3] => 3 [cntUPts] => 3 [4] => 8191 [RankingDivisionDefinitionId] => 8191 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 132 [SportEventId] => 132 [9] => F-32 [DivisionName] => F-32 [10] => Forms * 18-34 * Black * Male [Description] => Forms * 18-34 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [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] => 34 [Sequence] => 34 ) Array ( [0] => 17036 [UserInfoId] => 17036 [1] => 132 [RankedSportEventId] => 132 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8191 [RankingDivisionDefinitionId] => 8191 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 132 [SportEventId] => 132 [9] => F-32 [DivisionName] => F-32 [10] => Forms * 18-34 * Black * Male [Description] => Forms * 18-34 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [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] => 34 [Sequence] => 34 ) Array ( [0] => 15366 [UserInfoId] => 15366 [1] => 132 [RankedSportEventId] => 132 [2] => 13 [sumUPts] => 13 [3] => 2 [cntUPts] => 2 [4] => 8191 [RankingDivisionDefinitionId] => 8191 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 132 [SportEventId] => 132 [9] => F-32 [DivisionName] => F-32 [10] => Forms * 18-34 * Black * Male [Description] => Forms * 18-34 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [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] => 34 [Sequence] => 34 ) Array ( [0] => 15468 [UserInfoId] => 15468 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8191 [RankingDivisionDefinitionId] => 8191 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 132 [SportEventId] => 132 [9] => F-32 [DivisionName] => F-32 [10] => Forms * 18-34 * Black * Male [Description] => Forms * 18-34 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [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] => 34 [Sequence] => 34 ) BB[ 15468 ]) 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=42 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=60 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 14998 [UserInfoId] => 14998 [1] => 42 [RankedSportEventId] => 42 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8217 [RankingDivisionDefinitionId] => 8217 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 60 [DivisionId] => 60 [8] => 340 [SportEventId] => 340 [9] => FH-10 [DivisionName] => FH-10 [10] => Forms - Traditional Hard Style * 18-34 * Black * Mixed [Description] => Forms - Traditional Hard Style * 18-34 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [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] => 60 [Sequence] => 60 ) Array ( [0] => 15468 [UserInfoId] => 15468 [1] => 42 [RankedSportEventId] => 42 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8217 [RankingDivisionDefinitionId] => 8217 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 60 [DivisionId] => 60 [8] => 340 [SportEventId] => 340 [9] => FH-10 [DivisionName] => FH-10 [10] => Forms - Traditional Hard Style * 18-34 * Black * Mixed [Description] => Forms - Traditional Hard Style * 18-34 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [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] => 60 [Sequence] => 60 ) BB[ 15468 ]) 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=340 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=60 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15468 [UserInfoId] => 15468 [1] => 340 [RankedSportEventId] => 340 [2] => 186 [sumUPts] => 186 [3] => 18 [cntUPts] => 18 [4] => 8217 [RankingDivisionDefinitionId] => 8217 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 60 [DivisionId] => 60 [8] => 340 [SportEventId] => 340 [9] => FH-10 [DivisionName] => FH-10 [10] => Forms - Traditional Hard Style * 18-34 * Black * Mixed [Description] => Forms - Traditional Hard Style * 18-34 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [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] => 60 [Sequence] => 60 ) BB[ 15468 ]) 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=140 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 17959 [UserInfoId] => 17959 [1] => 110 [RankedSportEventId] => 110 [2] => 69 [sumUPts] => 69 [3] => 6 [cntUPts] => 6 [4] => 8297 [RankingDivisionDefinitionId] => 8297 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 140 [DivisionId] => 140 [8] => 110 [SportEventId] => 110 [9] => S-58 [DivisionName] => S-58 [10] => Sparring - Point * 18-34 * Advanced * Male * Heavy (84.32+) [Description] => Sparring - Point * 18-34 * Advanced * Male * Heavy (84.32+) [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => 10 [WeightClass] => 10 [19] => 84.31999969482422 [WeightLow] => 84.31999969482422 [20] => -1 [WeightHigh] => -1 [21] => 140 [Sequence] => 140 ) Array ( [0] => 20344 [UserInfoId] => 20344 [1] => 110 [RankedSportEventId] => 110 [2] => 33 [sumUPts] => 33 [3] => 3 [cntUPts] => 3 [4] => 8297 [RankingDivisionDefinitionId] => 8297 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 140 [DivisionId] => 140 [8] => 110 [SportEventId] => 110 [9] => S-58 [DivisionName] => S-58 [10] => Sparring - Point * 18-34 * Advanced * Male * Heavy (84.32+) [Description] => Sparring - Point * 18-34 * Advanced * Male * Heavy (84.32+) [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => 10 [WeightClass] => 10 [19] => 84.31999969482422 [WeightLow] => 84.31999969482422 [20] => -1 [WeightHigh] => -1 [21] => 140 [Sequence] => 140 ) Array ( [0] => 15468 [UserInfoId] => 15468 [1] => 110 [RankedSportEventId] => 110 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8297 [RankingDivisionDefinitionId] => 8297 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 140 [DivisionId] => 140 [8] => 110 [SportEventId] => 110 [9] => S-58 [DivisionName] => S-58 [10] => Sparring - Point * 18-34 * Advanced * Male * Heavy (84.32+) [Description] => Sparring - Point * 18-34 * Advanced * Male * Heavy (84.32+) [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => 10 [WeightClass] => 10 [19] => 84.31999969482422 [WeightLow] => 84.31999969482422 [20] => -1 [WeightHigh] => -1 [21] => 140 [Sequence] => 140 ) BB[ 15468 ]) 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=150 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15468 [UserInfoId] => 15468 [1] => 110 [RankedSportEventId] => 110 [2] => 203 [sumUPts] => 203 [3] => 20 [cntUPts] => 20 [4] => 8307 [RankingDivisionDefinitionId] => 8307 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 150 [DivisionId] => 150 [8] => 110 [SportEventId] => 110 [9] => S-68 [DivisionName] => S-68 [10] => Sparring - Point * 18-34 * Black * Male * Heavy (84.32+) [Description] => Sparring - Point * 18-34 * Black * Male * Heavy (84.32+) [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => 10 [WeightClass] => 10 [19] => 84.31999969482422 [WeightLow] => 84.31999969482422 [20] => -1 [WeightHigh] => -1 [21] => 150 [Sequence] => 150 ) Standings for Tyler, Matt


Standings for:
Tyler, Matt
Event & Description Skill Level Weight (lbs) Points # Events Rank
F-32 Forms
Male * 18 - 34 yrs
Black Belt 1214
FH-10 Forms - Traditional
Mixed * 18 - 34 yrs
Black Belt 912
FH-10 Forms - Traditional Hard Style
Mixed * 18 - 34 yrs
Black Belt 186181
S-58 Sparring - Point
Male * 18 - 34 yrs
Advanced15683.5199432+ 2423
S-68 Sparring - Point
Male * 18 - 34 yrs
Black Belt15683.5199432+ 203201
Total434