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 3360, 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

Uber Eats to treat Boulderthon® runners to top-notch experience at new Downtown Start Village

BOULDER, Colo./ENDURANCE SPORTSWIRE/ – Boulderthon®, the fastest-growing running series in Colorado, has announced a brand new partnership with Uber Eats for the 2023 event. The on-demand delivery app and website that helps bring millions of people around the world the things they want at the tap of a button will be...

Press Releases

Running

Sponsorship

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

Showcased

Nonaste Announces Big Savings on Popular Performance Laundry Detergents and Car Seat Protectors for Active People on Prime Day – July 11 through July 12. Early access deals beginning July 8.

SAN DIEGO, CA – June 29, 2023/ENDURANCE SPORTSWIRE/ – Nonaste®, pronounced “No Nasty!”, high-performance laundry detergents, and sweat-proof/water-proof premium car seat protectors is announcing Big Savings of 25% - 30% from July 8 through July 12 during Amazon Prime Day, just in time for workouts, runs, yoga, and beach fun in...

Press Releases

Products

June 29, 2023

USA Cycling Welcomes BikeInsure as Official Bicycle Insurance Partner

Colorado Springs, Colorado /ENDURANCE SPORTSWIRE/ – We are thrilled to announce that USA Cycling has partnered with BikeInsure through 2026, a bicycle insurance company that shares our commitment to promoting the crucial 'need' of protecting bicycles with its specialty bike insurance policy. As a USA Cycling member, you can quickly sign up...

Cycling

Press Releases

Sponsorship

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