BB[ 15453 ]) 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=156 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15062 [UserInfoId] => 15062 [1] => 299 [RankedSportEventId] => 299 [2] => 131 [sumUPts] => 131 [3] => 16 [cntUPts] => 16 [4] => 8313 [RankingDivisionDefinitionId] => 8313 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 156 [DivisionId] => 156 [8] => 299 [SportEventId] => 299 [9] => B-1 [DivisionName] => B-1 [10] => Breaking - Power Wood - Hand/Elbow * <= 11 * Beg / Intr / Adv [Description] => Breaking - Power Wood - Hand/Elbow * <= 11 * Beg / Intr / Adv [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 156 [Sequence] => 156 ) Array ( [0] => 19237 [UserInfoId] => 19237 [1] => 299 [RankedSportEventId] => 299 [2] => 115 [sumUPts] => 115 [3] => 11 [cntUPts] => 11 [4] => 8313 [RankingDivisionDefinitionId] => 8313 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 156 [DivisionId] => 156 [8] => 299 [SportEventId] => 299 [9] => B-1 [DivisionName] => B-1 [10] => Breaking - Power Wood - Hand/Elbow * <= 11 * Beg / Intr / Adv [Description] => Breaking - Power Wood - Hand/Elbow * <= 11 * Beg / Intr / Adv [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 156 [Sequence] => 156 ) Array ( [0] => 16929 [UserInfoId] => 16929 [1] => 299 [RankedSportEventId] => 299 [2] => 111 [sumUPts] => 111 [3] => 10 [cntUPts] => 10 [4] => 8313 [RankingDivisionDefinitionId] => 8313 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 156 [DivisionId] => 156 [8] => 299 [SportEventId] => 299 [9] => B-1 [DivisionName] => B-1 [10] => Breaking - Power Wood - Hand/Elbow * <= 11 * Beg / Intr / Adv [Description] => Breaking - Power Wood - Hand/Elbow * <= 11 * Beg / Intr / Adv [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 156 [Sequence] => 156 ) Array ( [0] => 15453 [UserInfoId] => 15453 [1] => 299 [RankedSportEventId] => 299 [2] => 110 [sumUPts] => 110 [3] => 10 [cntUPts] => 10 [4] => 8313 [RankingDivisionDefinitionId] => 8313 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 156 [DivisionId] => 156 [8] => 299 [SportEventId] => 299 [9] => B-1 [DivisionName] => B-1 [10] => Breaking - Power Wood - Hand/Elbow * <= 11 * Beg / Intr / Adv [Description] => Breaking - Power Wood - Hand/Elbow * <= 11 * Beg / Intr / Adv [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 156 [Sequence] => 156 ) BB[ 15453 ]) 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=4 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 16178 [UserInfoId] => 16178 [1] => 132 [RankedSportEventId] => 132 [2] => 60 [sumUPts] => 60 [3] => 7 [cntUPts] => 7 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 19237 [UserInfoId] => 19237 [1] => 132 [RankedSportEventId] => 132 [2] => 53 [sumUPts] => 53 [3] => 7 [cntUPts] => 7 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 19755 [UserInfoId] => 19755 [1] => 132 [RankedSportEventId] => 132 [2] => 33 [sumUPts] => 33 [3] => 3 [cntUPts] => 3 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 16797 [UserInfoId] => 16797 [1] => 132 [RankedSportEventId] => 132 [2] => 30 [sumUPts] => 30 [3] => 3 [cntUPts] => 3 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 21045 [UserInfoId] => 21045 [1] => 132 [RankedSportEventId] => 132 [2] => 25 [sumUPts] => 25 [3] => 4 [cntUPts] => 4 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 19776 [UserInfoId] => 19776 [1] => 132 [RankedSportEventId] => 132 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 16896 [UserInfoId] => 16896 [1] => 132 [RankedSportEventId] => 132 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 21416 [UserInfoId] => 21416 [1] => 132 [RankedSportEventId] => 132 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 20838 [UserInfoId] => 20838 [1] => 132 [RankedSportEventId] => 132 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 19117 [UserInfoId] => 19117 [1] => 132 [RankedSportEventId] => 132 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 19880 [UserInfoId] => 19880 [1] => 132 [RankedSportEventId] => 132 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 20853 [UserInfoId] => 20853 [1] => 132 [RankedSportEventId] => 132 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 21157 [UserInfoId] => 21157 [1] => 132 [RankedSportEventId] => 132 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 15129 [UserInfoId] => 15129 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 19790 [UserInfoId] => 19790 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 21725 [UserInfoId] => 21725 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 21199 [UserInfoId] => 21199 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 20843 [UserInfoId] => 20843 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 20993 [UserInfoId] => 20993 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 16416 [UserInfoId] => 16416 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 18011 [UserInfoId] => 18011 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 21161 [UserInfoId] => 21161 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 19660 [UserInfoId] => 19660 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 19912 [UserInfoId] => 19912 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 20177 [UserInfoId] => 20177 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 15739 [UserInfoId] => 15739 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 20978 [UserInfoId] => 20978 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) Array ( [0] => 15453 [UserInfoId] => 15453 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8161 [RankingDivisionDefinitionId] => 8161 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 132 [SportEventId] => 132 [9] => F-2 [DivisionName] => F-2 [10] => Forms * 6-7 * Beginner * Mixed [Description] => Forms * 6-7 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) BB[ 15453 ]) 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=5 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15453 [UserInfoId] => 15453 [1] => 132 [RankedSportEventId] => 132 [2] => 107 [sumUPts] => 107 [3] => 11 [cntUPts] => 11 [4] => 8162 [RankingDivisionDefinitionId] => 8162 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 5 [DivisionId] => 5 [8] => 132 [SportEventId] => 132 [9] => F-3 [DivisionName] => F-3 [10] => Forms * 6-7 * Intermediate * Mixed [Description] => Forms * 6-7 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 5 [Sequence] => 5 ) BB[ 15453 ]) 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=107 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 16178 [UserInfoId] => 16178 [1] => 110 [RankedSportEventId] => 110 [2] => 54 [sumUPts] => 54 [3] => 7 [cntUPts] => 7 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 18242 [UserInfoId] => 18242 [1] => 110 [RankedSportEventId] => 110 [2] => 53 [sumUPts] => 53 [3] => 6 [cntUPts] => 6 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 19030 [UserInfoId] => 19030 [1] => 110 [RankedSportEventId] => 110 [2] => 45 [sumUPts] => 45 [3] => 5 [cntUPts] => 5 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 20592 [UserInfoId] => 20592 [1] => 110 [RankedSportEventId] => 110 [2] => 34 [sumUPts] => 34 [3] => 5 [cntUPts] => 5 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 20853 [UserInfoId] => 20853 [1] => 110 [RankedSportEventId] => 110 [2] => 33 [sumUPts] => 33 [3] => 3 [cntUPts] => 3 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 20838 [UserInfoId] => 20838 [1] => 110 [RankedSportEventId] => 110 [2] => 27 [sumUPts] => 27 [3] => 3 [cntUPts] => 3 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 17632 [UserInfoId] => 17632 [1] => 110 [RankedSportEventId] => 110 [2] => 27 [sumUPts] => 27 [3] => 4 [cntUPts] => 4 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 16896 [UserInfoId] => 16896 [1] => 110 [RankedSportEventId] => 110 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 16797 [UserInfoId] => 16797 [1] => 110 [RankedSportEventId] => 110 [2] => 24 [sumUPts] => 24 [3] => 3 [cntUPts] => 3 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 20666 [UserInfoId] => 20666 [1] => 110 [RankedSportEventId] => 110 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 20916 [UserInfoId] => 20916 [1] => 110 [RankedSportEventId] => 110 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 19796 [UserInfoId] => 19796 [1] => 110 [RankedSportEventId] => 110 [2] => 18 [sumUPts] => 18 [3] => 3 [cntUPts] => 3 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 18011 [UserInfoId] => 18011 [1] => 110 [RankedSportEventId] => 110 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 20843 [UserInfoId] => 20843 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 20981 [UserInfoId] => 20981 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 17730 [UserInfoId] => 17730 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 21340 [UserInfoId] => 21340 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 19790 [UserInfoId] => 19790 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 21161 [UserInfoId] => 21161 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 22046 [UserInfoId] => 22046 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 20004 [UserInfoId] => 20004 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 18678 [UserInfoId] => 18678 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 20212 [UserInfoId] => 20212 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 15527 [UserInfoId] => 15527 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 16177 [UserInfoId] => 16177 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 15321 [UserInfoId] => 15321 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 20924 [UserInfoId] => 20924 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 15739 [UserInfoId] => 15739 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 18364 [UserInfoId] => 18364 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 19662 [UserInfoId] => 19662 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 20939 [UserInfoId] => 20939 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 20730 [UserInfoId] => 20730 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 21680 [UserInfoId] => 21680 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 21781 [UserInfoId] => 21781 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 19226 [UserInfoId] => 19226 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 20177 [UserInfoId] => 20177 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 21023 [UserInfoId] => 21023 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 21339 [UserInfoId] => 21339 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 22083 [UserInfoId] => 22083 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 20514 [UserInfoId] => 20514 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 19660 [UserInfoId] => 19660 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) Array ( [0] => 15453 [UserInfoId] => 15453 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8264 [RankingDivisionDefinitionId] => 8264 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 107 [DivisionId] => 107 [8] => 110 [SportEventId] => 110 [9] => S-25 [DivisionName] => S-25 [10] => Sparring - Point * 6-7 * Beginner * Male [Description] => Sparring - Point * 6-7 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 107 [Sequence] => 107 ) BB[ 15453 ]) 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=108 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15453 [UserInfoId] => 15453 [1] => 110 [RankedSportEventId] => 110 [2] => 104 [sumUPts] => 104 [3] => 12 [cntUPts] => 12 [4] => 8265 [RankingDivisionDefinitionId] => 8265 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 108 [DivisionId] => 108 [8] => 110 [SportEventId] => 110 [9] => S-26 [DivisionName] => S-26 [10] => Sparring - Point * 6-7 * Intermediate * Male [Description] => Sparring - Point * 6-7 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 6 [AgeLow] => 6 [14] => 7 [AgeHigh] => 7 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 108 [Sequence] => 108 ) Standings for Collins, Braxtyn Ryan


Standings for:
Collins, Braxtyn Ryan
Event & Description Skill Level Weight (lbs) Points # Events Rank
B-1 Breaking - Power Wood - Hand/Elbow
Mixed * ≤ 11 yrs
Beginner 110104
F-2 Forms
Mixed * 6 - 7 yrs
Beginner 12128
F-3 Forms
Mixed * 6 - 7 yrs
Intermediate 107111
S-25 Sparring - Point
Male * 6 - 7 yrs
Beginner 6142
S-26 Sparring - Point
Male * 6 - 7 yrs
Intermediate 104121
Total339