BB[ 17111 ]) 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=95 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=165 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 17111 [UserInfoId] => 17111 [1] => 95 [RankedSportEventId] => 95 [2] => 24 [sumUPts] => 24 [3] => 2 [cntUPts] => 2 [4] => 8322 [RankingDivisionDefinitionId] => 8322 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 165 [DivisionId] => 165 [8] => 95 [SportEventId] => 95 [9] => BC-10 [DivisionName] => BC-10 [10] => Breaking - Creative Open * 18+ * Beg / Intr / Adv * Mixed [Description] => Breaking - Creative Open * 18+ * Beg / Intr / Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 165 [Sequence] => 165 ) BB[ 17111 ]) 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=161 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15069 [UserInfoId] => 15069 [1] => 299 [RankedSportEventId] => 299 [2] => 122 [sumUPts] => 122 [3] => 11 [cntUPts] => 11 [4] => 8318 [RankingDivisionDefinitionId] => 8318 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 161 [DivisionId] => 161 [8] => 299 [SportEventId] => 299 [9] => B-6 [DivisionName] => B-6 [10] => Breaking - Power Wood - Hand/Elbow * 18+ * Female * Beg / Intr / [Description] => Breaking - Power Wood - Hand/Elbow * 18+ * Female * Beg / Intr / [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 161 [Sequence] => 161 ) Array ( [0] => 17111 [UserInfoId] => 17111 [1] => 299 [RankedSportEventId] => 299 [2] => 81 [sumUPts] => 81 [3] => 7 [cntUPts] => 7 [4] => 8318 [RankingDivisionDefinitionId] => 8318 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 161 [DivisionId] => 161 [8] => 299 [SportEventId] => 299 [9] => B-6 [DivisionName] => B-6 [10] => Breaking - Power Wood - Hand/Elbow * 18+ * Female * Beg / Intr / [Description] => Breaking - Power Wood - Hand/Elbow * 18+ * Female * Beg / Intr / [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 161 [Sequence] => 161 ) BB[ 17111 ]) 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=27 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15007 [UserInfoId] => 15007 [1] => 132 [RankedSportEventId] => 132 [2] => 225 [sumUPts] => 225 [3] => 21 [cntUPts] => 21 [4] => 8184 [RankingDivisionDefinitionId] => 8184 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 27 [DivisionId] => 27 [8] => 132 [SportEventId] => 132 [9] => F-25 [DivisionName] => F-25 [10] => Forms * 18+ * Intermediate * Female [Description] => Forms * 18+ * Intermediate * Female [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 27 [Sequence] => 27 ) Array ( [0] => 17111 [UserInfoId] => 17111 [1] => 132 [RankedSportEventId] => 132 [2] => 51 [sumUPts] => 51 [3] => 7 [cntUPts] => 7 [4] => 8184 [RankingDivisionDefinitionId] => 8184 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 27 [DivisionId] => 27 [8] => 132 [SportEventId] => 132 [9] => F-25 [DivisionName] => F-25 [10] => Forms * 18+ * Intermediate * Female [Description] => Forms * 18+ * Intermediate * Female [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 27 [Sequence] => 27 ) BB[ 17111 ]) 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=46 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15007 [UserInfoId] => 15007 [1] => 277 [RankedSportEventId] => 277 [2] => 150 [sumUPts] => 150 [3] => 14 [cntUPts] => 14 [4] => 8203 [RankingDivisionDefinitionId] => 8203 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 46 [DivisionId] => 46 [8] => 277 [SportEventId] => 277 [9] => M-9 [DivisionName] => M-9 [10] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [Description] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 46 [Sequence] => 46 ) Array ( [0] => 13479 [UserInfoId] => 13479 [1] => 277 [RankedSportEventId] => 277 [2] => 45 [sumUPts] => 45 [3] => 5 [cntUPts] => 5 [4] => 8203 [RankingDivisionDefinitionId] => 8203 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 46 [DivisionId] => 46 [8] => 277 [SportEventId] => 277 [9] => M-9 [DivisionName] => M-9 [10] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [Description] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 46 [Sequence] => 46 ) Array ( [0] => 14984 [UserInfoId] => 14984 [1] => 277 [RankedSportEventId] => 277 [2] => 42 [sumUPts] => 42 [3] => 5 [cntUPts] => 5 [4] => 8203 [RankingDivisionDefinitionId] => 8203 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 46 [DivisionId] => 46 [8] => 277 [SportEventId] => 277 [9] => M-9 [DivisionName] => M-9 [10] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [Description] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 46 [Sequence] => 46 ) Array ( [0] => 15149 [UserInfoId] => 15149 [1] => 277 [RankedSportEventId] => 277 [2] => 36 [sumUPts] => 36 [3] => 4 [cntUPts] => 4 [4] => 8203 [RankingDivisionDefinitionId] => 8203 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 46 [DivisionId] => 46 [8] => 277 [SportEventId] => 277 [9] => M-9 [DivisionName] => M-9 [10] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [Description] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 46 [Sequence] => 46 ) Array ( [0] => 19827 [UserInfoId] => 19827 [1] => 277 [RankedSportEventId] => 277 [2] => 36 [sumUPts] => 36 [3] => 6 [cntUPts] => 6 [4] => 8203 [RankingDivisionDefinitionId] => 8203 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 46 [DivisionId] => 46 [8] => 277 [SportEventId] => 277 [9] => M-9 [DivisionName] => M-9 [10] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [Description] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 46 [Sequence] => 46 ) Array ( [0] => 16125 [UserInfoId] => 16125 [1] => 277 [RankedSportEventId] => 277 [2] => 27 [sumUPts] => 27 [3] => 3 [cntUPts] => 3 [4] => 8203 [RankingDivisionDefinitionId] => 8203 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 46 [DivisionId] => 46 [8] => 277 [SportEventId] => 277 [9] => M-9 [DivisionName] => M-9 [10] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [Description] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 46 [Sequence] => 46 ) Array ( [0] => 19008 [UserInfoId] => 19008 [1] => 277 [RankedSportEventId] => 277 [2] => 22 [sumUPts] => 22 [3] => 3 [cntUPts] => 3 [4] => 8203 [RankingDivisionDefinitionId] => 8203 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 46 [DivisionId] => 46 [8] => 277 [SportEventId] => 277 [9] => M-9 [DivisionName] => M-9 [10] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [Description] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 46 [Sequence] => 46 ) Array ( [0] => 15737 [UserInfoId] => 15737 [1] => 277 [RankedSportEventId] => 277 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [4] => 8203 [RankingDivisionDefinitionId] => 8203 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 46 [DivisionId] => 46 [8] => 277 [SportEventId] => 277 [9] => M-9 [DivisionName] => M-9 [10] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [Description] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 46 [Sequence] => 46 ) Array ( [0] => 20698 [UserInfoId] => 20698 [1] => 277 [RankedSportEventId] => 277 [2] => 18 [sumUPts] => 18 [3] => 3 [cntUPts] => 3 [4] => 8203 [RankingDivisionDefinitionId] => 8203 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 46 [DivisionId] => 46 [8] => 277 [SportEventId] => 277 [9] => M-9 [DivisionName] => M-9 [10] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [Description] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 46 [Sequence] => 46 ) Array ( [0] => 17959 [UserInfoId] => 17959 [1] => 277 [RankedSportEventId] => 277 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8203 [RankingDivisionDefinitionId] => 8203 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 46 [DivisionId] => 46 [8] => 277 [SportEventId] => 277 [9] => M-9 [DivisionName] => M-9 [10] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [Description] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 46 [Sequence] => 46 ) Array ( [0] => 19961 [UserInfoId] => 19961 [1] => 277 [RankedSportEventId] => 277 [2] => 15 [sumUPts] => 15 [3] => 2 [cntUPts] => 2 [4] => 8203 [RankingDivisionDefinitionId] => 8203 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 46 [DivisionId] => 46 [8] => 277 [SportEventId] => 277 [9] => M-9 [DivisionName] => M-9 [10] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [Description] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 46 [Sequence] => 46 ) Array ( [0] => 16586 [UserInfoId] => 16586 [1] => 277 [RankedSportEventId] => 277 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8203 [RankingDivisionDefinitionId] => 8203 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 46 [DivisionId] => 46 [8] => 277 [SportEventId] => 277 [9] => M-9 [DivisionName] => M-9 [10] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [Description] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 46 [Sequence] => 46 ) Array ( [0] => 21178 [UserInfoId] => 21178 [1] => 277 [RankedSportEventId] => 277 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8203 [RankingDivisionDefinitionId] => 8203 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 46 [DivisionId] => 46 [8] => 277 [SportEventId] => 277 [9] => M-9 [DivisionName] => M-9 [10] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [Description] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 46 [Sequence] => 46 ) Array ( [0] => 17111 [UserInfoId] => 17111 [1] => 277 [RankedSportEventId] => 277 [2] => 9 [sumUPts] => 9 [3] => 1 [cntUPts] => 1 [4] => 8203 [RankingDivisionDefinitionId] => 8203 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 46 [DivisionId] => 46 [8] => 277 [SportEventId] => 277 [9] => M-9 [DivisionName] => M-9 [10] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [Description] => Forms - Specialty * 18+ * Beg / Intr / Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 46 [Sequence] => 46 ) BB[ 17111 ]) 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=58 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15007 [UserInfoId] => 15007 [1] => 340 [RankedSportEventId] => 340 [2] => 213 [sumUPts] => 213 [3] => 20 [cntUPts] => 20 [4] => 8215 [RankingDivisionDefinitionId] => 8215 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 58 [DivisionId] => 58 [8] => 340 [SportEventId] => 340 [9] => FH-8 [DivisionName] => FH-8 [10] => Forms - Traditional Hard Style * 18+ * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * 18+ * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 58 [Sequence] => 58 ) Array ( [0] => 15149 [UserInfoId] => 15149 [1] => 340 [RankedSportEventId] => 340 [2] => 104 [sumUPts] => 104 [3] => 13 [cntUPts] => 13 [4] => 8215 [RankingDivisionDefinitionId] => 8215 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 58 [DivisionId] => 58 [8] => 340 [SportEventId] => 340 [9] => FH-8 [DivisionName] => FH-8 [10] => Forms - Traditional Hard Style * 18+ * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * 18+ * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 58 [Sequence] => 58 ) Array ( [0] => 17111 [UserInfoId] => 17111 [1] => 340 [RankedSportEventId] => 340 [2] => 18 [sumUPts] => 18 [3] => 2 [cntUPts] => 2 [4] => 8215 [RankingDivisionDefinitionId] => 8215 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 58 [DivisionId] => 58 [8] => 340 [SportEventId] => 340 [9] => FH-8 [DivisionName] => FH-8 [10] => Forms - Traditional Hard Style * 18+ * Intermediate * Mixed [Description] => Forms - Traditional Hard Style * 18+ * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 58 [Sequence] => 58 ) BB[ 17111 ]) 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=69 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 16508 [UserInfoId] => 16508 [1] => 341 [RankedSportEventId] => 341 [2] => 45 [sumUPts] => 45 [3] => 4 [cntUPts] => 4 [4] => 8226 [RankingDivisionDefinitionId] => 8226 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 69 [DivisionId] => 69 [8] => 341 [SportEventId] => 341 [9] => FS-8 [DivisionName] => FS-8 [10] => Forms - Traditional Soft Style * 18+ * Intermediate * Mixed [Description] => Forms - Traditional Soft Style * 18+ * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 69 [Sequence] => 69 ) Array ( [0] => 17111 [UserInfoId] => 17111 [1] => 341 [RankedSportEventId] => 341 [2] => 33 [sumUPts] => 33 [3] => 3 [cntUPts] => 3 [4] => 8226 [RankingDivisionDefinitionId] => 8226 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 69 [DivisionId] => 69 [8] => 341 [SportEventId] => 341 [9] => FS-8 [DivisionName] => FS-8 [10] => Forms - Traditional Soft Style * 18+ * Intermediate * Mixed [Description] => Forms - Traditional Soft Style * 18+ * Intermediate * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 69 [Sequence] => 69 ) BB[ 17111 ]) SELECT UserInfoId, rem.RankedSportEventId, sum(Points) as sumUPts, count(Points) as cntUPts, rdd.* FROM UserRankingPoints urp, RankingEventMappings rem, RankingDivisionDefinitions rdd WHERE urp.SportEventId=rem.SportEventId AND urp.RankingSystemId=8 AND rem.RankedSportEventId=213 AND urp.RankingSystemId=rdd.RankingSystemDefinitionId AND urp.TournamentId in ( 145,146,147,148,149,150,151,152,153,154,155,156,157,159,161,162,163,164,165,166,167,168,169,170,171 ) AND urp.RankingDivisionId=rdd.DivisionId AND urp.RankingDivisionId=80 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 15007 [UserInfoId] => 15007 [1] => 213 [RankedSportEventId] => 213 [2] => 237 [sumUPts] => 237 [3] => 22 [cntUPts] => 22 [4] => 8237 [RankingDivisionDefinitionId] => 8237 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 80 [DivisionId] => 80 [8] => 213 [SportEventId] => 213 [9] => SD-9 [DivisionName] => SD-9 [10] => Self Defense * 18+ * Beg / Intr / Adv * Mixed [Description] => Self Defense * 18+ * Beg / Intr / Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 80 [Sequence] => 80 ) Array ( [0] => 17111 [UserInfoId] => 17111 [1] => 213 [RankedSportEventId] => 213 [2] => 51 [sumUPts] => 51 [3] => 7 [cntUPts] => 7 [4] => 8237 [RankingDivisionDefinitionId] => 8237 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 80 [DivisionId] => 80 [8] => 213 [SportEventId] => 213 [9] => SD-9 [DivisionName] => SD-9 [10] => Self Defense * 18+ * Beg / Intr / Adv * Mixed [Description] => Self Defense * 18+ * Beg / Intr / Adv * Mixed [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 11 [BeltRankLow] => 11 [16] => 27 [BeltRankHigh] => 27 [17] => 1230 [BeltRankClass] => 1230 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 80 [Sequence] => 80 ) BB[ 17111 ]) 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=130 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 17111 [UserInfoId] => 17111 [1] => 110 [RankedSportEventId] => 110 [2] => 108 [sumUPts] => 108 [3] => 11 [cntUPts] => 11 [4] => 8287 [RankingDivisionDefinitionId] => 8287 [5] => 8 [RankingSystemDefinitionId] => 8 [6] => 3 [SportId] => 3 [7] => 130 [DivisionId] => 130 [8] => 110 [SportEventId] => 110 [9] => S-48 [DivisionName] => S-48 [10] => Sparring - Point * 18+ * Intermediate * Female [Description] => Sparring - Point * 18+ * Intermediate * Female [11] => 0 [Disabled] => 0 [12] => 2 [Gender] => 2 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 18 [BeltRankLow] => 18 [16] => 23 [BeltRankHigh] => 23 [17] => 1227 [BeltRankClass] => 1227 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 130 [Sequence] => 130 ) Standings for Kunkel, Kittie


Standings for:
Kunkel, Kittie
Event & Description Skill Level Weight (lbs) Points # Events Rank
BC-10 Breaking - Creative Open
Mixed * 18+ yrs
Beginner 2421
B-6 Breaking - Power Wood - Hand/Elbow
Female * 18+ yrs
Beginner 8172
F-25 Forms
Female * 18+ yrs
Intermediate 5172
M-9 Forms - Specialty
Mixed * 18+ yrs
Beginner 9114
FH-8 Forms - Traditional Hard Style
Mixed * 18+ yrs
Intermediate 1823
FS-8 Forms - Traditional Soft Style
Mixed * 18+ yrs
Intermediate 3332
SD-9 Self Defense
Mixed * 18+ yrs
Beginner 5172
S-48 Sparring - Point
Female * 18+ yrs
Intermediate 108111
Total375