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

June 30, 2023

The Third AR World Series South American Championship Opens Registration

/ENDURANCE SPORTSWIRE/ – The third ARWS South American Series is already underway and registrations are now open to bring together 160 athletes from across the continent at the Championship final in Brazil. After the Championship races of the 2020 and 2021 series at the Vulcania AR at Pucón in Chile and...

Events

Press Releases

June 30, 2023

Stoked Oats athlete Gene Dykes an inspiration for all at the 50th running of the Western States Endurance Run

Auburn, CA, June 30, 2023 /ENDURANCE SPORTSWIRE/ - Stoked Oats (SO) athlete and septuagenarian Gene Dykes, inspired all in attendance at the 2023 Western States event, proving that it’s never too late to find passion in running. Although Gene did not finish the race and complete the goal of becoming...

Events

Press Releases

Running

Sponsorship

June 29, 2023

USA Cycling Announces 2023 BMX Freestyle World Championship Teams

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ - The 2023 UCI Cycling World Championships will make history in Glasgow, Scotland as the first World Championship where 13 events will be contested across 7 disciplines. 11 athletes will compete in the BMX Freestyle Park contest August 5-7, 2023. All athletes will compete in the...

Cycling

Events

Press Releases

June 29, 2023

Long Beach Marathon Highlights Partnership with the Aquarium of the Pacific for National Aquarium Month

Long Beach, California – June 29, 2023 /ENDURANCE SPORTSWIRE/ – The Long Beach Marathon and Half Marathon is kicking off its partnership with the nonprofit Aquarium of the Pacific during National Aquarium Month in June. The two community institutions are once again coming together to host the Aquarium of the Pacific...

Events

Press Releases

Running

Sponsorship

June 29, 2023

XTERRA France this Weekend in Xonrupt

/ENDURANCE SPORTSWIRE/ – The 16th annual XTERRA France off-road triathlon takes place this Sunday, July 2, in the beautiful Vosges mountains of Xonrupt. It’s the 12th of 21 stops on the 2023 XTERRA EMEA Tour, and annually draws thousands of racers and fans from around the world to the beautiful lake...

Events

Press Releases

Triathlon

June 29, 2023

GFNY tackles L’Alpe d’Huez at GFNY La Vaujany this Sunday

New York City, June 29, 2023 /ENDURANCE SPORTSWIRE/ - This Sunday, mountain village Vaujany, located in the French Alps, will host the third edition of GFNY La Vaujany. The challenging race course is 151 km long with an elevation gain of 3914m. Riders will tackle the lesser known Col de...

Cycling

Events

Press Releases

June 29, 2023

National Cycling League’s Second Race of Inaugural Series Set for August 13 in Denver

DENVER /ENDURANCE SPORTSWIRE/ - The National Cycling League (NCL), the first-of-its-kind professional cycling league, has announced the second race of its inaugural NCL Cup race series is set for Sunday, Aug. 13 at Dick’s Sporting Goods Park in Commerce City, Colorado, located just minutes from downtown Denver. Ten co-ed teams...

Cycling

Events

Press Releases

Triathlon

June 29, 2023

USA Triathlon’s Endurance Exchange Presented by BOA Nutrition Heading to Charlotte In 2024

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ - USA Triathlon’s fifth annual Endurance Exchange presented by BOA Nutrition endurance sports industry conference will be held in person Jan. 4-7, 2024 in Charlotte, North Carolina, offering endurance sports professionals and athletes the best educational and networking opportunities in the industry. With live sessions presented...

Events

Press Releases

Trade Shows

Triathlon

June 29, 2023

AdventureCORPS Presents the Badwater 135 Ultramarathon on July 4-6, 2023

Lone Pine, CA/ENDURANCE SPORTSWIRE/ – On July 4-6, 2023, AdventureCORPS will present its legendary BADWATER® 135 Ultramarathon, the 135-Mile World Championship. Now in its 46th year, this world-renowned event pits up to 100 of the world's toughest athletes against one another and the elements in a crucible like no other. From below sea level in...

Events

Press Releases

Running