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

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

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

June 29, 2023

BikeBox Partners with the Adventure Racing World Series

/ENDURANCE SPORTSWIRE/ - Taking on an expedition-length adventure race by foot, bike and kayak is the challenge that teams face when they enter one of the Adventure Racing World Series Qualifier events held in exotic locations around the world each year. Getting to the start line can be just as...

Business

Cycling

Events

Press Releases

Products