Started: 2019-10-19 08:22:05
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 = 9) 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 = 10 ORDER BY BOBToGroupPercent Desc, BOB Desc LIMIT 50
Execute Time: 0.011184215545654 Seconds
Rows Returned: 7

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 Cambridge's Yabba Dabba Doozie(F)	4	0	36	25.00%
	3	Retriever (Labrador)	Ch Beaumark's Baron Of Torngat(M)	4	0	0	25.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)	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.