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 (8742)
) 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 4560, 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

Athletic Brewing Company to Match First $100,000 Donated to The Michael James Jackson Foundation’s 2nd Annual Diversity Campaign

BROOKLYN, N.Y. - April 13, 2023 /ENDURANCE SPORTSWIRE/ - The Michael James Jackson Foundation for Brewing & Distilling (The MJF) has launched its second annual matching fundraising challenge in partnership with Athletic Brewing Company and ProBrewer. Beginning today and continuing through May 8, 2023, Athletic Brewing will match the first...

Awards

Business

Giving

Press Releases

Products

Sponsorship

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 13, 2023

Challenged Athletes Foundation Announces Annual Grant Distribution Totaling $7 Million in Support for 3,996 Individuals Across 101 Different Sports

SAN DIEGO, CA – April 12, 2023 /ENDURANCE SPORTSWIRE/ - The Challenged Athletes Foundation (CAF) is thrilled to announce its largest grant distribution, providing life-changing access to sports and physical activity through 3,996 grants valued at more than $7M. CAF is a world leader in the adaptive sports movement and...

Giving

Press Releases

April 13, 2023

Tifosi Optics includes Rail Race as part of its regular product offerings

Watkinsville, GA (April 13, 2023)  /ENDURANCE SPORTSWIRE/ – Tifosi Optics, the #1 selling brand of cycling eyewear in the United States, is excited to re-release its once limited edition Rail Race as part of its full-time lineup. Popular amongst cyclists but equally functional for other endurance pursuits, the Rail Race offers...

Cycling

Press Releases

Products

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

Alchemy Bikes Launches New Lycos Gravel Bike Option

Golden, Colorado (April 12, 2023)/ENDURANCE SPORTSWIRE/ – Just months after launching their flagship gravel bike, the Lycos Au, and just in time for the Sea Otter Classic bike expo, Alchemy Bikes – a leading fabricator-to-rider boutique bike manufacturer – is proud to announce a dramatic reduction in the entry price for the...

Cycling

Press Releases

Products

Triathlon

April 12, 2023

ORTLIEB Launches Soulo Everyday Carry Backpack

HEILSBRONN, Germany  /ENDURANCE SPORTSWIRE/ – ORTLIEB, the German brand known for its high-quality German-made bags, has just launched the Soulo backpack - the perfect urban companion for those who want to keep their things dry and stylish on the go. The Soulo daypack boasts a stylish and minimalist design, but don't...

OSW Syndicated

Press Releases

Products