BB[ 15249 ]) 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=40 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15514 [UserInfoId] => 15514 [1] => 277 [RankedSportEventId] => 277 [2] => 84 [sumUPts] => 84 [3] => 9 [cntUPts] => 9 [4] => 8197 [RankingDivisionDefinitionId] => 8197 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 40 [DivisionId] => 40 [8] => 277 [SportEventId] => 277 [9] => M-3 [DivisionName] => M-3 [10] => Forms - Specialty * <= 11 * Advanced * Mixed [Description] => Forms - Specialty * <= 11 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 40 [Sequence] => 40 ) Array ( [0] => 15651 [UserInfoId] => 15651 [1] => 277 [RankedSportEventId] => 277 [2] => 60 [sumUPts] => 60 [3] => 5 [cntUPts] => 5 [4] => 8197 [RankingDivisionDefinitionId] => 8197 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 40 [DivisionId] => 40 [8] => 277 [SportEventId] => 277 [9] => M-3 [DivisionName] => M-3 [10] => Forms - Specialty * <= 11 * Advanced * Mixed [Description] => Forms - Specialty * <= 11 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 40 [Sequence] => 40 ) Array ( [0] => 15133 [UserInfoId] => 15133 [1] => 277 [RankedSportEventId] => 277 [2] => 42 [sumUPts] => 42 [3] => 4 [cntUPts] => 4 [4] => 8197 [RankingDivisionDefinitionId] => 8197 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 40 [DivisionId] => 40 [8] => 277 [SportEventId] => 277 [9] => M-3 [DivisionName] => M-3 [10] => Forms - Specialty * <= 11 * Advanced * Mixed [Description] => Forms - Specialty * <= 11 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 40 [Sequence] => 40 ) Array ( [0] => 13480 [UserInfoId] => 13480 [1] => 277 [RankedSportEventId] => 277 [2] => 36 [sumUPts] => 36 [3] => 4 [cntUPts] => 4 [4] => 8197 [RankingDivisionDefinitionId] => 8197 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 40 [DivisionId] => 40 [8] => 277 [SportEventId] => 277 [9] => M-3 [DivisionName] => M-3 [10] => Forms - Specialty * <= 11 * Advanced * Mixed [Description] => Forms - Specialty * <= 11 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 40 [Sequence] => 40 ) Array ( [0] => 15249 [UserInfoId] => 15249 [1] => 277 [RankedSportEventId] => 277 [2] => 36 [sumUPts] => 36 [3] => 3 [cntUPts] => 3 [4] => 8197 [RankingDivisionDefinitionId] => 8197 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 40 [DivisionId] => 40 [8] => 277 [SportEventId] => 277 [9] => M-3 [DivisionName] => M-3 [10] => Forms - Specialty * <= 11 * Advanced * Mixed [Description] => Forms - Specialty * <= 11 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 40 [Sequence] => 40 ) BB[ 15249 ]) 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=44 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15074 [UserInfoId] => 15074 [1] => 277 [RankedSportEventId] => 277 [2] => 64 [sumUPts] => 64 [3] => 7 [cntUPts] => 7 [4] => 8201 [RankingDivisionDefinitionId] => 8201 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 44 [DivisionId] => 44 [8] => 277 [SportEventId] => 277 [9] => M-7 [DivisionName] => M-7 [10] => Forms - Specialty * 12-17 * Advanced * Mixed [Description] => Forms - Specialty * 12-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 44 [Sequence] => 44 ) Array ( [0] => 15437 [UserInfoId] => 15437 [1] => 277 [RankedSportEventId] => 277 [2] => 57 [sumUPts] => 57 [3] => 5 [cntUPts] => 5 [4] => 8201 [RankingDivisionDefinitionId] => 8201 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 44 [DivisionId] => 44 [8] => 277 [SportEventId] => 277 [9] => M-7 [DivisionName] => M-7 [10] => Forms - Specialty * 12-17 * Advanced * Mixed [Description] => Forms - Specialty * 12-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 44 [Sequence] => 44 ) Array ( [0] => 15627 [UserInfoId] => 15627 [1] => 277 [RankedSportEventId] => 277 [2] => 42 [sumUPts] => 42 [3] => 5 [cntUPts] => 5 [4] => 8201 [RankingDivisionDefinitionId] => 8201 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 44 [DivisionId] => 44 [8] => 277 [SportEventId] => 277 [9] => M-7 [DivisionName] => M-7 [10] => Forms - Specialty * 12-17 * Advanced * Mixed [Description] => Forms - Specialty * 12-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 44 [Sequence] => 44 ) Array ( [0] => 15721 [UserInfoId] => 15721 [1] => 277 [RankedSportEventId] => 277 [2] => 33 [sumUPts] => 33 [3] => 3 [cntUPts] => 3 [4] => 8201 [RankingDivisionDefinitionId] => 8201 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 44 [DivisionId] => 44 [8] => 277 [SportEventId] => 277 [9] => M-7 [DivisionName] => M-7 [10] => Forms - Specialty * 12-17 * Advanced * Mixed [Description] => Forms - Specialty * 12-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 44 [Sequence] => 44 ) Array ( [0] => 18113 [UserInfoId] => 18113 [1] => 277 [RankedSportEventId] => 277 [2] => 24 [sumUPts] => 24 [3] => 3 [cntUPts] => 3 [4] => 8201 [RankingDivisionDefinitionId] => 8201 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 44 [DivisionId] => 44 [8] => 277 [SportEventId] => 277 [9] => M-7 [DivisionName] => M-7 [10] => Forms - Specialty * 12-17 * Advanced * Mixed [Description] => Forms - Specialty * 12-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 44 [Sequence] => 44 ) Array ( [0] => 15249 [UserInfoId] => 15249 [1] => 277 [RankedSportEventId] => 277 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8201 [RankingDivisionDefinitionId] => 8201 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 44 [DivisionId] => 44 [8] => 277 [SportEventId] => 277 [9] => M-7 [DivisionName] => M-7 [10] => Forms - Specialty * 12-17 * Advanced * Mixed [Description] => Forms - Specialty * 12-17 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 44 [Sequence] => 44 ) BB[ 15249 ]) 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=53 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15651 [UserInfoId] => 15651 [1] => 340 [RankedSportEventId] => 340 [2] => 54 [sumUPts] => 54 [3] => 5 [cntUPts] => 5 [4] => 8210 [RankingDivisionDefinitionId] => 8210 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 53 [DivisionId] => 53 [8] => 340 [SportEventId] => 340 [9] => FH-3 [DivisionName] => FH-3 [10] => Forms - Traditional Hard Style * <= 11 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 53 [Sequence] => 53 ) Array ( [0] => 15133 [UserInfoId] => 15133 [1] => 340 [RankedSportEventId] => 340 [2] => 42 [sumUPts] => 42 [3] => 4 [cntUPts] => 4 [4] => 8210 [RankingDivisionDefinitionId] => 8210 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 53 [DivisionId] => 53 [8] => 340 [SportEventId] => 340 [9] => FH-3 [DivisionName] => FH-3 [10] => Forms - Traditional Hard Style * <= 11 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 53 [Sequence] => 53 ) Array ( [0] => 19916 [UserInfoId] => 19916 [1] => 340 [RankedSportEventId] => 340 [2] => 36 [sumUPts] => 36 [3] => 4 [cntUPts] => 4 [4] => 8210 [RankingDivisionDefinitionId] => 8210 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 53 [DivisionId] => 53 [8] => 340 [SportEventId] => 340 [9] => FH-3 [DivisionName] => FH-3 [10] => Forms - Traditional Hard Style * <= 11 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 53 [Sequence] => 53 ) Array ( [0] => 15062 [UserInfoId] => 15062 [1] => 340 [RankedSportEventId] => 340 [2] => 36 [sumUPts] => 36 [3] => 3 [cntUPts] => 3 [4] => 8210 [RankingDivisionDefinitionId] => 8210 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 53 [DivisionId] => 53 [8] => 340 [SportEventId] => 340 [9] => FH-3 [DivisionName] => FH-3 [10] => Forms - Traditional Hard Style * <= 11 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 53 [Sequence] => 53 ) Array ( [0] => 15705 [UserInfoId] => 15705 [1] => 340 [RankedSportEventId] => 340 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8210 [RankingDivisionDefinitionId] => 8210 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 53 [DivisionId] => 53 [8] => 340 [SportEventId] => 340 [9] => FH-3 [DivisionName] => FH-3 [10] => Forms - Traditional Hard Style * <= 11 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 53 [Sequence] => 53 ) Array ( [0] => 15950 [UserInfoId] => 15950 [1] => 340 [RankedSportEventId] => 340 [2] => 18 [sumUPts] => 18 [3] => 3 [cntUPts] => 3 [4] => 8210 [RankingDivisionDefinitionId] => 8210 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 53 [DivisionId] => 53 [8] => 340 [SportEventId] => 340 [9] => FH-3 [DivisionName] => FH-3 [10] => Forms - Traditional Hard Style * <= 11 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 53 [Sequence] => 53 ) Array ( [0] => 15611 [UserInfoId] => 15611 [1] => 340 [RankedSportEventId] => 340 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [4] => 8210 [RankingDivisionDefinitionId] => 8210 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 53 [DivisionId] => 53 [8] => 340 [SportEventId] => 340 [9] => FH-3 [DivisionName] => FH-3 [10] => Forms - Traditional Hard Style * <= 11 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 53 [Sequence] => 53 ) Array ( [0] => 16049 [UserInfoId] => 16049 [1] => 340 [RankedSportEventId] => 340 [2] => 13 [sumUPts] => 13 [3] => 2 [cntUPts] => 2 [4] => 8210 [RankingDivisionDefinitionId] => 8210 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 53 [DivisionId] => 53 [8] => 340 [SportEventId] => 340 [9] => FH-3 [DivisionName] => FH-3 [10] => Forms - Traditional Hard Style * <= 11 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 53 [Sequence] => 53 ) Array ( [0] => 15249 [UserInfoId] => 15249 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8210 [RankingDivisionDefinitionId] => 8210 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 53 [DivisionId] => 53 [8] => 340 [SportEventId] => 340 [9] => FH-3 [DivisionName] => FH-3 [10] => Forms - Traditional Hard Style * <= 11 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 53 [Sequence] => 53 ) BB[ 15249 ]) 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=56 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 12742 [UserInfoId] => 12742 [1] => 340 [RankedSportEventId] => 340 [2] => 56 [sumUPts] => 56 [3] => 6 [cntUPts] => 6 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 16860 [UserInfoId] => 16860 [1] => 340 [RankedSportEventId] => 340 [2] => 45 [sumUPts] => 45 [3] => 4 [cntUPts] => 4 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 20630 [UserInfoId] => 20630 [1] => 340 [RankedSportEventId] => 340 [2] => 25 [sumUPts] => 25 [3] => 3 [cntUPts] => 3 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 15481 [UserInfoId] => 15481 [1] => 340 [RankedSportEventId] => 340 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 13305 [UserInfoId] => 13305 [1] => 340 [RankedSportEventId] => 340 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 13396 [UserInfoId] => 13396 [1] => 340 [RankedSportEventId] => 340 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 17118 [UserInfoId] => 17118 [1] => 340 [RankedSportEventId] => 340 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 21355 [UserInfoId] => 21355 [1] => 340 [RankedSportEventId] => 340 [2] => 15 [sumUPts] => 15 [3] => 3 [cntUPts] => 3 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 20077 [UserInfoId] => 20077 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 19635 [UserInfoId] => 19635 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 15657 [UserInfoId] => 15657 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 17891 [UserInfoId] => 17891 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 21728 [UserInfoId] => 21728 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 12813 [UserInfoId] => 12813 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 18269 [UserInfoId] => 18269 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 16925 [UserInfoId] => 16925 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 17119 [UserInfoId] => 17119 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 19744 [UserInfoId] => 19744 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 15705 [UserInfoId] => 15705 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 15790 [UserInfoId] => 15790 [1] => 340 [RankedSportEventId] => 340 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 15344 [UserInfoId] => 15344 [1] => 340 [RankedSportEventId] => 340 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 19715 [UserInfoId] => 19715 [1] => 340 [RankedSportEventId] => 340 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 17083 [UserInfoId] => 17083 [1] => 340 [RankedSportEventId] => 340 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 20144 [UserInfoId] => 20144 [1] => 340 [RankedSportEventId] => 340 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 13348 [UserInfoId] => 13348 [1] => 340 [RankedSportEventId] => 340 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 20587 [UserInfoId] => 20587 [1] => 340 [RankedSportEventId] => 340 [2] => 8 [sumUPts] => 8 [3] => 1 [cntUPts] => 1 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 16867 [UserInfoId] => 16867 [1] => 340 [RankedSportEventId] => 340 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 22018 [UserInfoId] => 22018 [1] => 340 [RankedSportEventId] => 340 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) Array ( [0] => 15249 [UserInfoId] => 15249 [1] => 340 [RankedSportEventId] => 340 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8213 [RankingDivisionDefinitionId] => 8213 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 56 [DivisionId] => 56 [8] => 340 [SportEventId] => 340 [9] => FH-6 [DivisionName] => FH-6 [10] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 56 [Sequence] => 56 ) BB[ 15249 ]) 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=115 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 13716 [UserInfoId] => 13716 [1] => 110 [RankedSportEventId] => 110 [2] => 90 [sumUPts] => 90 [3] => 8 [cntUPts] => 8 [4] => 8272 [RankingDivisionDefinitionId] => 8272 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 115 [DivisionId] => 115 [8] => 110 [SportEventId] => 110 [9] => S-33 [DivisionName] => S-33 [10] => Sparring - Point * 10-11 * Advanced * Male [Description] => Sparring - Point * 10-11 * Advanced * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 115 [Sequence] => 115 ) Array ( [0] => 18409 [UserInfoId] => 18409 [1] => 110 [RankedSportEventId] => 110 [2] => 54 [sumUPts] => 54 [3] => 5 [cntUPts] => 5 [4] => 8272 [RankingDivisionDefinitionId] => 8272 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 115 [DivisionId] => 115 [8] => 110 [SportEventId] => 110 [9] => S-33 [DivisionName] => S-33 [10] => Sparring - Point * 10-11 * Advanced * Male [Description] => Sparring - Point * 10-11 * Advanced * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 115 [Sequence] => 115 ) Array ( [0] => 19916 [UserInfoId] => 19916 [1] => 110 [RankedSportEventId] => 110 [2] => 48 [sumUPts] => 48 [3] => 7 [cntUPts] => 7 [4] => 8272 [RankingDivisionDefinitionId] => 8272 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 115 [DivisionId] => 115 [8] => 110 [SportEventId] => 110 [9] => S-33 [DivisionName] => S-33 [10] => Sparring - Point * 10-11 * Advanced * Male [Description] => Sparring - Point * 10-11 * Advanced * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 115 [Sequence] => 115 ) Array ( [0] => 15133 [UserInfoId] => 15133 [1] => 110 [RankedSportEventId] => 110 [2] => 39 [sumUPts] => 39 [3] => 4 [cntUPts] => 4 [4] => 8272 [RankingDivisionDefinitionId] => 8272 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 115 [DivisionId] => 115 [8] => 110 [SportEventId] => 110 [9] => S-33 [DivisionName] => S-33 [10] => Sparring - Point * 10-11 * Advanced * Male [Description] => Sparring - Point * 10-11 * Advanced * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 115 [Sequence] => 115 ) Array ( [0] => 13503 [UserInfoId] => 13503 [1] => 110 [RankedSportEventId] => 110 [2] => 33 [sumUPts] => 33 [3] => 4 [cntUPts] => 4 [4] => 8272 [RankingDivisionDefinitionId] => 8272 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 115 [DivisionId] => 115 [8] => 110 [SportEventId] => 110 [9] => S-33 [DivisionName] => S-33 [10] => Sparring - Point * 10-11 * Advanced * Male [Description] => Sparring - Point * 10-11 * Advanced * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 115 [Sequence] => 115 ) Array ( [0] => 13367 [UserInfoId] => 13367 [1] => 110 [RankedSportEventId] => 110 [2] => 30 [sumUPts] => 30 [3] => 4 [cntUPts] => 4 [4] => 8272 [RankingDivisionDefinitionId] => 8272 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 115 [DivisionId] => 115 [8] => 110 [SportEventId] => 110 [9] => S-33 [DivisionName] => S-33 [10] => Sparring - Point * 10-11 * Advanced * Male [Description] => Sparring - Point * 10-11 * Advanced * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 115 [Sequence] => 115 ) Array ( [0] => 15249 [UserInfoId] => 15249 [1] => 110 [RankedSportEventId] => 110 [2] => 30 [sumUPts] => 30 [3] => 3 [cntUPts] => 3 [4] => 8272 [RankingDivisionDefinitionId] => 8272 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 115 [DivisionId] => 115 [8] => 110 [SportEventId] => 110 [9] => S-33 [DivisionName] => S-33 [10] => Sparring - Point * 10-11 * Advanced * Male [Description] => Sparring - Point * 10-11 * Advanced * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 115 [Sequence] => 115 ) BB[ 15249 ]) 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=119 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15403 [UserInfoId] => 15403 [1] => 110 [RankedSportEventId] => 110 [2] => 81 [sumUPts] => 81 [3] => 11 [cntUPts] => 11 [4] => 8276 [RankingDivisionDefinitionId] => 8276 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 119 [DivisionId] => 119 [8] => 110 [SportEventId] => 110 [9] => S-37 [DivisionName] => S-37 [10] => Sparring - Point * 12-13 * Advanced * Male [Description] => Sparring - Point * 12-13 * Advanced * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 119 [Sequence] => 119 ) Array ( [0] => 15627 [UserInfoId] => 15627 [1] => 110 [RankedSportEventId] => 110 [2] => 51 [sumUPts] => 51 [3] => 6 [cntUPts] => 6 [4] => 8276 [RankingDivisionDefinitionId] => 8276 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 119 [DivisionId] => 119 [8] => 110 [SportEventId] => 110 [9] => S-37 [DivisionName] => S-37 [10] => Sparring - Point * 12-13 * Advanced * Male [Description] => Sparring - Point * 12-13 * Advanced * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 119 [Sequence] => 119 ) Array ( [0] => 15028 [UserInfoId] => 15028 [1] => 110 [RankedSportEventId] => 110 [2] => 48 [sumUPts] => 48 [3] => 4 [cntUPts] => 4 [4] => 8276 [RankingDivisionDefinitionId] => 8276 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 119 [DivisionId] => 119 [8] => 110 [SportEventId] => 110 [9] => S-37 [DivisionName] => S-37 [10] => Sparring - Point * 12-13 * Advanced * Male [Description] => Sparring - Point * 12-13 * Advanced * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 119 [Sequence] => 119 ) Array ( [0] => 13742 [UserInfoId] => 13742 [1] => 110 [RankedSportEventId] => 110 [2] => 45 [sumUPts] => 45 [3] => 4 [cntUPts] => 4 [4] => 8276 [RankingDivisionDefinitionId] => 8276 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 119 [DivisionId] => 119 [8] => 110 [SportEventId] => 110 [9] => S-37 [DivisionName] => S-37 [10] => Sparring - Point * 12-13 * Advanced * Male [Description] => Sparring - Point * 12-13 * Advanced * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 119 [Sequence] => 119 ) Array ( [0] => 13780 [UserInfoId] => 13780 [1] => 110 [RankedSportEventId] => 110 [2] => 42 [sumUPts] => 42 [3] => 4 [cntUPts] => 4 [4] => 8276 [RankingDivisionDefinitionId] => 8276 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 119 [DivisionId] => 119 [8] => 110 [SportEventId] => 110 [9] => S-37 [DivisionName] => S-37 [10] => Sparring - Point * 12-13 * Advanced * Male [Description] => Sparring - Point * 12-13 * Advanced * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 119 [Sequence] => 119 ) Array ( [0] => 13660 [UserInfoId] => 13660 [1] => 110 [RankedSportEventId] => 110 [2] => 39 [sumUPts] => 39 [3] => 4 [cntUPts] => 4 [4] => 8276 [RankingDivisionDefinitionId] => 8276 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 119 [DivisionId] => 119 [8] => 110 [SportEventId] => 110 [9] => S-37 [DivisionName] => S-37 [10] => Sparring - Point * 12-13 * Advanced * Male [Description] => Sparring - Point * 12-13 * Advanced * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 119 [Sequence] => 119 ) Array ( [0] => 15404 [UserInfoId] => 15404 [1] => 110 [RankedSportEventId] => 110 [2] => 36 [sumUPts] => 36 [3] => 3 [cntUPts] => 3 [4] => 8276 [RankingDivisionDefinitionId] => 8276 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 119 [DivisionId] => 119 [8] => 110 [SportEventId] => 110 [9] => S-37 [DivisionName] => S-37 [10] => Sparring - Point * 12-13 * Advanced * Male [Description] => Sparring - Point * 12-13 * Advanced * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 119 [Sequence] => 119 ) Array ( [0] => 13535 [UserInfoId] => 13535 [1] => 110 [RankedSportEventId] => 110 [2] => 36 [sumUPts] => 36 [3] => 4 [cntUPts] => 4 [4] => 8276 [RankingDivisionDefinitionId] => 8276 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 119 [DivisionId] => 119 [8] => 110 [SportEventId] => 110 [9] => S-37 [DivisionName] => S-37 [10] => Sparring - Point * 12-13 * Advanced * Male [Description] => Sparring - Point * 12-13 * Advanced * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 119 [Sequence] => 119 ) Array ( [0] => 15074 [UserInfoId] => 15074 [1] => 110 [RankedSportEventId] => 110 [2] => 28 [sumUPts] => 28 [3] => 5 [cntUPts] => 5 [4] => 8276 [RankingDivisionDefinitionId] => 8276 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 119 [DivisionId] => 119 [8] => 110 [SportEventId] => 110 [9] => S-37 [DivisionName] => S-37 [10] => Sparring - Point * 12-13 * Advanced * Male [Description] => Sparring - Point * 12-13 * Advanced * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 119 [Sequence] => 119 ) Array ( [0] => 16267 [UserInfoId] => 16267 [1] => 110 [RankedSportEventId] => 110 [2] => 22 [sumUPts] => 22 [3] => 4 [cntUPts] => 4 [4] => 8276 [RankingDivisionDefinitionId] => 8276 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 119 [DivisionId] => 119 [8] => 110 [SportEventId] => 110 [9] => S-37 [DivisionName] => S-37 [10] => Sparring - Point * 12-13 * Advanced * Male [Description] => Sparring - Point * 12-13 * Advanced * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 119 [Sequence] => 119 ) Array ( [0] => 13544 [UserInfoId] => 13544 [1] => 110 [RankedSportEventId] => 110 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8276 [RankingDivisionDefinitionId] => 8276 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 119 [DivisionId] => 119 [8] => 110 [SportEventId] => 110 [9] => S-37 [DivisionName] => S-37 [10] => Sparring - Point * 12-13 * Advanced * Male [Description] => Sparring - Point * 12-13 * Advanced * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 119 [Sequence] => 119 ) Array ( [0] => 20405 [UserInfoId] => 20405 [1] => 110 [RankedSportEventId] => 110 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8276 [RankingDivisionDefinitionId] => 8276 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 119 [DivisionId] => 119 [8] => 110 [SportEventId] => 110 [9] => S-37 [DivisionName] => S-37 [10] => Sparring - Point * 12-13 * Advanced * Male [Description] => Sparring - Point * 12-13 * Advanced * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 119 [Sequence] => 119 ) Array ( [0] => 15249 [UserInfoId] => 15249 [1] => 110 [RankedSportEventId] => 110 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8276 [RankingDivisionDefinitionId] => 8276 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 119 [DivisionId] => 119 [8] => 110 [SportEventId] => 110 [9] => S-37 [DivisionName] => S-37 [10] => Sparring - Point * 12-13 * Advanced * Male [Description] => Sparring - Point * 12-13 * Advanced * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 119 [Sequence] => 119 ) Standings for Chapa, Fernando


Standings for:
Chapa, Fernando
Event & Description Skill Level Weight (lbs) Points # Events Rank
M-3 Forms - Specialty
Mixed * ≤ 11 yrs
Advanced 3635
M-7 Forms - Specialty
Mixed * 12 - 17 yrs
Advanced 2426
FH-3 Forms - Traditional Hard Style
Mixed * ≤ 11 yrs
Advanced 1219
FH-6 Forms - Traditional Hard Style
Mixed * 12 - 17 yrs
Advanced 6129
S-33 Sparring - Point
Male * 10 - 11 yrs
Advanced 3037
S-37 Sparring - Point
Male * 12 - 13 yrs
Advanced 15213
Total123