BB[ 19068 ]) 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=166 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19068 [UserInfoId] => 19068 [1] => 95 [RankedSportEventId] => 95 [2] => 122 [sumUPts] => 122 [3] => 11 [cntUPts] => 11 [4] => 8323 [RankingDivisionDefinitionId] => 8323 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 166 [DivisionId] => 166 [8] => 95 [SportEventId] => 95 [9] => BC-11 [DivisionName] => BC-11 [10] => Breaking - Creative Open * 18+ * Black * Mixed [Description] => Breaking - Creative Open * 18+ * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 166 [Sequence] => 166 ) BB[ 19068 ]) 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=160 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19068 [UserInfoId] => 19068 [1] => 299 [RankedSportEventId] => 299 [2] => 122 [sumUPts] => 122 [3] => 12 [cntUPts] => 12 [4] => 8317 [RankingDivisionDefinitionId] => 8317 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 160 [DivisionId] => 160 [8] => 299 [SportEventId] => 299 [9] => B-5 [DivisionName] => B-5 [10] => Breaking - Power Wood - Hand/Elbow * 18+ * Male * Black [Description] => Breaking - Power Wood - Hand/Elbow * 18+ * Male * Black [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 160 [Sequence] => 160 ) BB[ 19068 ]) 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=34 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 13315 [UserInfoId] => 13315 [1] => 132 [RankedSportEventId] => 132 [2] => 36 [sumUPts] => 36 [3] => 3 [cntUPts] => 3 [4] => 8191 [RankingDivisionDefinitionId] => 8191 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 132 [SportEventId] => 132 [9] => F-32 [DivisionName] => F-32 [10] => Forms * 18-34 * Black * Male [Description] => Forms * 18-34 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) Array ( [0] => 17036 [UserInfoId] => 17036 [1] => 132 [RankedSportEventId] => 132 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8191 [RankingDivisionDefinitionId] => 8191 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 132 [SportEventId] => 132 [9] => F-32 [DivisionName] => F-32 [10] => Forms * 18-34 * Black * Male [Description] => Forms * 18-34 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) Array ( [0] => 15366 [UserInfoId] => 15366 [1] => 132 [RankedSportEventId] => 132 [2] => 13 [sumUPts] => 13 [3] => 2 [cntUPts] => 2 [4] => 8191 [RankingDivisionDefinitionId] => 8191 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 132 [SportEventId] => 132 [9] => F-32 [DivisionName] => F-32 [10] => Forms * 18-34 * Black * Male [Description] => Forms * 18-34 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) Array ( [0] => 14998 [UserInfoId] => 14998 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8191 [RankingDivisionDefinitionId] => 8191 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 132 [SportEventId] => 132 [9] => F-32 [DivisionName] => F-32 [10] => Forms * 18-34 * Black * Male [Description] => Forms * 18-34 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) Array ( [0] => 15427 [UserInfoId] => 15427 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8191 [RankingDivisionDefinitionId] => 8191 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 132 [SportEventId] => 132 [9] => F-32 [DivisionName] => F-32 [10] => Forms * 18-34 * Black * Male [Description] => Forms * 18-34 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) Array ( [0] => 15468 [UserInfoId] => 15468 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8191 [RankingDivisionDefinitionId] => 8191 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 132 [SportEventId] => 132 [9] => F-32 [DivisionName] => F-32 [10] => Forms * 18-34 * Black * Male [Description] => Forms * 18-34 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) Array ( [0] => 20153 [UserInfoId] => 20153 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8191 [RankingDivisionDefinitionId] => 8191 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 132 [SportEventId] => 132 [9] => F-32 [DivisionName] => F-32 [10] => Forms * 18-34 * Black * Male [Description] => Forms * 18-34 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) Array ( [0] => 19886 [UserInfoId] => 19886 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8191 [RankingDivisionDefinitionId] => 8191 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 132 [SportEventId] => 132 [9] => F-32 [DivisionName] => F-32 [10] => Forms * 18-34 * Black * Male [Description] => Forms * 18-34 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) Array ( [0] => 19562 [UserInfoId] => 19562 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8191 [RankingDivisionDefinitionId] => 8191 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 132 [SportEventId] => 132 [9] => F-32 [DivisionName] => F-32 [10] => Forms * 18-34 * Black * Male [Description] => Forms * 18-34 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) Array ( [0] => 20202 [UserInfoId] => 20202 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8191 [RankingDivisionDefinitionId] => 8191 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 132 [SportEventId] => 132 [9] => F-32 [DivisionName] => F-32 [10] => Forms * 18-34 * Black * Male [Description] => Forms * 18-34 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) Array ( [0] => 19619 [UserInfoId] => 19619 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8191 [RankingDivisionDefinitionId] => 8191 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 132 [SportEventId] => 132 [9] => F-32 [DivisionName] => F-32 [10] => Forms * 18-34 * Black * Male [Description] => Forms * 18-34 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) Array ( [0] => 16672 [UserInfoId] => 16672 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8191 [RankingDivisionDefinitionId] => 8191 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 132 [SportEventId] => 132 [9] => F-32 [DivisionName] => F-32 [10] => Forms * 18-34 * Black * Male [Description] => Forms * 18-34 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) Array ( [0] => 21231 [UserInfoId] => 21231 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8191 [RankingDivisionDefinitionId] => 8191 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 132 [SportEventId] => 132 [9] => F-32 [DivisionName] => F-32 [10] => Forms * 18-34 * Black * Male [Description] => Forms * 18-34 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) Array ( [0] => 21808 [UserInfoId] => 21808 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8191 [RankingDivisionDefinitionId] => 8191 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 132 [SportEventId] => 132 [9] => F-32 [DivisionName] => F-32 [10] => Forms * 18-34 * Black * Male [Description] => Forms * 18-34 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) Array ( [0] => 15035 [UserInfoId] => 15035 [1] => 132 [RankedSportEventId] => 132 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8191 [RankingDivisionDefinitionId] => 8191 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 132 [SportEventId] => 132 [9] => F-32 [DivisionName] => F-32 [10] => Forms * 18-34 * Black * Male [Description] => Forms * 18-34 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) Array ( [0] => 19068 [UserInfoId] => 19068 [1] => 132 [RankedSportEventId] => 132 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8191 [RankingDivisionDefinitionId] => 8191 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 34 [DivisionId] => 34 [8] => 132 [SportEventId] => 132 [9] => F-32 [DivisionName] => F-32 [10] => Forms * 18-34 * Black * Male [Description] => Forms * 18-34 * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 34 [Sequence] => 34 ) BB[ 19068 ]) 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=35 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19068 [UserInfoId] => 19068 [1] => 132 [RankedSportEventId] => 132 [2] => 147 [sumUPts] => 147 [3] => 18 [cntUPts] => 18 [4] => 8192 [RankingDivisionDefinitionId] => 8192 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 35 [DivisionId] => 35 [8] => 132 [SportEventId] => 132 [9] => F-33 [DivisionName] => F-33 [10] => Forms * 35+ * Black * Male [Description] => Forms * 35+ * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 35 [AgeLow] => 35 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 35 [Sequence] => 35 ) BB[ 19068 ]) 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=37 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15312 [UserInfoId] => 15312 [1] => 132 [RankedSportEventId] => 132 [2] => 193 [sumUPts] => 193 [3] => 20 [cntUPts] => 20 [4] => 8194 [RankingDivisionDefinitionId] => 8194 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 37 [DivisionId] => 37 [8] => 132 [SportEventId] => 132 [9] => F-35 [DivisionName] => F-35 [10] => Forms * 45+ * Black * Male [Description] => Forms * 45+ * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 45 [AgeLow] => 45 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 37 [Sequence] => 37 ) Array ( [0] => 14783 [UserInfoId] => 14783 [1] => 132 [RankedSportEventId] => 132 [2] => 124 [sumUPts] => 124 [3] => 15 [cntUPts] => 15 [4] => 8194 [RankingDivisionDefinitionId] => 8194 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 37 [DivisionId] => 37 [8] => 132 [SportEventId] => 132 [9] => F-35 [DivisionName] => F-35 [10] => Forms * 45+ * Black * Male [Description] => Forms * 45+ * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 45 [AgeLow] => 45 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 37 [Sequence] => 37 ) Array ( [0] => 19068 [UserInfoId] => 19068 [1] => 132 [RankedSportEventId] => 132 [2] => 58 [sumUPts] => 58 [3] => 9 [cntUPts] => 9 [4] => 8194 [RankingDivisionDefinitionId] => 8194 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 37 [DivisionId] => 37 [8] => 132 [SportEventId] => 132 [9] => F-35 [DivisionName] => F-35 [10] => Forms * 45+ * Black * Male [Description] => Forms * 45+ * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 45 [AgeLow] => 45 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 37 [Sequence] => 37 ) BB[ 19068 ]) 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=220 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=71 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19068 [UserInfoId] => 19068 [1] => 220 [RankedSportEventId] => 220 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8228 [RankingDivisionDefinitionId] => 8228 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 71 [DivisionId] => 71 [8] => 341 [SportEventId] => 341 [9] => FS-10 [DivisionName] => FS-10 [10] => Forms - Traditional Soft Style * 18+ * Black * Mixed [Description] => Forms - Traditional Soft Style * 18+ * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 71 [Sequence] => 71 ) BB[ 19068 ]) 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=47 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19068 [UserInfoId] => 19068 [1] => 277 [RankedSportEventId] => 277 [2] => 191 [sumUPts] => 191 [3] => 18 [cntUPts] => 18 [4] => 8204 [RankingDivisionDefinitionId] => 8204 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 47 [DivisionId] => 47 [8] => 277 [SportEventId] => 277 [9] => M-10 [DivisionName] => M-10 [10] => Forms - Specialty * 18+ * Black * Mixed [Description] => Forms - Specialty * 18+ * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 47 [Sequence] => 47 ) BB[ 19068 ]) 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=48 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 14783 [UserInfoId] => 14783 [1] => 277 [RankedSportEventId] => 277 [2] => 147 [sumUPts] => 147 [3] => 15 [cntUPts] => 15 [4] => 8205 [RankingDivisionDefinitionId] => 8205 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 48 [DivisionId] => 48 [8] => 277 [SportEventId] => 277 [9] => M-11 [DivisionName] => M-11 [10] => Forms - Specialty * 35+ * Black * Mixed [Description] => Forms - Specialty * 35+ * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 35 [AgeLow] => 35 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 48 [Sequence] => 48 ) Array ( [0] => 19068 [UserInfoId] => 19068 [1] => 277 [RankedSportEventId] => 277 [2] => 131 [sumUPts] => 131 [3] => 18 [cntUPts] => 18 [4] => 8205 [RankingDivisionDefinitionId] => 8205 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 48 [DivisionId] => 48 [8] => 277 [SportEventId] => 277 [9] => M-11 [DivisionName] => M-11 [10] => Forms - Specialty * 35+ * Black * Mixed [Description] => Forms - Specialty * 35+ * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 35 [AgeLow] => 35 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 48 [Sequence] => 48 ) BB[ 19068 ]) 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=61 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 14783 [UserInfoId] => 14783 [1] => 340 [RankedSportEventId] => 340 [2] => 119 [sumUPts] => 119 [3] => 14 [cntUPts] => 14 [4] => 8218 [RankingDivisionDefinitionId] => 8218 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 61 [DivisionId] => 61 [8] => 340 [SportEventId] => 340 [9] => FH-11 [DivisionName] => FH-11 [10] => Forms - Traditional Hard Style * 35+ * Black * Mixed [Description] => Forms - Traditional Hard Style * 35+ * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 35 [AgeLow] => 35 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 61 [Sequence] => 61 ) Array ( [0] => 19068 [UserInfoId] => 19068 [1] => 340 [RankedSportEventId] => 340 [2] => 107 [sumUPts] => 107 [3] => 17 [cntUPts] => 17 [4] => 8218 [RankingDivisionDefinitionId] => 8218 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 61 [DivisionId] => 61 [8] => 340 [SportEventId] => 340 [9] => FH-11 [DivisionName] => FH-11 [10] => Forms - Traditional Hard Style * 35+ * Black * Mixed [Description] => Forms - Traditional Hard Style * 35+ * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 35 [AgeLow] => 35 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 61 [Sequence] => 61 ) BB[ 19068 ]) 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=71 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19068 [UserInfoId] => 19068 [1] => 341 [RankedSportEventId] => 341 [2] => 197 [sumUPts] => 197 [3] => 19 [cntUPts] => 19 [4] => 8228 [RankingDivisionDefinitionId] => 8228 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 71 [DivisionId] => 71 [8] => 341 [SportEventId] => 341 [9] => FS-10 [DivisionName] => FS-10 [10] => Forms - Traditional Soft Style * 18+ * Black * Mixed [Description] => Forms - Traditional Soft Style * 18+ * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 71 [Sequence] => 71 ) BB[ 19068 ]) SELECT UserInfoId, rem.RankedSportEventId, sum(Points) as sumUPts, count(Points) as cntUPts, rdd.* FROM UserRankingPoints urp, RankingEventMappings rem, RankingDivisionDefinitions rdd WHERE urp.SportEventId=rem.SportEventId AND urp.RankingSystemId=8 AND rem.RankedSportEventId=213 AND urp.RankingSystemId=rdd.RankingSystemDefinitionId AND urp.TournamentId in ( 145,146,147,148,149,150,151,152,153,154,155,156,157,159,161,162,163,164,165,166,167,168,169,170,171 ) AND urp.RankingDivisionId=rdd.DivisionId AND urp.RankingDivisionId=81 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19068 [UserInfoId] => 19068 [1] => 213 [RankedSportEventId] => 213 [2] => 192 [sumUPts] => 192 [3] => 19 [cntUPts] => 19 [4] => 8238 [RankingDivisionDefinitionId] => 8238 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 81 [DivisionId] => 81 [8] => 213 [SportEventId] => 213 [9] => SD-10 [DivisionName] => SD-10 [10] => Self Defense * 18+ * Black * Mixed [Description] => Self Defense * 18+ * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 81 [Sequence] => 81 ) BB[ 19068 ]) 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=155 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15312 [UserInfoId] => 15312 [1] => 110 [RankedSportEventId] => 110 [2] => 198 [sumUPts] => 198 [3] => 20 [cntUPts] => 20 [4] => 8312 [RankingDivisionDefinitionId] => 8312 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 155 [DivisionId] => 155 [8] => 110 [SportEventId] => 110 [9] => S-73 [DivisionName] => S-73 [10] => Sparring - Point * 55+ * Black * Male [Description] => Sparring - Point * 55+ * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 55 [AgeLow] => 55 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 155 [Sequence] => 155 ) Array ( [0] => 19068 [UserInfoId] => 19068 [1] => 110 [RankedSportEventId] => 110 [2] => 80 [sumUPts] => 80 [3] => 9 [cntUPts] => 9 [4] => 8312 [RankingDivisionDefinitionId] => 8312 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 155 [DivisionId] => 155 [8] => 110 [SportEventId] => 110 [9] => S-73 [DivisionName] => S-73 [10] => Sparring - Point * 55+ * Black * Male [Description] => Sparring - Point * 55+ * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 55 [AgeLow] => 55 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 155 [Sequence] => 155 ) BB[ 19068 ]) 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=133 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=49 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19068 [UserInfoId] => 19068 [1] => 133 [RankedSportEventId] => 133 [2] => 108 [sumUPts] => 108 [3] => 16 [cntUPts] => 16 [4] => 8206 [RankingDivisionDefinitionId] => 8206 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 49 [DivisionId] => 49 [8] => 133 [SportEventId] => 133 [9] => M-12 [DivisionName] => M-12 [10] => Weapons * 18+ * Black * Mixed [Description] => Weapons * 18+ * Black * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 1229 [BeltRankClass] => 1229 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 49 [Sequence] => 49 ) Standings for Elder, Charles Rhey


Standings for:
Elder, Charles Rhey
Event & Description Skill Level Weight (lbs) Points # Events Rank
BC-11 Breaking - Creative Open
Mixed * 18+ yrs
Black Belt 122111
B-5 Breaking - Power Wood - Hand/Elbow
Male * 18+ yrs
Black Belt 122121
F-32 Forms
Male * 18 - 34 yrs
Black Belt 6116
F-33 Forms
Male * 35+ yrs
Black Belt 147181
F-35 Forms
Male * 45+ yrs
Black Belt 5893
FS-10 Forms - Soft Contemporary
Mixed * 18+ yrs
Black Belt 1211
M-10 Forms - Specialty
Mixed * 18+ yrs
Black Belt 191181
M-11 Forms - Specialty
Mixed * 35+ yrs
Black Belt 131182
FH-11 Forms - Traditional Hard Style
Mixed * 35+ yrs
Black Belt 107172
FS-10 Forms - Traditional Soft Style
Mixed * 18+ yrs
Black Belt 197191
SD-10 Self Defense
Mixed * 18+ yrs
Black Belt 192191
S-73 Sparring - Point
Male * 55+ yrs
Black Belt 8092
M-12 Weapons
Mixed * 18+ yrs
Black Belt 108161
Total1473