BB[ 13275 ]) 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=299 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=158 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 13275 [UserInfoId] => 13275 [1] => 299 [RankedSportEventId] => 299 [2] => 160 [sumUPts] => 160 [3] => 15 [cntUPts] => 15 [4] => 8315 [RankingDivisionDefinitionId] => 8315 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 158 [DivisionId] => 158 [8] => 299 [SportEventId] => 299 [9] => B-3 [DivisionName] => B-3 [10] => Breaking - Power Wood - Hand/Elbow * <= 17 * Black * Mixed [Description] => Breaking - Power Wood - Hand/Elbow * <= 17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [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] => 158 [Sequence] => 158 ) BB[ 13275 ]) 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 ) Array ( [0] => 15282 [UserInfoId] => 15282 [1] => 132 [RankedSportEventId] => 132 [2] => 63 [sumUPts] => 63 [3] => 8 [cntUPts] => 8 [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] => 13275 [UserInfoId] => 13275 [1] => 132 [RankedSportEventId] => 132 [2] => 21 [sumUPts] => 21 [3] => 3 [cntUPts] => 3 [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[ 13275 ]) 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=24 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 13699 [UserInfoId] => 13699 [1] => 132 [RankedSportEventId] => 132 [2] => 96 [sumUPts] => 96 [3] => 8 [cntUPts] => 8 [4] => 8181 [RankingDivisionDefinitionId] => 8181 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 132 [SportEventId] => 132 [9] => F-22 [DivisionName] => F-22 [10] => Forms * 16-17 * Advanced * Mixed [Description] => Forms * 16-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 16 [AgeLow] => 16 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) Array ( [0] => 14879 [UserInfoId] => 14879 [1] => 132 [RankedSportEventId] => 132 [2] => 60 [sumUPts] => 60 [3] => 6 [cntUPts] => 6 [4] => 8181 [RankingDivisionDefinitionId] => 8181 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 132 [SportEventId] => 132 [9] => F-22 [DivisionName] => F-22 [10] => Forms * 16-17 * Advanced * Mixed [Description] => Forms * 16-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 16 [AgeLow] => 16 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) Array ( [0] => 13539 [UserInfoId] => 13539 [1] => 132 [RankedSportEventId] => 132 [2] => 39 [sumUPts] => 39 [3] => 4 [cntUPts] => 4 [4] => 8181 [RankingDivisionDefinitionId] => 8181 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 132 [SportEventId] => 132 [9] => F-22 [DivisionName] => F-22 [10] => Forms * 16-17 * Advanced * Mixed [Description] => Forms * 16-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 16 [AgeLow] => 16 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) Array ( [0] => 17083 [UserInfoId] => 17083 [1] => 132 [RankedSportEventId] => 132 [2] => 36 [sumUPts] => 36 [3] => 4 [cntUPts] => 4 [4] => 8181 [RankingDivisionDefinitionId] => 8181 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 132 [SportEventId] => 132 [9] => F-22 [DivisionName] => F-22 [10] => Forms * 16-17 * Advanced * Mixed [Description] => Forms * 16-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 16 [AgeLow] => 16 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) Array ( [0] => 18216 [UserInfoId] => 18216 [1] => 132 [RankedSportEventId] => 132 [2] => 24 [sumUPts] => 24 [3] => 3 [cntUPts] => 3 [4] => 8181 [RankingDivisionDefinitionId] => 8181 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 132 [SportEventId] => 132 [9] => F-22 [DivisionName] => F-22 [10] => Forms * 16-17 * Advanced * Mixed [Description] => Forms * 16-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 16 [AgeLow] => 16 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) Array ( [0] => 19804 [UserInfoId] => 19804 [1] => 132 [RankedSportEventId] => 132 [2] => 24 [sumUPts] => 24 [3] => 3 [cntUPts] => 3 [4] => 8181 [RankingDivisionDefinitionId] => 8181 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 132 [SportEventId] => 132 [9] => F-22 [DivisionName] => F-22 [10] => Forms * 16-17 * Advanced * Mixed [Description] => Forms * 16-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 16 [AgeLow] => 16 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) Array ( [0] => 20367 [UserInfoId] => 20367 [1] => 132 [RankedSportEventId] => 132 [2] => 24 [sumUPts] => 24 [3] => 3 [cntUPts] => 3 [4] => 8181 [RankingDivisionDefinitionId] => 8181 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 132 [SportEventId] => 132 [9] => F-22 [DivisionName] => F-22 [10] => Forms * 16-17 * Advanced * Mixed [Description] => Forms * 16-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 16 [AgeLow] => 16 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) Array ( [0] => 21662 [UserInfoId] => 21662 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8181 [RankingDivisionDefinitionId] => 8181 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 132 [SportEventId] => 132 [9] => F-22 [DivisionName] => F-22 [10] => Forms * 16-17 * Advanced * Mixed [Description] => Forms * 16-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 16 [AgeLow] => 16 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) Array ( [0] => 13513 [UserInfoId] => 13513 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8181 [RankingDivisionDefinitionId] => 8181 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 132 [SportEventId] => 132 [9] => F-22 [DivisionName] => F-22 [10] => Forms * 16-17 * Advanced * Mixed [Description] => Forms * 16-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 16 [AgeLow] => 16 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) Array ( [0] => 17433 [UserInfoId] => 17433 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8181 [RankingDivisionDefinitionId] => 8181 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 132 [SportEventId] => 132 [9] => F-22 [DivisionName] => F-22 [10] => Forms * 16-17 * Advanced * Mixed [Description] => Forms * 16-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 16 [AgeLow] => 16 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) Array ( [0] => 18635 [UserInfoId] => 18635 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8181 [RankingDivisionDefinitionId] => 8181 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 132 [SportEventId] => 132 [9] => F-22 [DivisionName] => F-22 [10] => Forms * 16-17 * Advanced * Mixed [Description] => Forms * 16-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 16 [AgeLow] => 16 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) Array ( [0] => 19608 [UserInfoId] => 19608 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8181 [RankingDivisionDefinitionId] => 8181 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 132 [SportEventId] => 132 [9] => F-22 [DivisionName] => F-22 [10] => Forms * 16-17 * Advanced * Mixed [Description] => Forms * 16-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 16 [AgeLow] => 16 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) Array ( [0] => 15010 [UserInfoId] => 15010 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8181 [RankingDivisionDefinitionId] => 8181 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 132 [SportEventId] => 132 [9] => F-22 [DivisionName] => F-22 [10] => Forms * 16-17 * Advanced * Mixed [Description] => Forms * 16-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 16 [AgeLow] => 16 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) Array ( [0] => 15165 [UserInfoId] => 15165 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8181 [RankingDivisionDefinitionId] => 8181 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 132 [SportEventId] => 132 [9] => F-22 [DivisionName] => F-22 [10] => Forms * 16-17 * Advanced * Mixed [Description] => Forms * 16-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 16 [AgeLow] => 16 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) Array ( [0] => 16022 [UserInfoId] => 16022 [1] => 132 [RankedSportEventId] => 132 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8181 [RankingDivisionDefinitionId] => 8181 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 132 [SportEventId] => 132 [9] => F-22 [DivisionName] => F-22 [10] => Forms * 16-17 * Advanced * Mixed [Description] => Forms * 16-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 16 [AgeLow] => 16 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) Array ( [0] => 20775 [UserInfoId] => 20775 [1] => 132 [RankedSportEventId] => 132 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8181 [RankingDivisionDefinitionId] => 8181 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 132 [SportEventId] => 132 [9] => F-22 [DivisionName] => F-22 [10] => Forms * 16-17 * Advanced * Mixed [Description] => Forms * 16-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 16 [AgeLow] => 16 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) Array ( [0] => 21663 [UserInfoId] => 21663 [1] => 132 [RankedSportEventId] => 132 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8181 [RankingDivisionDefinitionId] => 8181 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 132 [SportEventId] => 132 [9] => F-22 [DivisionName] => F-22 [10] => Forms * 16-17 * Advanced * Mixed [Description] => Forms * 16-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 16 [AgeLow] => 16 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) Array ( [0] => 20777 [UserInfoId] => 20777 [1] => 132 [RankedSportEventId] => 132 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8181 [RankingDivisionDefinitionId] => 8181 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 132 [SportEventId] => 132 [9] => F-22 [DivisionName] => F-22 [10] => Forms * 16-17 * Advanced * Mixed [Description] => Forms * 16-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 16 [AgeLow] => 16 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) Array ( [0] => 13275 [UserInfoId] => 13275 [1] => 132 [RankedSportEventId] => 132 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8181 [RankingDivisionDefinitionId] => 8181 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 132 [SportEventId] => 132 [9] => F-22 [DivisionName] => F-22 [10] => Forms * 16-17 * Advanced * Mixed [Description] => Forms * 16-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 16 [AgeLow] => 16 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) BB[ 13275 ]) 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 ) BB[ 13275 ]) 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 ) Array ( [0] => 13739 [UserInfoId] => 13739 [1] => 341 [RankedSportEventId] => 341 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [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] => 18216 [UserInfoId] => 18216 [1] => 341 [RankedSportEventId] => 341 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [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] => 13660 [UserInfoId] => 13660 [1] => 341 [RankedSportEventId] => 341 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [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] => 13275 [UserInfoId] => 13275 [1] => 341 [RankedSportEventId] => 341 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [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[ 13275 ]) 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=213 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=79 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 13275 [UserInfoId] => 13275 [1] => 213 [RankedSportEventId] => 213 [2] => 213 [sumUPts] => 213 [3] => 21 [cntUPts] => 21 [4] => 8236 [RankingDivisionDefinitionId] => 8236 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 79 [DivisionId] => 79 [8] => 213 [SportEventId] => 213 [9] => SD-8 [DivisionName] => SD-8 [10] => Self Defense * 12-17 * Black * Mixed [Description] => Self Defense * 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] => 79 [Sequence] => 79 ) BB[ 13275 ]) 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=102 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15360 [UserInfoId] => 15360 [1] => 110 [RankedSportEventId] => 110 [2] => 143 [sumUPts] => 143 [3] => 13 [cntUPts] => 13 [4] => 8259 [RankingDivisionDefinitionId] => 8259 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 102 [DivisionId] => 102 [8] => 110 [SportEventId] => 110 [9] => S-20 [DivisionName] => S-20 [10] => Sparring - Point * 14-15 * Black * Female [Description] => Sparring - Point * 14-15 * Black * Female [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [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] => 102 [Sequence] => 102 ) Array ( [0] => 13275 [UserInfoId] => 13275 [1] => 110 [RankedSportEventId] => 110 [2] => 48 [sumUPts] => 48 [3] => 4 [cntUPts] => 4 [4] => 8259 [RankingDivisionDefinitionId] => 8259 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 102 [DivisionId] => 102 [8] => 110 [SportEventId] => 110 [9] => S-20 [DivisionName] => S-20 [10] => Sparring - Point * 14-15 * Black * Female [Description] => Sparring - Point * 14-15 * Black * Female [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [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] => 102 [Sequence] => 102 ) BB[ 13275 ]) 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=106 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 13275 [UserInfoId] => 13275 [1] => 110 [RankedSportEventId] => 110 [2] => 171 [sumUPts] => 171 [3] => 17 [cntUPts] => 17 [4] => 8263 [RankingDivisionDefinitionId] => 8263 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 106 [DivisionId] => 106 [8] => 110 [SportEventId] => 110 [9] => S-24 [DivisionName] => S-24 [10] => Sparring - Point * 16-17 * Black * Female [Description] => Sparring - Point * 16-17 * Black * Female [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [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] => 106 [Sequence] => 106 ) Standings for Lewis, Erin


Standings for:
Lewis, Erin
Event & Description Skill Level Weight (lbs) Points # Events Rank
B-3 Breaking - Power Wood - Hand/Elbow
Mixed * ≤ 17 yrs
Black Belt 160151
F-19 Forms
Mixed * 14 - 15 yrs
Black Belt 2135
F-22 Forms
Mixed * 16 - 17 yrs
Advanced 6119
F-23 Forms
Mixed * 16 - 17 yrs
Black Belt 109141
FS-6 Forms - Traditional Soft Style
Mixed * 12 - 17 yrs
Advanced 1526
SD-8 Self Defense
Mixed * 12 - 17 yrs
Black Belt 213211
S-20 Sparring - Point
Female * 14 - 15 yrs
Black Belt 4842
S-24 Sparring - Point
Female * 16 - 17 yrs
Black Belt 171171
Total743