This site is of interest to people who are horseback riding, horse back riding, horseback riders, horse riders, equestrian equipment, trucks and trailers for hauling horses. Horse trailers, tack and equipment for riding are important. Equine health supplements and stable supplies, as well as saddlery, leather goods, bridles, english riding clothing are part of equestrian events.
Mill Creek Pony Club H.T. at Longview
May 14-15, 2016 - Kansas City, MO
| Division |
Phase |
Current Leader |
| Rider |
Horse |
Score |
| Prelim |
Final Scores |
Madigan Murphy |
Willdebrandt |
29.6 |
| Prelim CT |
Final Scores |
Meighan Ferguson |
Cappataggle Clover |
40.6 |
| Training |
Final Scores |
Diane Palm |
Achilles |
30.4 |
| Training YR |
Final Scores |
Hannah Stohr |
World Beyond |
27.5 |
| Novice Jr |
Final Scores |
Shayla Clark |
Solo Attraction |
31.0 |
| Novice Jr Rider |
Final Scores |
Miriam Copeland |
D'Stinctive |
27.8 |
| Novice Sr |
Final Scores |
David Harris |
Country Schoolin |
30.0 |
| Novice Sr Amateur |
Final Scores |
Hadley White |
Mmc Van Gogh |
29.3 |
| BNovce Sr Horse |
Final Scores |
Penny Goddard |
Courageous |
28.0 |
| BNovice Jr |
Final Scores |
Bonnie Tom |
Knight O' Gold |
27.3 |
| BNovice Jr-Horse |
Final Scores |
Alexandra Marsh |
Mudcat Charlie |
31.6 |
| BNovice Sr |
Final Scores |
Lauren Stiver |
Brementown |
26.8 |
| BNovice Sr Amateur |
Final Scores |
Natasha Hoppe |
Chics Red Man |
24.8 |
| Starter Jr A |
Final Scores |
Clare Price |
Galaxy |
31.3 |
| Starter Jr B |
Final Scores |
Lila Entwistle |
Tinker Toy |
31.9 |
| Starter SR |
Final Scores |
Missy Carlisle |
Cool Beans |
23.1 |
| Starter CT |
Final Scores |
|
|
|
ERROR in pony club QUERYSELECT pct.Level as pcLevel, pct.Section as pcSection, pcl.Name as Level_Name, lb.Name as Team_Name, Leading_Total
FROM (select Level, Section from pcteams group by Level, Section) pct
INNER JOIN pclevels pcl ON pct.Level = pcl.Level AND pct.Section = pcl.Section
LEFT OUTER JOIN (
SELECT pct0.Level, pct0.Section, pct0.Name, pct0.Final_Total as Leading_Total
FROM pcteams pct0
INNER JOIN (
SELECT Level, Section, Final_place, MIN(Final_Total) as Final_Total
FROM pcteams WHERE Final_Total>0 OR Final_Place = 1
GROUP BY Level, Section, Final_place
Having Final_Place<='1'
) ft ON pct0.Level = ft.Level AND pct0.Section = ft.Section AND pct0.Final_Total=ft.Final_Total AND pct0.Final_Place=ft.Final_Place
) lb ON lb.Level=pct.Level
LEFT OUTER JOIN levels ON `Team Level` = pct.Level
ORDER BY `Team Level`, pcSection