BB[ 19859 ]) 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=7 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 17730 [UserInfoId] => 17730 [1] => 132 [RankedSportEventId] => 132 [2] => 57 [sumUPts] => 57 [3] => 6 [cntUPts] => 6 [4] => 8164 [RankingDivisionDefinitionId] => 8164 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 7 [DivisionId] => 7 [8] => 132 [SportEventId] => 132 [9] => F-5 [DivisionName] => F-5 [10] => Forms * 8-9 * Beginner * Mixed [Description] => Forms * 8-9 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 7 [Sequence] => 7 ) Array ( [0] => 19980 [UserInfoId] => 19980 [1] => 132 [RankedSportEventId] => 132 [2] => 36 [sumUPts] => 36 [3] => 3 [cntUPts] => 3 [4] => 8164 [RankingDivisionDefinitionId] => 8164 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 7 [DivisionId] => 7 [8] => 132 [SportEventId] => 132 [9] => F-5 [DivisionName] => F-5 [10] => Forms * 8-9 * Beginner * Mixed [Description] => Forms * 8-9 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 7 [Sequence] => 7 ) Array ( [0] => 19859 [UserInfoId] => 19859 [1] => 132 [RankedSportEventId] => 132 [2] => 33 [sumUPts] => 33 [3] => 3 [cntUPts] => 3 [4] => 8164 [RankingDivisionDefinitionId] => 8164 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 7 [DivisionId] => 7 [8] => 132 [SportEventId] => 132 [9] => F-5 [DivisionName] => F-5 [10] => Forms * 8-9 * Beginner * Mixed [Description] => Forms * 8-9 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 7 [Sequence] => 7 ) BB[ 19859 ]) 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=10 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19637 [UserInfoId] => 19637 [1] => 132 [RankedSportEventId] => 132 [2] => 64 [sumUPts] => 64 [3] => 8 [cntUPts] => 8 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 19896 [UserInfoId] => 19896 [1] => 132 [RankedSportEventId] => 132 [2] => 56 [sumUPts] => 56 [3] => 6 [cntUPts] => 6 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 20226 [UserInfoId] => 20226 [1] => 132 [RankedSportEventId] => 132 [2] => 51 [sumUPts] => 51 [3] => 5 [cntUPts] => 5 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 20169 [UserInfoId] => 20169 [1] => 132 [RankedSportEventId] => 132 [2] => 33 [sumUPts] => 33 [3] => 3 [cntUPts] => 3 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 16796 [UserInfoId] => 16796 [1] => 132 [RankedSportEventId] => 132 [2] => 30 [sumUPts] => 30 [3] => 4 [cntUPts] => 4 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 18012 [UserInfoId] => 18012 [1] => 132 [RankedSportEventId] => 132 [2] => 30 [sumUPts] => 30 [3] => 4 [cntUPts] => 4 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 19959 [UserInfoId] => 19959 [1] => 132 [RankedSportEventId] => 132 [2] => 28 [sumUPts] => 28 [3] => 4 [cntUPts] => 4 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 20182 [UserInfoId] => 20182 [1] => 132 [RankedSportEventId] => 132 [2] => 24 [sumUPts] => 24 [3] => 3 [cntUPts] => 3 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 19938 [UserInfoId] => 19938 [1] => 132 [RankedSportEventId] => 132 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 21010 [UserInfoId] => 21010 [1] => 132 [RankedSportEventId] => 132 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 21052 [UserInfoId] => 21052 [1] => 132 [RankedSportEventId] => 132 [2] => 20 [sumUPts] => 20 [3] => 3 [cntUPts] => 3 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 19945 [UserInfoId] => 19945 [1] => 132 [RankedSportEventId] => 132 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 18493 [UserInfoId] => 18493 [1] => 132 [RankedSportEventId] => 132 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 21372 [UserInfoId] => 21372 [1] => 132 [RankedSportEventId] => 132 [2] => 18 [sumUPts] => 18 [3] => 3 [cntUPts] => 3 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 19636 [UserInfoId] => 19636 [1] => 132 [RankedSportEventId] => 132 [2] => 18 [sumUPts] => 18 [3] => 3 [cntUPts] => 3 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 21201 [UserInfoId] => 21201 [1] => 132 [RankedSportEventId] => 132 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 20725 [UserInfoId] => 20725 [1] => 132 [RankedSportEventId] => 132 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 19664 [UserInfoId] => 19664 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 19980 [UserInfoId] => 19980 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 21670 [UserInfoId] => 21670 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 21353 [UserInfoId] => 21353 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 19936 [UserInfoId] => 19936 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 19994 [UserInfoId] => 19994 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 19795 [UserInfoId] => 19795 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 21151 [UserInfoId] => 21151 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 19814 [UserInfoId] => 19814 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 19968 [UserInfoId] => 19968 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 19902 [UserInfoId] => 19902 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 19948 [UserInfoId] => 19948 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 20713 [UserInfoId] => 20713 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 20846 [UserInfoId] => 20846 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 19899 [UserInfoId] => 19899 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 21373 [UserInfoId] => 21373 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) Array ( [0] => 19859 [UserInfoId] => 19859 [1] => 132 [RankedSportEventId] => 132 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8167 [RankingDivisionDefinitionId] => 8167 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 10 [DivisionId] => 10 [8] => 132 [SportEventId] => 132 [9] => F-8 [DivisionName] => F-8 [10] => Forms * 10-11 * Beginner * Mixed [Description] => Forms * 10-11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 10 [Sequence] => 10 ) BB[ 19859 ]) SELECT UserInfoId, rem.RankedSportEventId, sum(Points) as sumUPts, count(Points) as cntUPts, rdd.* FROM UserRankingPoints urp, RankingEventMappings rem, RankingDivisionDefinitions rdd WHERE urp.SportEventId=rem.SportEventId AND urp.RankingSystemId=8 AND rem.RankedSportEventId=277 AND urp.RankingSystemId=rdd.RankingSystemDefinitionId AND urp.TournamentId in ( 145,146,147,148,149,150,151,152,153,154,155,156,157,159,161,162,163,164,165,166,167,168,169,170,171 ) AND urp.RankingDivisionId=rdd.DivisionId AND urp.RankingDivisionId=38 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19859 [UserInfoId] => 19859 [1] => 277 [RankedSportEventId] => 277 [2] => 78 [sumUPts] => 78 [3] => 8 [cntUPts] => 8 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) BB[ 19859 ]) SELECT UserInfoId, rem.RankedSportEventId, sum(Points) as sumUPts, count(Points) as cntUPts, rdd.* FROM UserRankingPoints urp, RankingEventMappings rem, RankingDivisionDefinitions rdd WHERE urp.SportEventId=rem.SportEventId AND urp.RankingSystemId=8 AND rem.RankedSportEventId=340 AND urp.RankingSystemId=rdd.RankingSystemDefinitionId AND urp.TournamentId in ( 145,146,147,148,149,150,151,152,153,154,155,156,157,159,161,162,163,164,165,166,167,168,169,170,171 ) AND urp.RankingDivisionId=rdd.DivisionId AND urp.RankingDivisionId=51 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19859 [UserInfoId] => 19859 [1] => 340 [RankedSportEventId] => 340 [2] => 57 [sumUPts] => 57 [3] => 5 [cntUPts] => 5 [4] => 8208 [RankingDivisionDefinitionId] => 8208 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 51 [DivisionId] => 51 [8] => 340 [SportEventId] => 340 [9] => FH-1 [DivisionName] => FH-1 [10] => Forms - Traditional Hard Style * <= 11 * Beginner * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 51 [Sequence] => 51 ) BB[ 19859 ]) 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=341 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=62 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19859 [UserInfoId] => 19859 [1] => 341 [RankedSportEventId] => 341 [2] => 78 [sumUPts] => 78 [3] => 8 [cntUPts] => 8 [4] => 8219 [RankingDivisionDefinitionId] => 8219 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 62 [DivisionId] => 62 [8] => 341 [SportEventId] => 341 [9] => FS-1 [DivisionName] => FS-1 [10] => Forms - Traditional Soft Style * <= 11 * Beginner * Mixed [Description] => Forms - Traditional Soft Style * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 62 [Sequence] => 62 ) BB[ 19859 ]) 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=88 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19859 [UserInfoId] => 19859 [1] => 110 [RankedSportEventId] => 110 [2] => 63 [sumUPts] => 63 [3] => 6 [cntUPts] => 6 [4] => 8245 [RankingDivisionDefinitionId] => 8245 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 88 [DivisionId] => 88 [8] => 110 [SportEventId] => 110 [9] => S-6 [DivisionName] => S-6 [10] => Sparring - Point * 8-9 * Beginner * Female [Description] => Sparring - Point * 8-9 * Beginner * Female [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 88 [Sequence] => 88 ) BB[ 19859 ]) 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=91 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19636 [UserInfoId] => 19636 [1] => 110 [RankedSportEventId] => 110 [2] => 63 [sumUPts] => 63 [3] => 7 [cntUPts] => 7 [4] => 8248 [RankingDivisionDefinitionId] => 8248 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 91 [DivisionId] => 91 [8] => 110 [SportEventId] => 110 [9] => S-9 [DivisionName] => S-9 [10] => Sparring - Point * 10-11 * Beginner * Female [Description] => Sparring - Point * 10-11 * Beginner * Female [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 91 [Sequence] => 91 ) Array ( [0] => 16796 [UserInfoId] => 16796 [1] => 110 [RankedSportEventId] => 110 [2] => 54 [sumUPts] => 54 [3] => 5 [cntUPts] => 5 [4] => 8248 [RankingDivisionDefinitionId] => 8248 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 91 [DivisionId] => 91 [8] => 110 [SportEventId] => 110 [9] => S-9 [DivisionName] => S-9 [10] => Sparring - Point * 10-11 * Beginner * Female [Description] => Sparring - Point * 10-11 * Beginner * Female [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 91 [Sequence] => 91 ) Array ( [0] => 20382 [UserInfoId] => 20382 [1] => 110 [RankedSportEventId] => 110 [2] => 50 [sumUPts] => 50 [3] => 5 [cntUPts] => 5 [4] => 8248 [RankingDivisionDefinitionId] => 8248 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 91 [DivisionId] => 91 [8] => 110 [SportEventId] => 110 [9] => S-9 [DivisionName] => S-9 [10] => Sparring - Point * 10-11 * Beginner * Female [Description] => Sparring - Point * 10-11 * Beginner * Female [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 91 [Sequence] => 91 ) Array ( [0] => 19859 [UserInfoId] => 19859 [1] => 110 [RankedSportEventId] => 110 [2] => 33 [sumUPts] => 33 [3] => 4 [cntUPts] => 4 [4] => 8248 [RankingDivisionDefinitionId] => 8248 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 91 [DivisionId] => 91 [8] => 110 [SportEventId] => 110 [9] => S-9 [DivisionName] => S-9 [10] => Sparring - Point * 10-11 * Beginner * Female [Description] => Sparring - Point * 10-11 * Beginner * Female [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 91 [Sequence] => 91 ) Standings for Pittman, Brystal


Standings for:
Pittman, Brystal
Event & Description Skill Level Weight (lbs) Points # Events Rank
F-5 Forms
Mixed * 8 - 9 yrs
Beginner 3333
F-8 Forms
Mixed * 10 - 11 yrs
Beginner 6134
M-1 Forms - Specialty
Mixed * ≤ 11 yrs
Beginner 7881
FH-1 Forms - Traditional Hard Style
Mixed * ≤ 11 yrs
Beginner 5751
FS-1 Forms - Traditional Soft Style
Mixed * ≤ 11 yrs
Beginner 7881
S-6 Sparring - Point
Female * 8 - 9 yrs
Beginner 6361
S-9 Sparring - Point
Female * 10 - 11 yrs
Beginner 3344
Total348