BB[ 15471 ]) 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=8 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15742 [UserInfoId] => 15742 [1] => 132 [RankedSportEventId] => 132 [2] => 57 [sumUPts] => 57 [3] => 5 [cntUPts] => 5 [4] => 8165 [RankingDivisionDefinitionId] => 8165 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 8 [DivisionId] => 8 [8] => 132 [SportEventId] => 132 [9] => F-6 [DivisionName] => F-6 [10] => Forms * 8-9 * Intermediate * Mixed [Description] => Forms * 8-9 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 8 [Sequence] => 8 ) Array ( [0] => 18247 [UserInfoId] => 18247 [1] => 132 [RankedSportEventId] => 132 [2] => 56 [sumUPts] => 56 [3] => 6 [cntUPts] => 6 [4] => 8165 [RankingDivisionDefinitionId] => 8165 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 8 [DivisionId] => 8 [8] => 132 [SportEventId] => 132 [9] => F-6 [DivisionName] => F-6 [10] => Forms * 8-9 * Intermediate * Mixed [Description] => Forms * 8-9 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 8 [Sequence] => 8 ) Array ( [0] => 14797 [UserInfoId] => 14797 [1] => 132 [RankedSportEventId] => 132 [2] => 54 [sumUPts] => 54 [3] => 5 [cntUPts] => 5 [4] => 8165 [RankingDivisionDefinitionId] => 8165 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 8 [DivisionId] => 8 [8] => 132 [SportEventId] => 132 [9] => F-6 [DivisionName] => F-6 [10] => Forms * 8-9 * Intermediate * Mixed [Description] => Forms * 8-9 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 8 [Sequence] => 8 ) Array ( [0] => 16083 [UserInfoId] => 16083 [1] => 132 [RankedSportEventId] => 132 [2] => 36 [sumUPts] => 36 [3] => 4 [cntUPts] => 4 [4] => 8165 [RankingDivisionDefinitionId] => 8165 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 8 [DivisionId] => 8 [8] => 132 [SportEventId] => 132 [9] => F-6 [DivisionName] => F-6 [10] => Forms * 8-9 * Intermediate * Mixed [Description] => Forms * 8-9 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 8 [Sequence] => 8 ) Array ( [0] => 15434 [UserInfoId] => 15434 [1] => 132 [RankedSportEventId] => 132 [2] => 36 [sumUPts] => 36 [3] => 5 [cntUPts] => 5 [4] => 8165 [RankingDivisionDefinitionId] => 8165 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 8 [DivisionId] => 8 [8] => 132 [SportEventId] => 132 [9] => F-6 [DivisionName] => F-6 [10] => Forms * 8-9 * Intermediate * Mixed [Description] => Forms * 8-9 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 8 [Sequence] => 8 ) Array ( [0] => 15469 [UserInfoId] => 15469 [1] => 132 [RankedSportEventId] => 132 [2] => 33 [sumUPts] => 33 [3] => 5 [cntUPts] => 5 [4] => 8165 [RankingDivisionDefinitionId] => 8165 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 8 [DivisionId] => 8 [8] => 132 [SportEventId] => 132 [9] => F-6 [DivisionName] => F-6 [10] => Forms * 8-9 * Intermediate * Mixed [Description] => Forms * 8-9 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 8 [Sequence] => 8 ) Array ( [0] => 19749 [UserInfoId] => 19749 [1] => 132 [RankedSportEventId] => 132 [2] => 31 [sumUPts] => 31 [3] => 5 [cntUPts] => 5 [4] => 8165 [RankingDivisionDefinitionId] => 8165 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 8 [DivisionId] => 8 [8] => 132 [SportEventId] => 132 [9] => F-6 [DivisionName] => F-6 [10] => Forms * 8-9 * Intermediate * Mixed [Description] => Forms * 8-9 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 8 [Sequence] => 8 ) Array ( [0] => 20821 [UserInfoId] => 20821 [1] => 132 [RankedSportEventId] => 132 [2] => 27 [sumUPts] => 27 [3] => 3 [cntUPts] => 3 [4] => 8165 [RankingDivisionDefinitionId] => 8165 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 8 [DivisionId] => 8 [8] => 132 [SportEventId] => 132 [9] => F-6 [DivisionName] => F-6 [10] => Forms * 8-9 * Intermediate * Mixed [Description] => Forms * 8-9 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 8 [Sequence] => 8 ) Array ( [0] => 15006 [UserInfoId] => 15006 [1] => 132 [RankedSportEventId] => 132 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8165 [RankingDivisionDefinitionId] => 8165 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 8 [DivisionId] => 8 [8] => 132 [SportEventId] => 132 [9] => F-6 [DivisionName] => F-6 [10] => Forms * 8-9 * Intermediate * Mixed [Description] => Forms * 8-9 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 8 [Sequence] => 8 ) Array ( [0] => 20053 [UserInfoId] => 20053 [1] => 132 [RankedSportEventId] => 132 [2] => 21 [sumUPts] => 21 [3] => 3 [cntUPts] => 3 [4] => 8165 [RankingDivisionDefinitionId] => 8165 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 8 [DivisionId] => 8 [8] => 132 [SportEventId] => 132 [9] => F-6 [DivisionName] => F-6 [10] => Forms * 8-9 * Intermediate * Mixed [Description] => Forms * 8-9 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 8 [Sequence] => 8 ) Array ( [0] => 15126 [UserInfoId] => 15126 [1] => 132 [RankedSportEventId] => 132 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [4] => 8165 [RankingDivisionDefinitionId] => 8165 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 8 [DivisionId] => 8 [8] => 132 [SportEventId] => 132 [9] => F-6 [DivisionName] => F-6 [10] => Forms * 8-9 * Intermediate * Mixed [Description] => Forms * 8-9 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 8 [Sequence] => 8 ) Array ( [0] => 13534 [UserInfoId] => 13534 [1] => 132 [RankedSportEventId] => 132 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [4] => 8165 [RankingDivisionDefinitionId] => 8165 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 8 [DivisionId] => 8 [8] => 132 [SportEventId] => 132 [9] => F-6 [DivisionName] => F-6 [10] => Forms * 8-9 * Intermediate * Mixed [Description] => Forms * 8-9 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 8 [Sequence] => 8 ) Array ( [0] => 15471 [UserInfoId] => 15471 [1] => 132 [RankedSportEventId] => 132 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8165 [RankingDivisionDefinitionId] => 8165 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 8 [DivisionId] => 8 [8] => 132 [SportEventId] => 132 [9] => F-6 [DivisionName] => F-6 [10] => Forms * 8-9 * Intermediate * Mixed [Description] => Forms * 8-9 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 8 [Sequence] => 8 ) BB[ 15471 ]) 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=277 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=38 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19859 [UserInfoId] => 19859 [1] => 277 [RankedSportEventId] => 277 [2] => 78 [sumUPts] => 78 [3] => 8 [cntUPts] => 8 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 38 [Sequence] => 38 ) Array ( [0] => 19839 [UserInfoId] => 19839 [1] => 277 [RankedSportEventId] => 277 [2] => 48 [sumUPts] => 48 [3] => 5 [cntUPts] => 5 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 38 [Sequence] => 38 ) Array ( [0] => 14987 [UserInfoId] => 14987 [1] => 277 [RankedSportEventId] => 277 [2] => 32 [sumUPts] => 32 [3] => 3 [cntUPts] => 3 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 38 [Sequence] => 38 ) Array ( [0] => 20816 [UserInfoId] => 20816 [1] => 277 [RankedSportEventId] => 277 [2] => 24 [sumUPts] => 24 [3] => 3 [cntUPts] => 3 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 38 [Sequence] => 38 ) Array ( [0] => 19795 [UserInfoId] => 19795 [1] => 277 [RankedSportEventId] => 277 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 38 [Sequence] => 38 ) Array ( [0] => 20797 [UserInfoId] => 20797 [1] => 277 [RankedSportEventId] => 277 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 38 [Sequence] => 38 ) Array ( [0] => 20182 [UserInfoId] => 20182 [1] => 277 [RankedSportEventId] => 277 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 38 [Sequence] => 38 ) Array ( [0] => 21010 [UserInfoId] => 21010 [1] => 277 [RankedSportEventId] => 277 [2] => 21 [sumUPts] => 21 [3] => 3 [cntUPts] => 3 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 38 [Sequence] => 38 ) Array ( [0] => 20591 [UserInfoId] => 20591 [1] => 277 [RankedSportEventId] => 277 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 38 [Sequence] => 38 ) Array ( [0] => 20382 [UserInfoId] => 20382 [1] => 277 [RankedSportEventId] => 277 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 38 [Sequence] => 38 ) Array ( [0] => 15471 [UserInfoId] => 15471 [1] => 277 [RankedSportEventId] => 277 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 38 [Sequence] => 38 ) BB[ 15471 ]) 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=277 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=39 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19673 [UserInfoId] => 19673 [1] => 277 [RankedSportEventId] => 277 [2] => 69 [sumUPts] => 69 [3] => 7 [cntUPts] => 7 [4] => 8196 [RankingDivisionDefinitionId] => 8196 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 39 [DivisionId] => 39 [8] => 277 [SportEventId] => 277 [9] => M-2 [DivisionName] => M-2 [10] => Forms - Specialty * <= 11 * Intermediate * Mixed [Description] => Forms - Specialty * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 39 [Sequence] => 39 ) Array ( [0] => 19749 [UserInfoId] => 19749 [1] => 277 [RankedSportEventId] => 277 [2] => 52 [sumUPts] => 52 [3] => 6 [cntUPts] => 6 [4] => 8196 [RankingDivisionDefinitionId] => 8196 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 39 [DivisionId] => 39 [8] => 277 [SportEventId] => 277 [9] => M-2 [DivisionName] => M-2 [10] => Forms - Specialty * <= 11 * Intermediate * Mixed [Description] => Forms - Specialty * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 39 [Sequence] => 39 ) Array ( [0] => 15248 [UserInfoId] => 15248 [1] => 277 [RankedSportEventId] => 277 [2] => 42 [sumUPts] => 42 [3] => 4 [cntUPts] => 4 [4] => 8196 [RankingDivisionDefinitionId] => 8196 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 39 [DivisionId] => 39 [8] => 277 [SportEventId] => 277 [9] => M-2 [DivisionName] => M-2 [10] => Forms - Specialty * <= 11 * Intermediate * Mixed [Description] => Forms - Specialty * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 39 [Sequence] => 39 ) Array ( [0] => 15469 [UserInfoId] => 15469 [1] => 277 [RankedSportEventId] => 277 [2] => 42 [sumUPts] => 42 [3] => 4 [cntUPts] => 4 [4] => 8196 [RankingDivisionDefinitionId] => 8196 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 39 [DivisionId] => 39 [8] => 277 [SportEventId] => 277 [9] => M-2 [DivisionName] => M-2 [10] => Forms - Specialty * <= 11 * Intermediate * Mixed [Description] => Forms - Specialty * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 39 [Sequence] => 39 ) Array ( [0] => 15635 [UserInfoId] => 15635 [1] => 277 [RankedSportEventId] => 277 [2] => 36 [sumUPts] => 36 [3] => 5 [cntUPts] => 5 [4] => 8196 [RankingDivisionDefinitionId] => 8196 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 39 [DivisionId] => 39 [8] => 277 [SportEventId] => 277 [9] => M-2 [DivisionName] => M-2 [10] => Forms - Specialty * <= 11 * Intermediate * Mixed [Description] => Forms - Specialty * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 39 [Sequence] => 39 ) Array ( [0] => 15644 [UserInfoId] => 15644 [1] => 277 [RankedSportEventId] => 277 [2] => 36 [sumUPts] => 36 [3] => 5 [cntUPts] => 5 [4] => 8196 [RankingDivisionDefinitionId] => 8196 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 39 [DivisionId] => 39 [8] => 277 [SportEventId] => 277 [9] => M-2 [DivisionName] => M-2 [10] => Forms - Specialty * <= 11 * Intermediate * Mixed [Description] => Forms - Specialty * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 39 [Sequence] => 39 ) Array ( [0] => 17751 [UserInfoId] => 17751 [1] => 277 [RankedSportEventId] => 277 [2] => 30 [sumUPts] => 30 [3] => 4 [cntUPts] => 4 [4] => 8196 [RankingDivisionDefinitionId] => 8196 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 39 [DivisionId] => 39 [8] => 277 [SportEventId] => 277 [9] => M-2 [DivisionName] => M-2 [10] => Forms - Specialty * <= 11 * Intermediate * Mixed [Description] => Forms - Specialty * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 39 [Sequence] => 39 ) Array ( [0] => 19795 [UserInfoId] => 19795 [1] => 277 [RankedSportEventId] => 277 [2] => 27 [sumUPts] => 27 [3] => 4 [cntUPts] => 4 [4] => 8196 [RankingDivisionDefinitionId] => 8196 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 39 [DivisionId] => 39 [8] => 277 [SportEventId] => 277 [9] => M-2 [DivisionName] => M-2 [10] => Forms - Specialty * <= 11 * Intermediate * Mixed [Description] => Forms - Specialty * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 39 [Sequence] => 39 ) Array ( [0] => 15126 [UserInfoId] => 15126 [1] => 277 [RankedSportEventId] => 277 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8196 [RankingDivisionDefinitionId] => 8196 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 39 [DivisionId] => 39 [8] => 277 [SportEventId] => 277 [9] => M-2 [DivisionName] => M-2 [10] => Forms - Specialty * <= 11 * Intermediate * Mixed [Description] => Forms - Specialty * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 39 [Sequence] => 39 ) Array ( [0] => 15947 [UserInfoId] => 15947 [1] => 277 [RankedSportEventId] => 277 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8196 [RankingDivisionDefinitionId] => 8196 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 39 [DivisionId] => 39 [8] => 277 [SportEventId] => 277 [9] => M-2 [DivisionName] => M-2 [10] => Forms - Specialty * <= 11 * Intermediate * Mixed [Description] => Forms - Specialty * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 39 [Sequence] => 39 ) Array ( [0] => 15833 [UserInfoId] => 15833 [1] => 277 [RankedSportEventId] => 277 [2] => 21 [sumUPts] => 21 [3] => 3 [cntUPts] => 3 [4] => 8196 [RankingDivisionDefinitionId] => 8196 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 39 [DivisionId] => 39 [8] => 277 [SportEventId] => 277 [9] => M-2 [DivisionName] => M-2 [10] => Forms - Specialty * <= 11 * Intermediate * Mixed [Description] => Forms - Specialty * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 39 [Sequence] => 39 ) Array ( [0] => 15471 [UserInfoId] => 15471 [1] => 277 [RankedSportEventId] => 277 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [4] => 8196 [RankingDivisionDefinitionId] => 8196 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 39 [DivisionId] => 39 [8] => 277 [SportEventId] => 277 [9] => M-2 [DivisionName] => M-2 [10] => Forms - Specialty * <= 11 * Intermediate * Mixed [Description] => Forms - Specialty * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 39 [Sequence] => 39 ) BB[ 15471 ]) 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=51 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19859 [UserInfoId] => 19859 [1] => 340 [RankedSportEventId] => 340 [2] => 57 [sumUPts] => 57 [3] => 5 [cntUPts] => 5 [4] => 8208 [RankingDivisionDefinitionId] => 8208 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 51 [DivisionId] => 51 [8] => 340 [SportEventId] => 340 [9] => FH-1 [DivisionName] => FH-1 [10] => Forms - Traditional Hard Style * <= 11 * Beginner * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 51 [Sequence] => 51 ) Array ( [0] => 20382 [UserInfoId] => 20382 [1] => 340 [RankedSportEventId] => 340 [2] => 43 [sumUPts] => 43 [3] => 5 [cntUPts] => 5 [4] => 8208 [RankingDivisionDefinitionId] => 8208 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 51 [DivisionId] => 51 [8] => 340 [SportEventId] => 340 [9] => FH-1 [DivisionName] => FH-1 [10] => Forms - Traditional Hard Style * <= 11 * Beginner * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 51 [Sequence] => 51 ) Array ( [0] => 20816 [UserInfoId] => 20816 [1] => 340 [RankedSportEventId] => 340 [2] => 36 [sumUPts] => 36 [3] => 3 [cntUPts] => 3 [4] => 8208 [RankingDivisionDefinitionId] => 8208 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 51 [DivisionId] => 51 [8] => 340 [SportEventId] => 340 [9] => FH-1 [DivisionName] => FH-1 [10] => Forms - Traditional Hard Style * <= 11 * Beginner * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 51 [Sequence] => 51 ) Array ( [0] => 14987 [UserInfoId] => 14987 [1] => 340 [RankedSportEventId] => 340 [2] => 32 [sumUPts] => 32 [3] => 3 [cntUPts] => 3 [4] => 8208 [RankingDivisionDefinitionId] => 8208 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 51 [DivisionId] => 51 [8] => 340 [SportEventId] => 340 [9] => FH-1 [DivisionName] => FH-1 [10] => Forms - Traditional Hard Style * <= 11 * Beginner * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 51 [Sequence] => 51 ) Array ( [0] => 17680 [UserInfoId] => 17680 [1] => 340 [RankedSportEventId] => 340 [2] => 27 [sumUPts] => 27 [3] => 3 [cntUPts] => 3 [4] => 8208 [RankingDivisionDefinitionId] => 8208 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 51 [DivisionId] => 51 [8] => 340 [SportEventId] => 340 [9] => FH-1 [DivisionName] => FH-1 [10] => Forms - Traditional Hard Style * <= 11 * Beginner * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 51 [Sequence] => 51 ) Array ( [0] => 19899 [UserInfoId] => 19899 [1] => 340 [RankedSportEventId] => 340 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8208 [RankingDivisionDefinitionId] => 8208 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 51 [DivisionId] => 51 [8] => 340 [SportEventId] => 340 [9] => FH-1 [DivisionName] => FH-1 [10] => Forms - Traditional Hard Style * <= 11 * Beginner * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 51 [Sequence] => 51 ) Array ( [0] => 21201 [UserInfoId] => 21201 [1] => 340 [RankedSportEventId] => 340 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8208 [RankingDivisionDefinitionId] => 8208 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 51 [DivisionId] => 51 [8] => 340 [SportEventId] => 340 [9] => FH-1 [DivisionName] => FH-1 [10] => Forms - Traditional Hard Style * <= 11 * Beginner * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 51 [Sequence] => 51 ) Array ( [0] => 19980 [UserInfoId] => 19980 [1] => 340 [RankedSportEventId] => 340 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8208 [RankingDivisionDefinitionId] => 8208 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 51 [DivisionId] => 51 [8] => 340 [SportEventId] => 340 [9] => FH-1 [DivisionName] => FH-1 [10] => Forms - Traditional Hard Style * <= 11 * Beginner * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 51 [Sequence] => 51 ) Array ( [0] => 19949 [UserInfoId] => 19949 [1] => 340 [RankedSportEventId] => 340 [2] => 13 [sumUPts] => 13 [3] => 2 [cntUPts] => 2 [4] => 8208 [RankingDivisionDefinitionId] => 8208 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 51 [DivisionId] => 51 [8] => 340 [SportEventId] => 340 [9] => FH-1 [DivisionName] => FH-1 [10] => Forms - Traditional Hard Style * <= 11 * Beginner * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 51 [Sequence] => 51 ) Array ( [0] => 15471 [UserInfoId] => 15471 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8208 [RankingDivisionDefinitionId] => 8208 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 51 [DivisionId] => 51 [8] => 340 [SportEventId] => 340 [9] => FH-1 [DivisionName] => FH-1 [10] => Forms - Traditional Hard Style * <= 11 * Beginner * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 51 [Sequence] => 51 ) BB[ 15471 ]) 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=52 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15434 [UserInfoId] => 15434 [1] => 340 [RankedSportEventId] => 340 [2] => 70 [sumUPts] => 70 [3] => 8 [cntUPts] => 8 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 19942 [UserInfoId] => 19942 [1] => 340 [RankedSportEventId] => 340 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 13753 [UserInfoId] => 13753 [1] => 340 [RankedSportEventId] => 340 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 15972 [UserInfoId] => 15972 [1] => 340 [RankedSportEventId] => 340 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 16165 [UserInfoId] => 16165 [1] => 340 [RankedSportEventId] => 340 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 20191 [UserInfoId] => 20191 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 21673 [UserInfoId] => 21673 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 13786 [UserInfoId] => 13786 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 19945 [UserInfoId] => 19945 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 15248 [UserInfoId] => 15248 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 15240 [UserInfoId] => 15240 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 15635 [UserInfoId] => 15635 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 21003 [UserInfoId] => 21003 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 14997 [UserInfoId] => 14997 [1] => 340 [RankedSportEventId] => 340 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 21249 [UserInfoId] => 21249 [1] => 340 [RankedSportEventId] => 340 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 15471 [UserInfoId] => 15471 [1] => 340 [RankedSportEventId] => 340 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) BB[ 15471 ]) 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=72 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19650 [UserInfoId] => 19650 [1] => 213 [RankedSportEventId] => 213 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8229 [RankingDivisionDefinitionId] => 8229 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 72 [DivisionId] => 72 [8] => 213 [SportEventId] => 213 [9] => SD-1 [DivisionName] => SD-1 [10] => Self Defense * <= 11 * Beginner * Mixed [Description] => Self Defense * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 72 [Sequence] => 72 ) Array ( [0] => 20575 [UserInfoId] => 20575 [1] => 213 [RankedSportEventId] => 213 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8229 [RankingDivisionDefinitionId] => 8229 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 72 [DivisionId] => 72 [8] => 213 [SportEventId] => 213 [9] => SD-1 [DivisionName] => SD-1 [10] => Self Defense * <= 11 * Beginner * Mixed [Description] => Self Defense * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 72 [Sequence] => 72 ) Array ( [0] => 19999 [UserInfoId] => 19999 [1] => 213 [RankedSportEventId] => 213 [2] => 16 [sumUPts] => 16 [3] => 2 [cntUPts] => 2 [4] => 8229 [RankingDivisionDefinitionId] => 8229 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 72 [DivisionId] => 72 [8] => 213 [SportEventId] => 213 [9] => SD-1 [DivisionName] => SD-1 [10] => Self Defense * <= 11 * Beginner * Mixed [Description] => Self Defense * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 72 [Sequence] => 72 ) Array ( [0] => 13300 [UserInfoId] => 13300 [1] => 213 [RankedSportEventId] => 213 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8229 [RankingDivisionDefinitionId] => 8229 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 72 [DivisionId] => 72 [8] => 213 [SportEventId] => 213 [9] => SD-1 [DivisionName] => SD-1 [10] => Self Defense * <= 11 * Beginner * Mixed [Description] => Self Defense * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 72 [Sequence] => 72 ) Array ( [0] => 15471 [UserInfoId] => 15471 [1] => 213 [RankedSportEventId] => 213 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8229 [RankingDivisionDefinitionId] => 8229 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 72 [DivisionId] => 72 [8] => 213 [SportEventId] => 213 [9] => SD-1 [DivisionName] => SD-1 [10] => Self Defense * <= 11 * Beginner * Mixed [Description] => Self Defense * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 72 [Sequence] => 72 ) BB[ 15471 ]) 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=73 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 13763 [UserInfoId] => 13763 [1] => 213 [RankedSportEventId] => 213 [2] => 72 [sumUPts] => 72 [3] => 7 [cntUPts] => 7 [4] => 8230 [RankingDivisionDefinitionId] => 8230 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 73 [DivisionId] => 73 [8] => 213 [SportEventId] => 213 [9] => SD-2 [DivisionName] => SD-2 [10] => Self Defense * <= 11 * Intermediate * Mixed [Description] => Self Defense * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 73 [Sequence] => 73 ) Array ( [0] => 16843 [UserInfoId] => 16843 [1] => 213 [RankedSportEventId] => 213 [2] => 36 [sumUPts] => 36 [3] => 4 [cntUPts] => 4 [4] => 8230 [RankingDivisionDefinitionId] => 8230 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 73 [DivisionId] => 73 [8] => 213 [SportEventId] => 213 [9] => SD-2 [DivisionName] => SD-2 [10] => Self Defense * <= 11 * Intermediate * Mixed [Description] => Self Defense * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 73 [Sequence] => 73 ) Array ( [0] => 13503 [UserInfoId] => 13503 [1] => 213 [RankedSportEventId] => 213 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8230 [RankingDivisionDefinitionId] => 8230 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 73 [DivisionId] => 73 [8] => 213 [SportEventId] => 213 [9] => SD-2 [DivisionName] => SD-2 [10] => Self Defense * <= 11 * Intermediate * Mixed [Description] => Self Defense * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 73 [Sequence] => 73 ) Array ( [0] => 16193 [UserInfoId] => 16193 [1] => 213 [RankedSportEventId] => 213 [2] => 24 [sumUPts] => 24 [3] => 3 [cntUPts] => 3 [4] => 8230 [RankingDivisionDefinitionId] => 8230 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 73 [DivisionId] => 73 [8] => 213 [SportEventId] => 213 [9] => SD-2 [DivisionName] => SD-2 [10] => Self Defense * <= 11 * Intermediate * Mixed [Description] => Self Defense * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 73 [Sequence] => 73 ) Array ( [0] => 15750 [UserInfoId] => 15750 [1] => 213 [RankedSportEventId] => 213 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8230 [RankingDivisionDefinitionId] => 8230 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 73 [DivisionId] => 73 [8] => 213 [SportEventId] => 213 [9] => SD-2 [DivisionName] => SD-2 [10] => Self Defense * <= 11 * Intermediate * Mixed [Description] => Self Defense * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 73 [Sequence] => 73 ) Array ( [0] => 13786 [UserInfoId] => 13786 [1] => 213 [RankedSportEventId] => 213 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8230 [RankingDivisionDefinitionId] => 8230 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 73 [DivisionId] => 73 [8] => 213 [SportEventId] => 213 [9] => SD-2 [DivisionName] => SD-2 [10] => Self Defense * <= 11 * Intermediate * Mixed [Description] => Self Defense * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 73 [Sequence] => 73 ) Array ( [0] => 15471 [UserInfoId] => 15471 [1] => 213 [RankedSportEventId] => 213 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8230 [RankingDivisionDefinitionId] => 8230 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 73 [DivisionId] => 73 [8] => 213 [SportEventId] => 213 [9] => SD-2 [DivisionName] => SD-2 [10] => Self Defense * <= 11 * Intermediate * Mixed [Description] => Self Defense * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 73 [Sequence] => 73 ) BB[ 15471 ]) 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=110 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 17730 [UserInfoId] => 17730 [1] => 110 [RankedSportEventId] => 110 [2] => 51 [sumUPts] => 51 [3] => 6 [cntUPts] => 6 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 19895 [UserInfoId] => 19895 [1] => 110 [RankedSportEventId] => 110 [2] => 39 [sumUPts] => 39 [3] => 5 [cntUPts] => 5 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 17680 [UserInfoId] => 17680 [1] => 110 [RankedSportEventId] => 110 [2] => 30 [sumUPts] => 30 [3] => 3 [cntUPts] => 3 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 15862 [UserInfoId] => 15862 [1] => 110 [RankedSportEventId] => 110 [2] => 26 [sumUPts] => 26 [3] => 3 [cntUPts] => 3 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 17830 [UserInfoId] => 17830 [1] => 110 [RankedSportEventId] => 110 [2] => 26 [sumUPts] => 26 [3] => 5 [cntUPts] => 5 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 20817 [UserInfoId] => 20817 [1] => 110 [RankedSportEventId] => 110 [2] => 24 [sumUPts] => 24 [3] => 3 [cntUPts] => 3 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 16559 [UserInfoId] => 16559 [1] => 110 [RankedSportEventId] => 110 [2] => 24 [sumUPts] => 24 [3] => 3 [cntUPts] => 3 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 20843 [UserInfoId] => 20843 [1] => 110 [RankedSportEventId] => 110 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 20174 [UserInfoId] => 20174 [1] => 110 [RankedSportEventId] => 110 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 17963 [UserInfoId] => 17963 [1] => 110 [RankedSportEventId] => 110 [2] => 21 [sumUPts] => 21 [3] => 3 [cntUPts] => 3 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 19980 [UserInfoId] => 19980 [1] => 110 [RankedSportEventId] => 110 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 15993 [UserInfoId] => 15993 [1] => 110 [RankedSportEventId] => 110 [2] => 18 [sumUPts] => 18 [3] => 3 [cntUPts] => 3 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 20217 [UserInfoId] => 20217 [1] => 110 [RankedSportEventId] => 110 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 19889 [UserInfoId] => 19889 [1] => 110 [RankedSportEventId] => 110 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 19806 [UserInfoId] => 19806 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 20286 [UserInfoId] => 20286 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 19581 [UserInfoId] => 19581 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 21944 [UserInfoId] => 21944 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 20309 [UserInfoId] => 20309 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 19858 [UserInfoId] => 19858 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 22068 [UserInfoId] => 22068 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 19657 [UserInfoId] => 19657 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 20863 [UserInfoId] => 20863 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 21720 [UserInfoId] => 21720 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 19639 [UserInfoId] => 19639 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 19867 [UserInfoId] => 19867 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 21456 [UserInfoId] => 21456 [1] => 110 [RankedSportEventId] => 110 [2] => 10 [sumUPts] => 10 [3] => 2 [cntUPts] => 2 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 19659 [UserInfoId] => 19659 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 18378 [UserInfoId] => 18378 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 20960 [UserInfoId] => 20960 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 20311 [UserInfoId] => 20311 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 19891 [UserInfoId] => 19891 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 21020 [UserInfoId] => 21020 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 21380 [UserInfoId] => 21380 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 21125 [UserInfoId] => 21125 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) Array ( [0] => 15471 [UserInfoId] => 15471 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8267 [RankingDivisionDefinitionId] => 8267 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 110 [DivisionId] => 110 [8] => 110 [SportEventId] => 110 [9] => S-28 [DivisionName] => S-28 [10] => Sparring - Point * 8-9 * Beginner * Male [Description] => Sparring - Point * 8-9 * Beginner * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 110 [Sequence] => 110 ) BB[ 15471 ]) 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=111 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 16843 [UserInfoId] => 16843 [1] => 110 [RankedSportEventId] => 110 [2] => 42 [sumUPts] => 42 [3] => 4 [cntUPts] => 4 [4] => 8268 [RankingDivisionDefinitionId] => 8268 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 111 [DivisionId] => 111 [8] => 110 [SportEventId] => 110 [9] => S-29 [DivisionName] => S-29 [10] => Sparring - Point * 8-9 * Intermediate * Male [Description] => Sparring - Point * 8-9 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 111 [Sequence] => 111 ) Array ( [0] => 14797 [UserInfoId] => 14797 [1] => 110 [RankedSportEventId] => 110 [2] => 36 [sumUPts] => 36 [3] => 3 [cntUPts] => 3 [4] => 8268 [RankingDivisionDefinitionId] => 8268 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 111 [DivisionId] => 111 [8] => 110 [SportEventId] => 110 [9] => S-29 [DivisionName] => S-29 [10] => Sparring - Point * 8-9 * Intermediate * Male [Description] => Sparring - Point * 8-9 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 111 [Sequence] => 111 ) Array ( [0] => 13621 [UserInfoId] => 13621 [1] => 110 [RankedSportEventId] => 110 [2] => 30 [sumUPts] => 30 [3] => 3 [cntUPts] => 3 [4] => 8268 [RankingDivisionDefinitionId] => 8268 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 111 [DivisionId] => 111 [8] => 110 [SportEventId] => 110 [9] => S-29 [DivisionName] => S-29 [10] => Sparring - Point * 8-9 * Intermediate * Male [Description] => Sparring - Point * 8-9 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 111 [Sequence] => 111 ) Array ( [0] => 16083 [UserInfoId] => 16083 [1] => 110 [RankedSportEventId] => 110 [2] => 30 [sumUPts] => 30 [3] => 4 [cntUPts] => 4 [4] => 8268 [RankingDivisionDefinitionId] => 8268 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 111 [DivisionId] => 111 [8] => 110 [SportEventId] => 110 [9] => S-29 [DivisionName] => S-29 [10] => Sparring - Point * 8-9 * Intermediate * Male [Description] => Sparring - Point * 8-9 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 111 [Sequence] => 111 ) Array ( [0] => 16557 [UserInfoId] => 16557 [1] => 110 [RankedSportEventId] => 110 [2] => 24 [sumUPts] => 24 [3] => 4 [cntUPts] => 4 [4] => 8268 [RankingDivisionDefinitionId] => 8268 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 111 [DivisionId] => 111 [8] => 110 [SportEventId] => 110 [9] => S-29 [DivisionName] => S-29 [10] => Sparring - Point * 8-9 * Intermediate * Male [Description] => Sparring - Point * 8-9 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 111 [Sequence] => 111 ) Array ( [0] => 16823 [UserInfoId] => 16823 [1] => 110 [RankedSportEventId] => 110 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8268 [RankingDivisionDefinitionId] => 8268 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 111 [DivisionId] => 111 [8] => 110 [SportEventId] => 110 [9] => S-29 [DivisionName] => S-29 [10] => Sparring - Point * 8-9 * Intermediate * Male [Description] => Sparring - Point * 8-9 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 111 [Sequence] => 111 ) Array ( [0] => 20053 [UserInfoId] => 20053 [1] => 110 [RankedSportEventId] => 110 [2] => 24 [sumUPts] => 24 [3] => 3 [cntUPts] => 3 [4] => 8268 [RankingDivisionDefinitionId] => 8268 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 111 [DivisionId] => 111 [8] => 110 [SportEventId] => 110 [9] => S-29 [DivisionName] => S-29 [10] => Sparring - Point * 8-9 * Intermediate * Male [Description] => Sparring - Point * 8-9 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 111 [Sequence] => 111 ) Array ( [0] => 15471 [UserInfoId] => 15471 [1] => 110 [RankedSportEventId] => 110 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8268 [RankingDivisionDefinitionId] => 8268 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 111 [DivisionId] => 111 [8] => 110 [SportEventId] => 110 [9] => S-29 [DivisionName] => S-29 [10] => Sparring - Point * 8-9 * Intermediate * Male [Description] => Sparring - Point * 8-9 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [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] => 111 [Sequence] => 111 ) Standings for Flannigan, Kaden Darneal


Standings for:
Flannigan, Kaden Darneal
Event & Description Skill Level Weight (lbs) Points # Events Rank
F-6 Forms
Mixed * 8 - 9 yrs
Intermediate 15213
M-1 Forms - Specialty
Mixed * ≤ 11 yrs
Beginner 12111
M-2 Forms - Specialty
Mixed * ≤ 11 yrs
Intermediate 18212
FH-1 Forms - Traditional Hard Style
Mixed * ≤ 11 yrs
Beginner 12110
FH-2 Forms - Traditional Hard Style
Mixed * ≤ 11 yrs
Intermediate 9116
SD-1 Self Defense
Mixed * ≤ 11 yrs
Beginner 1215
SD-2 Self Defense
Mixed * ≤ 11 yrs
Intermediate 1217
S-28 Sparring - Point
Male * 8 - 9 yrs
Beginner 6136
S-29 Sparring - Point
Male * 8 - 9 yrs
Intermediate 2428
Total120