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 3030, 10

April 13, 2023

IRONMAN to Bring New Voices to the microphone; Diverse Cast of Announcers to Call In IRONMAN and IRONMAN 70.3 Finishers in 2023

TAMPA, Fla. (April 13, 2023)  /ENDURANCE SPORTSWIRE/ – The list of voices calling athletes across IRONMAN® and IRONMAN® 70.3® finish lines will be expanding in 2023 to include some familiar voices as well as new ones. As the IRONMAN community bids farewell to Mike Reilly, the most famous voice in the...

Events

Press Releases

Triathlon

April 13, 2023

COROS and NN Running launch the Eliud Kipchoge ‘Road to Boston’ Giveaway

Irvine, April 13, 2023 /ENDURANCE SPORTSWIRE/ – COROS Wearables Inc., makers of endurance sports wearables and training software, announced that it has teamed up with NN Running Team to launch the Eliud Kipchoge Road to Boston Giveaway, in the run-up to the Boston Marathon 2023. COROS and NN Running Team have teamed...

Events

Press Releases

Running

April 13, 2023

Marathon Returns to Christie Clinic Illinois Race Weekend in 2024

CHAMPAIGN, Ill.  /ENDURANCE SPORTSWIRE/ – For the first time since 2019, the full marathon distance is confirmed to be returning to Christie Clinic Illinois Race Weekend in 2024 on Apr. 27. Race organizers held a press conference on Wednesday where they revealed the new marathon course map, the process by which...

Events

Press Releases

Running

April 12, 2023

MB-2 Bomber Featured at Upcoming Virtual Race

WRIGHT- PATTERSON AIR FORCE BASE, Ohio /ENDURANCE SPORTSWIRE/ - The MB-2 (NBS-1) Bomber will be the third retired aircraft to headline the 2023 History & Heritage Race Series, powered by the Air Force Marathon, beginning May 1. The event marks the third of six virtual races during the series’s third...

Events

Press Releases

April 12, 2023

Article One Enlists Web3 Running Community, Run As You Are, in Hosting Digital Donation Drive to Protect the Great Lakes Basin’s Water

FLINT, Mich. (April 12, 2023) /ENDURANCE SPORTSWIRE/ – Article One, the award-winning independent eyewear brand, and Run As You Are, a digital running community offering immersive online experiences, today announced a virtual Earth Week campaign that will raise funds for the Michigan-based water conservation nonprofit, FLOW (For Love of Water). The...

Events

Giving

Running

April 12, 2023

The Championship Confirms Free Live Stream in Partnership with ROUVY

12 April 2023 /ENDURANCE SPORTSWIRE/ – The Championship, the flagship event of Challenge Family taking place on 21 May, has announced the event will broadcast for free via live stream in partnership with ROUVY. With a professional field of over 60 athletes, including defending champion Sara Perez Sala (ESP), Fenella Langridge (GBR),...

Events

Press Releases

Sponsorship

Triathlon

April 12, 2023

Dr. Squatch to be Official Soap Partner With Spartan

BOSTON, MASS. (4/12/23) /EMDURANCE SPORTSWIRE/ - Spartan, the world's leading endurance sports and extreme wellness brand, announced Dr. Squatch will be the Official Soap and Body Wash Partner for select races in the 2023 race season Spartans love this brand and their products! We are very excited to be working...

Business

Events

Press Releases

Products

Running

Sponsorship

April 12, 2023

BibRave and Nuun® Hydration Team Up to Deliver Nuun-Inspired Art Gallery at 2023 Boston Marathon

/ENDURANCE SPORTSWIRE/ – BibRave, the premier marketing agency in the fitness and endurance space, is partnering with Nuun® Hydration to create an experiential activation at the 2023 Boston Marathon on April 15. On display at the Pellas Contemporary Art Gallery, the Nuun® Gallery combines an immersive cultural event with education about healthy...

Events

Press Releases

Running