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

August 24, 2023

Cycling travel experts Sportive Breaks announce new partnership with Active on Holiday

August 2023 - UK/ENDURANCE SPORTSWIRE/ – Cycling travel experts, Sportive Breaks promote bespoke premium travel packages for cyclists looking to take part in the world’s most prestigious grand tours, cycling classics and weekenders. They offer a range of customised travel packages including cycling tours, training camps, hospitality, and VIP experiences, allowing...

Business

Cycling

Events

Press Releases

August 24, 2023

Superstar Line-Up Ready To Begin Super League Triathlon’s $1.24m Championship Series In London

/ENDURANCE SPORTSWIRE/ – Super League Triathlon’s 2023 Championship Series gets underway in London this weekend with a stellar field of athletes competing for individual and team honours as well as a slice of the massive $1.24m prize pool. West India Quay will play host to the stars of the sport...

Events

Press Releases

Triathlon

August 24, 2023

Tri The Wildwoods Triathlon Celebrates 20 Years

North Wildwood, New Jersey, August, 2023/ENDURANCE SPORTSWIRE/ – What started as a bit of a “side hustle” for Stephen Del Monte in his hometown of North Wildwood NJ, The Tri the Wildwoods Triathlon has become the foundation for the meteoric growth of DelMoSports as one of the leading multisport production companies in...

Events

Press Releases

Triathlon

August 24, 2023

Super Sunday: two GFNY races on same day

/EMDIRANCE SPORTSWIRE/ - GFNY Sweden Uppsala The inaugural edition of GFNY Uppsala starts from Ulva Kvarn and offers racers a 133.8 km long course with 1592m of climbing. The course will take riders along rolling hills of glorious Uppsala countryside. There will also be hard packed unpaved road segments which...

Cycling

Events

Press Releases

August 24, 2023

Expedicion Guarani is the last 2023 Adventure Racing World Championship Qualifier

/ENDURANCE SPORTSWIRE/ – Expedicion Guarani in Paraguay offers the last available qualifying place for the last the 2023 Adventure Racing World Championship in South Africa in October. Expedición Guaraní is far from taking a break after organizing their own triumphant World Championships last year. The organizing team, led by the...

Cycling

Events

Press Releases

Running

August 24, 2023

Scarab Cycles Launches Darien Mountain Bike

EL RETIRO, Colombia /ENDURANCE SPORTSWIRE/ - Scarab Cycles, is thrilled to announce the launch of the Scarab Darien, an adventure-ready, yet racy, hardtail mountain bike. Inspired by the legendary Darien Gap, a remote and challenging stretch of untamed jungle that is so deep that has kept South America disconnected by...

Cycling

Press Releases

Products

August 24, 2023

The Kerrville Tri and evamor Enhance Partnership

AUSTIN, Texas /ENDURANCE SPORTSWIRE/ – The Kerrville Triathlon Festival welcomes evamor as Official Water sponsor for the second year in a row. In addition to providing water to all finishers, the company will keep staff and volunteers hydrated as well as offer the public a chance to try the water at...

Events

Press Releases

Sponsorship

Triathlon

August 23, 2023

Malibu Triathlon Returns to Benefit Pediatric Cancer Research Program at Children’s Hospital Los Angeles

MALIBU, Calif. /ENDURANCE SPORTSWIRE/ - The Malibu Triathlon, presented by Super League Triathlon returns to Zuma Beach for its 38th Annual swim-bike-run race weekend on Sept. 30 - Oct. 1, 2023. More than 5,000 athletes, including Hollywood celebrities, will test their fitness as they raise critical funds for the Pediatric Cancer...

Giving

Press Releases

Triathlon

August 22, 2023

Footwear Study Reveals Data Proving the BOA PerformFit Wrap Improves Runner Speed, Stability, Efficiency on Trail Terrain

Denver, CO (August 22, 2023)/ENDURANCE SPORTSWIRE/ – BOA®, creators of high-performance dial-based fit solutions, unveils trail run-specific footwear study that scientifically proves the BOA® Fit System and its PerformFit™ Wrap improves athlete’s speed, stability, and efficiency on varied trail terrain, over traditional laces. The BOA Performance Fit Lab, established in 2018, has...

Press Releases

Products

Running

Studies

August 22, 2023

2023 VinFast IRONMAN 70.3 World Championship by the Numbers: Lahti, Finland Set to Host Top Triathletes from Around The Globe on August 26 & 27

- More than 6,000 registered athletes from 115 countries, regions and territories will converge in Lahti, Finland for the 2023 VinFast IRONMAN 70.3 World Championship triathlon - The United States of America is the most represented nation followed by France, Germany, United Kingdom, and Australia, with athletes also flying in...

Events

Press Releases

Triathlon