Started: 2019-12-12 08:52:15 Statement: select dogs.sex, dogs.TableKey as DogKey, TitleName, BOBRank as Ranking, (Select BOBRank FROM standingsprovince as S2 WHERE S2.Province_ID = 1 AND S2.Dog_ID = standingsprovince.Dog_Id AND S2.ResultYear = 2019 AND S2.ResultMonth = 11) LastMonthRanking,
BreedName, OwnerName, DogName, CallName, BOBPoints as TotalPoints, BIS, GP1, GP2, GP3, GP4, S_BIS, S_GP1, S_GP2, S_GP3, S_GP4,HandlerName, BOB, S_BOB, BOBPoints, BOBtoGroupPercent
FROM standingsprovince
INNER JOIN breeds on breeds.ID_NO = standingsprovince.Breed_ID
INNER JOIN dogs on dogs.ID_NO = standingsprovince.Dog_ID
LEFT JOIN handler on handler.ID_NO = Dogs.Handlers_ID
LEFT JOIN titles on titles.ID_NO = Dogs.Titles_ID
WHERE BOB>= 3 and StandingsProvince.Province_ID = 1 AND RankDog = '1' and Breed_ID = 672 AND BOBRank IS NOT NULL and BOBRank <> 0 AND ResultYear = 2019 AND ResultMonth = 12 ORDER BY BOBToGroupPercent Desc, BOB Desc LIMIT 50 Execute Time: 0.041634082794189 Seconds Rows Returned: 8
Picture |
Rank |
Breed |
Dog Name |
All Breed BOB |
Specialty BOB |
Points |
% GRP |
| 1 | Retriever (Labrador) | Ch Labralynes Molly(F) | 3 | 0 | 16 | 33.33% |
| 1 | Retriever (Labrador) | Ch Compass' Guiding Light(F) | 3 | 0 | 21 | 33.33% |
| 3 | Retriever (Labrador) | Ch Beaumark's Baron Of Torngat(M) | 4 | 0 | 0 | 25.00% |
| 4 | Retriever (Labrador) | GCh Cambridge's Yabba Dabba Doozie(F) | 5 | 0 | 38 | 20.00% |
| 5 | Retriever (Labrador) | Eagertrieves Jeep YJ(M) | 6 | 0 | 26 | 0.00% |
| 5 | Retriever (Labrador) | Ch Mayhemfarms Aint Misbehaving(F) | 4 | 0 | 17 | 0.00% |
 | 5 | Retriever (Labrador) | GCh Westholms Who's Your Daddy(M) | 3 | 1 | 52 | 0.00% |
| 5 | Retriever (Labrador) | Labralayne's Horse Power(M) | 3 | 0 | 9 | 0.00% |
The Group % Standings are a percentage based on the number of time that a
dog wins the breed and goes on to place in the group.
1. A dog must have a minimum of 3 Best of Breed wins to be ranked in the
Group % standings.
2. Group placement is any placement from 1st to 4th.
3. Group placements include all-breed shows and Group specialties.
|
|