BB[ 15580 ]) 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 ) Array ( [0] => 13594 [UserInfoId] => 13594 [1] => 132 [RankedSportEventId] => 132 [2] => 52 [sumUPts] => 52 [3] => 5 [cntUPts] => 5 [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] => 14727 [UserInfoId] => 14727 [1] => 132 [RankedSportEventId] => 132 [2] => 35 [sumUPts] => 35 [3] => 5 [cntUPts] => 5 [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] => 13698 [UserInfoId] => 13698 [1] => 132 [RankedSportEventId] => 132 [2] => 33 [sumUPts] => 33 [3] => 5 [cntUPts] => 5 [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] => 15580 [UserInfoId] => 15580 [1] => 132 [RankedSportEventId] => 132 [2] => 24 [sumUPts] => 24 [3] => 4 [cntUPts] => 4 [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[ 15580 ]) 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 ) Array ( [0] => 15580 [UserInfoId] => 15580 [1] => 277 [RankedSportEventId] => 277 [2] => 99 [sumUPts] => 99 [3] => 10 [cntUPts] => 10 [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[ 15580 ]) 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=272 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=50 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 13368 [UserInfoId] => 13368 [1] => 272 [RankedSportEventId] => 272 [2] => 48 [sumUPts] => 48 [3] => 4 [cntUPts] => 4 [4] => 8207 [RankingDivisionDefinitionId] => 8207 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 50 [DivisionId] => 50 [8] => 272 [SportEventId] => 272 [9] => M-13 [DivisionName] => M-13 [10] => Forms - Teams - Open * Mixed [Description] => Forms - Teams - Open * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 0 [AgeLow] => 0 [14] => 0 [AgeHigh] => 0 [15] => 0 [BeltRankLow] => 0 [16] => 0 [BeltRankHigh] => 0 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 50 [Sequence] => 50 ) Array ( [0] => 13367 [UserInfoId] => 13367 [1] => 272 [RankedSportEventId] => 272 [2] => 48 [sumUPts] => 48 [3] => 4 [cntUPts] => 4 [4] => 8207 [RankingDivisionDefinitionId] => 8207 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 50 [DivisionId] => 50 [8] => 272 [SportEventId] => 272 [9] => M-13 [DivisionName] => M-13 [10] => Forms - Teams - Open * Mixed [Description] => Forms - Teams - Open * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 0 [AgeLow] => 0 [14] => 0 [AgeHigh] => 0 [15] => 0 [BeltRankLow] => 0 [16] => 0 [BeltRankHigh] => 0 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 50 [Sequence] => 50 ) Array ( [0] => 13365 [UserInfoId] => 13365 [1] => 272 [RankedSportEventId] => 272 [2] => 48 [sumUPts] => 48 [3] => 4 [cntUPts] => 4 [4] => 8207 [RankingDivisionDefinitionId] => 8207 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 50 [DivisionId] => 50 [8] => 272 [SportEventId] => 272 [9] => M-13 [DivisionName] => M-13 [10] => Forms - Teams - Open * Mixed [Description] => Forms - Teams - Open * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 0 [AgeLow] => 0 [14] => 0 [AgeHigh] => 0 [15] => 0 [BeltRankLow] => 0 [16] => 0 [BeltRankHigh] => 0 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 50 [Sequence] => 50 ) Array ( [0] => 13479 [UserInfoId] => 13479 [1] => 272 [RankedSportEventId] => 272 [2] => 39 [sumUPts] => 39 [3] => 5 [cntUPts] => 5 [4] => 8207 [RankingDivisionDefinitionId] => 8207 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 50 [DivisionId] => 50 [8] => 272 [SportEventId] => 272 [9] => M-13 [DivisionName] => M-13 [10] => Forms - Teams - Open * Mixed [Description] => Forms - Teams - Open * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 0 [AgeLow] => 0 [14] => 0 [AgeHigh] => 0 [15] => 0 [BeltRankLow] => 0 [16] => 0 [BeltRankHigh] => 0 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 50 [Sequence] => 50 ) Array ( [0] => 19673 [UserInfoId] => 19673 [1] => 272 [RankedSportEventId] => 272 [2] => 36 [sumUPts] => 36 [3] => 4 [cntUPts] => 4 [4] => 8207 [RankingDivisionDefinitionId] => 8207 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 50 [DivisionId] => 50 [8] => 272 [SportEventId] => 272 [9] => M-13 [DivisionName] => M-13 [10] => Forms - Teams - Open * Mixed [Description] => Forms - Teams - Open * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 0 [AgeLow] => 0 [14] => 0 [AgeHigh] => 0 [15] => 0 [BeltRankLow] => 0 [16] => 0 [BeltRankHigh] => 0 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 50 [Sequence] => 50 ) Array ( [0] => 15044 [UserInfoId] => 15044 [1] => 272 [RankedSportEventId] => 272 [2] => 33 [sumUPts] => 33 [3] => 3 [cntUPts] => 3 [4] => 8207 [RankingDivisionDefinitionId] => 8207 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 50 [DivisionId] => 50 [8] => 272 [SportEventId] => 272 [9] => M-13 [DivisionName] => M-13 [10] => Forms - Teams - Open * Mixed [Description] => Forms - Teams - Open * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 0 [AgeLow] => 0 [14] => 0 [AgeHigh] => 0 [15] => 0 [BeltRankLow] => 0 [16] => 0 [BeltRankHigh] => 0 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 50 [Sequence] => 50 ) Array ( [0] => 20437 [UserInfoId] => 20437 [1] => 272 [RankedSportEventId] => 272 [2] => 30 [sumUPts] => 30 [3] => 3 [cntUPts] => 3 [4] => 8207 [RankingDivisionDefinitionId] => 8207 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 50 [DivisionId] => 50 [8] => 272 [SportEventId] => 272 [9] => M-13 [DivisionName] => M-13 [10] => Forms - Teams - Open * Mixed [Description] => Forms - Teams - Open * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 0 [AgeLow] => 0 [14] => 0 [AgeHigh] => 0 [15] => 0 [BeltRankLow] => 0 [16] => 0 [BeltRankHigh] => 0 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 50 [Sequence] => 50 ) Array ( [0] => 19795 [UserInfoId] => 19795 [1] => 272 [RankedSportEventId] => 272 [2] => 30 [sumUPts] => 30 [3] => 4 [cntUPts] => 4 [4] => 8207 [RankingDivisionDefinitionId] => 8207 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 50 [DivisionId] => 50 [8] => 272 [SportEventId] => 272 [9] => M-13 [DivisionName] => M-13 [10] => Forms - Teams - Open * Mixed [Description] => Forms - Teams - Open * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 0 [AgeLow] => 0 [14] => 0 [AgeHigh] => 0 [15] => 0 [BeltRankLow] => 0 [16] => 0 [BeltRankHigh] => 0 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 50 [Sequence] => 50 ) Array ( [0] => 20093 [UserInfoId] => 20093 [1] => 272 [RankedSportEventId] => 272 [2] => 30 [sumUPts] => 30 [3] => 4 [cntUPts] => 4 [4] => 8207 [RankingDivisionDefinitionId] => 8207 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 50 [DivisionId] => 50 [8] => 272 [SportEventId] => 272 [9] => M-13 [DivisionName] => M-13 [10] => Forms - Teams - Open * Mixed [Description] => Forms - Teams - Open * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 0 [AgeLow] => 0 [14] => 0 [AgeHigh] => 0 [15] => 0 [BeltRankLow] => 0 [16] => 0 [BeltRankHigh] => 0 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 50 [Sequence] => 50 ) Array ( [0] => 13478 [UserInfoId] => 13478 [1] => 272 [RankedSportEventId] => 272 [2] => 30 [sumUPts] => 30 [3] => 4 [cntUPts] => 4 [4] => 8207 [RankingDivisionDefinitionId] => 8207 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 50 [DivisionId] => 50 [8] => 272 [SportEventId] => 272 [9] => M-13 [DivisionName] => M-13 [10] => Forms - Teams - Open * Mixed [Description] => Forms - Teams - Open * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 0 [AgeLow] => 0 [14] => 0 [AgeHigh] => 0 [15] => 0 [BeltRankLow] => 0 [16] => 0 [BeltRankHigh] => 0 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 50 [Sequence] => 50 ) Array ( [0] => 15437 [UserInfoId] => 15437 [1] => 272 [RankedSportEventId] => 272 [2] => 27 [sumUPts] => 27 [3] => 3 [cntUPts] => 3 [4] => 8207 [RankingDivisionDefinitionId] => 8207 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 50 [DivisionId] => 50 [8] => 272 [SportEventId] => 272 [9] => M-13 [DivisionName] => M-13 [10] => Forms - Teams - Open * Mixed [Description] => Forms - Teams - Open * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 0 [AgeLow] => 0 [14] => 0 [AgeHigh] => 0 [15] => 0 [BeltRankLow] => 0 [16] => 0 [BeltRankHigh] => 0 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 50 [Sequence] => 50 ) Array ( [0] => 15580 [UserInfoId] => 15580 [1] => 272 [RankedSportEventId] => 272 [2] => 27 [sumUPts] => 27 [3] => 3 [cntUPts] => 3 [4] => 8207 [RankingDivisionDefinitionId] => 8207 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 50 [DivisionId] => 50 [8] => 272 [SportEventId] => 272 [9] => M-13 [DivisionName] => M-13 [10] => Forms - Teams - Open * Mixed [Description] => Forms - Teams - Open * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 0 [AgeLow] => 0 [14] => 0 [AgeHigh] => 0 [15] => 0 [BeltRankLow] => 0 [16] => 0 [BeltRankHigh] => 0 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 50 [Sequence] => 50 ) BB[ 15580 ]) 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 ) Array ( [0] => 15101 [UserInfoId] => 15101 [1] => 133 [RankedSportEventId] => 133 [2] => 84 [sumUPts] => 84 [3] => 9 [cntUPts] => 9 [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 ) Array ( [0] => 15580 [UserInfoId] => 15580 [1] => 133 [RankedSportEventId] => 133 [2] => 81 [sumUPts] => 81 [3] => 9 [cntUPts] => 9 [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 Burns, Zedrick


Standings for:
Burns, Zedrick
Event & Description Skill Level Weight (lbs) Points # Events Rank
F-35 Forms
Male * 45+ yrs
Black Belt 2447
M-11 Forms - Specialty
Mixed * 35+ yrs
Black Belt 99103
M-13 Forms - Teams - Open
Mixed
ALL 27312
M-12 Weapons
Mixed * 18+ yrs
Black Belt 8193
Total231