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

December 10, 2023

Mississippi Gulf Coast Marathon Weekend: A Resounding Success!

BILOXI, MS. /ENDURANCE SPORTSWIRE/ - The Mississippi Gulf Coast Marathon Weekend reached its peak on Sunday morning as participants from across the nation crossed the finish line with remarkable achievements in the Marathon and Half Marathon. The coastal landscape served as a stunning backdrop for the runners, who showcased exceptional...

Business

Events

Press Releases

Running

Sponsorship

December 10, 2023

Eight Titles Awarded on the Third Day of Cyclocross Nationals at Joe Creason Park

LOUISVILLE, Ky. /ENDURANCE SPORTSWIRE - It was another beautiful day in Louisville for the 2023 USA Cycling Cyclocross National Championships. With lines being dialed in and course conditions drying out, each race saw a battle of attrition as riders from around the country competed for the coveted Stars and Stripes...

Cycling

Events

Press Releases

December 10, 2023

Colorado Mesa University and University of Colorado Boulder Claim 2024 Collegiate Cyclocross Omnium Titles

December 8, 2023, LOUISVILLE, Ky. /ENDURANCE SPORTSWIRE/ - Warm temperatures, overcast skies, and low dew points greeted the fourth day of the 2023 USA Cycling Cyclocross National Championships took place on Friday. The Masters Women, Men’s and Women’s Singlespeed, Collegiate Team Relays, and Non-Champ Team Relay took on the 1.7-mile...

Cycling

Events

Press Releases

December 9, 2023

Junior Racing Kicks off the Penultimate Day of Cyclocross National Championships

December 9, 2023,  LOUISVILLE, Ky. /ENDURANCER SPORTSWIRE/ - On the penultimate day of the 2023 USA Cycling Cyclocross National Championships, massive junior fields brought exciting showdowns. With course conditions changing rapidly, from slick in the morning to wet around lunchtime, and finishing with a mud-fest for the final races, the...

Cycling

Events

Press Releases

December 9, 2023

LLama – a new App by CWRB

[Australia, Brisbane, 9 December 2023] /ENDURANCE SPORTSWIRE/ - This World Llama Day, Chicks Who Ride Bikes (CWRB) - Australia’s largest women’s cycling community – announced today that they have launched a new and improved mobile app for female cyclists. In addition to the features released on the pilot app (cwrb),...

Business

Cycling

Events

Press Releases

Products

Triathlon

December 8, 2023

Kane Footwear Launches Collab Shoe with Matt Choi

Westport, CT (December 8, 2023) /ENDURANCE SPORTSWIRE/ - Kane Footwear is thrilled to announce the launch of their collaborative Revive design in partnership with running influencer and personal trainer Matt Choi. The shoe features a sky blue base color with yellow and dark blue speckles, along with Choi’s tagline “Limitless”...

Business

Press Releases

Products

Running

December 8, 2023

Perceev Announces Partnership with Triathlon Industry Legend, Bob Babbitt

December 8, 2023 /ENDURANCE SPORTSWIRE/ - Perceev, an innovative new software as a service platform for endurance races, is thrilled to announce its partnership with USA Triathlon and Ironman Hall of Famer Bob Babbitt, who will play a key role on the advisory board. Bob has been a part of...

Business

Press Releases

Products

December 8, 2023

2024 Race Across America to Finish in Atlantic City

Boulder, CO /ENDURANCE SPORTSWIRE/ - The executive management of Race Across America, Inc. (the Company) recently announced the 2024 Race Across America (RAAM) finish will be in Atlantic City, New Jersey. RAAM - widely known as The World’s Toughest Bicycle Race – is a 3000-mile coast-to-coast race across the America....

Business

Cycling

Events

Press Releases