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

February 17, 2023

Alchemy Bikes Increases Rear Travel on Two Arktos MTBs; Pre-Order Now

Golden, Colorado (February 17, 2023) /ENDURANCE SPORTSWIRE/ – Addressing what they see as the future of mountain bike design, Alchemy Bikes – a leading fabricator-to-rider boutique bike manufacturer – is updating its critically acclaimed Arktos line of full-suspension carbon mountain bikes for 2023 with longer rear travel on two of its most...

Cycling

Press Releases

Products

Triathlon

February 17, 2023

2023 Sea Otter Classic Summit to Host Can’t-Miss Outdoor Industry Event

MONTEREY, Calif. (Feb. 17, 2023) /ENDURANCE SPORTSWIRE/ – The Sea Otter Classic Summit produced by Life Time, is set to host an industry-exclusive dinner at the Monterey Bay Aquarium on April 19, 2023 - the final day of the renowned Summit. The Monterey Bay Aquarium provides a one-of-a-kind backdrop for this unique...

Cycling

Press Releases

Trade Shows

February 17, 2023

The IRONMAN Foundation Celebrates 20th Anniversary

TAMPA, Fla. (Feb. 17, 2023) /ENDURANCE SPORTSWIRE/ - This month, The IRONMAN Foundation, whose mission is to create positive, tangible change in IRONMAN® and Rock ‘n’ Roll® Running Series race communities through grant funding and volunteerism, kicks off the celebration of its 20th anniversary of service. Since its inception in...

Giving

Press Releases

Running

Triathlon

February 17, 2023

Non-Executive Board Established for the Adventure Racing World Series

/ENDURANCE SPORTSWIRE/ - Following the announcement of new ownership for the Adventure Racing World Series, under the leadership of Heidi Muller, a new Non-Executive Board has been formed and held their first meetings and discussions. The formation of the new board and its inaugural meeting on February 9th, took place...

Business

Press Releases

February 17, 2023

Best Bike Split Announces 2023 Season Partners

Austin, TX /ENDURANCE SPORTSWIRE/ - Best Bike Split, the leading provider of race-pacing technology and analysis, is proud to announce its continued support of the World's top Men's and Women's cycling teams in 2023. The company will sponsor teams competing at the highest UCI World Tour level, including CANYON//SRAM, Trek-Segafredo,...

Cycling

Press Releases

Sponsorship

Triathlon

February 17, 2023

The Ascension Seton Austin Marathon Weekend Kicks Off Today

AUSTIN, Texas, February 17, 2023 /ENDURANCE SPORTSWIRE/ – The Ascension Seton Austin Marathon, Half Marathon and 5k is set to take place this weekend in Austin, Texas. Highlights of this world-class event include three race distances for participants of all speeds and abilities, the Health & Fitness Expo, and a 3-block-long...

Events

Press Releases

Running

February 16, 2023

AbbottWMM Global Run Club launches The Road to the Majors

MEDIA ALERT February 16, 2023 /ENDURANCE SPORTSWIRE/ – The AbbottWMM Global Run Club today launched a virtual six-race half marathon series - The Road to the Majors – to give runners on their Six Star journey additional chances to enter draws for the Abbott World Marathon Majors they still need to accomplish. For each...

Events

Press Releases

Running

February 16, 2023

SMITH Announces New Partnership with Santa Cruz RockShox Pro XC Team

Portland, Oregon (February 16, 2023) /ENDURANCE SPORTSWIRE/ – Smith is excited to announce this week its global partnership with the Santa Cruz RockShox Pro XC team as the official supplier of bike helmets and performance eyewear for the 2023-2024 seasons. The UCI World Cup Santa Cruz RockShox Pro XC team is...

Cycling

Press Releases

Sponsorship