BB[ 13705 ]) 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=9 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=4 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 13705 [UserInfoId] => 13705 [1] => 95 [RankedSportEventId] => 95 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8327 [RankingDivisionDefinitionId] => 8327 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 4 [DivisionId] => 4 [8] => 95 [SportEventId] => 95 [9] => BCO-3 [DivisionName] => BCO-3 [10] => Breaking - Creative Open * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Creative Open * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 4 [Sequence] => 4 ) BB[ 13705 ]) 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=9 AND rem.RankedSportEventId=275 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] => 19247 [UserInfoId] => 19247 [1] => 275 [RankedSportEventId] => 275 [2] => 53 [sumUPts] => 53 [3] => 5 [cntUPts] => 5 [4] => 8364 [RankingDivisionDefinitionId] => 8364 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 41 [DivisionId] => 41 [8] => 275 [SportEventId] => 275 [9] => BPCE-2 [DivisionName] => BPCE-2 [10] => Breaking - Power Concrete Elbow * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Concrete Elbow * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 41 [Sequence] => 41 ) Array ( [0] => 19919 [UserInfoId] => 19919 [1] => 275 [RankedSportEventId] => 275 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8364 [RankingDivisionDefinitionId] => 8364 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 41 [DivisionId] => 41 [8] => 275 [SportEventId] => 275 [9] => BPCE-2 [DivisionName] => BPCE-2 [10] => Breaking - Power Concrete Elbow * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Concrete Elbow * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 41 [Sequence] => 41 ) Array ( [0] => 13705 [UserInfoId] => 13705 [1] => 275 [RankedSportEventId] => 275 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8364 [RankingDivisionDefinitionId] => 8364 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 41 [DivisionId] => 41 [8] => 275 [SportEventId] => 275 [9] => BPCE-2 [DivisionName] => BPCE-2 [10] => Breaking - Power Concrete Elbow * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Concrete Elbow * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 41 [Sequence] => 41 ) BB[ 13705 ]) 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=9 AND rem.RankedSportEventId=276 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=48 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19247 [UserInfoId] => 19247 [1] => 276 [RankedSportEventId] => 276 [2] => 53 [sumUPts] => 53 [3] => 5 [cntUPts] => 5 [4] => 8371 [RankingDivisionDefinitionId] => 8371 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 48 [DivisionId] => 48 [8] => 276 [SportEventId] => 276 [9] => BPCF-2 [DivisionName] => BPCF-2 [10] => Breaking - Power Concrete Foot * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Concrete Foot * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 48 [Sequence] => 48 ) Array ( [0] => 21077 [UserInfoId] => 21077 [1] => 276 [RankedSportEventId] => 276 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8371 [RankingDivisionDefinitionId] => 8371 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 48 [DivisionId] => 48 [8] => 276 [SportEventId] => 276 [9] => BPCF-2 [DivisionName] => BPCF-2 [10] => Breaking - Power Concrete Foot * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Concrete Foot * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 48 [Sequence] => 48 ) Array ( [0] => 19919 [UserInfoId] => 19919 [1] => 276 [RankedSportEventId] => 276 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8371 [RankingDivisionDefinitionId] => 8371 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 48 [DivisionId] => 48 [8] => 276 [SportEventId] => 276 [9] => BPCF-2 [DivisionName] => BPCF-2 [10] => Breaking - Power Concrete Foot * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Concrete Foot * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 48 [Sequence] => 48 ) Array ( [0] => 13705 [UserInfoId] => 13705 [1] => 276 [RankedSportEventId] => 276 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8371 [RankingDivisionDefinitionId] => 8371 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 48 [DivisionId] => 48 [8] => 276 [SportEventId] => 276 [9] => BPCF-2 [DivisionName] => BPCF-2 [10] => Breaking - Power Concrete Foot * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Concrete Foot * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 48 [Sequence] => 48 ) BB[ 13705 ]) 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=9 AND rem.RankedSportEventId=274 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] => 19247 [UserInfoId] => 19247 [1] => 274 [RankedSportEventId] => 274 [2] => 29 [sumUPts] => 29 [3] => 3 [cntUPts] => 3 [4] => 8378 [RankingDivisionDefinitionId] => 8378 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 55 [DivisionId] => 55 [8] => 274 [SportEventId] => 274 [9] => BPCH-2 [DivisionName] => BPCH-2 [10] => Breaking - Power Concrete Hand * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Concrete Hand * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 55 [Sequence] => 55 ) Array ( [0] => 19919 [UserInfoId] => 19919 [1] => 274 [RankedSportEventId] => 274 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8378 [RankingDivisionDefinitionId] => 8378 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 55 [DivisionId] => 55 [8] => 274 [SportEventId] => 274 [9] => BPCH-2 [DivisionName] => BPCH-2 [10] => Breaking - Power Concrete Hand * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Concrete Hand * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 55 [Sequence] => 55 ) Array ( [0] => 13705 [UserInfoId] => 13705 [1] => 274 [RankedSportEventId] => 274 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8378 [RankingDivisionDefinitionId] => 8378 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 55 [DivisionId] => 55 [8] => 274 [SportEventId] => 274 [9] => BPCH-2 [DivisionName] => BPCH-2 [10] => Breaking - Power Concrete Hand * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Concrete Hand * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 55 [Sequence] => 55 ) BB[ 13705 ]) 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=9 AND rem.RankedSportEventId=97 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=14 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19826 [UserInfoId] => 19826 [1] => 97 [RankedSportEventId] => 97 [2] => 48 [sumUPts] => 48 [3] => 4 [cntUPts] => 4 [4] => 8337 [RankingDivisionDefinitionId] => 8337 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 97 [SportEventId] => 97 [9] => BPWE-5 [DivisionName] => BPWE-5 [10] => Breaking - Power Wood Elbow * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Wood Elbow * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 14 [Sequence] => 14 ) Array ( [0] => 19247 [UserInfoId] => 19247 [1] => 97 [RankedSportEventId] => 97 [2] => 26 [sumUPts] => 26 [3] => 3 [cntUPts] => 3 [4] => 8337 [RankingDivisionDefinitionId] => 8337 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 97 [SportEventId] => 97 [9] => BPWE-5 [DivisionName] => BPWE-5 [10] => Breaking - Power Wood Elbow * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Wood Elbow * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 14 [Sequence] => 14 ) Array ( [0] => 19817 [UserInfoId] => 19817 [1] => 97 [RankedSportEventId] => 97 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8337 [RankingDivisionDefinitionId] => 8337 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 97 [SportEventId] => 97 [9] => BPWE-5 [DivisionName] => BPWE-5 [10] => Breaking - Power Wood Elbow * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Wood Elbow * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 14 [Sequence] => 14 ) Array ( [0] => 15737 [UserInfoId] => 15737 [1] => 97 [RankedSportEventId] => 97 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8337 [RankingDivisionDefinitionId] => 8337 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 97 [SportEventId] => 97 [9] => BPWE-5 [DivisionName] => BPWE-5 [10] => Breaking - Power Wood Elbow * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Wood Elbow * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 14 [Sequence] => 14 ) Array ( [0] => 21077 [UserInfoId] => 21077 [1] => 97 [RankedSportEventId] => 97 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8337 [RankingDivisionDefinitionId] => 8337 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 97 [SportEventId] => 97 [9] => BPWE-5 [DivisionName] => BPWE-5 [10] => Breaking - Power Wood Elbow * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Wood Elbow * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 14 [Sequence] => 14 ) Array ( [0] => 13705 [UserInfoId] => 13705 [1] => 97 [RankedSportEventId] => 97 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8337 [RankingDivisionDefinitionId] => 8337 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 14 [DivisionId] => 14 [8] => 97 [SportEventId] => 97 [9] => BPWE-5 [DivisionName] => BPWE-5 [10] => Breaking - Power Wood Elbow * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Wood Elbow * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 14 [Sequence] => 14 ) BB[ 13705 ]) 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=9 AND rem.RankedSportEventId=98 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=24 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 21077 [UserInfoId] => 21077 [1] => 98 [RankedSportEventId] => 98 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8347 [RankingDivisionDefinitionId] => 8347 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 98 [SportEventId] => 98 [9] => BPWF-5 [DivisionName] => BPWF-5 [10] => Breaking - Power Wood Foot * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Wood Foot * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) Array ( [0] => 19247 [UserInfoId] => 19247 [1] => 98 [RankedSportEventId] => 98 [2] => 17 [sumUPts] => 17 [3] => 2 [cntUPts] => 2 [4] => 8347 [RankingDivisionDefinitionId] => 8347 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 98 [SportEventId] => 98 [9] => BPWF-5 [DivisionName] => BPWF-5 [10] => Breaking - Power Wood Foot * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Wood Foot * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) Array ( [0] => 19919 [UserInfoId] => 19919 [1] => 98 [RankedSportEventId] => 98 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8347 [RankingDivisionDefinitionId] => 8347 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 98 [SportEventId] => 98 [9] => BPWF-5 [DivisionName] => BPWF-5 [10] => Breaking - Power Wood Foot * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Wood Foot * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) Array ( [0] => 13705 [UserInfoId] => 13705 [1] => 98 [RankedSportEventId] => 98 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8347 [RankingDivisionDefinitionId] => 8347 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 24 [DivisionId] => 24 [8] => 98 [SportEventId] => 98 [9] => BPWF-5 [DivisionName] => BPWF-5 [10] => Breaking - Power Wood Foot * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Wood Foot * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 24 [Sequence] => 24 ) BB[ 13705 ]) 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=9 AND rem.RankedSportEventId=96 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=34 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 16712 [UserInfoId] => 16712 [1] => 96 [RankedSportEventId] => 96 [2] => 51 [sumUPts] => 51 [3] => 5 [cntUPts] => 5 [4] => 8357 [RankingDivisionDefinitionId] => 8357 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 96 [SportEventId] => 96 [9] => BPWH-5 [DivisionName] => BPWH-5 [10] => Breaking - Power Wood Hand * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Wood Hand * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) Array ( [0] => 17470 [UserInfoId] => 17470 [1] => 96 [RankedSportEventId] => 96 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8357 [RankingDivisionDefinitionId] => 8357 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 96 [SportEventId] => 96 [9] => BPWH-5 [DivisionName] => BPWH-5 [10] => Breaking - Power Wood Hand * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Wood Hand * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) Array ( [0] => 21077 [UserInfoId] => 21077 [1] => 96 [RankedSportEventId] => 96 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8357 [RankingDivisionDefinitionId] => 8357 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 96 [SportEventId] => 96 [9] => BPWH-5 [DivisionName] => BPWH-5 [10] => Breaking - Power Wood Hand * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Wood Hand * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) Array ( [0] => 19247 [UserInfoId] => 19247 [1] => 96 [RankedSportEventId] => 96 [2] => 14 [sumUPts] => 14 [3] => 2 [cntUPts] => 2 [4] => 8357 [RankingDivisionDefinitionId] => 8357 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 96 [SportEventId] => 96 [9] => BPWH-5 [DivisionName] => BPWH-5 [10] => Breaking - Power Wood Hand * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Wood Hand * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) Array ( [0] => 19919 [UserInfoId] => 19919 [1] => 96 [RankedSportEventId] => 96 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8357 [RankingDivisionDefinitionId] => 8357 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 96 [SportEventId] => 96 [9] => BPWH-5 [DivisionName] => BPWH-5 [10] => Breaking - Power Wood Hand * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Wood Hand * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) Array ( [0] => 19817 [UserInfoId] => 19817 [1] => 96 [RankedSportEventId] => 96 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8357 [RankingDivisionDefinitionId] => 8357 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 96 [SportEventId] => 96 [9] => BPWH-5 [DivisionName] => BPWH-5 [10] => Breaking - Power Wood Hand * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Wood Hand * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) Array ( [0] => 13705 [UserInfoId] => 13705 [1] => 96 [RankedSportEventId] => 96 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8357 [RankingDivisionDefinitionId] => 8357 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 96 [SportEventId] => 96 [9] => BPWH-5 [DivisionName] => BPWH-5 [10] => Breaking - Power Wood Hand * 18+ yrs * Beg/Int/Adv * Male [Description] => Breaking - Power Wood Hand * 18+ yrs * Beg/Int/Adv * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 4 [BeltRankClass] => 4 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) Standings for Killam, Paul II


Standings for:
Killam, Paul II
Event & Description Skill Level Weight (lbs) Points # Events Rank
BCO-3 Breaking - Creative Open
Male * 18+ yrs
Beginner 1211
BPCE-2 Breaking - Power Concrete - Elbow
Mixed * 18+ yrs
Beginner 1213
BPCF-2 Breaking - Power Concrete - Foot
Mixed * 18+ yrs
Beginner 1214
BPCH-2 Breaking - Power Concrete - Hand
Mixed * 18+ yrs
Beginner 1213
BPWE-5 Breaking - Power Wood - Elbow
Mixed * 18+ yrs
Beginner 916
BPWF-5 Breaking - Power Wood - Foot
Mixed * 18+ yrs
Beginner 1214
BPWH-5 Breaking - Power Wood - Hand
Mixed * 18+ yrs
Beginner 1217
Total81