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

Two-Time MLB All-Star Justin Turner Creates Signature Collection with Kaenon Sunglasses

Irvine, Calif (June 29, 2023)/ENDURANCE SPORTSWIRE/ – Kaenon is releasing its first signature sunglass collection with two-time MLB All-Star Justin Turner. The first installment of the Justin Turner Signature Collection from Kaenon includes two versions of the Arcata SR, Turner's preferred model for on-field play. Unlike typical athlete-endorsement relationships, Turner has a...

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

Aleck and SMITH Announce Strategic Partnership to Integrate Crash Sensor Technology into Bike Helmets for 2024

South Lake Tahoe, CA (June. 29, 2022) /ENDURANCE SPORTSWIRE/ – Aleck® – the industry-leading maker of wireless helmet audio systems for outdoor sports – and SMITH – the global market leader in snow goggles and helmets, and industry innovator across bike helmets, sport, lifestyle, and prescription eyewear – announce a strategic...

Cycling

Press Releases

Products

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

Pureboost, #1 Best-Selling Clean Energy Drink Launches Apple Cider Vinegar New launch comes off the heels of rapid growth into retailers and recent fundraise

San Diego, CA /ENDURANCE SPORTSWIRE/ - Pureboost, Amazon’s number one best-selling antioxidant clean energy drink, launches its newest product – Apple Cider Vinegar. In the convenience of a portable pack, Pureboost Apple Cider Vinegar is part of their Superfoods Clean Energy segment, and, as with all other products, is completely...

Business

Press Releases

Products

June 28, 2023

Kitman Labs Announces Transcontinental Deal with Chicago Fire and FC Lugano

Menlo Park California and Chicago, Illinois (June 28, 2023)/ENDURANCE SPORTSWIRE/ – Kitman Labs, the global SaaS platform providing the only single, centralized operating system for performance intelligence in the elite performance industry, announced a recent deal with the Chicago Fire of Major League Soccer (MLS) and FC Lugano of the Swiss Super...

Business

Press Releases

Products

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