SELECT SQL_CALC_FOUND_ROWS  wp_posts.*, IF(wppm.meta_value= 1, 'YES', NULL) as showcased
			 FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_postmeta as wppm ON (wp_posts.ID = wppm.post_id AND wppm.meta_key = 'promoted')
			 WHERE 1=1  AND ( 
  wp_term_relationships.term_taxonomy_id IN (16)
) AND wp_posts.post_type = 'post' AND ((wp_posts.post_status = 'publish')) AND wp_posts.ID NOT IN ( SELECT ID FROM wp_posts WHERE post_type IN ('post','page','attachment','job_listing','podcasts','industry-news','product','business-directory','testimonial') AND ID IN ( SELECT post_id FROM wp_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value NOT IN (0) AND pm.meta_value IN ( SELECT group_id FROM wp_groups_group ) AND post_id NOT IN ( SELECT post_id FROM wp_postmeta pm WHERE pm.meta_key = 'groups-read' AND pm.meta_value IN (0) ) ) )  AND wp_posts.ID IN  (    SELECT ID FROM wp_posts WHERE ID NOT IN ( SELECT post_id FROM wp_postmeta WHERE wp_postmeta.meta_key = 'groups-groups_read_post' )    UNION ALL    SELECT post_id AS ID FROM wp_postmeta WHERE wp_postmeta.meta_key = 'groups-groups_read_post' AND wp_postmeta.meta_value IN ('')  ) 
			 GROUP BY wp_posts.ID
			 ORDER BY wp_posts.menu_order,  wp_posts.menu_order, wp_posts.post_date DESC
			 LIMIT 3000, 10

September 16, 2022

Run Medford Gets Star-Struck For Mayor’s Celebrity Mile

Sept. 14, 2022, BOSTON – Nearly 20 celebrities will be toeing the line this Sunday at Run Medford, a brand new weekend-long celebration of community, running, and the City of Medford produced by DMSE Sports and hosted by the Dave McGillivray Finish Strong Foundation. Members of the media, sports legends,...

Events

Press Releases

Running

September 15, 2022

Long Beach Marathon Prepares for Take Off with Long Beach Airport

LONG BEACH – September 15, 2022 /ENDURANCE SPORTSWIRE/ – Ahead of more than 15,000 runners hitting the pavement at the Long Beach Marathon and Half Marathon in October, Long Beach Airport (LGB) and race organizers today announced a renewed partnership for the 2022 event. The premier fall marathon in Southern California...

Events

Press Releases

Running

September 15, 2022

Chicago Half Marathon Celebrates 25 Years on September 25 with ‘All Things Chicago’ Theme

CHICAGO – (September 15, 2021) /ENDURANCE SPORTSWIRE/ – The HOKA Chicago Half Marathon produced by Life Time will celebrate its 25th anniversary as the Windy City’s most established and iconic half marathon on September 25. In recognition of the historic milestone, race organizer Life Time has created an ‘All Things Chicago’...

Events

Press Releases

Running

September 15, 2022

Strong Pro Field Expected in Colorado Springs for 3rd Annual Pikes Peak APEX Presented by RockShox

Colorado Springs, CO, September 15, 2022 /ENDURANCE SPORTSWIRE/ – Sports Strategies announces another stacked race for the 4-day mountain bike challenge on the slopes of Pikes Peak. $25,000 is up for grabs, split evenly between the men and women’s top finishers. With defending champ Keegan Swenson having to withdraw after being selected for...

Cycling

Events

Press Releases

September 15, 2022

ROUVY: La Vuelta Virtual ‘22 Summary – 7K riders worldwide, a winner from Belgium and 5K Euro for inclusive cycling

Madrid, Spain / September 15th, 2022 /ENDURANCE SPORTSWIRE/ – La Vuelta Virtual on ROUVY, last weekend, had a magnificent wrap up in Madrid. Everyone witnessed the amazing story of Ward Simons who became the first winner of La Vuelta Virtual ‘22 at the in-person Grand Final. The pharmacist from Belgium managed...

Cycling

Events

Press Releases

September 14, 2022

IRONMAN 70.3 Perú returns to Lima, Peru for 2023

Lima, Perú (September 14, 2022)/ENDURANCE SPORTSWIRE/ – IRONMAN announced today that IRONMAN® 70.3® Perú triathlon will return to Lima, Perú for the first time since 2019. The fourth edition of IRONMAN 70.3 Perú triathlon is scheduled to take place on Sunday, April 23, 2023. Registration for the event opens on Thursday,...

Events

Press Releases

Triathlon

September 14, 2022

Gran Fondo Maryland Announced as USA Cycling Gran Fondo National Championship for 2023

Gettysburg, PA – September 14, 2022)/ENDURANCE SPORTSWIRE/ – Gran Fondo National Series is proud to announce that the 2023 USA Cycling Gran Fondo National Championships will be held in conjunction with Gran Fondo Maryland. The date for the Championships in Frederick, Maryland, will be September 17, 2023. Gran Fondo National Series...

Cycling

Events

Press Releases

September 14, 2022

Athletic Brewing Company Announces Return of Oktoberfest

MILFORD, Conn. and SAN DIEGO (September 14, 2022)/ENDURANCE SPORTSWIRE/ – Athletic Brewing Company, the leading non-alcoholic craft brewer in the U.S., today announced the return of its beloved Oktoberfest Non-Alcoholic Festbier for a fourth year. As the seasons change and fall festivities return, Athletic Oktoberfest pairs perfectly with all of your...

Events

Press Releases

Products

September 13, 2022

Challenge Family continues with virtual racing – The digital twin of the Italian Sanremo is set for Sep 15th, one week before the actual race

Almere, Netherlands / September 13th, 2022 /ENDURANCE SPORTSWIRE/ - Challenge Family and ROUVY continue to digitize the best triathlon locations around the world. Now with the Challenge Almere behind, the next stop is the middle-distance triathlon in the Ligurian region. The international tri community and Sanremo participants are set to...

Events

Press Releases

Triathlon