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

August 9, 2023

Valente Successfully Defends Omnium World Title, Earns Second Rainbow Jersey of the Week

August 9, 2023, GLASGOW /ENDURANCE SPORTSWIRE/ - On the final night of track cycling at the 2023 UCI Cycling World Championships, Jennifer Valente (San Diego; TWENTY24 Pro Cycling) successfully defended her World Championship Title in the Women’s Omnium. “To back up last year is really special in a different kind of...

Cycling

Events

Press Releases

August 9, 2023

IRONMAN 70.3 Oregon Triathlon extended in Salem for an additional five years

SALEM, Ore. / TAMPA, Fla. (August 9, 2023)/ENDURANCE SPORTSWIRE/ – IRONMAN and Travel Salem have agreed to a five-year agreement to keep the IRONMAN® 70.3® Oregon triathlon in Salem, Oregon through 2028. The event, which has sold out every year since it was first announced in 2021, remains one of the...

Events

Press Releases

Triathlon

August 9, 2023

PTO Signs Up Leading Beverage Brand POKKA For First PTO Asian Open

London, UK /ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) has signed leading Asian beverage brand POKKA as the Official Drinks Partner of the PTO Asian Open. The one-year partnership will start at this month’s inaugural PTO Asian Open in Singapore on 19-20 August and focus its activity around on-course product at...

Press Releases

Sponsorship

Triathlon

August 9, 2023

USA Triathlon Approves 80/20 Endurance Coaching Certification for 4 CEUs

Lehi, UTAH/ENDURANCE SPORTSWIRE/ - 80/20 Endurance, a trailblazing provider of online training resources for endurance athletes and coaches, is thrilled to announce a major achievement: our renowned 80/20 Endurance Coaching Certification Course has been officially endorsed by USA Triathlon, enabling participants to earn 4 Continuing Education Units (CEUs). "This milestone...

Business

Press Releases

Triathlon

August 9, 2023

Sprint finish at Inaugural GFNY Rockford-Illinois

New York City, August 9, 2023 /ENDURANCE SPORTSWIRE/ - Rockford hosted the inaugural edition of GFNY Rockford this past Sunday. The race course was 93.6 miles long with an elevation gain of 3583 feet. The race started off fast and already by mile 1.5, forty riders formed the lead group....

Cycling

Events

Press Releases

August 9, 2023

Endurance Quest Espoo Returns to the Adventure Racing World Series

/ENDURANCE SPORTSWIRE/ – After a nine-year break, the legendary Endurance Quest Espoo (FINLAND) Adventure Race returns to the Adventure Racing World Series this coming weekend – and once again the race is sold out. Thirty-two teams, two more than planned, will start their 226-kilometer challenge on Saturday morning at 10am....

Cycling

Events

Press Releases

Running

August 8, 2023

Williams Takes Fourth in the Points Race on the Penultimate Day of Track World Championships

August 8, 2023, GLASGOW /ENDURANCE SPORTSWIRE/ - Day six of the 2023 UCI Cycling World Championships saw Lily Williams (Tallahassee, Fla.; Human Powered Health) battle for points, lap after lap, to earn fourth. Around the Glasgow City Circuit, the Americans competed in the Team Time Trial Mixed Relay. After a valiant...

Cycling

Events

Press Releases

August 8, 2023

Advances in Endurance Sports Medicine on Display at Cape Elizabeth Marathon

Plymouth, MA/ENDURANCE SPORTSWIRE/ – Sports Medicine Consultants, LLS an industry leader of medical coverage services for large athletic events, unveiled their latest device to move injured participants more effectively. Called the REX Rapid Extraction Mobile Stretcher, it is redefining the industry by allowing a single person to effortlessly move any patient...

OSW Syndicated

Press Releases

Products

Running

Triathlon

August 8, 2023

2023 City2Surf Returns This Weekend

/ENDURANCE SPORTSWIRE/ - With just five days until the City2Surf returns the countdown is on as the world’s largest fun run gets ready to set the streets of Sydney alive with its sea of colour and party atmosphere. This Sunday, more than 75,000 people will line up for this world-famous...

Events

Press Releases

Running