BB[ 17594 ]) 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=95 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=163 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19452 [UserInfoId] => 19452 [1] => 95 [RankedSportEventId] => 95 [2] => 40 [sumUPts] => 40 [3] => 4 [cntUPts] => 4 [4] => 8320 [RankingDivisionDefinitionId] => 8320 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 163 [DivisionId] => 163 [8] => 95 [SportEventId] => 95 [9] => BC-8 [DivisionName] => BC-8 [10] => Breaking - Creative Open * <= 17 * Beg / Intr / Adv * Mixed [Description] => Breaking - Creative Open * <= 17 * Beg / Intr / Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 17 [AgeHigh] => 17 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 163 [Sequence] => 163 ) Array ( [0] => 13503 [UserInfoId] => 13503 [1] => 95 [RankedSportEventId] => 95 [2] => 36 [sumUPts] => 36 [3] => 3 [cntUPts] => 3 [4] => 8320 [RankingDivisionDefinitionId] => 8320 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 163 [DivisionId] => 163 [8] => 95 [SportEventId] => 95 [9] => BC-8 [DivisionName] => BC-8 [10] => Breaking - Creative Open * <= 17 * Beg / Intr / Adv * Mixed [Description] => Breaking - Creative Open * <= 17 * Beg / Intr / Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 17 [AgeHigh] => 17 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 163 [Sequence] => 163 ) Array ( [0] => 17594 [UserInfoId] => 17594 [1] => 95 [RankedSportEventId] => 95 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8320 [RankingDivisionDefinitionId] => 8320 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 163 [DivisionId] => 163 [8] => 95 [SportEventId] => 95 [9] => BC-8 [DivisionName] => BC-8 [10] => Breaking - Creative Open * <= 17 * Beg / Intr / Adv * Mixed [Description] => Breaking - Creative Open * <= 17 * Beg / Intr / Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 17 [AgeHigh] => 17 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 163 [Sequence] => 163 ) BB[ 17594 ]) SELECT UserInfoId, rem.RankedSportEventId, sum(Points) as sumUPts, count(Points) as cntUPts, rdd.* FROM UserRankingPoints urp, RankingEventMappings rem, RankingDivisionDefinitions rdd WHERE urp.SportEventId=rem.SportEventId AND urp.RankingSystemId=8 AND rem.RankedSportEventId=299 AND urp.RankingSystemId=rdd.RankingSystemDefinitionId AND urp.TournamentId in ( 145,146,147,148,149,150,151,152,153,154,155,156,157,159,161,162,163,164,165,166,167,168,169,170,171 ) AND urp.RankingDivisionId=rdd.DivisionId AND urp.RankingDivisionId=157 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 20163 [UserInfoId] => 20163 [1] => 299 [RankedSportEventId] => 299 [2] => 75 [sumUPts] => 75 [3] => 7 [cntUPts] => 7 [4] => 8314 [RankingDivisionDefinitionId] => 8314 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 157 [DivisionId] => 157 [8] => 299 [SportEventId] => 299 [9] => B-2 [DivisionName] => B-2 [10] => Breaking - Power Wood - Hand/Elbow * 12-17 * Beg / Intr / Adv * [Description] => Breaking - Power Wood - Hand/Elbow * 12-17 * Beg / Intr / Adv * [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 157 [Sequence] => 157 ) Array ( [0] => 17594 [UserInfoId] => 17594 [1] => 299 [RankedSportEventId] => 299 [2] => 41 [sumUPts] => 41 [3] => 4 [cntUPts] => 4 [4] => 8314 [RankingDivisionDefinitionId] => 8314 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 157 [DivisionId] => 157 [8] => 299 [SportEventId] => 299 [9] => B-2 [DivisionName] => B-2 [10] => Breaking - Power Wood - Hand/Elbow * 12-17 * Beg / Intr / Adv * [Description] => Breaking - Power Wood - Hand/Elbow * 12-17 * Beg / Intr / Adv * [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 157 [Sequence] => 157 ) BB[ 17594 ]) 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=23 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 17594 [UserInfoId] => 17594 [1] => 132 [RankedSportEventId] => 132 [2] => 45 [sumUPts] => 45 [3] => 5 [cntUPts] => 5 [4] => 8180 [RankingDivisionDefinitionId] => 8180 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 23 [DivisionId] => 23 [8] => 132 [SportEventId] => 132 [9] => F-21 [DivisionName] => F-21 [10] => Forms * 16-17 * Intermediate * Mixed [Description] => Forms * 16-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 16 [AgeLow] => 16 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 23 [Sequence] => 23 ) BB[ 17594 ]) 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=43 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15008 [UserInfoId] => 15008 [1] => 277 [RankedSportEventId] => 277 [2] => 105 [sumUPts] => 105 [3] => 17 [cntUPts] => 17 [4] => 8200 [RankingDivisionDefinitionId] => 8200 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 43 [DivisionId] => 43 [8] => 277 [SportEventId] => 277 [9] => M-6 [DivisionName] => M-6 [10] => Forms - Specialty * 12-17 * Intermediate * Mixed [Description] => Forms - Specialty * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 43 [Sequence] => 43 ) Array ( [0] => 15248 [UserInfoId] => 15248 [1] => 277 [RankedSportEventId] => 277 [2] => 67 [sumUPts] => 67 [3] => 8 [cntUPts] => 8 [4] => 8200 [RankingDivisionDefinitionId] => 8200 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 43 [DivisionId] => 43 [8] => 277 [SportEventId] => 277 [9] => M-6 [DivisionName] => M-6 [10] => Forms - Specialty * 12-17 * Intermediate * Mixed [Description] => Forms - Specialty * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 43 [Sequence] => 43 ) Array ( [0] => 13316 [UserInfoId] => 13316 [1] => 277 [RankedSportEventId] => 277 [2] => 48 [sumUPts] => 48 [3] => 5 [cntUPts] => 5 [4] => 8200 [RankingDivisionDefinitionId] => 8200 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 43 [DivisionId] => 43 [8] => 277 [SportEventId] => 277 [9] => M-6 [DivisionName] => M-6 [10] => Forms - Specialty * 12-17 * Intermediate * Mixed [Description] => Forms - Specialty * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 43 [Sequence] => 43 ) Array ( [0] => 15290 [UserInfoId] => 15290 [1] => 277 [RankedSportEventId] => 277 [2] => 45 [sumUPts] => 45 [3] => 5 [cntUPts] => 5 [4] => 8200 [RankingDivisionDefinitionId] => 8200 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 43 [DivisionId] => 43 [8] => 277 [SportEventId] => 277 [9] => M-6 [DivisionName] => M-6 [10] => Forms - Specialty * 12-17 * Intermediate * Mixed [Description] => Forms - Specialty * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 43 [Sequence] => 43 ) Array ( [0] => 14896 [UserInfoId] => 14896 [1] => 277 [RankedSportEventId] => 277 [2] => 42 [sumUPts] => 42 [3] => 5 [cntUPts] => 5 [4] => 8200 [RankingDivisionDefinitionId] => 8200 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 43 [DivisionId] => 43 [8] => 277 [SportEventId] => 277 [9] => M-6 [DivisionName] => M-6 [10] => Forms - Specialty * 12-17 * Intermediate * Mixed [Description] => Forms - Specialty * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 43 [Sequence] => 43 ) Array ( [0] => 20103 [UserInfoId] => 20103 [1] => 277 [RankedSportEventId] => 277 [2] => 36 [sumUPts] => 36 [3] => 4 [cntUPts] => 4 [4] => 8200 [RankingDivisionDefinitionId] => 8200 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 43 [DivisionId] => 43 [8] => 277 [SportEventId] => 277 [9] => M-6 [DivisionName] => M-6 [10] => Forms - Specialty * 12-17 * Intermediate * Mixed [Description] => Forms - Specialty * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 43 [Sequence] => 43 ) Array ( [0] => 20437 [UserInfoId] => 20437 [1] => 277 [RankedSportEventId] => 277 [2] => 33 [sumUPts] => 33 [3] => 4 [cntUPts] => 4 [4] => 8200 [RankingDivisionDefinitionId] => 8200 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 43 [DivisionId] => 43 [8] => 277 [SportEventId] => 277 [9] => M-6 [DivisionName] => M-6 [10] => Forms - Specialty * 12-17 * Intermediate * Mixed [Description] => Forms - Specialty * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 43 [Sequence] => 43 ) Array ( [0] => 20302 [UserInfoId] => 20302 [1] => 277 [RankedSportEventId] => 277 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8200 [RankingDivisionDefinitionId] => 8200 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 43 [DivisionId] => 43 [8] => 277 [SportEventId] => 277 [9] => M-6 [DivisionName] => M-6 [10] => Forms - Specialty * 12-17 * Intermediate * Mixed [Description] => Forms - Specialty * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 43 [Sequence] => 43 ) Array ( [0] => 16791 [UserInfoId] => 16791 [1] => 277 [RankedSportEventId] => 277 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8200 [RankingDivisionDefinitionId] => 8200 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 43 [DivisionId] => 43 [8] => 277 [SportEventId] => 277 [9] => M-6 [DivisionName] => M-6 [10] => Forms - Specialty * 12-17 * Intermediate * Mixed [Description] => Forms - Specialty * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 43 [Sequence] => 43 ) Array ( [0] => 15708 [UserInfoId] => 15708 [1] => 277 [RankedSportEventId] => 277 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [4] => 8200 [RankingDivisionDefinitionId] => 8200 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 43 [DivisionId] => 43 [8] => 277 [SportEventId] => 277 [9] => M-6 [DivisionName] => M-6 [10] => Forms - Specialty * 12-17 * Intermediate * Mixed [Description] => Forms - Specialty * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 43 [Sequence] => 43 ) Array ( [0] => 20124 [UserInfoId] => 20124 [1] => 277 [RankedSportEventId] => 277 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8200 [RankingDivisionDefinitionId] => 8200 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 43 [DivisionId] => 43 [8] => 277 [SportEventId] => 277 [9] => M-6 [DivisionName] => M-6 [10] => Forms - Specialty * 12-17 * Intermediate * Mixed [Description] => Forms - Specialty * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 43 [Sequence] => 43 ) Array ( [0] => 18117 [UserInfoId] => 18117 [1] => 277 [RankedSportEventId] => 277 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8200 [RankingDivisionDefinitionId] => 8200 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 43 [DivisionId] => 43 [8] => 277 [SportEventId] => 277 [9] => M-6 [DivisionName] => M-6 [10] => Forms - Specialty * 12-17 * Intermediate * Mixed [Description] => Forms - Specialty * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 43 [Sequence] => 43 ) Array ( [0] => 19732 [UserInfoId] => 19732 [1] => 277 [RankedSportEventId] => 277 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8200 [RankingDivisionDefinitionId] => 8200 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 43 [DivisionId] => 43 [8] => 277 [SportEventId] => 277 [9] => M-6 [DivisionName] => M-6 [10] => Forms - Specialty * 12-17 * Intermediate * Mixed [Description] => Forms - Specialty * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 43 [Sequence] => 43 ) Array ( [0] => 17594 [UserInfoId] => 17594 [1] => 277 [RankedSportEventId] => 277 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8200 [RankingDivisionDefinitionId] => 8200 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 43 [DivisionId] => 43 [8] => 277 [SportEventId] => 277 [9] => M-6 [DivisionName] => M-6 [10] => Forms - Specialty * 12-17 * Intermediate * Mixed [Description] => Forms - Specialty * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 43 [Sequence] => 43 ) BB[ 17594 ]) 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=55 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15008 [UserInfoId] => 15008 [1] => 340 [RankedSportEventId] => 340 [2] => 109 [sumUPts] => 109 [3] => 16 [cntUPts] => 16 [4] => 8212 [RankingDivisionDefinitionId] => 8212 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 55 [DivisionId] => 55 [8] => 340 [SportEventId] => 340 [9] => FH-5 [DivisionName] => FH-5 [10] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 55 [Sequence] => 55 ) Array ( [0] => 15248 [UserInfoId] => 15248 [1] => 340 [RankedSportEventId] => 340 [2] => 80 [sumUPts] => 80 [3] => 9 [cntUPts] => 9 [4] => 8212 [RankingDivisionDefinitionId] => 8212 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 55 [DivisionId] => 55 [8] => 340 [SportEventId] => 340 [9] => FH-5 [DivisionName] => FH-5 [10] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 55 [Sequence] => 55 ) Array ( [0] => 13779 [UserInfoId] => 13779 [1] => 340 [RankedSportEventId] => 340 [2] => 57 [sumUPts] => 57 [3] => 7 [cntUPts] => 7 [4] => 8212 [RankingDivisionDefinitionId] => 8212 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 55 [DivisionId] => 55 [8] => 340 [SportEventId] => 340 [9] => FH-5 [DivisionName] => FH-5 [10] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 55 [Sequence] => 55 ) Array ( [0] => 17083 [UserInfoId] => 17083 [1] => 340 [RankedSportEventId] => 340 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8212 [RankingDivisionDefinitionId] => 8212 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 55 [DivisionId] => 55 [8] => 340 [SportEventId] => 340 [9] => FH-5 [DivisionName] => FH-5 [10] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 55 [Sequence] => 55 ) Array ( [0] => 13754 [UserInfoId] => 13754 [1] => 340 [RankedSportEventId] => 340 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8212 [RankingDivisionDefinitionId] => 8212 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 55 [DivisionId] => 55 [8] => 340 [SportEventId] => 340 [9] => FH-5 [DivisionName] => FH-5 [10] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 55 [Sequence] => 55 ) Array ( [0] => 19941 [UserInfoId] => 19941 [1] => 340 [RankedSportEventId] => 340 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8212 [RankingDivisionDefinitionId] => 8212 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 55 [DivisionId] => 55 [8] => 340 [SportEventId] => 340 [9] => FH-5 [DivisionName] => FH-5 [10] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 55 [Sequence] => 55 ) Array ( [0] => 20328 [UserInfoId] => 20328 [1] => 340 [RankedSportEventId] => 340 [2] => 20 [sumUPts] => 20 [3] => 2 [cntUPts] => 2 [4] => 8212 [RankingDivisionDefinitionId] => 8212 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 55 [DivisionId] => 55 [8] => 340 [SportEventId] => 340 [9] => FH-5 [DivisionName] => FH-5 [10] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 55 [Sequence] => 55 ) Array ( [0] => 13752 [UserInfoId] => 13752 [1] => 340 [RankedSportEventId] => 340 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8212 [RankingDivisionDefinitionId] => 8212 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 55 [DivisionId] => 55 [8] => 340 [SportEventId] => 340 [9] => FH-5 [DivisionName] => FH-5 [10] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 55 [Sequence] => 55 ) Array ( [0] => 16945 [UserInfoId] => 16945 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 2 [cntUPts] => 2 [4] => 8212 [RankingDivisionDefinitionId] => 8212 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 55 [DivisionId] => 55 [8] => 340 [SportEventId] => 340 [9] => FH-5 [DivisionName] => FH-5 [10] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 55 [Sequence] => 55 ) Array ( [0] => 20915 [UserInfoId] => 20915 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8212 [RankingDivisionDefinitionId] => 8212 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 55 [DivisionId] => 55 [8] => 340 [SportEventId] => 340 [9] => FH-5 [DivisionName] => FH-5 [10] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 55 [Sequence] => 55 ) Array ( [0] => 21251 [UserInfoId] => 21251 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8212 [RankingDivisionDefinitionId] => 8212 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 55 [DivisionId] => 55 [8] => 340 [SportEventId] => 340 [9] => FH-5 [DivisionName] => FH-5 [10] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 55 [Sequence] => 55 ) Array ( [0] => 17096 [UserInfoId] => 17096 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8212 [RankingDivisionDefinitionId] => 8212 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 55 [DivisionId] => 55 [8] => 340 [SportEventId] => 340 [9] => FH-5 [DivisionName] => FH-5 [10] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 55 [Sequence] => 55 ) Array ( [0] => 17594 [UserInfoId] => 17594 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8212 [RankingDivisionDefinitionId] => 8212 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 55 [DivisionId] => 55 [8] => 340 [SportEventId] => 340 [9] => FH-5 [DivisionName] => FH-5 [10] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 55 [Sequence] => 55 ) BB[ 17594 ]) 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=122 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15407 [UserInfoId] => 15407 [1] => 110 [RankedSportEventId] => 110 [2] => 48 [sumUPts] => 48 [3] => 4 [cntUPts] => 4 [4] => 8279 [RankingDivisionDefinitionId] => 8279 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 122 [DivisionId] => 122 [8] => 110 [SportEventId] => 110 [9] => S-40 [DivisionName] => S-40 [10] => Sparring - Point * 14-15 * Intermediate * Male [Description] => Sparring - Point * 14-15 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 122 [Sequence] => 122 ) Array ( [0] => 16945 [UserInfoId] => 16945 [1] => 110 [RankedSportEventId] => 110 [2] => 42 [sumUPts] => 42 [3] => 4 [cntUPts] => 4 [4] => 8279 [RankingDivisionDefinitionId] => 8279 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 122 [DivisionId] => 122 [8] => 110 [SportEventId] => 110 [9] => S-40 [DivisionName] => S-40 [10] => Sparring - Point * 14-15 * Intermediate * Male [Description] => Sparring - Point * 14-15 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 122 [Sequence] => 122 ) Array ( [0] => 15466 [UserInfoId] => 15466 [1] => 110 [RankedSportEventId] => 110 [2] => 42 [sumUPts] => 42 [3] => 4 [cntUPts] => 4 [4] => 8279 [RankingDivisionDefinitionId] => 8279 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 122 [DivisionId] => 122 [8] => 110 [SportEventId] => 110 [9] => S-40 [DivisionName] => S-40 [10] => Sparring - Point * 14-15 * Intermediate * Male [Description] => Sparring - Point * 14-15 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 122 [Sequence] => 122 ) Array ( [0] => 17083 [UserInfoId] => 17083 [1] => 110 [RankedSportEventId] => 110 [2] => 36 [sumUPts] => 36 [3] => 3 [cntUPts] => 3 [4] => 8279 [RankingDivisionDefinitionId] => 8279 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 122 [DivisionId] => 122 [8] => 110 [SportEventId] => 110 [9] => S-40 [DivisionName] => S-40 [10] => Sparring - Point * 14-15 * Intermediate * Male [Description] => Sparring - Point * 14-15 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 122 [Sequence] => 122 ) Array ( [0] => 20127 [UserInfoId] => 20127 [1] => 110 [RankedSportEventId] => 110 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8279 [RankingDivisionDefinitionId] => 8279 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 122 [DivisionId] => 122 [8] => 110 [SportEventId] => 110 [9] => S-40 [DivisionName] => S-40 [10] => Sparring - Point * 14-15 * Intermediate * Male [Description] => Sparring - Point * 14-15 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 122 [Sequence] => 122 ) Array ( [0] => 19732 [UserInfoId] => 19732 [1] => 110 [RankedSportEventId] => 110 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [4] => 8279 [RankingDivisionDefinitionId] => 8279 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 122 [DivisionId] => 122 [8] => 110 [SportEventId] => 110 [9] => S-40 [DivisionName] => S-40 [10] => Sparring - Point * 14-15 * Intermediate * Male [Description] => Sparring - Point * 14-15 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 122 [Sequence] => 122 ) Array ( [0] => 21760 [UserInfoId] => 21760 [1] => 110 [RankedSportEventId] => 110 [2] => 16 [sumUPts] => 16 [3] => 2 [cntUPts] => 2 [4] => 8279 [RankingDivisionDefinitionId] => 8279 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 122 [DivisionId] => 122 [8] => 110 [SportEventId] => 110 [9] => S-40 [DivisionName] => S-40 [10] => Sparring - Point * 14-15 * Intermediate * Male [Description] => Sparring - Point * 14-15 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 122 [Sequence] => 122 ) Array ( [0] => 17864 [UserInfoId] => 17864 [1] => 110 [RankedSportEventId] => 110 [2] => 16 [sumUPts] => 16 [3] => 2 [cntUPts] => 2 [4] => 8279 [RankingDivisionDefinitionId] => 8279 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 122 [DivisionId] => 122 [8] => 110 [SportEventId] => 110 [9] => S-40 [DivisionName] => S-40 [10] => Sparring - Point * 14-15 * Intermediate * Male [Description] => Sparring - Point * 14-15 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 122 [Sequence] => 122 ) Array ( [0] => 20130 [UserInfoId] => 20130 [1] => 110 [RankedSportEventId] => 110 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8279 [RankingDivisionDefinitionId] => 8279 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 122 [DivisionId] => 122 [8] => 110 [SportEventId] => 110 [9] => S-40 [DivisionName] => S-40 [10] => Sparring - Point * 14-15 * Intermediate * Male [Description] => Sparring - Point * 14-15 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 122 [Sequence] => 122 ) Array ( [0] => 19881 [UserInfoId] => 19881 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8279 [RankingDivisionDefinitionId] => 8279 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 122 [DivisionId] => 122 [8] => 110 [SportEventId] => 110 [9] => S-40 [DivisionName] => S-40 [10] => Sparring - Point * 14-15 * Intermediate * Male [Description] => Sparring - Point * 14-15 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 122 [Sequence] => 122 ) Array ( [0] => 16596 [UserInfoId] => 16596 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8279 [RankingDivisionDefinitionId] => 8279 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 122 [DivisionId] => 122 [8] => 110 [SportEventId] => 110 [9] => S-40 [DivisionName] => S-40 [10] => Sparring - Point * 14-15 * Intermediate * Male [Description] => Sparring - Point * 14-15 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 122 [Sequence] => 122 ) Array ( [0] => 17228 [UserInfoId] => 17228 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8279 [RankingDivisionDefinitionId] => 8279 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 122 [DivisionId] => 122 [8] => 110 [SportEventId] => 110 [9] => S-40 [DivisionName] => S-40 [10] => Sparring - Point * 14-15 * Intermediate * Male [Description] => Sparring - Point * 14-15 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 122 [Sequence] => 122 ) Array ( [0] => 18534 [UserInfoId] => 18534 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8279 [RankingDivisionDefinitionId] => 8279 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 122 [DivisionId] => 122 [8] => 110 [SportEventId] => 110 [9] => S-40 [DivisionName] => S-40 [10] => Sparring - Point * 14-15 * Intermediate * Male [Description] => Sparring - Point * 14-15 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 122 [Sequence] => 122 ) Array ( [0] => 18827 [UserInfoId] => 18827 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8279 [RankingDivisionDefinitionId] => 8279 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 122 [DivisionId] => 122 [8] => 110 [SportEventId] => 110 [9] => S-40 [DivisionName] => S-40 [10] => Sparring - Point * 14-15 * Intermediate * Male [Description] => Sparring - Point * 14-15 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 122 [Sequence] => 122 ) Array ( [0] => 16791 [UserInfoId] => 16791 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8279 [RankingDivisionDefinitionId] => 8279 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 122 [DivisionId] => 122 [8] => 110 [SportEventId] => 110 [9] => S-40 [DivisionName] => S-40 [10] => Sparring - Point * 14-15 * Intermediate * Male [Description] => Sparring - Point * 14-15 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 122 [Sequence] => 122 ) Array ( [0] => 20349 [UserInfoId] => 20349 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8279 [RankingDivisionDefinitionId] => 8279 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 122 [DivisionId] => 122 [8] => 110 [SportEventId] => 110 [9] => S-40 [DivisionName] => S-40 [10] => Sparring - Point * 14-15 * Intermediate * Male [Description] => Sparring - Point * 14-15 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 122 [Sequence] => 122 ) Array ( [0] => 20160 [UserInfoId] => 20160 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8279 [RankingDivisionDefinitionId] => 8279 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 122 [DivisionId] => 122 [8] => 110 [SportEventId] => 110 [9] => S-40 [DivisionName] => S-40 [10] => Sparring - Point * 14-15 * Intermediate * Male [Description] => Sparring - Point * 14-15 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 122 [Sequence] => 122 ) Array ( [0] => 19739 [UserInfoId] => 19739 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8279 [RankingDivisionDefinitionId] => 8279 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 122 [DivisionId] => 122 [8] => 110 [SportEventId] => 110 [9] => S-40 [DivisionName] => S-40 [10] => Sparring - Point * 14-15 * Intermediate * Male [Description] => Sparring - Point * 14-15 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 122 [Sequence] => 122 ) Array ( [0] => 16592 [UserInfoId] => 16592 [1] => 110 [RankedSportEventId] => 110 [2] => 8 [sumUPts] => 8 [3] => 1 [cntUPts] => 1 [4] => 8279 [RankingDivisionDefinitionId] => 8279 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 122 [DivisionId] => 122 [8] => 110 [SportEventId] => 110 [9] => S-40 [DivisionName] => S-40 [10] => Sparring - Point * 14-15 * Intermediate * Male [Description] => Sparring - Point * 14-15 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 122 [Sequence] => 122 ) Array ( [0] => 22168 [UserInfoId] => 22168 [1] => 110 [RankedSportEventId] => 110 [2] => 8 [sumUPts] => 8 [3] => 1 [cntUPts] => 1 [4] => 8279 [RankingDivisionDefinitionId] => 8279 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 122 [DivisionId] => 122 [8] => 110 [SportEventId] => 110 [9] => S-40 [DivisionName] => S-40 [10] => Sparring - Point * 14-15 * Intermediate * Male [Description] => Sparring - Point * 14-15 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 122 [Sequence] => 122 ) Array ( [0] => 20926 [UserInfoId] => 20926 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8279 [RankingDivisionDefinitionId] => 8279 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 122 [DivisionId] => 122 [8] => 110 [SportEventId] => 110 [9] => S-40 [DivisionName] => S-40 [10] => Sparring - Point * 14-15 * Intermediate * Male [Description] => Sparring - Point * 14-15 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 122 [Sequence] => 122 ) Array ( [0] => 17594 [UserInfoId] => 17594 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8279 [RankingDivisionDefinitionId] => 8279 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 122 [DivisionId] => 122 [8] => 110 [SportEventId] => 110 [9] => S-40 [DivisionName] => S-40 [10] => Sparring - Point * 14-15 * Intermediate * Male [Description] => Sparring - Point * 14-15 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 14 [AgeLow] => 14 [14] => 15 [AgeHigh] => 15 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 122 [Sequence] => 122 ) BB[ 17594 ]) 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=126 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 17594 [UserInfoId] => 17594 [1] => 110 [RankedSportEventId] => 110 [2] => 77 [sumUPts] => 77 [3] => 7 [cntUPts] => 7 [4] => 8283 [RankingDivisionDefinitionId] => 8283 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 126 [DivisionId] => 126 [8] => 110 [SportEventId] => 110 [9] => S-44 [DivisionName] => S-44 [10] => Sparring - Point * 16-17 * Intermediate * Male [Description] => Sparring - Point * 16-17 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 16 [AgeLow] => 16 [14] => 17 [AgeHigh] => 17 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 126 [Sequence] => 126 ) Standings for Rogers, Alex Xavier


Standings for:
Rogers, Alex Xavier
Event & Description Skill Level Weight (lbs) Points # Events Rank
BC-8 Breaking - Creative Open
Mixed * ≤ 17 yrs
Beginner 2423
B-2 Breaking - Power Wood - Hand/Elbow
Mixed * 12 - 17 yrs
Beginner 4142
F-21 Forms
Mixed * 16 - 17 yrs
Intermediate 4551
M-6 Forms - Specialty
Mixed * 12 - 17 yrs
Intermediate 12214
FH-5 Forms - Traditional Hard Style
Mixed * 12 - 17 yrs
Intermediate 12113
S-40 Sparring - Point
Male * 14 - 15 yrs
Intermediate 6122
S-44 Sparring - Point
Male * 16 - 17 yrs
Intermediate 7771
Total217