BB[ 15248 ]) 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=11 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 20191 [UserInfoId] => 20191 [1] => 132 [RankedSportEventId] => 132 [2] => 144 [sumUPts] => 144 [3] => 16 [cntUPts] => 16 [4] => 8168 [RankingDivisionDefinitionId] => 8168 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 11 [DivisionId] => 11 [8] => 132 [SportEventId] => 132 [9] => F-9 [DivisionName] => F-9 [10] => Forms * 10-11 * Intermediate * Mixed [Description] => Forms * 10-11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [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] => 11 [Sequence] => 11 ) Array ( [0] => 15248 [UserInfoId] => 15248 [1] => 132 [RankedSportEventId] => 132 [2] => 72 [sumUPts] => 72 [3] => 6 [cntUPts] => 6 [4] => 8168 [RankingDivisionDefinitionId] => 8168 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 11 [DivisionId] => 11 [8] => 132 [SportEventId] => 132 [9] => F-9 [DivisionName] => F-9 [10] => Forms * 10-11 * Intermediate * Mixed [Description] => Forms * 10-11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [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] => 11 [Sequence] => 11 ) BB[ 15248 ]) 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=15 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15008 [UserInfoId] => 15008 [1] => 132 [RankedSportEventId] => 132 [2] => 82 [sumUPts] => 82 [3] => 10 [cntUPts] => 10 [4] => 8172 [RankingDivisionDefinitionId] => 8172 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 15 [DivisionId] => 15 [8] => 132 [SportEventId] => 132 [9] => F-13 [DivisionName] => F-13 [10] => Forms * 12-13 * Intermediate * Mixed [Description] => Forms * 12-13 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 15 [Sequence] => 15 ) Array ( [0] => 15248 [UserInfoId] => 15248 [1] => 132 [RankedSportEventId] => 132 [2] => 73 [sumUPts] => 73 [3] => 9 [cntUPts] => 9 [4] => 8172 [RankingDivisionDefinitionId] => 8172 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 15 [DivisionId] => 15 [8] => 132 [SportEventId] => 132 [9] => F-13 [DivisionName] => F-13 [10] => Forms * 12-13 * Intermediate * Mixed [Description] => Forms * 12-13 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 15 [Sequence] => 15 ) BB[ 15248 ]) 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=39 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19673 [UserInfoId] => 19673 [1] => 277 [RankedSportEventId] => 277 [2] => 69 [sumUPts] => 69 [3] => 7 [cntUPts] => 7 [4] => 8196 [RankingDivisionDefinitionId] => 8196 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 39 [DivisionId] => 39 [8] => 277 [SportEventId] => 277 [9] => M-2 [DivisionName] => M-2 [10] => Forms - Specialty * <= 11 * Intermediate * Mixed [Description] => Forms - Specialty * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 39 [Sequence] => 39 ) Array ( [0] => 19749 [UserInfoId] => 19749 [1] => 277 [RankedSportEventId] => 277 [2] => 52 [sumUPts] => 52 [3] => 6 [cntUPts] => 6 [4] => 8196 [RankingDivisionDefinitionId] => 8196 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 39 [DivisionId] => 39 [8] => 277 [SportEventId] => 277 [9] => M-2 [DivisionName] => M-2 [10] => Forms - Specialty * <= 11 * Intermediate * Mixed [Description] => Forms - Specialty * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 39 [Sequence] => 39 ) Array ( [0] => 15248 [UserInfoId] => 15248 [1] => 277 [RankedSportEventId] => 277 [2] => 42 [sumUPts] => 42 [3] => 4 [cntUPts] => 4 [4] => 8196 [RankingDivisionDefinitionId] => 8196 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 39 [DivisionId] => 39 [8] => 277 [SportEventId] => 277 [9] => M-2 [DivisionName] => M-2 [10] => Forms - Specialty * <= 11 * Intermediate * Mixed [Description] => Forms - Specialty * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 39 [Sequence] => 39 ) BB[ 15248 ]) 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=43 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15008 [UserInfoId] => 15008 [1] => 277 [RankedSportEventId] => 277 [2] => 105 [sumUPts] => 105 [3] => 17 [cntUPts] => 17 [4] => 8200 [RankingDivisionDefinitionId] => 8200 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 43 [DivisionId] => 43 [8] => 277 [SportEventId] => 277 [9] => M-6 [DivisionName] => M-6 [10] => Forms - Specialty * 12-17 * Intermediate * Mixed [Description] => Forms - Specialty * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [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] => 43 [Sequence] => 43 ) Array ( [0] => 15248 [UserInfoId] => 15248 [1] => 277 [RankedSportEventId] => 277 [2] => 67 [sumUPts] => 67 [3] => 8 [cntUPts] => 8 [4] => 8200 [RankingDivisionDefinitionId] => 8200 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 43 [DivisionId] => 43 [8] => 277 [SportEventId] => 277 [9] => M-6 [DivisionName] => M-6 [10] => Forms - Specialty * 12-17 * Intermediate * Mixed [Description] => Forms - Specialty * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [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] => 43 [Sequence] => 43 ) BB[ 15248 ]) 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=52 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15434 [UserInfoId] => 15434 [1] => 340 [RankedSportEventId] => 340 [2] => 70 [sumUPts] => 70 [3] => 8 [cntUPts] => 8 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 19942 [UserInfoId] => 19942 [1] => 340 [RankedSportEventId] => 340 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 13753 [UserInfoId] => 13753 [1] => 340 [RankedSportEventId] => 340 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 15972 [UserInfoId] => 15972 [1] => 340 [RankedSportEventId] => 340 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 16165 [UserInfoId] => 16165 [1] => 340 [RankedSportEventId] => 340 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 20191 [UserInfoId] => 20191 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 21673 [UserInfoId] => 21673 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 13786 [UserInfoId] => 13786 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 19945 [UserInfoId] => 19945 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) Array ( [0] => 15248 [UserInfoId] => 15248 [1] => 340 [RankedSportEventId] => 340 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8209 [RankingDivisionDefinitionId] => 8209 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 340 [SportEventId] => 340 [9] => FH-2 [DivisionName] => FH-2 [10] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * <= 11 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 52 [Sequence] => 52 ) BB[ 15248 ]) 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=55 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15008 [UserInfoId] => 15008 [1] => 340 [RankedSportEventId] => 340 [2] => 109 [sumUPts] => 109 [3] => 16 [cntUPts] => 16 [4] => 8212 [RankingDivisionDefinitionId] => 8212 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 55 [DivisionId] => 55 [8] => 340 [SportEventId] => 340 [9] => FH-5 [DivisionName] => FH-5 [10] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [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] => 55 [Sequence] => 55 ) Array ( [0] => 15248 [UserInfoId] => 15248 [1] => 340 [RankedSportEventId] => 340 [2] => 80 [sumUPts] => 80 [3] => 9 [cntUPts] => 9 [4] => 8212 [RankingDivisionDefinitionId] => 8212 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 55 [DivisionId] => 55 [8] => 340 [SportEventId] => 340 [9] => FH-5 [DivisionName] => FH-5 [10] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * 12-17 * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 12 [AgeLow] => 12 [14] => 17 [AgeHigh] => 17 [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] => 55 [Sequence] => 55 ) BB[ 15248 ]) 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=114 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 20191 [UserInfoId] => 20191 [1] => 110 [RankedSportEventId] => 110 [2] => 175 [sumUPts] => 175 [3] => 18 [cntUPts] => 18 [4] => 8271 [RankingDivisionDefinitionId] => 8271 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 114 [DivisionId] => 114 [8] => 110 [SportEventId] => 110 [9] => S-32 [DivisionName] => S-32 [10] => Sparring - Point * 10-11 * Intermediate * Male [Description] => Sparring - Point * 10-11 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [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] => 114 [Sequence] => 114 ) Array ( [0] => 15167 [UserInfoId] => 15167 [1] => 110 [RankedSportEventId] => 110 [2] => 45 [sumUPts] => 45 [3] => 5 [cntUPts] => 5 [4] => 8271 [RankingDivisionDefinitionId] => 8271 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 114 [DivisionId] => 114 [8] => 110 [SportEventId] => 110 [9] => S-32 [DivisionName] => S-32 [10] => Sparring - Point * 10-11 * Intermediate * Male [Description] => Sparring - Point * 10-11 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [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] => 114 [Sequence] => 114 ) Array ( [0] => 15033 [UserInfoId] => 15033 [1] => 110 [RankedSportEventId] => 110 [2] => 45 [sumUPts] => 45 [3] => 7 [cntUPts] => 7 [4] => 8271 [RankingDivisionDefinitionId] => 8271 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 114 [DivisionId] => 114 [8] => 110 [SportEventId] => 110 [9] => S-32 [DivisionName] => S-32 [10] => Sparring - Point * 10-11 * Intermediate * Male [Description] => Sparring - Point * 10-11 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [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] => 114 [Sequence] => 114 ) Array ( [0] => 17580 [UserInfoId] => 17580 [1] => 110 [RankedSportEventId] => 110 [2] => 42 [sumUPts] => 42 [3] => 5 [cntUPts] => 5 [4] => 8271 [RankingDivisionDefinitionId] => 8271 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 114 [DivisionId] => 114 [8] => 110 [SportEventId] => 110 [9] => S-32 [DivisionName] => S-32 [10] => Sparring - Point * 10-11 * Intermediate * Male [Description] => Sparring - Point * 10-11 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [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] => 114 [Sequence] => 114 ) Array ( [0] => 15248 [UserInfoId] => 15248 [1] => 110 [RankedSportEventId] => 110 [2] => 36 [sumUPts] => 36 [3] => 4 [cntUPts] => 4 [4] => 8271 [RankingDivisionDefinitionId] => 8271 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 114 [DivisionId] => 114 [8] => 110 [SportEventId] => 110 [9] => S-32 [DivisionName] => S-32 [10] => Sparring - Point * 10-11 * Intermediate * Male [Description] => Sparring - Point * 10-11 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 10 [AgeLow] => 10 [14] => 11 [AgeHigh] => 11 [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] => 114 [Sequence] => 114 ) BB[ 15248 ]) 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=118 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15248 [UserInfoId] => 15248 [1] => 110 [RankedSportEventId] => 110 [2] => 74 [sumUPts] => 74 [3] => 8 [cntUPts] => 8 [4] => 8275 [RankingDivisionDefinitionId] => 8275 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 118 [DivisionId] => 118 [8] => 110 [SportEventId] => 110 [9] => S-36 [DivisionName] => S-36 [10] => Sparring - Point * 12-13 * Intermediate * Male [Description] => Sparring - Point * 12-13 * Intermediate * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 12 [AgeLow] => 12 [14] => 13 [AgeHigh] => 13 [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] => 118 [Sequence] => 118 ) Standings for Sampson, David Paul


Standings for:
Sampson, David Paul
Event & Description Skill Level Weight (lbs) Points # Events Rank
F-9 Forms
Mixed * 10 - 11 yrs
Intermediate 7262
F-13 Forms
Mixed * 12 - 13 yrs
Intermediate 7392
M-2 Forms - Specialty
Mixed * ≤ 11 yrs
Intermediate 4243
M-6 Forms - Specialty
Mixed * 12 - 17 yrs
Intermediate 6782
FH-2 Forms - Traditional Hard Style
Mixed * ≤ 11 yrs
Intermediate 12110
FH-5 Forms - Traditional Hard Style
Mixed * 12 - 17 yrs
Intermediate 8092
S-32 Sparring - Point
Male * 10 - 11 yrs
Intermediate 3645
S-36 Sparring - Point
Male * 12 - 13 yrs
Intermediate 7481
Total456