BB[ 15651 ]) 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=9 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15514 [UserInfoId] => 15514 [1] => 132 [RankedSportEventId] => 132 [2] => 66 [sumUPts] => 66 [3] => 8 [cntUPts] => 8 [4] => 8166 [RankingDivisionDefinitionId] => 8166 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 9 [DivisionId] => 9 [8] => 132 [SportEventId] => 132 [9] => F-7 [DivisionName] => F-7 [10] => Forms * 8-9 * Adv / BB * Mixed [Description] => Forms * 8-9 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 9 [Sequence] => 9 ) Array ( [0] => 14797 [UserInfoId] => 14797 [1] => 132 [RankedSportEventId] => 132 [2] => 47 [sumUPts] => 47 [3] => 5 [cntUPts] => 5 [4] => 8166 [RankingDivisionDefinitionId] => 8166 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 9 [DivisionId] => 9 [8] => 132 [SportEventId] => 132 [9] => F-7 [DivisionName] => F-7 [10] => Forms * 8-9 * Adv / BB * Mixed [Description] => Forms * 8-9 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 9 [Sequence] => 9 ) Array ( [0] => 13368 [UserInfoId] => 13368 [1] => 132 [RankedSportEventId] => 132 [2] => 42 [sumUPts] => 42 [3] => 4 [cntUPts] => 4 [4] => 8166 [RankingDivisionDefinitionId] => 8166 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 9 [DivisionId] => 9 [8] => 132 [SportEventId] => 132 [9] => F-7 [DivisionName] => F-7 [10] => Forms * 8-9 * Adv / BB * Mixed [Description] => Forms * 8-9 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 9 [Sequence] => 9 ) Array ( [0] => 13478 [UserInfoId] => 13478 [1] => 132 [RankedSportEventId] => 132 [2] => 39 [sumUPts] => 39 [3] => 4 [cntUPts] => 4 [4] => 8166 [RankingDivisionDefinitionId] => 8166 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 9 [DivisionId] => 9 [8] => 132 [SportEventId] => 132 [9] => F-7 [DivisionName] => F-7 [10] => Forms * 8-9 * Adv / BB * Mixed [Description] => Forms * 8-9 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 9 [Sequence] => 9 ) Array ( [0] => 19118 [UserInfoId] => 19118 [1] => 132 [RankedSportEventId] => 132 [2] => 39 [sumUPts] => 39 [3] => 4 [cntUPts] => 4 [4] => 8166 [RankingDivisionDefinitionId] => 8166 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 9 [DivisionId] => 9 [8] => 132 [SportEventId] => 132 [9] => F-7 [DivisionName] => F-7 [10] => Forms * 8-9 * Adv / BB * Mixed [Description] => Forms * 8-9 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 9 [Sequence] => 9 ) Array ( [0] => 15692 [UserInfoId] => 15692 [1] => 132 [RankedSportEventId] => 132 [2] => 30 [sumUPts] => 30 [3] => 3 [cntUPts] => 3 [4] => 8166 [RankingDivisionDefinitionId] => 8166 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 9 [DivisionId] => 9 [8] => 132 [SportEventId] => 132 [9] => F-7 [DivisionName] => F-7 [10] => Forms * 8-9 * Adv / BB * Mixed [Description] => Forms * 8-9 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 9 [Sequence] => 9 ) Array ( [0] => 15746 [UserInfoId] => 15746 [1] => 132 [RankedSportEventId] => 132 [2] => 30 [sumUPts] => 30 [3] => 3 [cntUPts] => 3 [4] => 8166 [RankingDivisionDefinitionId] => 8166 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 9 [DivisionId] => 9 [8] => 132 [SportEventId] => 132 [9] => F-7 [DivisionName] => F-7 [10] => Forms * 8-9 * Adv / BB * Mixed [Description] => Forms * 8-9 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 9 [Sequence] => 9 ) Array ( [0] => 19758 [UserInfoId] => 19758 [1] => 132 [RankedSportEventId] => 132 [2] => 25 [sumUPts] => 25 [3] => 3 [cntUPts] => 3 [4] => 8166 [RankingDivisionDefinitionId] => 8166 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 9 [DivisionId] => 9 [8] => 132 [SportEventId] => 132 [9] => F-7 [DivisionName] => F-7 [10] => Forms * 8-9 * Adv / BB * Mixed [Description] => Forms * 8-9 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 9 [Sequence] => 9 ) Array ( [0] => 17563 [UserInfoId] => 17563 [1] => 132 [RankedSportEventId] => 132 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8166 [RankingDivisionDefinitionId] => 8166 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 9 [DivisionId] => 9 [8] => 132 [SportEventId] => 132 [9] => F-7 [DivisionName] => F-7 [10] => Forms * 8-9 * Adv / BB * Mixed [Description] => Forms * 8-9 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 9 [Sequence] => 9 ) Array ( [0] => 16755 [UserInfoId] => 16755 [1] => 132 [RankedSportEventId] => 132 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8166 [RankingDivisionDefinitionId] => 8166 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 9 [DivisionId] => 9 [8] => 132 [SportEventId] => 132 [9] => F-7 [DivisionName] => F-7 [10] => Forms * 8-9 * Adv / BB * Mixed [Description] => Forms * 8-9 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 9 [Sequence] => 9 ) Array ( [0] => 19718 [UserInfoId] => 19718 [1] => 132 [RankedSportEventId] => 132 [2] => 14 [sumUPts] => 14 [3] => 3 [cntUPts] => 3 [4] => 8166 [RankingDivisionDefinitionId] => 8166 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 9 [DivisionId] => 9 [8] => 132 [SportEventId] => 132 [9] => F-7 [DivisionName] => F-7 [10] => Forms * 8-9 * Adv / BB * Mixed [Description] => Forms * 8-9 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 9 [Sequence] => 9 ) Array ( [0] => 15326 [UserInfoId] => 15326 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8166 [RankingDivisionDefinitionId] => 8166 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 9 [DivisionId] => 9 [8] => 132 [SportEventId] => 132 [9] => F-7 [DivisionName] => F-7 [10] => Forms * 8-9 * Adv / BB * Mixed [Description] => Forms * 8-9 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 9 [Sequence] => 9 ) Array ( [0] => 21303 [UserInfoId] => 21303 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8166 [RankingDivisionDefinitionId] => 8166 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 9 [DivisionId] => 9 [8] => 132 [SportEventId] => 132 [9] => F-7 [DivisionName] => F-7 [10] => Forms * 8-9 * Adv / BB * Mixed [Description] => Forms * 8-9 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 9 [Sequence] => 9 ) Array ( [0] => 18499 [UserInfoId] => 18499 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8166 [RankingDivisionDefinitionId] => 8166 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 9 [DivisionId] => 9 [8] => 132 [SportEventId] => 132 [9] => F-7 [DivisionName] => F-7 [10] => Forms * 8-9 * Adv / BB * Mixed [Description] => Forms * 8-9 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 9 [Sequence] => 9 ) Array ( [0] => 20039 [UserInfoId] => 20039 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8166 [RankingDivisionDefinitionId] => 8166 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 9 [DivisionId] => 9 [8] => 132 [SportEventId] => 132 [9] => F-7 [DivisionName] => F-7 [10] => Forms * 8-9 * Adv / BB * Mixed [Description] => Forms * 8-9 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 9 [Sequence] => 9 ) Array ( [0] => 15651 [UserInfoId] => 15651 [1] => 132 [RankedSportEventId] => 132 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8166 [RankingDivisionDefinitionId] => 8166 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 9 [DivisionId] => 9 [8] => 132 [SportEventId] => 132 [9] => F-7 [DivisionName] => F-7 [10] => Forms * 8-9 * Adv / BB * Mixed [Description] => Forms * 8-9 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 0 [BeltRankClass] => 0 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 9 [Sequence] => 9 ) BB[ 15651 ]) 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=12 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 13716 [UserInfoId] => 13716 [1] => 132 [RankedSportEventId] => 132 [2] => 69 [sumUPts] => 69 [3] => 8 [cntUPts] => 8 [4] => 8169 [RankingDivisionDefinitionId] => 8169 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 12 [DivisionId] => 12 [8] => 132 [SportEventId] => 132 [9] => F-10 [DivisionName] => F-10 [10] => Forms * 10-11 * Advanced * Mixed [Description] => Forms * 10-11 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 12 [Sequence] => 12 ) Array ( [0] => 15651 [UserInfoId] => 15651 [1] => 132 [RankedSportEventId] => 132 [2] => 60 [sumUPts] => 60 [3] => 5 [cntUPts] => 5 [4] => 8169 [RankingDivisionDefinitionId] => 8169 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 12 [DivisionId] => 12 [8] => 132 [SportEventId] => 132 [9] => F-10 [DivisionName] => F-10 [10] => Forms * 10-11 * Advanced * Mixed [Description] => Forms * 10-11 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 12 [Sequence] => 12 ) BB[ 15651 ]) 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=40 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15514 [UserInfoId] => 15514 [1] => 277 [RankedSportEventId] => 277 [2] => 84 [sumUPts] => 84 [3] => 9 [cntUPts] => 9 [4] => 8197 [RankingDivisionDefinitionId] => 8197 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 40 [DivisionId] => 40 [8] => 277 [SportEventId] => 277 [9] => M-3 [DivisionName] => M-3 [10] => Forms - Specialty * <= 11 * Advanced * Mixed [Description] => Forms - Specialty * <= 11 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 40 [Sequence] => 40 ) Array ( [0] => 15651 [UserInfoId] => 15651 [1] => 277 [RankedSportEventId] => 277 [2] => 60 [sumUPts] => 60 [3] => 5 [cntUPts] => 5 [4] => 8197 [RankingDivisionDefinitionId] => 8197 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 40 [DivisionId] => 40 [8] => 277 [SportEventId] => 277 [9] => M-3 [DivisionName] => M-3 [10] => Forms - Specialty * <= 11 * Advanced * Mixed [Description] => Forms - Specialty * <= 11 * Advanced * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 27 [BeltRankHigh] => 27 [17] => 1228 [BeltRankClass] => 1228 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 40 [Sequence] => 40 ) BB[ 15651 ]) 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=53 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15651 [UserInfoId] => 15651 [1] => 340 [RankedSportEventId] => 340 [2] => 54 [sumUPts] => 54 [3] => 5 [cntUPts] => 5 [4] => 8210 [RankingDivisionDefinitionId] => 8210 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 53 [DivisionId] => 53 [8] => 340 [SportEventId] => 340 [9] => FH-3 [DivisionName] => FH-3 [10] => Forms - Traditional Hard Style * <= 11 * Adv / BB * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Adv / BB * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 53 [Sequence] => 53 ) BB[ 15651 ]) 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=112 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 14797 [UserInfoId] => 14797 [1] => 110 [RankedSportEventId] => 110 [2] => 56 [sumUPts] => 56 [3] => 5 [cntUPts] => 5 [4] => 8269 [RankingDivisionDefinitionId] => 8269 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 112 [DivisionId] => 112 [8] => 110 [SportEventId] => 110 [9] => S-30 [DivisionName] => S-30 [10] => Sparring - Point * 8-9 * Adv / BB * Male [Description] => Sparring - Point * 8-9 * Adv / BB * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 112 [Sequence] => 112 ) Array ( [0] => 19842 [UserInfoId] => 19842 [1] => 110 [RankedSportEventId] => 110 [2] => 30 [sumUPts] => 30 [3] => 3 [cntUPts] => 3 [4] => 8269 [RankingDivisionDefinitionId] => 8269 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 112 [DivisionId] => 112 [8] => 110 [SportEventId] => 110 [9] => S-30 [DivisionName] => S-30 [10] => Sparring - Point * 8-9 * Adv / BB * Male [Description] => Sparring - Point * 8-9 * Adv / BB * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 112 [Sequence] => 112 ) Array ( [0] => 15746 [UserInfoId] => 15746 [1] => 110 [RankedSportEventId] => 110 [2] => 30 [sumUPts] => 30 [3] => 3 [cntUPts] => 3 [4] => 8269 [RankingDivisionDefinitionId] => 8269 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 112 [DivisionId] => 112 [8] => 110 [SportEventId] => 110 [9] => S-30 [DivisionName] => S-30 [10] => Sparring - Point * 8-9 * Adv / BB * Male [Description] => Sparring - Point * 8-9 * Adv / BB * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 112 [Sequence] => 112 ) Array ( [0] => 19758 [UserInfoId] => 19758 [1] => 110 [RankedSportEventId] => 110 [2] => 28 [sumUPts] => 28 [3] => 3 [cntUPts] => 3 [4] => 8269 [RankingDivisionDefinitionId] => 8269 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 112 [DivisionId] => 112 [8] => 110 [SportEventId] => 110 [9] => S-30 [DivisionName] => S-30 [10] => Sparring - Point * 8-9 * Adv / BB * Male [Description] => Sparring - Point * 8-9 * Adv / BB * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 112 [Sequence] => 112 ) Array ( [0] => 16111 [UserInfoId] => 16111 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8269 [RankingDivisionDefinitionId] => 8269 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 112 [DivisionId] => 112 [8] => 110 [SportEventId] => 110 [9] => S-30 [DivisionName] => S-30 [10] => Sparring - Point * 8-9 * Adv / BB * Male [Description] => Sparring - Point * 8-9 * Adv / BB * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 112 [Sequence] => 112 ) Array ( [0] => 21303 [UserInfoId] => 21303 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8269 [RankingDivisionDefinitionId] => 8269 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 112 [DivisionId] => 112 [8] => 110 [SportEventId] => 110 [9] => S-30 [DivisionName] => S-30 [10] => Sparring - Point * 8-9 * Adv / BB * Male [Description] => Sparring - Point * 8-9 * Adv / BB * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 112 [Sequence] => 112 ) Array ( [0] => 18499 [UserInfoId] => 18499 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8269 [RankingDivisionDefinitionId] => 8269 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 112 [DivisionId] => 112 [8] => 110 [SportEventId] => 110 [9] => S-30 [DivisionName] => S-30 [10] => Sparring - Point * 8-9 * Adv / BB * Male [Description] => Sparring - Point * 8-9 * Adv / BB * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 112 [Sequence] => 112 ) Array ( [0] => 20027 [UserInfoId] => 20027 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8269 [RankingDivisionDefinitionId] => 8269 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 112 [DivisionId] => 112 [8] => 110 [SportEventId] => 110 [9] => S-30 [DivisionName] => S-30 [10] => Sparring - Point * 8-9 * Adv / BB * Male [Description] => Sparring - Point * 8-9 * Adv / BB * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 112 [Sequence] => 112 ) Array ( [0] => 13502 [UserInfoId] => 13502 [1] => 110 [RankedSportEventId] => 110 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8269 [RankingDivisionDefinitionId] => 8269 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 112 [DivisionId] => 112 [8] => 110 [SportEventId] => 110 [9] => S-30 [DivisionName] => S-30 [10] => Sparring - Point * 8-9 * Adv / BB * Male [Description] => Sparring - Point * 8-9 * Adv / BB * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 112 [Sequence] => 112 ) Array ( [0] => 15400 [UserInfoId] => 15400 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8269 [RankingDivisionDefinitionId] => 8269 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 112 [DivisionId] => 112 [8] => 110 [SportEventId] => 110 [9] => S-30 [DivisionName] => S-30 [10] => Sparring - Point * 8-9 * Adv / BB * Male [Description] => Sparring - Point * 8-9 * Adv / BB * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 112 [Sequence] => 112 ) Array ( [0] => 18628 [UserInfoId] => 18628 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8269 [RankingDivisionDefinitionId] => 8269 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 112 [DivisionId] => 112 [8] => 110 [SportEventId] => 110 [9] => S-30 [DivisionName] => S-30 [10] => Sparring - Point * 8-9 * Adv / BB * Male [Description] => Sparring - Point * 8-9 * Adv / BB * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 112 [Sequence] => 112 ) Array ( [0] => 19866 [UserInfoId] => 19866 [1] => 110 [RankedSportEventId] => 110 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8269 [RankingDivisionDefinitionId] => 8269 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 112 [DivisionId] => 112 [8] => 110 [SportEventId] => 110 [9] => S-30 [DivisionName] => S-30 [10] => Sparring - Point * 8-9 * Adv / BB * Male [Description] => Sparring - Point * 8-9 * Adv / BB * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 112 [Sequence] => 112 ) Array ( [0] => 20742 [UserInfoId] => 20742 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8269 [RankingDivisionDefinitionId] => 8269 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 112 [DivisionId] => 112 [8] => 110 [SportEventId] => 110 [9] => S-30 [DivisionName] => S-30 [10] => Sparring - Point * 8-9 * Adv / BB * Male [Description] => Sparring - Point * 8-9 * Adv / BB * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 112 [Sequence] => 112 ) Array ( [0] => 21476 [UserInfoId] => 21476 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8269 [RankingDivisionDefinitionId] => 8269 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 112 [DivisionId] => 112 [8] => 110 [SportEventId] => 110 [9] => S-30 [DivisionName] => S-30 [10] => Sparring - Point * 8-9 * Adv / BB * Male [Description] => Sparring - Point * 8-9 * Adv / BB * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 112 [Sequence] => 112 ) Array ( [0] => 15478 [UserInfoId] => 15478 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8269 [RankingDivisionDefinitionId] => 8269 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 112 [DivisionId] => 112 [8] => 110 [SportEventId] => 110 [9] => S-30 [DivisionName] => S-30 [10] => Sparring - Point * 8-9 * Adv / BB * Male [Description] => Sparring - Point * 8-9 * Adv / BB * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 112 [Sequence] => 112 ) Array ( [0] => 18022 [UserInfoId] => 18022 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8269 [RankingDivisionDefinitionId] => 8269 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 112 [DivisionId] => 112 [8] => 110 [SportEventId] => 110 [9] => S-30 [DivisionName] => S-30 [10] => Sparring - Point * 8-9 * Adv / BB * Male [Description] => Sparring - Point * 8-9 * Adv / BB * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 112 [Sequence] => 112 ) Array ( [0] => 15651 [UserInfoId] => 15651 [1] => 110 [RankedSportEventId] => 110 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8269 [RankingDivisionDefinitionId] => 8269 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 112 [DivisionId] => 112 [8] => 110 [SportEventId] => 110 [9] => S-30 [DivisionName] => S-30 [10] => Sparring - Point * 8-9 * Adv / BB * Male [Description] => Sparring - Point * 8-9 * Adv / BB * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 8 [AgeLow] => 8 [14] => 9 [AgeHigh] => 9 [15] => 24 [BeltRankLow] => 24 [16] => 28 [BeltRankHigh] => 28 [17] => 1232 [BeltRankClass] => 1232 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 112 [Sequence] => 112 ) Standings for Argumaniz, Isaiah Michael


Standings for:
Argumaniz, Isaiah Michael
Event & Description Skill Level Weight (lbs) Points # Events Rank
F-7 Forms
Mixed * 8 - 9 yrs
Advanced 12116
F-10 Forms
Mixed * 10 - 11 yrs
Advanced 6052
M-3 Forms - Specialty
Mixed * ≤ 11 yrs
Advanced 6052
FH-3 Forms - Traditional Hard Style
Mixed * ≤ 11 yrs
Advanced 5451
S-30 Sparring - Point
Male * 8 - 9 yrs
Advanced 6117
Total192