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

June 25, 2024

Project Mayhem CX Announces Inaugural Cyclocross Race Series in Connecticut

Connecticut, USA /ENDURANCE SPORTSWIRE/ - PMCX (Project Mayhem CX) is thrilled to announce the launch of its inaugural cyclocross race series, set to kick off this September. This new series aims to deliver a fun and exciting regional cyclocross experience that is inclusive and welcoming to all racers, regardless of...

Cycling

Events

Press Releases

Sponsorship

June 25, 2024

Battle Of The Brits: Charles-Barclay Leads Strong British Line Up For London T100 Triathlon

London, UK/ENDURANCE SPORTSWIRE/ – T100 series leader Lucy Charles-Barclay will get the chance to win her first T100 race on home soil, as the Professional Triathletes Organisation (PTO) and World Triathlon announced the 15 contracted female athletes taking the start line for the London T100 Triathlon on 27-28 July next...

Events

Press Releases

Triathlon

June 25, 2024

Over 40 Professional Athletes Line Up for Challenge Cagnes-sur-Mer

/ENDURANCE SPORTSWIRE/ – Challenge Family racing is back to France’s Côte d’Azur this weekend for the second edition of Challenge Cagnes-sur-Mer. This year's event features a strong professional field with 48 professional athletes competing. In the men's field, Jack Moody (AUS) has a great record. The Challenge Family Bonus ranking...

Events

Press Releases

Triathlon

June 25, 2024

The Countdown is on to Crusher in the Tushar

Beaver, Utah (Wednesday, June 25) /ENDURANCE SPORTSWIRE/ – The Life Time Grand Prix presented by Mazda returns for the third race of the series on Saturday, July 13th with the Life Time Crusher in the Tushar. This noted event in Beaver, Utah, is arguably the toughest 69.9-mile race on the planet...

Cycling

Events

Press Releases

June 24, 2024

IRONMAN Comes to Illinois for First Time with New IRONMAN 70.3 Triathlon to be Hosted in Rockford

- Inaugural IRONMAN 70.3 Rockford-Illinois triathlon is scheduled to take place on June 22, 2025 - General registration to open on July 1, 2024, at www.ironman.com/im703-rockford-illinois ROCKFORD, Ill. / TAMPA, Fla. (June 24, 2024) /ENDURANCE SPORTSWIRE/ – IRONMAN, the global leader in long-distance triathlon, announced today that it will host...

Events

Press Releases

Triathlon

June 24, 2024

Rouvier and Morvillo Win XTERRA Switzerland Amidst Challenging Conditions

VALLÉE DE LA BRÉVINE, SWITZERLAND /ENDURANCE SPORTSWIRE/ – XTERRA Switzerland marked the 11th stop of the 2024 XTERRA EMEA Tour on June 22, 2024. Valentin Rouvier (FRA) and Bianca Morvillo (ITA) were victorious in the valley beneath the Neuchâtel mountains. The two-day event attracted both local and international competitors offering...

Cycling

Events

Press Releases

Running

Triathlon

June 24, 2024

Smiles Shine Through Rain-Soaked 2024 Boston 10K presented by Brigham and Women’s Hospital

BOSTON /ENDURANCE SPORTSWIRE/ – More than 8,100 athletes took part in today’s 2024 Boston 10K presented by Brigham and Women’s Hospital persevering through intermittent downpours to reach the finish at Boston Common. Sabastian Sawe (Kenya) and Melknat Wudu (Ethiopia) each won their first B.A.A. event, breaking the tape in 27:42...

Events

Press Releases

Running