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

October 11, 2022

The Challenged Athletes Foundation Returns to Deliver the Ultimate Inclusive Sports Weekend To Support Athletes With Physical Challenges

SAN DIEGO, CA /ENDURANCE SPORTSWIRE/ - Returning to Mission Bay, the Challenged Athletes Foundation (CAF) is set to host its flagship event, the Community Challenge, powered by Strava featuring the San Diego Triathlon Challenge presented by Dan and Geof, from Friday, October 21 - Sunday, October 23. Entering its 29th year,...

Events

Giving

Press Releases

Triathlon

October 11, 2022

Mardi Gras Mambo welcomes Baton Rouge General as Title Sponsor

Baton Rouge, LA /ENDURANCE SPORTSWIRE/ - On your mark, get set, go! Carnival season starts early as FRESHJUNKIE Racing (FJR) is thrilled to announce registration is Now Open for the 2023 Baton Rouge General Mardi Gras Mambo. The event boasts a distance for everyone from beginners to runners dipping their...

Business

Events

Press Releases

Running

Sponsorship

October 11, 2022

RunSignup Q3 Company Update

October 11, 2022 - Moorestown, NJ /ENDURANCE SPORTSWIRE/ - RunSignup, the leading registration provider for U.S. endurance events, provides a third quarter update. Data continues to show signs of the endurance industry improving after the long effects from the pandemic - yet Hurricane Ian’s impact on the industry was immediate...

Business

Cycling

Events

Giving

Press Releases

Running

Triathlon

October 11, 2022

2023 Missoula Marathon to Include Prize Money for Non-Binary Participants

Missoula, MT. /ENDURANCE SPORTSWIRE/ – The Missoula Marathon, organized by the nonprofit Run Wild Missoula, has long been a leader in celebrating and welcoming the LBGTQ+ community. In 2023, race organizers will back up their commitment to gender inclusion by offering equal prize money for winners of male, female, and non-binary...

Events

Press Releases

Running

October 11, 2022

Samsung to be the Official Smartwatch of Spartan US and Tough Mudder US

BOSTON, MASS. (10/11/22) /ENDURANCE SPORTSWIRE/ - Leading endurance sports and extreme wellness brands Spartan and Tough Mudder have announced that Samsung will be the official smartwatch of both US entities for the remainder of the 2022 race season. “We are excited to have both our Spartan and Tough Mudder series...

Events

Press Releases

Running

Sponsorship

October 10, 2022

Rubicon Coffee and ATRA Partner for U.S. Mountain & Trail Team Fundraiser

/ENDURANCE SPORTSWIRE/ - Nevada-based Rubicon Coffee has partnered with the American Trail Runners Association to offer their Long Distance Dark Roast for an exclusive fundraiser to support America’s fastest mountain and trail runners. “We have been raising funds to help offset travel costs for athletes to the World Championships since ATRA’s...

Events

Giving

Press Releases

Sponsorship

October 10, 2022

History Made at the 2022 VinFast IRONMAN World Championship

KAILUA-KONA, Hawai`i (October 10, 2022) /ENDURANCE SPORTSWIRE/ - After a long three-year hiatus, the IRONMAN World Championship returned to the Kailua-Kona and the Island of Hawai`i and with it an abundance of inspiration and history made. Below are some of the significant moments at this year’s event, that was held...

Events

Press Releases

Triathlon

October 10, 2022

Filippo Ganna Smashes Cycling’s Famed Hour Record Riding World-First Pinarello Custom 3D Printed Bike

Solana Beach, CA. (Oct. 10, 2022) /ENDURANCE SPORTSWIRE/ – On Saturday, Filippo Ganna, 26, an Italian track and road cyclist who rides for the Ineos Grenadiers team, recorded the longest distance ever ridden in one hour at the Tissot Velodrome in Grenchen, Switzerland. Ganna rode 56.792 kilometers (35.288 miles) on a fully 3D-printed...

Cycling

Events

Press Releases

October 10, 2022

National Day of Spain with La Vuelta on ROUVY – Celebrate the fiesta and get fit on a virtual journey!

Madrid, Spain / October 10th, 2022/ENDURANCE SPORTSWIRE/ – With the indoor training season starting, the international community of endurance sports gets ready to spend more and more time on their trainers every day. ROUVY turns this training routine into fun fitness sessions with an added value for everyone - learning geography...

Cycling

Events

Press Releases