AA) SELECT DISTINCT sed.*, urp.RankingDivisionId FROM UserRankingPoints urp, RankingEventMappings rem, SportEventDefinitions sed WHERE UserInfoId=13726 AND urp.SportEventId=rem.SportEventId AND urp.RankingSystemId=9 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 rem.RankedSportEventId=sed.SportEventId ORDER BY urp.RankingSystemId, EventName, urp.RankingDivisionId
AA
Array ( [0] => 95 [SportEventId] => 95 [1] => 3 [SportId] => 3 [2] => 3 [EventType] => 3 [3] => 54 [EventClass] => 54 [4] => 1 [EventPersons] => 1 [5] => Breaking - Creative Open [EventName] => Breaking - Creative Open [6] => Breaking - Creative Open [EventDescription] => Breaking - Creative Open [7] => 0 [WeighinRequired] => 0 [8] => BICO [EventPrefix] => BICO [9] => images/breaking.png [EventImage] => images/breaking.png [10] => images/Registration/eo_break-crea-open.jpg [EventEoImage] => images/Registration/eo_break-crea-open.jpg [11] => Breaking - Creative Open [EventEoTitle] => Breaking - Creative Open [12] => break-crea-open [EventRegistration] => break-crea-open [13] => 54 [RegistrationSequence] => 54 [14] => 8 [RankingDivisionId] => 8 )
BB[ 13726 ]) 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=9 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=8 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19068 [UserInfoId] => 19068 [1] => 95 [RankedSportEventId] => 95 [2] => 122 [sumUPts] => 122 [3] => 11 [cntUPts] => 11 [4] => 8331 [RankingDivisionDefinitionId] => 8331 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 8 [DivisionId] => 8 [8] => 95 [SportEventId] => 95 [9] => BCO-7 [DivisionName] => BCO-7 [10] => Breaking - Creative Open * 18+ yrs * Black * Male [Description] => Breaking - Creative Open * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 8 [Sequence] => 8 ) Array ( [0] => 13738 [UserInfoId] => 13738 [1] => 95 [RankedSportEventId] => 95 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8331 [RankingDivisionDefinitionId] => 8331 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 8 [DivisionId] => 8 [8] => 95 [SportEventId] => 95 [9] => BCO-7 [DivisionName] => BCO-7 [10] => Breaking - Creative Open * 18+ yrs * Black * Male [Description] => Breaking - Creative Open * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 8 [Sequence] => 8 ) Array ( [0] => 13726 [UserInfoId] => 13726 [1] => 95 [RankedSportEventId] => 95 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8331 [RankingDivisionDefinitionId] => 8331 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 8 [DivisionId] => 8 [8] => 95 [SportEventId] => 95 [9] => BCO-7 [DivisionName] => BCO-7 [10] => Breaking - Creative Open * 18+ yrs * Black * Male [Description] => Breaking - Creative Open * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 8 [Sequence] => 8 ) BB
Array ( [0] => 13726 [UserInfoId] => 13726 [1] => 95 [RankedSportEventId] => 95 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8331 [RankingDivisionDefinitionId] => 8331 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 8 [DivisionId] => 8 [8] => 95 [SportEventId] => 95 [9] => BCO-7 [DivisionName] => BCO-7 [10] => Breaking - Creative Open * 18+ yrs * Black * Male [Description] => Breaking - Creative Open * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 1 [Gender] => 1 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 8 [Sequence] => 8 [position] => 3 )
AA
Array ( [0] => 275 [SportEventId] => 275 [1] => 3 [SportId] => 3 [2] => 3 [EventType] => 3 [3] => 275 [EventClass] => 275 [4] => 1 [EventPersons] => 1 [5] => Breaking - Power Concrete - Elbow [EventName] => Breaking - Power Concrete - Elbow [6] => Breaking - Power Concrete - Elbow [EventDescription] => Breaking - Power Concrete - Elbow [7] => 0 [WeighinRequired] => 0 [8] => BIPCE [EventPrefix] => BIPCE [9] => images/Events/Break-Concrete-Elbow.png [EventImage] => images/Events/Break-Concrete-Elbow.png [10] => images/Registration/eo_break-pwr-concrete-elbow.jpg [EventEoImage] => images/Registration/eo_break-pwr-concrete-elbow.jpg [11] => Breaking - Power Concrete - Elbow [EventEoTitle] => Breaking - Power Concrete - Elbow [12] => break-pwr-conc-e [EventRegistration] => break-pwr-conc-e [13] => 275 [RegistrationSequence] => 275 [14] => 45 [RankingDivisionId] => 45 )
BB[ 13726 ]) 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=9 AND rem.RankedSportEventId=275 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=45 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 13726 [UserInfoId] => 13726 [1] => 275 [RankedSportEventId] => 275 [2] => 63 [sumUPts] => 63 [3] => 7 [cntUPts] => 7 [4] => 8368 [RankingDivisionDefinitionId] => 8368 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 275 [SportEventId] => 275 [9] => BPCE-6 [DivisionName] => BPCE-6 [10] => Breaking - Power Concrete Elbow * 18+ yrs * Black * Male [Description] => Breaking - Power Concrete Elbow * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 ) BB
Array ( [0] => 13726 [UserInfoId] => 13726 [1] => 275 [RankedSportEventId] => 275 [2] => 63 [sumUPts] => 63 [3] => 7 [cntUPts] => 7 [4] => 8368 [RankingDivisionDefinitionId] => 8368 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 45 [DivisionId] => 45 [8] => 275 [SportEventId] => 275 [9] => BPCE-6 [DivisionName] => BPCE-6 [10] => Breaking - Power Concrete Elbow * 18+ yrs * Black * Male [Description] => Breaking - Power Concrete Elbow * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 45 [Sequence] => 45 [position] => 1 )
AA
Array ( [0] => 276 [SportEventId] => 276 [1] => 3 [SportId] => 3 [2] => 3 [EventType] => 3 [3] => 276 [EventClass] => 276 [4] => 1 [EventPersons] => 1 [5] => Breaking - Power Concrete - Foot [EventName] => Breaking - Power Concrete - Foot [6] => Breaking - Power Concrete - Foot [EventDescription] => Breaking - Power Concrete - Foot [7] => 0 [WeighinRequired] => 0 [8] => BIPCF [EventPrefix] => BIPCF [9] => images/Events/Break-Concrete-Foot.png [EventImage] => images/Events/Break-Concrete-Foot.png [10] => images/Registration/eo_break-pwr-concrete-foot.jpg [EventEoImage] => images/Registration/eo_break-pwr-concrete-foot.jpg [11] => Breaking - Power Concrete - Foot [EventEoTitle] => Breaking - Power Concrete - Foot [12] => break-pwr-conc-f [EventRegistration] => break-pwr-conc-f [13] => 276 [RegistrationSequence] => 276 [14] => 52 [RankingDivisionId] => 52 )
BB[ 13726 ]) 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=9 AND rem.RankedSportEventId=276 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] => 13726 [UserInfoId] => 13726 [1] => 276 [RankedSportEventId] => 276 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8375 [RankingDivisionDefinitionId] => 8375 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 276 [SportEventId] => 276 [9] => BPCF-6 [DivisionName] => BPCF-6 [10] => Breaking - Power Concrete Foot * 18+ yrs * Black * Male [Description] => Breaking - Power Concrete Foot * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 52 [Sequence] => 52 ) BB
Array ( [0] => 13726 [UserInfoId] => 13726 [1] => 276 [RankedSportEventId] => 276 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8375 [RankingDivisionDefinitionId] => 8375 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 52 [DivisionId] => 52 [8] => 276 [SportEventId] => 276 [9] => BPCF-6 [DivisionName] => BPCF-6 [10] => Breaking - Power Concrete Foot * 18+ yrs * Black * Male [Description] => Breaking - Power Concrete Foot * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 52 [Sequence] => 52 [position] => 1 )
AA
Array ( [0] => 274 [SportEventId] => 274 [1] => 3 [SportId] => 3 [2] => 3 [EventType] => 3 [3] => 274 [EventClass] => 274 [4] => 1 [EventPersons] => 1 [5] => Breaking - Power Concrete - Hand [EventName] => Breaking - Power Concrete - Hand [6] => Breaking - Power Concrete - Hand [EventDescription] => Breaking - Power Concrete - Hand [7] => 0 [WeighinRequired] => 0 [8] => BIPCH [EventPrefix] => BIPCH [9] => images/Events/Break-Concrete-Hand.png [EventImage] => images/Events/Break-Concrete-Hand.png [10] => images/Registration/eo_break-pwr-concrete-hand.jpg [EventEoImage] => images/Registration/eo_break-pwr-concrete-hand.jpg [11] => Breaking - Power Concrete - Hand [EventEoTitle] => Breaking - Power Concrete - Hand [12] => break-pwr-conc-h [EventRegistration] => break-pwr-conc-h [13] => 274 [RegistrationSequence] => 274 [14] => 59 [RankingDivisionId] => 59 )
BB[ 13726 ]) 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=9 AND rem.RankedSportEventId=274 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=59 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 13726 [UserInfoId] => 13726 [1] => 274 [RankedSportEventId] => 274 [2] => 104 [sumUPts] => 104 [3] => 9 [cntUPts] => 9 [4] => 8382 [RankingDivisionDefinitionId] => 8382 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 59 [DivisionId] => 59 [8] => 274 [SportEventId] => 274 [9] => BPCH-6 [DivisionName] => BPCH-6 [10] => Breaking - Power Concrete Hand * 18+ yrs * Black * Male [Description] => Breaking - Power Concrete Hand * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 59 [Sequence] => 59 ) BB
Array ( [0] => 13726 [UserInfoId] => 13726 [1] => 274 [RankedSportEventId] => 274 [2] => 104 [sumUPts] => 104 [3] => 9 [cntUPts] => 9 [4] => 8382 [RankingDivisionDefinitionId] => 8382 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 59 [DivisionId] => 59 [8] => 274 [SportEventId] => 274 [9] => BPCH-6 [DivisionName] => BPCH-6 [10] => Breaking - Power Concrete Hand * 18+ yrs * Black * Male [Description] => Breaking - Power Concrete Hand * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 59 [Sequence] => 59 [position] => 1 )
AA
Array ( [0] => 97 [SportEventId] => 97 [1] => 3 [SportId] => 3 [2] => 3 [EventType] => 3 [3] => 56 [EventClass] => 56 [4] => 1 [EventPersons] => 1 [5] => Breaking - Power Wood - Elbow [EventName] => Breaking - Power Wood - Elbow [6] => Breaking - Power Wood - Elbow [EventDescription] => Breaking - Power Wood - Elbow [7] => 0 [WeighinRequired] => 0 [8] => BIPWE [EventPrefix] => BIPWE [9] => images/Events/Break-Wood-Elbow.png [EventImage] => images/Events/Break-Wood-Elbow.png [10] => images/Registration/eo_break-pwr-wood-elbow.jpg [EventEoImage] => images/Registration/eo_break-pwr-wood-elbow.jpg [11] => Breaking - Power Wood - Elbow [EventEoTitle] => Breaking - Power Wood - Elbow [12] => break-pwr-wood-e [EventRegistration] => break-pwr-wood-e [13] => 56 [RegistrationSequence] => 56 [14] => 18 [RankingDivisionId] => 18 )
BB[ 13726 ]) 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=9 AND rem.RankedSportEventId=97 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=18 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 19068 [UserInfoId] => 19068 [1] => 97 [RankedSportEventId] => 97 [2] => 51 [sumUPts] => 51 [3] => 5 [cntUPts] => 5 [4] => 8341 [RankingDivisionDefinitionId] => 8341 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 18 [DivisionId] => 18 [8] => 97 [SportEventId] => 97 [9] => BPWE-9 [DivisionName] => BPWE-9 [10] => Breaking - Power Wood Elbow * 18+ yrs * Black * Male [Description] => Breaking - Power Wood Elbow * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 18 [Sequence] => 18 ) Array ( [0] => 16009 [UserInfoId] => 16009 [1] => 97 [RankedSportEventId] => 97 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8341 [RankingDivisionDefinitionId] => 8341 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 18 [DivisionId] => 18 [8] => 97 [SportEventId] => 97 [9] => BPWE-9 [DivisionName] => BPWE-9 [10] => Breaking - Power Wood Elbow * 18+ yrs * Black * Male [Description] => Breaking - Power Wood Elbow * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 18 [Sequence] => 18 ) Array ( [0] => 13726 [UserInfoId] => 13726 [1] => 97 [RankedSportEventId] => 97 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8341 [RankingDivisionDefinitionId] => 8341 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 18 [DivisionId] => 18 [8] => 97 [SportEventId] => 97 [9] => BPWE-9 [DivisionName] => BPWE-9 [10] => Breaking - Power Wood Elbow * 18+ yrs * Black * Male [Description] => Breaking - Power Wood Elbow * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 18 [Sequence] => 18 ) BB
Array ( [0] => 13726 [UserInfoId] => 13726 [1] => 97 [RankedSportEventId] => 97 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8341 [RankingDivisionDefinitionId] => 8341 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 18 [DivisionId] => 18 [8] => 97 [SportEventId] => 97 [9] => BPWE-9 [DivisionName] => BPWE-9 [10] => Breaking - Power Wood Elbow * 18+ yrs * Black * Male [Description] => Breaking - Power Wood Elbow * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 18 [Sequence] => 18 [position] => 3 )
AA
Array ( [0] => 98 [SportEventId] => 98 [1] => 3 [SportId] => 3 [2] => 3 [EventType] => 3 [3] => 57 [EventClass] => 57 [4] => 1 [EventPersons] => 1 [5] => Breaking - Power Wood - Foot [EventName] => Breaking - Power Wood - Foot [6] => Breaking - Power Wood - Foot [EventDescription] => Breaking - Power Wood - Foot [7] => 0 [WeighinRequired] => 0 [8] => BIPWF [EventPrefix] => BIPWF [9] => images/Events/Break-Wood-Foot.png [EventImage] => images/Events/Break-Wood-Foot.png [10] => images/Registration/eo_break-pwr-wood-foot.jpg [EventEoImage] => images/Registration/eo_break-pwr-wood-foot.jpg [11] => Breaking - Power Wood - Foot [EventEoTitle] => Breaking - Power Wood - Foot [12] => break-pwr-wood-f [EventRegistration] => break-pwr-wood-f [13] => 57 [RegistrationSequence] => 57 [14] => 28 [RankingDivisionId] => 28 )
BB[ 13726 ]) 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=9 AND rem.RankedSportEventId=98 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=28 GROUP BY UserInfoId ORDER BY sumUPts DESC
Array ( [0] => 18623 [UserInfoId] => 18623 [1] => 98 [RankedSportEventId] => 98 [2] => 36 [sumUPts] => 36 [3] => 3 [cntUPts] => 3 [4] => 8351 [RankingDivisionDefinitionId] => 8351 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 28 [DivisionId] => 28 [8] => 98 [SportEventId] => 98 [9] => BPWF-9 [DivisionName] => BPWF-9 [10] => Breaking - Power Wood Foot * 18+ yrs * Black * Male [Description] => Breaking - Power Wood Foot * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 28 [Sequence] => 28 ) Array ( [0] => 13726 [UserInfoId] => 13726 [1] => 98 [RankedSportEventId] => 98 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8351 [RankingDivisionDefinitionId] => 8351 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 28 [DivisionId] => 28 [8] => 98 [SportEventId] => 98 [9] => BPWF-9 [DivisionName] => BPWF-9 [10] => Breaking - Power Wood Foot * 18+ yrs * Black * Male [Description] => Breaking - Power Wood Foot * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 28 [Sequence] => 28 ) BB
Array ( [0] => 13726 [UserInfoId] => 13726 [1] => 98 [RankedSportEventId] => 98 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8351 [RankingDivisionDefinitionId] => 8351 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 28 [DivisionId] => 28 [8] => 98 [SportEventId] => 98 [9] => BPWF-9 [DivisionName] => BPWF-9 [10] => Breaking - Power Wood Foot * 18+ yrs * Black * Male [Description] => Breaking - Power Wood Foot * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 28 [Sequence] => 28 [position] => 2 )
AA
Array ( [0] => 96 [SportEventId] => 96 [1] => 3 [SportId] => 3 [2] => 3 [EventType] => 3 [3] => 55 [EventClass] => 55 [4] => 1 [EventPersons] => 1 [5] => Breaking - Power Wood - Hand [EventName] => Breaking - Power Wood - Hand [6] => Breaking - Power Wood - Hand [EventDescription] => Breaking - Power Wood - Hand [7] => 0 [WeighinRequired] => 0 [8] => BIPWH [EventPrefix] => BIPWH [9] => images/Events/Break-Wood-Hand.png [EventImage] => images/Events/Break-Wood-Hand.png [10] => images/Registration/eo_break-pwr-wood-hand.jpg [EventEoImage] => images/Registration/eo_break-pwr-wood-hand.jpg [11] => Breaking - Power Wood - Hand [EventEoTitle] => Breaking - Power Wood - Hand [12] => break-pwr-wood-h [EventRegistration] => break-pwr-wood-h [13] => 55 [RegistrationSequence] => 55 [14] => 38 [RankingDivisionId] => 38 )
BB[ 13726 ]) 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=9 AND rem.RankedSportEventId=96 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] => 19068 [UserInfoId] => 19068 [1] => 96 [RankedSportEventId] => 96 [2] => 110 [sumUPts] => 110 [3] => 11 [cntUPts] => 11 [4] => 8361 [RankingDivisionDefinitionId] => 8361 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 96 [SportEventId] => 96 [9] => BPWH-9 [DivisionName] => BPWH-9 [10] => Breaking - Power Wood Hand * 18+ yrs * Black * Male [Description] => Breaking - Power Wood Hand * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 18623 [UserInfoId] => 18623 [1] => 96 [RankedSportEventId] => 96 [2] => 48 [sumUPts] => 48 [3] => 4 [cntUPts] => 4 [4] => 8361 [RankingDivisionDefinitionId] => 8361 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 96 [SportEventId] => 96 [9] => BPWH-9 [DivisionName] => BPWH-9 [10] => Breaking - Power Wood Hand * 18+ yrs * Black * Male [Description] => Breaking - Power Wood Hand * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) Array ( [0] => 13726 [UserInfoId] => 13726 [1] => 96 [RankedSportEventId] => 96 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8361 [RankingDivisionDefinitionId] => 8361 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 96 [SportEventId] => 96 [9] => BPWH-9 [DivisionName] => BPWH-9 [10] => Breaking - Power Wood Hand * 18+ yrs * Black * Male [Description] => Breaking - Power Wood Hand * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 ) BB
Array ( [0] => 13726 [UserInfoId] => 13726 [1] => 96 [RankedSportEventId] => 96 [2] => 12 [sumUPts] => 12 [3] => 1 [cntUPts] => 1 [4] => 8361 [RankingDivisionDefinitionId] => 8361 [5] => 9 [RankingSystemDefinitionId] => 9 [6] => 3 [SportId] => 3 [7] => 38 [DivisionId] => 38 [8] => 96 [SportEventId] => 96 [9] => BPWH-9 [DivisionName] => BPWH-9 [10] => Breaking - Power Wood Hand * 18+ yrs * Black * Male [Description] => Breaking - Power Wood Hand * 18+ yrs * Black * Male [11] => 0 [Disabled] => 0 [12] => 3 [Gender] => 3 [13] => 18 [AgeLow] => 18 [14] => -1 [AgeHigh] => -1 [15] => 28 [BeltRankLow] => 28 [16] => 28 [BeltRankHigh] => 28 [17] => 5 [BeltRankClass] => 5 [18] => -1 [WeightClass] => -1 [19] => 0 [WeightLow] => 0 [20] => 0 [WeightHigh] => 0 [21] => 38 [Sequence] => 38 [position] => 3 )
Standings for Hinkle, Wayne A


Standings for:
Hinkle, Wayne A
Event & Description Skill Level Weight (lbs) Points # Events Rank
BCO-7 Breaking - Creative Open
Male * 18+ yrs
Black Belt 1213
BPCE-6 Breaking - Power Concrete - Elbow
Mixed * 18+ yrs
Black Belt 6371
BPCF-6 Breaking - Power Concrete - Foot
Mixed * 18+ yrs
Black Belt 1211
BPCH-6 Breaking - Power Concrete - Hand
Mixed * 18+ yrs
Black Belt 10491
BPWE-9 Breaking - Power Wood - Elbow
Mixed * 18+ yrs
Black Belt 1213
BPWF-9 Breaking - Power Wood - Foot
Mixed * 18+ yrs
Black Belt 1212
BPWH-9 Breaking - Power Wood - Hand
Mixed * 18+ yrs
Black Belt 1213
Total227