BB[ 15062 ]) SELECT UserInfoId, rem.RankedSportEventId, sum(Points) as sumUPts, count(Points) as cntUPts, rdd.* FROM UserRankingPoints urp, RankingEventMappings rem, RankingDivisionDefinitions rdd WHERE urp.SportEventId=rem.SportEventId AND urp.RankingSystemId=8 AND rem.RankedSportEventId=299 AND urp.RankingSystemId=rdd.RankingSystemDefinitionId AND urp.TournamentId in ( 145,146,147,148,149,150,151,152,153,154,155,156,157,159,161,162,163,164,165,166,167,168,169,170,171 ) AND urp.RankingDivisionId=rdd.DivisionId AND urp.RankingDivisionId=156 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15062 [UserInfoId] => 15062 [1] => 299 [RankedSportEventId] => 299 [2] => 131 [sumUPts] => 131 [3] => 16 [cntUPts] => 16 [4] => 8313 [RankingDivisionDefinitionId] => 8313 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 156 [DivisionId] => 156 [8] => 299 [SportEventId] => 299 [9] => B-1 [DivisionName] => B-1 [10] => Breaking - Power Wood - Hand/Elbow * <= 11 * Beg / Intr / Adv [Description] => Breaking - Power Wood - Hand/Elbow * <= 11 * Beg / Intr / Adv [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 156 [Sequence] => 156 ) BB[ 15062 ]) SELECT UserInfoId, rem.RankedSportEventId, sum(Points) as sumUPts, count(Points) as cntUPts, rdd.* FROM UserRankingPoints urp, RankingEventMappings rem, RankingDivisionDefinitions rdd WHERE urp.SportEventId=rem.SportEventId AND urp.RankingSystemId=8 AND rem.RankedSportEventId=299 AND urp.RankingSystemId=rdd.RankingSystemDefinitionId AND urp.TournamentId in ( 145,146,147,148,149,150,151,152,153,154,155,156,157,159,161,162,163,164,165,166,167,168,169,170,171 ) AND urp.RankingDivisionId=rdd.DivisionId AND urp.RankingDivisionId=158 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 13275 [UserInfoId] => 13275 [1] => 299 [RankedSportEventId] => 299 [2] => 160 [sumUPts] => 160 [3] => 15 [cntUPts] => 15 [4] => 8315 [RankingDivisionDefinitionId] => 8315 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 158 [DivisionId] => 158 [8] => 299 [SportEventId] => 299 [9] => B-3 [DivisionName] => B-3 [10] => Breaking - Power Wood - Hand/Elbow * <= 17 * Black * Mixed [Description] => Breaking - Power Wood - Hand/Elbow * <= 17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 158 [Sequence] => 158 ) Array ( [0] => 15281 [UserInfoId] => 15281 [1] => 299 [RankedSportEventId] => 299 [2] => 48 [sumUPts] => 48 [3] => 4 [cntUPts] => 4 [4] => 8315 [RankingDivisionDefinitionId] => 8315 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 158 [DivisionId] => 158 [8] => 299 [SportEventId] => 299 [9] => B-3 [DivisionName] => B-3 [10] => Breaking - Power Wood - Hand/Elbow * <= 17 * Black * Mixed [Description] => Breaking - Power Wood - Hand/Elbow * <= 17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 158 [Sequence] => 158 ) Array ( [0] => 19381 [UserInfoId] => 19381 [1] => 299 [RankedSportEventId] => 299 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8315 [RankingDivisionDefinitionId] => 8315 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 158 [DivisionId] => 158 [8] => 299 [SportEventId] => 299 [9] => B-3 [DivisionName] => B-3 [10] => Breaking - Power Wood - Hand/Elbow * <= 17 * Black * Mixed [Description] => Breaking - Power Wood - Hand/Elbow * <= 17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 158 [Sequence] => 158 ) Array ( [0] => 15062 [UserInfoId] => 15062 [1] => 299 [RankedSportEventId] => 299 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8315 [RankingDivisionDefinitionId] => 8315 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 158 [DivisionId] => 158 [8] => 299 [SportEventId] => 299 [9] => B-3 [DivisionName] => B-3 [10] => Breaking - Power Wood - Hand/Elbow * <= 17 * Black * Mixed [Description] => Breaking - Power Wood - Hand/Elbow * <= 17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 158 [Sequence] => 158 ) BB[ 15062 ]) 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=13 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15062 [UserInfoId] => 15062 [1] => 132 [RankedSportEventId] => 132 [2] => 179 [sumUPts] => 179 [3] => 20 [cntUPts] => 20 [4] => 8170 [RankingDivisionDefinitionId] => 8170 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 13 [DivisionId] => 13 [8] => 132 [SportEventId] => 132 [9] => F-11 [DivisionName] => F-11 [10] => Forms * 10-11 * Black * Mixed [Description] => Forms * 10-11 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 13 [Sequence] => 13 ) BB[ 15062 ]) 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=17 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 12742 [UserInfoId] => 12742 [1] => 132 [RankedSportEventId] => 132 [2] => 60 [sumUPts] => 60 [3] => 7 [cntUPts] => 7 [4] => 8174 [RankingDivisionDefinitionId] => 8174 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 17 [DivisionId] => 17 [8] => 132 [SportEventId] => 132 [9] => F-15 [DivisionName] => F-15 [10] => Forms * 12-13 * Black * Mixed [Description] => Forms * 12-13 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 17 [Sequence] => 17 ) Array ( [0] => 15481 [UserInfoId] => 15481 [1] => 132 [RankedSportEventId] => 132 [2] => 54 [sumUPts] => 54 [3] => 6 [cntUPts] => 6 [4] => 8174 [RankingDivisionDefinitionId] => 8174 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 17 [DivisionId] => 17 [8] => 132 [SportEventId] => 132 [9] => F-15 [DivisionName] => F-15 [10] => Forms * 12-13 * Black * Mixed [Description] => Forms * 12-13 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 17 [Sequence] => 17 ) Array ( [0] => 13396 [UserInfoId] => 13396 [1] => 132 [RankedSportEventId] => 132 [2] => 48 [sumUPts] => 48 [3] => 5 [cntUPts] => 5 [4] => 8174 [RankingDivisionDefinitionId] => 8174 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 17 [DivisionId] => 17 [8] => 132 [SportEventId] => 132 [9] => F-15 [DivisionName] => F-15 [10] => Forms * 12-13 * Black * Mixed [Description] => Forms * 12-13 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 17 [Sequence] => 17 ) Array ( [0] => 15303 [UserInfoId] => 15303 [1] => 132 [RankedSportEventId] => 132 [2] => 42 [sumUPts] => 42 [3] => 5 [cntUPts] => 5 [4] => 8174 [RankingDivisionDefinitionId] => 8174 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 17 [DivisionId] => 17 [8] => 132 [SportEventId] => 132 [9] => F-15 [DivisionName] => F-15 [10] => Forms * 12-13 * Black * Mixed [Description] => Forms * 12-13 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 17 [Sequence] => 17 ) Array ( [0] => 15705 [UserInfoId] => 15705 [1] => 132 [RankedSportEventId] => 132 [2] => 30 [sumUPts] => 30 [3] => 3 [cntUPts] => 3 [4] => 8174 [RankingDivisionDefinitionId] => 8174 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 17 [DivisionId] => 17 [8] => 132 [SportEventId] => 132 [9] => F-15 [DivisionName] => F-15 [10] => Forms * 12-13 * Black * Mixed [Description] => Forms * 12-13 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 17 [Sequence] => 17 ) Array ( [0] => 14903 [UserInfoId] => 14903 [1] => 132 [RankedSportEventId] => 132 [2] => 27 [sumUPts] => 27 [3] => 3 [cntUPts] => 3 [4] => 8174 [RankingDivisionDefinitionId] => 8174 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 17 [DivisionId] => 17 [8] => 132 [SportEventId] => 132 [9] => F-15 [DivisionName] => F-15 [10] => Forms * 12-13 * Black * Mixed [Description] => Forms * 12-13 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 17 [Sequence] => 17 ) Array ( [0] => 16860 [UserInfoId] => 16860 [1] => 132 [RankedSportEventId] => 132 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8174 [RankingDivisionDefinitionId] => 8174 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 17 [DivisionId] => 17 [8] => 132 [SportEventId] => 132 [9] => F-15 [DivisionName] => F-15 [10] => Forms * 12-13 * Black * Mixed [Description] => Forms * 12-13 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 17 [Sequence] => 17 ) Array ( [0] => 18731 [UserInfoId] => 18731 [1] => 132 [RankedSportEventId] => 132 [2] => 20 [sumUPts] => 20 [3] => 4 [cntUPts] => 4 [4] => 8174 [RankingDivisionDefinitionId] => 8174 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 17 [DivisionId] => 17 [8] => 132 [SportEventId] => 132 [9] => F-15 [DivisionName] => F-15 [10] => Forms * 12-13 * Black * Mixed [Description] => Forms * 12-13 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 17 [Sequence] => 17 ) Array ( [0] => 13342 [UserInfoId] => 13342 [1] => 132 [RankedSportEventId] => 132 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8174 [RankingDivisionDefinitionId] => 8174 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 17 [DivisionId] => 17 [8] => 132 [SportEventId] => 132 [9] => F-15 [DivisionName] => F-15 [10] => Forms * 12-13 * Black * Mixed [Description] => Forms * 12-13 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 17 [Sequence] => 17 ) Array ( [0] => 12813 [UserInfoId] => 12813 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8174 [RankingDivisionDefinitionId] => 8174 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 17 [DivisionId] => 17 [8] => 132 [SportEventId] => 132 [9] => F-15 [DivisionName] => F-15 [10] => Forms * 12-13 * Black * Mixed [Description] => Forms * 12-13 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 17 [Sequence] => 17 ) Array ( [0] => 16554 [UserInfoId] => 16554 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8174 [RankingDivisionDefinitionId] => 8174 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 17 [DivisionId] => 17 [8] => 132 [SportEventId] => 132 [9] => F-15 [DivisionName] => F-15 [10] => Forms * 12-13 * Black * Mixed [Description] => Forms * 12-13 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 17 [Sequence] => 17 ) Array ( [0] => 19715 [UserInfoId] => 19715 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8174 [RankingDivisionDefinitionId] => 8174 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 17 [DivisionId] => 17 [8] => 132 [SportEventId] => 132 [9] => F-15 [DivisionName] => F-15 [10] => Forms * 12-13 * Black * Mixed [Description] => Forms * 12-13 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 17 [Sequence] => 17 ) Array ( [0] => 19759 [UserInfoId] => 19759 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8174 [RankingDivisionDefinitionId] => 8174 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 17 [DivisionId] => 17 [8] => 132 [SportEventId] => 132 [9] => F-15 [DivisionName] => F-15 [10] => Forms * 12-13 * Black * Mixed [Description] => Forms * 12-13 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 17 [Sequence] => 17 ) Array ( [0] => 17891 [UserInfoId] => 17891 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8174 [RankingDivisionDefinitionId] => 8174 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 17 [DivisionId] => 17 [8] => 132 [SportEventId] => 132 [9] => F-15 [DivisionName] => F-15 [10] => Forms * 12-13 * Black * Mixed [Description] => Forms * 12-13 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 17 [Sequence] => 17 ) Array ( [0] => 15687 [UserInfoId] => 15687 [1] => 132 [RankedSportEventId] => 132 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8174 [RankingDivisionDefinitionId] => 8174 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 17 [DivisionId] => 17 [8] => 132 [SportEventId] => 132 [9] => F-15 [DivisionName] => F-15 [10] => Forms * 12-13 * Black * Mixed [Description] => Forms * 12-13 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 17 [Sequence] => 17 ) Array ( [0] => 21146 [UserInfoId] => 21146 [1] => 132 [RankedSportEventId] => 132 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8174 [RankingDivisionDefinitionId] => 8174 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 17 [DivisionId] => 17 [8] => 132 [SportEventId] => 132 [9] => F-15 [DivisionName] => F-15 [10] => Forms * 12-13 * Black * Mixed [Description] => Forms * 12-13 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 17 [Sequence] => 17 ) Array ( [0] => 15062 [UserInfoId] => 15062 [1] => 132 [RankedSportEventId] => 132 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8174 [RankingDivisionDefinitionId] => 8174 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 17 [DivisionId] => 17 [8] => 132 [SportEventId] => 132 [9] => F-15 [DivisionName] => F-15 [10] => Forms * 12-13 * Black * Mixed [Description] => Forms * 12-13 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 17 [Sequence] => 17 ) BB[ 15062 ]) 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=41 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15062 [UserInfoId] => 15062 [1] => 277 [RankedSportEventId] => 277 [2] => 211 [sumUPts] => 211 [3] => 21 [cntUPts] => 21 [4] => 8198 [RankingDivisionDefinitionId] => 8198 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 41 [DivisionId] => 41 [8] => 277 [SportEventId] => 277 [9] => M-4 [DivisionName] => M-4 [10] => Forms - Specialty * <= 11 * Black * Mixed [Description] => Forms - Specialty * <= 11 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 41 [Sequence] => 41 ) BB[ 15062 ]) 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=45 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 14939 [UserInfoId] => 14939 [1] => 277 [RankedSportEventId] => 277 [2] => 97 [sumUPts] => 97 [3] => 9 [cntUPts] => 9 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 15481 [UserInfoId] => 15481 [1] => 277 [RankedSportEventId] => 277 [2] => 57 [sumUPts] => 57 [3] => 6 [cntUPts] => 6 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 15626 [UserInfoId] => 15626 [1] => 277 [RankedSportEventId] => 277 [2] => 51 [sumUPts] => 51 [3] => 5 [cntUPts] => 5 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 13396 [UserInfoId] => 13396 [1] => 277 [RankedSportEventId] => 277 [2] => 39 [sumUPts] => 39 [3] => 5 [cntUPts] => 5 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 15303 [UserInfoId] => 15303 [1] => 277 [RankedSportEventId] => 277 [2] => 37 [sumUPts] => 37 [3] => 5 [cntUPts] => 5 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 13305 [UserInfoId] => 13305 [1] => 277 [RankedSportEventId] => 277 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 15307 [UserInfoId] => 15307 [1] => 277 [RankedSportEventId] => 277 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 15288 [UserInfoId] => 15288 [1] => 277 [RankedSportEventId] => 277 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 19365 [UserInfoId] => 19365 [1] => 277 [RankedSportEventId] => 277 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 20836 [UserInfoId] => 20836 [1] => 277 [RankedSportEventId] => 277 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 12813 [UserInfoId] => 12813 [1] => 277 [RankedSportEventId] => 277 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 18731 [UserInfoId] => 18731 [1] => 277 [RankedSportEventId] => 277 [2] => 10 [sumUPts] => 10 [3] => 2 [cntUPts] => 2 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 20139 [UserInfoId] => 20139 [1] => 277 [RankedSportEventId] => 277 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 17891 [UserInfoId] => 17891 [1] => 277 [RankedSportEventId] => 277 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 15542 [UserInfoId] => 15542 [1] => 277 [RankedSportEventId] => 277 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 15687 [UserInfoId] => 15687 [1] => 277 [RankedSportEventId] => 277 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 20783 [UserInfoId] => 20783 [1] => 277 [RankedSportEventId] => 277 [2] => 9 [sumUPts] => 9 [3] => 2 [cntUPts] => 2 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 19759 [UserInfoId] => 19759 [1] => 277 [RankedSportEventId] => 277 [2] => 9 [sumUPts] => 9 [3] => 2 [cntUPts] => 2 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 19966 [UserInfoId] => 19966 [1] => 277 [RankedSportEventId] => 277 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 19825 [UserInfoId] => 19825 [1] => 277 [RankedSportEventId] => 277 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 15721 [UserInfoId] => 15721 [1] => 277 [RankedSportEventId] => 277 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 21934 [UserInfoId] => 21934 [1] => 277 [RankedSportEventId] => 277 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 15281 [UserInfoId] => 15281 [1] => 277 [RankedSportEventId] => 277 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 21728 [UserInfoId] => 21728 [1] => 277 [RankedSportEventId] => 277 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 13775 [UserInfoId] => 13775 [1] => 277 [RankedSportEventId] => 277 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 17233 [UserInfoId] => 17233 [1] => 277 [RankedSportEventId] => 277 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 15705 [UserInfoId] => 15705 [1] => 277 [RankedSportEventId] => 277 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) Array ( [0] => 15062 [UserInfoId] => 15062 [1] => 277 [RankedSportEventId] => 277 [2] => 4 [sumUPts] => 4 [3] => 1 [cntUPts] => 1 [4] => 8202 [RankingDivisionDefinitionId] => 8202 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 277 [SportEventId] => 277 [9] => M-8 [DivisionName] => M-8 [10] => Forms - Specialty * 12-17 * Black * Mixed [Description] => Forms - Specialty * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) BB[ 15062 ]) 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=42 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] => 15062 [UserInfoId] => 15062 [1] => 42 [RankedSportEventId] => 42 [2] => 9 [sumUPts] => 9 [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[ 15062 ]) 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 ) BB[ 15062 ]) 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=75 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15062 [UserInfoId] => 15062 [1] => 213 [RankedSportEventId] => 213 [2] => 205 [sumUPts] => 205 [3] => 19 [cntUPts] => 19 [4] => 8232 [RankingDivisionDefinitionId] => 8232 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 75 [DivisionId] => 75 [8] => 213 [SportEventId] => 213 [9] => SD-4 [DivisionName] => SD-4 [10] => Self Defense * <= 11 * Black * Mixed [Description] => Self Defense * <= 11 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 75 [Sequence] => 75 ) BB[ 15062 ]) SELECT UserInfoId, rem.RankedSportEventId, sum(Points) as sumUPts, count(Points) as cntUPts, rdd.* FROM UserRankingPoints urp, RankingEventMappings rem, RankingDivisionDefinitions rdd WHERE urp.SportEventId=rem.SportEventId AND urp.RankingSystemId=8 AND rem.RankedSportEventId=213 AND urp.RankingSystemId=rdd.RankingSystemDefinitionId AND urp.TournamentId in ( 145,146,147,148,149,150,151,152,153,154,155,156,157,159,161,162,163,164,165,166,167,168,169,170,171 ) AND urp.RankingDivisionId=rdd.DivisionId AND urp.RankingDivisionId=79 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 13275 [UserInfoId] => 13275 [1] => 213 [RankedSportEventId] => 213 [2] => 213 [sumUPts] => 213 [3] => 21 [cntUPts] => 21 [4] => 8236 [RankingDivisionDefinitionId] => 8236 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 79 [DivisionId] => 79 [8] => 213 [SportEventId] => 213 [9] => SD-8 [DivisionName] => SD-8 [10] => Self Defense * 12-17 * Black * Mixed [Description] => Self Defense * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 79 [Sequence] => 79 ) Array ( [0] => 12742 [UserInfoId] => 12742 [1] => 213 [RankedSportEventId] => 213 [2] => 54 [sumUPts] => 54 [3] => 6 [cntUPts] => 6 [4] => 8236 [RankingDivisionDefinitionId] => 8236 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 79 [DivisionId] => 79 [8] => 213 [SportEventId] => 213 [9] => SD-8 [DivisionName] => SD-8 [10] => Self Defense * 12-17 * Black * Mixed [Description] => Self Defense * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 79 [Sequence] => 79 ) Array ( [0] => 15044 [UserInfoId] => 15044 [1] => 213 [RankedSportEventId] => 213 [2] => 21 [sumUPts] => 21 [3] => 3 [cntUPts] => 3 [4] => 8236 [RankingDivisionDefinitionId] => 8236 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 79 [DivisionId] => 79 [8] => 213 [SportEventId] => 213 [9] => SD-8 [DivisionName] => SD-8 [10] => Self Defense * 12-17 * Black * Mixed [Description] => Self Defense * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 79 [Sequence] => 79 ) Array ( [0] => 13612 [UserInfoId] => 13612 [1] => 213 [RankedSportEventId] => 213 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [4] => 8236 [RankingDivisionDefinitionId] => 8236 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 79 [DivisionId] => 79 [8] => 213 [SportEventId] => 213 [9] => SD-8 [DivisionName] => SD-8 [10] => Self Defense * 12-17 * Black * Mixed [Description] => Self Defense * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 79 [Sequence] => 79 ) Array ( [0] => 15028 [UserInfoId] => 15028 [1] => 213 [RankedSportEventId] => 213 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [4] => 8236 [RankingDivisionDefinitionId] => 8236 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 79 [DivisionId] => 79 [8] => 213 [SportEventId] => 213 [9] => SD-8 [DivisionName] => SD-8 [10] => Self Defense * 12-17 * Black * Mixed [Description] => Self Defense * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 79 [Sequence] => 79 ) Array ( [0] => 15542 [UserInfoId] => 15542 [1] => 213 [RankedSportEventId] => 213 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8236 [RankingDivisionDefinitionId] => 8236 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 79 [DivisionId] => 79 [8] => 213 [SportEventId] => 213 [9] => SD-8 [DivisionName] => SD-8 [10] => Self Defense * 12-17 * Black * Mixed [Description] => Self Defense * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 79 [Sequence] => 79 ) Array ( [0] => 19555 [UserInfoId] => 19555 [1] => 213 [RankedSportEventId] => 213 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8236 [RankingDivisionDefinitionId] => 8236 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 79 [DivisionId] => 79 [8] => 213 [SportEventId] => 213 [9] => SD-8 [DivisionName] => SD-8 [10] => Self Defense * 12-17 * Black * Mixed [Description] => Self Defense * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 79 [Sequence] => 79 ) Array ( [0] => 15303 [UserInfoId] => 15303 [1] => 213 [RankedSportEventId] => 213 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8236 [RankingDivisionDefinitionId] => 8236 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 79 [DivisionId] => 79 [8] => 213 [SportEventId] => 213 [9] => SD-8 [DivisionName] => SD-8 [10] => Self Defense * 12-17 * Black * Mixed [Description] => Self Defense * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 79 [Sequence] => 79 ) Array ( [0] => 20156 [UserInfoId] => 20156 [1] => 213 [RankedSportEventId] => 213 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8236 [RankingDivisionDefinitionId] => 8236 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 79 [DivisionId] => 79 [8] => 213 [SportEventId] => 213 [9] => SD-8 [DivisionName] => SD-8 [10] => Self Defense * 12-17 * Black * Mixed [Description] => Self Defense * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 79 [Sequence] => 79 ) Array ( [0] => 20420 [UserInfoId] => 20420 [1] => 213 [RankedSportEventId] => 213 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8236 [RankingDivisionDefinitionId] => 8236 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 79 [DivisionId] => 79 [8] => 213 [SportEventId] => 213 [9] => SD-8 [DivisionName] => SD-8 [10] => Self Defense * 12-17 * Black * Mixed [Description] => Self Defense * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 79 [Sequence] => 79 ) Array ( [0] => 19825 [UserInfoId] => 19825 [1] => 213 [RankedSportEventId] => 213 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8236 [RankingDivisionDefinitionId] => 8236 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 79 [DivisionId] => 79 [8] => 213 [SportEventId] => 213 [9] => SD-8 [DivisionName] => SD-8 [10] => Self Defense * 12-17 * Black * Mixed [Description] => Self Defense * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 79 [Sequence] => 79 ) Array ( [0] => 15062 [UserInfoId] => 15062 [1] => 213 [RankedSportEventId] => 213 [2] => 4 [sumUPts] => 4 [3] => 1 [cntUPts] => 1 [4] => 8236 [RankingDivisionDefinitionId] => 8236 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 79 [DivisionId] => 79 [8] => 213 [SportEventId] => 213 [9] => SD-8 [DivisionName] => SD-8 [10] => Self Defense * 12-17 * Black * Mixed [Description] => Self Defense * 12-17 * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 79 [Sequence] => 79 ) BB[ 15062 ]) 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=116 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15062 [UserInfoId] => 15062 [1] => 110 [RankedSportEventId] => 110 [2] => 226 [sumUPts] => 226 [3] => 21 [cntUPts] => 21 [4] => 8273 [RankingDivisionDefinitionId] => 8273 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 116 [DivisionId] => 116 [8] => 110 [SportEventId] => 110 [9] => S-34 [DivisionName] => S-34 [10] => Sparring - Point * 10-11 * Black * Male [Description] => Sparring - Point * 10-11 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 116 [Sequence] => 116 ) BB[ 15062 ]) 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=120 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 16860 [UserInfoId] => 16860 [1] => 110 [RankedSportEventId] => 110 [2] => 60 [sumUPts] => 60 [3] => 5 [cntUPts] => 5 [4] => 8277 [RankingDivisionDefinitionId] => 8277 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 120 [DivisionId] => 120 [8] => 110 [SportEventId] => 110 [9] => S-38 [DivisionName] => S-38 [10] => Sparring - Point * 12-13 * Black * Male [Description] => Sparring - Point * 12-13 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 120 [Sequence] => 120 ) Array ( [0] => 15303 [UserInfoId] => 15303 [1] => 110 [RankedSportEventId] => 110 [2] => 49 [sumUPts] => 49 [3] => 5 [cntUPts] => 5 [4] => 8277 [RankingDivisionDefinitionId] => 8277 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 120 [DivisionId] => 120 [8] => 110 [SportEventId] => 110 [9] => S-38 [DivisionName] => S-38 [10] => Sparring - Point * 12-13 * Black * Male [Description] => Sparring - Point * 12-13 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 120 [Sequence] => 120 ) Array ( [0] => 12742 [UserInfoId] => 12742 [1] => 110 [RankedSportEventId] => 110 [2] => 38 [sumUPts] => 38 [3] => 4 [cntUPts] => 4 [4] => 8277 [RankingDivisionDefinitionId] => 8277 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 120 [DivisionId] => 120 [8] => 110 [SportEventId] => 110 [9] => S-38 [DivisionName] => S-38 [10] => Sparring - Point * 12-13 * Black * Male [Description] => Sparring - Point * 12-13 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 120 [Sequence] => 120 ) Array ( [0] => 13396 [UserInfoId] => 13396 [1] => 110 [RankedSportEventId] => 110 [2] => 33 [sumUPts] => 33 [3] => 4 [cntUPts] => 4 [4] => 8277 [RankingDivisionDefinitionId] => 8277 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 120 [DivisionId] => 120 [8] => 110 [SportEventId] => 110 [9] => S-38 [DivisionName] => S-38 [10] => Sparring - Point * 12-13 * Black * Male [Description] => Sparring - Point * 12-13 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 120 [Sequence] => 120 ) Array ( [0] => 15288 [UserInfoId] => 15288 [1] => 110 [RankedSportEventId] => 110 [2] => 33 [sumUPts] => 33 [3] => 4 [cntUPts] => 4 [4] => 8277 [RankingDivisionDefinitionId] => 8277 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 120 [DivisionId] => 120 [8] => 110 [SportEventId] => 110 [9] => S-38 [DivisionName] => S-38 [10] => Sparring - Point * 12-13 * Black * Male [Description] => Sparring - Point * 12-13 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 120 [Sequence] => 120 ) Array ( [0] => 13776 [UserInfoId] => 13776 [1] => 110 [RankedSportEventId] => 110 [2] => 30 [sumUPts] => 30 [3] => 3 [cntUPts] => 3 [4] => 8277 [RankingDivisionDefinitionId] => 8277 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 120 [DivisionId] => 120 [8] => 110 [SportEventId] => 110 [9] => S-38 [DivisionName] => S-38 [10] => Sparring - Point * 12-13 * Black * Male [Description] => Sparring - Point * 12-13 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 120 [Sequence] => 120 ) Array ( [0] => 15028 [UserInfoId] => 15028 [1] => 110 [RankedSportEventId] => 110 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8277 [RankingDivisionDefinitionId] => 8277 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 120 [DivisionId] => 120 [8] => 110 [SportEventId] => 110 [9] => S-38 [DivisionName] => S-38 [10] => Sparring - Point * 12-13 * Black * Male [Description] => Sparring - Point * 12-13 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 120 [Sequence] => 120 ) Array ( [0] => 13342 [UserInfoId] => 13342 [1] => 110 [RankedSportEventId] => 110 [2] => 21 [sumUPts] => 21 [3] => 3 [cntUPts] => 3 [4] => 8277 [RankingDivisionDefinitionId] => 8277 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 120 [DivisionId] => 120 [8] => 110 [SportEventId] => 110 [9] => S-38 [DivisionName] => S-38 [10] => Sparring - Point * 12-13 * Black * Male [Description] => Sparring - Point * 12-13 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 120 [Sequence] => 120 ) Array ( [0] => 19726 [UserInfoId] => 19726 [1] => 110 [RankedSportEventId] => 110 [2] => 14 [sumUPts] => 14 [3] => 3 [cntUPts] => 3 [4] => 8277 [RankingDivisionDefinitionId] => 8277 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 120 [DivisionId] => 120 [8] => 110 [SportEventId] => 110 [9] => S-38 [DivisionName] => S-38 [10] => Sparring - Point * 12-13 * Black * Male [Description] => Sparring - Point * 12-13 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 120 [Sequence] => 120 ) Array ( [0] => 13775 [UserInfoId] => 13775 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8277 [RankingDivisionDefinitionId] => 8277 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 120 [DivisionId] => 120 [8] => 110 [SportEventId] => 110 [9] => S-38 [DivisionName] => S-38 [10] => Sparring - Point * 12-13 * Black * Male [Description] => Sparring - Point * 12-13 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 120 [Sequence] => 120 ) Array ( [0] => 13612 [UserInfoId] => 13612 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8277 [RankingDivisionDefinitionId] => 8277 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 120 [DivisionId] => 120 [8] => 110 [SportEventId] => 110 [9] => S-38 [DivisionName] => S-38 [10] => Sparring - Point * 12-13 * Black * Male [Description] => Sparring - Point * 12-13 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 120 [Sequence] => 120 ) Array ( [0] => 17891 [UserInfoId] => 17891 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8277 [RankingDivisionDefinitionId] => 8277 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 120 [DivisionId] => 120 [8] => 110 [SportEventId] => 110 [9] => S-38 [DivisionName] => S-38 [10] => Sparring - Point * 12-13 * Black * Male [Description] => Sparring - Point * 12-13 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 120 [Sequence] => 120 ) Array ( [0] => 21685 [UserInfoId] => 21685 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8277 [RankingDivisionDefinitionId] => 8277 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 120 [DivisionId] => 120 [8] => 110 [SportEventId] => 110 [9] => S-38 [DivisionName] => S-38 [10] => Sparring - Point * 12-13 * Black * Male [Description] => Sparring - Point * 12-13 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 120 [Sequence] => 120 ) Array ( [0] => 20139 [UserInfoId] => 20139 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8277 [RankingDivisionDefinitionId] => 8277 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 120 [DivisionId] => 120 [8] => 110 [SportEventId] => 110 [9] => S-38 [DivisionName] => S-38 [10] => Sparring - Point * 12-13 * Black * Male [Description] => Sparring - Point * 12-13 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 120 [Sequence] => 120 ) Array ( [0] => 21146 [UserInfoId] => 21146 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8277 [RankingDivisionDefinitionId] => 8277 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 120 [DivisionId] => 120 [8] => 110 [SportEventId] => 110 [9] => S-38 [DivisionName] => S-38 [10] => Sparring - Point * 12-13 * Black * Male [Description] => Sparring - Point * 12-13 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 120 [Sequence] => 120 ) Array ( [0] => 19759 [UserInfoId] => 19759 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 2 [cntUPts] => 2 [4] => 8277 [RankingDivisionDefinitionId] => 8277 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 120 [DivisionId] => 120 [8] => 110 [SportEventId] => 110 [9] => S-38 [DivisionName] => S-38 [10] => Sparring - Point * 12-13 * Black * Male [Description] => Sparring - Point * 12-13 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 120 [Sequence] => 120 ) Array ( [0] => 19715 [UserInfoId] => 19715 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8277 [RankingDivisionDefinitionId] => 8277 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 120 [DivisionId] => 120 [8] => 110 [SportEventId] => 110 [9] => S-38 [DivisionName] => S-38 [10] => Sparring - Point * 12-13 * Black * Male [Description] => Sparring - Point * 12-13 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 120 [Sequence] => 120 ) Array ( [0] => 21482 [UserInfoId] => 21482 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8277 [RankingDivisionDefinitionId] => 8277 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 120 [DivisionId] => 120 [8] => 110 [SportEventId] => 110 [9] => S-38 [DivisionName] => S-38 [10] => Sparring - Point * 12-13 * Black * Male [Description] => Sparring - Point * 12-13 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 120 [Sequence] => 120 ) Array ( [0] => 15062 [UserInfoId] => 15062 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8277 [RankingDivisionDefinitionId] => 8277 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 120 [DivisionId] => 120 [8] => 110 [SportEventId] => 110 [9] => S-38 [DivisionName] => S-38 [10] => Sparring - Point * 12-13 * Black * Male [Description] => Sparring - Point * 12-13 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 120 [Sequence] => 120 ) Standings for Collum, Devyn


Standings for:
Collum, Devyn
Event & Description Skill Level Weight (lbs) Points # Events Rank
B-1 Breaking - Power Wood - Hand/Elbow
Mixed * ≤ 11 yrs
Beginner 131161
B-3 Breaking - Power Wood - Hand/Elbow
Mixed * ≤ 17 yrs
Black Belt 1214
F-11 Forms
Mixed * 10 - 11 yrs
Black Belt 179201
F-15 Forms
Mixed * 12 - 13 yrs
Black Belt 6117
M-4 Forms - Specialty
Mixed * ≤ 11 yrs
Black Belt 211211
M-8 Forms - Specialty
Mixed * 12 - 17 yrs
Black Belt 4128
FH-3 Forms - Traditional
Mixed * ≤ 11 yrs
Advanced 911
FH-3 Forms - Traditional Hard Style
Mixed * ≤ 11 yrs
Advanced 3634
SD-4 Self Defense
Mixed * ≤ 11 yrs
Black Belt 205191
SD-8 Self Defense
Mixed * 12 - 17 yrs
Black Belt 4112
S-34 Sparring - Point
Male * 10 - 11 yrs
Black Belt 226211
S-38 Sparring - Point
Male * 12 - 13 yrs
Black Belt 6119
Total1029