BB[ 20059 ]) 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=156 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15062 [UserInfoId] => 15062 [1] => 299 [RankedSportEventId] => 299 [2] => 131 [sumUPts] => 131 [3] => 16 [cntUPts] => 16 [4] => 8313 [RankingDivisionDefinitionId] => 8313 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 156 [DivisionId] => 156 [8] => 299 [SportEventId] => 299 [9] => B-1 [DivisionName] => B-1 [10] => Breaking - Power Wood - Hand/Elbow * <= 11 * Beg / Intr / Adv [Description] => Breaking - Power Wood - Hand/Elbow * <= 11 * Beg / Intr / Adv [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 156 [Sequence] => 156 ) Array ( [0] => 19237 [UserInfoId] => 19237 [1] => 299 [RankedSportEventId] => 299 [2] => 115 [sumUPts] => 115 [3] => 11 [cntUPts] => 11 [4] => 8313 [RankingDivisionDefinitionId] => 8313 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 156 [DivisionId] => 156 [8] => 299 [SportEventId] => 299 [9] => B-1 [DivisionName] => B-1 [10] => Breaking - Power Wood - Hand/Elbow * <= 11 * Beg / Intr / Adv [Description] => Breaking - Power Wood - Hand/Elbow * <= 11 * Beg / Intr / Adv [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 156 [Sequence] => 156 ) Array ( [0] => 16929 [UserInfoId] => 16929 [1] => 299 [RankedSportEventId] => 299 [2] => 111 [sumUPts] => 111 [3] => 10 [cntUPts] => 10 [4] => 8313 [RankingDivisionDefinitionId] => 8313 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 156 [DivisionId] => 156 [8] => 299 [SportEventId] => 299 [9] => B-1 [DivisionName] => B-1 [10] => Breaking - Power Wood - Hand/Elbow * <= 11 * Beg / Intr / Adv [Description] => Breaking - Power Wood - Hand/Elbow * <= 11 * Beg / Intr / Adv [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 156 [Sequence] => 156 ) Array ( [0] => 15453 [UserInfoId] => 15453 [1] => 299 [RankedSportEventId] => 299 [2] => 110 [sumUPts] => 110 [3] => 10 [cntUPts] => 10 [4] => 8313 [RankingDivisionDefinitionId] => 8313 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 156 [DivisionId] => 156 [8] => 299 [SportEventId] => 299 [9] => B-1 [DivisionName] => B-1 [10] => Breaking - Power Wood - Hand/Elbow * <= 11 * Beg / Intr / Adv [Description] => Breaking - Power Wood - Hand/Elbow * <= 11 * Beg / Intr / Adv [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 156 [Sequence] => 156 ) Array ( [0] => 20191 [UserInfoId] => 20191 [1] => 299 [RankedSportEventId] => 299 [2] => 108 [sumUPts] => 108 [3] => 13 [cntUPts] => 13 [4] => 8313 [RankingDivisionDefinitionId] => 8313 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 156 [DivisionId] => 156 [8] => 299 [SportEventId] => 299 [9] => B-1 [DivisionName] => B-1 [10] => Breaking - Power Wood - Hand/Elbow * <= 11 * Beg / Intr / Adv [Description] => Breaking - Power Wood - Hand/Elbow * <= 11 * Beg / Intr / Adv [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 156 [Sequence] => 156 ) Array ( [0] => 20059 [UserInfoId] => 20059 [1] => 299 [RankedSportEventId] => 299 [2] => 96 [sumUPts] => 96 [3] => 9 [cntUPts] => 9 [4] => 8313 [RankingDivisionDefinitionId] => 8313 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 156 [DivisionId] => 156 [8] => 299 [SportEventId] => 299 [9] => B-1 [DivisionName] => B-1 [10] => Breaking - Power Wood - Hand/Elbow * <= 11 * Beg / Intr / Adv [Description] => Breaking - Power Wood - Hand/Elbow * <= 11 * Beg / Intr / Adv [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [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] => 156 [Sequence] => 156 ) BB[ 20059 ]) 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=163 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 20059 [UserInfoId] => 20059 [1] => 299 [RankedSportEventId] => 299 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8320 [RankingDivisionDefinitionId] => 8320 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 163 [DivisionId] => 163 [8] => 95 [SportEventId] => 95 [9] => BC-8 [DivisionName] => BC-8 [10] => Breaking - Creative Open * <= 17 * Beg / Intr / Adv * Mixed [Description] => Breaking - Creative Open * <= 17 * Beg / Intr / Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 17 [AgeHigh] => 17 [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] => 163 [Sequence] => 163 ) BB[ 20059 ]) 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=3 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19776 [UserInfoId] => 19776 [1] => 132 [RankedSportEventId] => 132 [2] => 60 [sumUPts] => 60 [3] => 6 [cntUPts] => 6 [4] => 8160 [RankingDivisionDefinitionId] => 8160 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 3 [DivisionId] => 3 [8] => 132 [SportEventId] => 132 [9] => F-1 [DivisionName] => F-1 [10] => Forms * <= 5 * Mixed [Description] => Forms * <= 5 * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 5 [AgeHigh] => 5 [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] => 3 [Sequence] => 3 ) Array ( [0] => 20059 [UserInfoId] => 20059 [1] => 132 [RankedSportEventId] => 132 [2] => 57 [sumUPts] => 57 [3] => 8 [cntUPts] => 8 [4] => 8160 [RankingDivisionDefinitionId] => 8160 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 3 [DivisionId] => 3 [8] => 132 [SportEventId] => 132 [9] => F-1 [DivisionName] => F-1 [10] => Forms * <= 5 * Mixed [Description] => Forms * <= 5 * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 5 [AgeHigh] => 5 [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] => 3 [Sequence] => 3 ) BB[ 20059 ]) 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=38 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19859 [UserInfoId] => 19859 [1] => 277 [RankedSportEventId] => 277 [2] => 78 [sumUPts] => 78 [3] => 8 [cntUPts] => 8 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 19839 [UserInfoId] => 19839 [1] => 277 [RankedSportEventId] => 277 [2] => 48 [sumUPts] => 48 [3] => 5 [cntUPts] => 5 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 14987 [UserInfoId] => 14987 [1] => 277 [RankedSportEventId] => 277 [2] => 32 [sumUPts] => 32 [3] => 3 [cntUPts] => 3 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 20816 [UserInfoId] => 20816 [1] => 277 [RankedSportEventId] => 277 [2] => 24 [sumUPts] => 24 [3] => 3 [cntUPts] => 3 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 19795 [UserInfoId] => 19795 [1] => 277 [RankedSportEventId] => 277 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 20797 [UserInfoId] => 20797 [1] => 277 [RankedSportEventId] => 277 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 20182 [UserInfoId] => 20182 [1] => 277 [RankedSportEventId] => 277 [2] => 21 [sumUPts] => 21 [3] => 2 [cntUPts] => 2 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 21010 [UserInfoId] => 21010 [1] => 277 [RankedSportEventId] => 277 [2] => 21 [sumUPts] => 21 [3] => 3 [cntUPts] => 3 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 20591 [UserInfoId] => 20591 [1] => 277 [RankedSportEventId] => 277 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 20382 [UserInfoId] => 20382 [1] => 277 [RankedSportEventId] => 277 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 15471 [UserInfoId] => 15471 [1] => 277 [RankedSportEventId] => 277 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 22073 [UserInfoId] => 22073 [1] => 277 [RankedSportEventId] => 277 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 19518 [UserInfoId] => 19518 [1] => 277 [RankedSportEventId] => 277 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 20666 [UserInfoId] => 20666 [1] => 277 [RankedSportEventId] => 277 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 15862 [UserInfoId] => 15862 [1] => 277 [RankedSportEventId] => 277 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 19906 [UserInfoId] => 19906 [1] => 277 [RankedSportEventId] => 277 [2] => 10 [sumUPts] => 10 [3] => 2 [cntUPts] => 2 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 21671 [UserInfoId] => 21671 [1] => 277 [RankedSportEventId] => 277 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 19691 [UserInfoId] => 19691 [1] => 277 [RankedSportEventId] => 277 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 16416 [UserInfoId] => 16416 [1] => 277 [RankedSportEventId] => 277 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 19687 [UserInfoId] => 19687 [1] => 277 [RankedSportEventId] => 277 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 21188 [UserInfoId] => 21188 [1] => 277 [RankedSportEventId] => 277 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 19136 [UserInfoId] => 19136 [1] => 277 [RankedSportEventId] => 277 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 18242 [UserInfoId] => 18242 [1] => 277 [RankedSportEventId] => 277 [2] => 8 [sumUPts] => 8 [3] => 1 [cntUPts] => 1 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 18529 [UserInfoId] => 18529 [1] => 277 [RankedSportEventId] => 277 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 20103 [UserInfoId] => 20103 [1] => 277 [RankedSportEventId] => 277 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 20048 [UserInfoId] => 20048 [1] => 277 [RankedSportEventId] => 277 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 20059 [UserInfoId] => 20059 [1] => 277 [RankedSportEventId] => 277 [2] => 6 [sumUPts] => 6 [3] => 1 [cntUPts] => 1 [4] => 8195 [RankingDivisionDefinitionId] => 8195 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 277 [SportEventId] => 277 [9] => M-1 [DivisionName] => M-1 [10] => Forms - Specialty * <= 11 * Beginner * Mixed [Description] => Forms - Specialty * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) BB[ 20059 ]) 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=62 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19859 [UserInfoId] => 19859 [1] => 341 [RankedSportEventId] => 341 [2] => 78 [sumUPts] => 78 [3] => 8 [cntUPts] => 8 [4] => 8219 [RankingDivisionDefinitionId] => 8219 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 62 [DivisionId] => 62 [8] => 341 [SportEventId] => 341 [9] => FS-1 [DivisionName] => FS-1 [10] => Forms - Traditional Soft Style * <= 11 * Beginner * Mixed [Description] => Forms - Traditional Soft Style * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 62 [Sequence] => 62 ) Array ( [0] => 20059 [UserInfoId] => 20059 [1] => 341 [RankedSportEventId] => 341 [2] => 39 [sumUPts] => 39 [3] => 5 [cntUPts] => 5 [4] => 8219 [RankingDivisionDefinitionId] => 8219 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 62 [DivisionId] => 62 [8] => 341 [SportEventId] => 341 [9] => FS-1 [DivisionName] => FS-1 [10] => Forms - Traditional Soft Style * <= 11 * Beginner * Mixed [Description] => Forms - Traditional Soft Style * <= 11 * Beginner * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => -1 [AgeLow] => -1 [14] => 11 [AgeHigh] => 11 [15] => 11 [BeltRankLow] => 11 [16] => 17 [BeltRankHigh] => 17 [17] => 1226 [BeltRankClass] => 1226 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 62 [Sequence] => 62 ) BB[ 20059 ]) 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=84 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 20059 [UserInfoId] => 20059 [1] => 110 [RankedSportEventId] => 110 [2] => 87 [sumUPts] => 87 [3] => 9 [cntUPts] => 9 [4] => 8241 [RankingDivisionDefinitionId] => 8241 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 84 [DivisionId] => 84 [8] => 110 [SportEventId] => 110 [9] => S-2 [DivisionName] => S-2 [10] => Sparring - Point * <= 5 * Female [Description] => Sparring - Point * <= 5 * Female [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [13] => -1 [AgeLow] => -1 [14] => 5 [AgeHigh] => 5 [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] => 84 [Sequence] => 84 ) Standings for Pittman, Landree


Standings for:
Pittman, Landree
Event & Description Skill Level Weight (lbs) Points # Events Rank
B-1 Breaking - Power Wood - Hand/Elbow
Mixed * ≤ 11 yrs
Beginner 9696
BC-8 Breaking - Power Wood - Hand/Elbow
Mixed * ≤ 17 yrs
Beginner 611
F-1 Forms
Mixed * ≤ 5 yrs
ALL 5782
M-1 Forms - Specialty
Mixed * ≤ 11 yrs
Beginner 6127
FS-1 Forms - Traditional Soft Style
Mixed * ≤ 11 yrs
Beginner 3952
S-2 Sparring - Point
Female * ≤ 5 yrs
ALL 8791
Total291