BB[ 20163 ]) 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=157 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 20163 [UserInfoId] => 20163 [1] => 299 [RankedSportEventId] => 299 [2] => 75 [sumUPts] => 75 [3] => 7 [cntUPts] => 7 [4] => 8314 [RankingDivisionDefinitionId] => 8314 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 157 [DivisionId] => 157 [8] => 299 [SportEventId] => 299 [9] => B-2 [DivisionName] => B-2 [10] => Breaking - Power Wood - Hand/Elbow * 12-17 * Beg / Intr / Adv * [Description] => Breaking - Power Wood - Hand/Elbow * 12-17 * Beg / Intr / Adv * [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [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] => 157 [Sequence] => 157 ) BB[ 20163 ]) 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=14 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 20833 [UserInfoId] => 20833 [1] => 132 [RankedSportEventId] => 132 [2] => 57 [sumUPts] => 57 [3] => 6 [cntUPts] => 6 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 20145 [UserInfoId] => 20145 [1] => 132 [RankedSportEventId] => 132 [2] => 33 [sumUPts] => 33 [3] => 3 [cntUPts] => 3 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 19802 [UserInfoId] => 19802 [1] => 132 [RankedSportEventId] => 132 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 20358 [UserInfoId] => 20358 [1] => 132 [RankedSportEventId] => 132 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 18472 [UserInfoId] => 18472 [1] => 132 [RankedSportEventId] => 132 [2] => 21 [sumUPts] => 21 [3] => 3 [cntUPts] => 3 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 20873 [UserInfoId] => 20873 [1] => 132 [RankedSportEventId] => 132 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 16260 [UserInfoId] => 16260 [1] => 132 [RankedSportEventId] => 132 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 16259 [UserInfoId] => 16259 [1] => 132 [RankedSportEventId] => 132 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 21155 [UserInfoId] => 21155 [1] => 132 [RankedSportEventId] => 132 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 18836 [UserInfoId] => 18836 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 20768 [UserInfoId] => 20768 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 20025 [UserInfoId] => 20025 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 19884 [UserInfoId] => 19884 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 20372 [UserInfoId] => 20372 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 18473 [UserInfoId] => 18473 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 18116 [UserInfoId] => 18116 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 21657 [UserInfoId] => 21657 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 18217 [UserInfoId] => 18217 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 19994 [UserInfoId] => 19994 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 21696 [UserInfoId] => 21696 [1] => 132 [RankedSportEventId] => 132 [2] => 11 [sumUPts] => 11 [3] => 2 [cntUPts] => 2 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 20289 [UserInfoId] => 20289 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 21084 [UserInfoId] => 21084 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 21637 [UserInfoId] => 21637 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 20067 [UserInfoId] => 20067 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 18751 [UserInfoId] => 18751 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 20159 [UserInfoId] => 20159 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 19621 [UserInfoId] => 19621 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 22104 [UserInfoId] => 22104 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 19879 [UserInfoId] => 19879 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 20620 [UserInfoId] => 20620 [1] => 132 [RankedSportEventId] => 132 [2] => 8 [sumUPts] => 8 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 21753 [UserInfoId] => 21753 [1] => 132 [RankedSportEventId] => 132 [2] => 8 [sumUPts] => 8 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 20737 [UserInfoId] => 20737 [1] => 132 [RankedSportEventId] => 132 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 19320 [UserInfoId] => 19320 [1] => 132 [RankedSportEventId] => 132 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 21098 [UserInfoId] => 21098 [1] => 132 [RankedSportEventId] => 132 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 18491 [UserInfoId] => 18491 [1] => 132 [RankedSportEventId] => 132 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 20589 [UserInfoId] => 20589 [1] => 132 [RankedSportEventId] => 132 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 21710 [UserInfoId] => 21710 [1] => 132 [RankedSportEventId] => 132 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 21313 [UserInfoId] => 21313 [1] => 132 [RankedSportEventId] => 132 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 20447 [UserInfoId] => 20447 [1] => 132 [RankedSportEventId] => 132 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 21786 [UserInfoId] => 21786 [1] => 132 [RankedSportEventId] => 132 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 19811 [UserInfoId] => 19811 [1] => 132 [RankedSportEventId] => 132 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 21660 [UserInfoId] => 21660 [1] => 132 [RankedSportEventId] => 132 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) Array ( [0] => 20163 [UserInfoId] => 20163 [1] => 132 [RankedSportEventId] => 132 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8171 [RankingDivisionDefinitionId] => 8171 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 132 [SportEventId] => 132 [9] => F-12 [DivisionName] => F-12 [10] => Forms * 12-13 * Beginner * Mixed [Description] => Forms * 12-13 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 14 [Sequence] => 14 ) BB[ 20163 ]) 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=18 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 20163 [UserInfoId] => 20163 [1] => 132 [RankedSportEventId] => 132 [2] => 69 [sumUPts] => 69 [3] => 6 [cntUPts] => 6 [4] => 8175 [RankingDivisionDefinitionId] => 8175 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 18 [DivisionId] => 18 [8] => 132 [SportEventId] => 132 [9] => F-16 [DivisionName] => F-16 [10] => Forms * 14-15 * Beginner * Mixed [Description] => Forms * 14-15 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [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] => 18 [Sequence] => 18 ) BB[ 20163 ]) SELECT UserInfoId, rem.RankedSportEventId, sum(Points) as sumUPts, count(Points) as cntUPts, rdd.* FROM UserRankingPoints urp, RankingEventMappings rem, RankingDivisionDefinitions rdd WHERE urp.SportEventId=rem.SportEventId AND urp.RankingSystemId=8 AND rem.RankedSportEventId=340 AND urp.RankingSystemId=rdd.RankingSystemDefinitionId AND urp.TournamentId in ( 145,146,147,148,149,150,151,152,153,154,155,156,157,159,161,162,163,164,165,166,167,168,169,170,171 ) AND urp.RankingDivisionId=rdd.DivisionId AND urp.RankingDivisionId=54 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 20132 [UserInfoId] => 20132 [1] => 340 [RankedSportEventId] => 340 [2] => 51 [sumUPts] => 51 [3] => 5 [cntUPts] => 5 [4] => 8211 [RankingDivisionDefinitionId] => 8211 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 54 [DivisionId] => 54 [8] => 340 [SportEventId] => 340 [9] => FH-4 [DivisionName] => FH-4 [10] => Forms - Traditional Hard Style * 12-17 * Beginner * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [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] => 54 [Sequence] => 54 ) Array ( [0] => 21810 [UserInfoId] => 21810 [1] => 340 [RankedSportEventId] => 340 [2] => 27 [sumUPts] => 27 [3] => 3 [cntUPts] => 3 [4] => 8211 [RankingDivisionDefinitionId] => 8211 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 54 [DivisionId] => 54 [8] => 340 [SportEventId] => 340 [9] => FH-4 [DivisionName] => FH-4 [10] => Forms - Traditional Hard Style * 12-17 * Beginner * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [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] => 54 [Sequence] => 54 ) Array ( [0] => 16418 [UserInfoId] => 16418 [1] => 340 [RankedSportEventId] => 340 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8211 [RankingDivisionDefinitionId] => 8211 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 54 [DivisionId] => 54 [8] => 340 [SportEventId] => 340 [9] => FH-4 [DivisionName] => FH-4 [10] => Forms - Traditional Hard Style * 12-17 * Beginner * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [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] => 54 [Sequence] => 54 ) Array ( [0] => 20603 [UserInfoId] => 20603 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8211 [RankingDivisionDefinitionId] => 8211 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 54 [DivisionId] => 54 [8] => 340 [SportEventId] => 340 [9] => FH-4 [DivisionName] => FH-4 [10] => Forms - Traditional Hard Style * 12-17 * Beginner * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [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] => 54 [Sequence] => 54 ) Array ( [0] => 21263 [UserInfoId] => 21263 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8211 [RankingDivisionDefinitionId] => 8211 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 54 [DivisionId] => 54 [8] => 340 [SportEventId] => 340 [9] => FH-4 [DivisionName] => FH-4 [10] => Forms - Traditional Hard Style * 12-17 * Beginner * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [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] => 54 [Sequence] => 54 ) Array ( [0] => 20971 [UserInfoId] => 20971 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8211 [RankingDivisionDefinitionId] => 8211 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 54 [DivisionId] => 54 [8] => 340 [SportEventId] => 340 [9] => FH-4 [DivisionName] => FH-4 [10] => Forms - Traditional Hard Style * 12-17 * Beginner * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [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] => 54 [Sequence] => 54 ) Array ( [0] => 20163 [UserInfoId] => 20163 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8211 [RankingDivisionDefinitionId] => 8211 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 54 [DivisionId] => 54 [8] => 340 [SportEventId] => 340 [9] => FH-4 [DivisionName] => FH-4 [10] => Forms - Traditional Hard Style * 12-17 * Beginner * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [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] => 54 [Sequence] => 54 ) BB[ 20163 ]) 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=76 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 21280 [UserInfoId] => 21280 [1] => 213 [RankedSportEventId] => 213 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8233 [RankingDivisionDefinitionId] => 8233 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 76 [DivisionId] => 76 [8] => 213 [SportEventId] => 213 [9] => SD-5 [DivisionName] => SD-5 [10] => Self Defense * 12-17 * Beginner * Mixed [Description] => Self Defense * 12-17 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [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] => 76 [Sequence] => 76 ) Array ( [0] => 20163 [UserInfoId] => 20163 [1] => 213 [RankedSportEventId] => 213 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8233 [RankingDivisionDefinitionId] => 8233 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 76 [DivisionId] => 76 [8] => 213 [SportEventId] => 213 [9] => SD-5 [DivisionName] => SD-5 [10] => Self Defense * 12-17 * Beginner * Mixed [Description] => Self Defense * 12-17 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [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] => 76 [Sequence] => 76 ) BB[ 20163 ]) 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=117 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 20145 [UserInfoId] => 20145 [1] => 110 [RankedSportEventId] => 110 [2] => 45 [sumUPts] => 45 [3] => 4 [cntUPts] => 4 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 20856 [UserInfoId] => 20856 [1] => 110 [RankedSportEventId] => 110 [2] => 30 [sumUPts] => 30 [3] => 3 [cntUPts] => 3 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 16259 [UserInfoId] => 16259 [1] => 110 [RankedSportEventId] => 110 [2] => 27 [sumUPts] => 27 [3] => 3 [cntUPts] => 3 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 18472 [UserInfoId] => 18472 [1] => 110 [RankedSportEventId] => 110 [2] => 24 [sumUPts] => 24 [3] => 3 [cntUPts] => 3 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 20132 [UserInfoId] => 20132 [1] => 110 [RankedSportEventId] => 110 [2] => 24 [sumUPts] => 24 [3] => 4 [cntUPts] => 4 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 16260 [UserInfoId] => 16260 [1] => 110 [RankedSportEventId] => 110 [2] => 21 [sumUPts] => 21 [3] => 3 [cntUPts] => 3 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 20873 [UserInfoId] => 20873 [1] => 110 [RankedSportEventId] => 110 [2] => 21 [sumUPts] => 21 [3] => 3 [cntUPts] => 3 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 21155 [UserInfoId] => 21155 [1] => 110 [RankedSportEventId] => 110 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 20196 [UserInfoId] => 20196 [1] => 110 [RankedSportEventId] => 110 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 19802 [UserInfoId] => 19802 [1] => 110 [RankedSportEventId] => 110 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 20729 [UserInfoId] => 20729 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 16418 [UserInfoId] => 16418 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 21755 [UserInfoId] => 21755 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 20190 [UserInfoId] => 20190 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 21084 [UserInfoId] => 21084 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 18491 [UserInfoId] => 18491 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 16970 [UserInfoId] => 16970 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 19320 [UserInfoId] => 19320 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 20417 [UserInfoId] => 20417 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 21280 [UserInfoId] => 21280 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 21683 [UserInfoId] => 21683 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 18473 [UserInfoId] => 18473 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 20159 [UserInfoId] => 20159 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 17809 [UserInfoId] => 17809 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 20054 [UserInfoId] => 20054 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 19884 [UserInfoId] => 19884 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 19975 [UserInfoId] => 19975 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 20780 [UserInfoId] => 20780 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 21313 [UserInfoId] => 21313 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 21529 [UserInfoId] => 21529 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 2 [cntUPts] => 2 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 20674 [UserInfoId] => 20674 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 21753 [UserInfoId] => 21753 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 21637 [UserInfoId] => 21637 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 21660 [UserInfoId] => 21660 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 22104 [UserInfoId] => 22104 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 21992 [UserInfoId] => 21992 [1] => 110 [RankedSportEventId] => 110 [2] => 8 [sumUPts] => 8 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 20643 [UserInfoId] => 20643 [1] => 110 [RankedSportEventId] => 110 [2] => 8 [sumUPts] => 8 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 21657 [UserInfoId] => 21657 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 21684 [UserInfoId] => 21684 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) Array ( [0] => 20163 [UserInfoId] => 20163 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8274 [RankingDivisionDefinitionId] => 8274 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 117 [DivisionId] => 117 [8] => 110 [SportEventId] => 110 [9] => S-35 [DivisionName] => S-35 [10] => Sparring - Point * 12-13 * Beginner * Male [Description] => Sparring - Point * 12-13 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 117 [Sequence] => 117 ) BB[ 20163 ]) 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=121 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 20163 [UserInfoId] => 20163 [1] => 110 [RankedSportEventId] => 110 [2] => 63 [sumUPts] => 63 [3] => 6 [cntUPts] => 6 [4] => 8278 [RankingDivisionDefinitionId] => 8278 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 121 [DivisionId] => 121 [8] => 110 [SportEventId] => 110 [9] => S-39 [DivisionName] => S-39 [10] => Sparring - Point * 14-15 * Beginner * Male [Description] => Sparring - Point * 14-15 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [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] => 121 [Sequence] => 121 ) Standings for Carey, Ian


Standings for:
Carey, Ian
Event & Description Skill Level Weight (lbs) Points # Events Rank
B-2 Breaking - Power Wood - Hand/Elbow
Mixed * 12 - 17 yrs
Beginner 7571
F-12 Forms
Mixed * 12 - 13 yrs
Beginner 6143
F-16 Forms
Mixed * 14 - 15 yrs
Beginner 6961
FH-4 Forms - Traditional Hard Style
Mixed * 12 - 17 yrs
Beginner 1217
SD-5 Self Defense
Mixed * 12 - 17 yrs
Beginner 1212
S-35 Sparring - Point
Male * 12 - 13 yrs
Beginner 6140
S-39 Sparring - Point
Male * 14 - 15 yrs
Beginner 6361
Total243