test race_results_list_z2

Race Results for Guest SELECT date_format(RaceDate,"%m/%d/%Y") as Date,RaceName,Location,EventType,DistanceMiles,NetTime, concat(PaceMin,':',convert(lpad(PaceSec,2,0) using utf8mb4)) AS Pace, OverallPlace,OverallTotal,DivGroup,DivPlace,DivTotal,Age FROM Results where MemberName = "" order by RaceName Asc, RaceDate DESC;

Date	Race Name	Location	Event Type	Distance	Net Time	Pace	Place	Total Entrants	Div	DivPlace	DivTotal	Age
01/01/2024	Apple Therapy Millenium Mile	Londonderry, NH	1M	1.00	00:08:53	8:52	592		80+	1		80
01/01/2024	Apple Therapy MILLENIUN mile	Londonderry, NH	1M	1.00	00:08:53	8:52	592		80+	1		80
11/14/2021	BIGGSteps 5K	Needham, MA	5K	3.10	00:28:48	9:17	1134	0	70+	1		78
03/26/2023	Black Cat 10	Salem Mass	10M	10.00	01:33:00	9:18	0	0	70+	1		73
09/04/2021	Cochecho Challenge Half Marathon	Dover, NH	Half Marathon	13.10	02:01:47	9:17	71	0	70+	1		73
06/04/2023	Corib pub	West Roxbury	5K	3.10	00:31:18	10:05	674	0	70-79	4		79
05/21/2023	Evan's Run	Norwell, MA	5K	3.10	00:30:09	9:43	238	0	70+	5		79
09/24/2023	McGuiggan 5k	Whitman Massachusetts	5K	3.10	00:26:59	8:42	0	0		0		74
10/08/2023	Newport Half Marathon	Newport Rhode Island	Half Marathon	13.10	02:05:30	9:34	0	0	70 - 90	0		74
10/15/2023	Paddy's Shillelagh Shuffle	Newton, MA	5K	3.10	00:00:00	0:00	821	0	70+	6		80
10/15/2023	paddys	Newton, MA	3K	1.86	00:00:00	0:00	821	0	70+	6		80
11/04/2023	PembrokeSteve	Randolph, Mass	5K	3.10	00:28:35	9:13	41	0	70+	2		74
08/21/2021	Saunders at Rye Harbor 10K	Rye, NH	10K	6.20	01:10:41	11:24	1	0	70+	1		78