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

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

June 29, 2023

46th Crim 10-Mile Race Seeks Title Sponsor

Flint, MI /ENDURANCE SPORTSWIRE/ –The HAP Crim Festival of Races, the signature event of the Crim Fitness Foundation, is returning to the historic bricks of downtown Flint for the 46th time August 25-26. The Festival, home to one of the nation’s largest and oldest 10-mile races, the “Crim,” is seeking a...

Events

Press Releases

Running

Sponsorship

June 29, 2023

Chasing Watts releases new details of their Chasing Watts Century Challenge.

/ENDURANCE SPORTSWIRE/ - Chasing Watts, the leading app for connecting cyclists with group rides, is thrilled to announce the fourth edition of the highly anticipated Chasing Watts Century Challenge. This year, the challenge takes on a new and exciting twist, as it puts the power in the hands of ride...

Cycling

Events

Press Releases

Sponsorship

June 29, 2023

Big River Race Management Hosts RRCA National Mile Championship at Macklind Mile

ST. LOUIS (June 29, 2023) /ENDURANCE SPORTSWIRE/ - Big River Race Management hosted the Road Runners Club of America’s National Mile Championship at its Macklind Mile event on June 24, 2023. The 16th annual Macklind Mile crowned RRCA National Mile Champions in the following categories: Top Overall Male – Noah Stevenson...

Events

Press Releases

Running

June 29, 2023

Atlanta Chosen by The National Cycling League to Host Inaugural Series Race

ATLANTA /ENDURANCE SPORTSWIRE/ - The National Cycling League (NCL), the first-of-its-kind professional cycling league, has announced that the third race of its inaugural NCL Cup race series is set for Sunday, August 20 at 12 p.m. in Atlanta. Ten co-ed teams of professional cyclists – including multiple Olympians, former Tour...

Cycling

Events

Press Releases

Triathlon

June 28, 2023

Jesper Svensson and Antony Costes to go head-to-head at Challenge Vansbro

/ENDURANCE SPORTSWIRE/ – Costes could use a win after failing to defend his title at Challenge Geraardsbergen earlier this month. At Challenge Vansbro, the Frenchman hopes to forget that negative feeling and for that reason alone he will be one hundred percent committed - or maybe even extra - to take...

Events

Press Releases

Triathlon

June 28, 2023

Safa Brian Announces “Tour to The Tour”

/ENDURANCE SPORTSWIRE/ – Safa Brian, cyclist and filmmaker, announced in a video on his YouTube channel today that he and two of his talented friends—Alex Colorito (videographer) and Taylor Dawson (cyclist)—are departing on Saturday, July 2nd, for a European bike adventure. Over ten days, the crew will enjoy a route that...

Cycling

Events

Press Releases

June 27, 2023

2023 IRONMAN 70.3 Mont-Tremblant Triathlon Rescheduled to take place on August 20 in conjunction with the full distance IRONMAN Mont-Tremblant Triathlon, part of the VinFast IRONMAN North America Series

MONT-TREMBLANT, QUEBEC, CANADA (June 27, 2023)/ENDURANCE SPORTSWIRE/ – IRONMAN and Tremblant Resort are pleased to announce that the IRONMAN® 70.3® Mont-Tremblant triathlon has been rescheduled for Sunday, August 20, 2023. The event, which was originally scheduled to take place on Sunday, June 25 was cancelled due to the devastating wildfires that...

Events

Press Releases

Triathlon