BB[ 16457 ]) 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=30 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15149 [UserInfoId] => 15149 [1] => 132 [RankedSportEventId] => 132 [2] => 113 [sumUPts] => 113 [3] => 15 [cntUPts] => 15 [4] => 8187 [RankingDivisionDefinitionId] => 8187 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 30 [DivisionId] => 30 [8] => 132 [SportEventId] => 132 [9] => F-28 [DivisionName] => F-28 [10] => Forms * 18+ * Intermediate * Male [Description] => Forms * 18+ * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [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] => 30 [Sequence] => 30 ) Array ( [0] => 19748 [UserInfoId] => 19748 [1] => 132 [RankedSportEventId] => 132 [2] => 65 [sumUPts] => 65 [3] => 6 [cntUPts] => 6 [4] => 8187 [RankingDivisionDefinitionId] => 8187 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 30 [DivisionId] => 30 [8] => 132 [SportEventId] => 132 [9] => F-28 [DivisionName] => F-28 [10] => Forms * 18+ * Intermediate * Male [Description] => Forms * 18+ * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [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] => 30 [Sequence] => 30 ) Array ( [0] => 13804 [UserInfoId] => 13804 [1] => 132 [RankedSportEventId] => 132 [2] => 60 [sumUPts] => 60 [3] => 6 [cntUPts] => 6 [4] => 8187 [RankingDivisionDefinitionId] => 8187 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 30 [DivisionId] => 30 [8] => 132 [SportEventId] => 132 [9] => F-28 [DivisionName] => F-28 [10] => Forms * 18+ * Intermediate * Male [Description] => Forms * 18+ * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [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] => 30 [Sequence] => 30 ) Array ( [0] => 16457 [UserInfoId] => 16457 [1] => 132 [RankedSportEventId] => 132 [2] => 51 [sumUPts] => 51 [3] => 5 [cntUPts] => 5 [4] => 8187 [RankingDivisionDefinitionId] => 8187 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 30 [DivisionId] => 30 [8] => 132 [SportEventId] => 132 [9] => F-28 [DivisionName] => F-28 [10] => Forms * 18+ * Intermediate * Male [Description] => Forms * 18+ * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [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] => 30 [Sequence] => 30 ) BB[ 16457 ]) 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=80 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15007 [UserInfoId] => 15007 [1] => 213 [RankedSportEventId] => 213 [2] => 237 [sumUPts] => 237 [3] => 22 [cntUPts] => 22 [4] => 8237 [RankingDivisionDefinitionId] => 8237 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 80 [DivisionId] => 80 [8] => 213 [SportEventId] => 213 [9] => SD-9 [DivisionName] => SD-9 [10] => Self Defense * 18+ * Beg / Intr / Adv * Mixed [Description] => Self Defense * 18+ * Beg / Intr / Adv * Mixed [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] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 80 [Sequence] => 80 ) Array ( [0] => 17111 [UserInfoId] => 17111 [1] => 213 [RankedSportEventId] => 213 [2] => 51 [sumUPts] => 51 [3] => 7 [cntUPts] => 7 [4] => 8237 [RankingDivisionDefinitionId] => 8237 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 80 [DivisionId] => 80 [8] => 213 [SportEventId] => 213 [9] => SD-9 [DivisionName] => SD-9 [10] => Self Defense * 18+ * Beg / Intr / Adv * Mixed [Description] => Self Defense * 18+ * Beg / Intr / Adv * Mixed [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] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 80 [Sequence] => 80 ) Array ( [0] => 21230 [UserInfoId] => 21230 [1] => 213 [RankedSportEventId] => 213 [2] => 30 [sumUPts] => 30 [3] => 3 [cntUPts] => 3 [4] => 8237 [RankingDivisionDefinitionId] => 8237 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 80 [DivisionId] => 80 [8] => 213 [SportEventId] => 213 [9] => SD-9 [DivisionName] => SD-9 [10] => Self Defense * 18+ * Beg / Intr / Adv * Mixed [Description] => Self Defense * 18+ * Beg / Intr / Adv * Mixed [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] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 80 [Sequence] => 80 ) Array ( [0] => 20698 [UserInfoId] => 20698 [1] => 213 [RankedSportEventId] => 213 [2] => 27 [sumUPts] => 27 [3] => 3 [cntUPts] => 3 [4] => 8237 [RankingDivisionDefinitionId] => 8237 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 80 [DivisionId] => 80 [8] => 213 [SportEventId] => 213 [9] => SD-9 [DivisionName] => SD-9 [10] => Self Defense * 18+ * Beg / Intr / Adv * Mixed [Description] => Self Defense * 18+ * Beg / Intr / Adv * Mixed [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] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 80 [Sequence] => 80 ) Array ( [0] => 16457 [UserInfoId] => 16457 [1] => 213 [RankedSportEventId] => 213 [2] => 24 [sumUPts] => 24 [3] => 3 [cntUPts] => 3 [4] => 8237 [RankingDivisionDefinitionId] => 8237 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 80 [DivisionId] => 80 [8] => 213 [SportEventId] => 213 [9] => SD-9 [DivisionName] => SD-9 [10] => Self Defense * 18+ * Beg / Intr / Adv * Mixed [Description] => Self Defense * 18+ * Beg / Intr / Adv * Mixed [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] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 80 [Sequence] => 80 ) BB[ 16457 ]) 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=138 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 16457 [UserInfoId] => 16457 [1] => 110 [RankedSportEventId] => 110 [2] => 60 [sumUPts] => 60 [3] => 5 [cntUPts] => 5 [4] => 8295 [RankingDivisionDefinitionId] => 8295 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 138 [DivisionId] => 138 [8] => 110 [SportEventId] => 110 [9] => S-56 [DivisionName] => S-56 [10] => Sparring - Point * 18-34 * Intermediate * Male * Heavy (84.32+) [Description] => Sparring - Point * 18-34 * Intermediate * Male * Heavy (84.32+) [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => 34 [AgeHigh] => 34 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => 10 [WeightClass] => 10 [19] => 84.31999969482422 [WeightLow] => 84.31999969482422 [20] => -1 [WeightHigh] => -1 [21] => 138 [Sequence] => 138 ) Standings for Oreamuno, Bryan


Standings for:
Oreamuno, Bryan
Event & Description Skill Level Weight (lbs) Points # Events Rank
F-28 Forms
Male * 18+ yrs
Intermediate 5154
SD-9 Self Defense
Mixed * 18+ yrs
Beginner 2435
S-56 Sparring - Point
Male * 18 - 34 yrs
Intermediate15683.5199432+ 6051
Total135