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

August 24, 2023

XTERRA World Cup Rolls Into the Rockies

/ENDURANCE SPORTSWIRE/ – The sixth of seven stops on the inaugural XTERRA World Cup takes place this Saturday, August 26, high up in the Rockies at Beaver Creek Resort in Avon, Colorado. As the last full-distance race on the World Cup schedule prior to the XTERRA World Championship in Italy...

Events

Press Releases

Triathlon

August 24, 2023

The Bayport Foundation Crawlin’ Crab Half Marathon Weekend Announces New 5K Course and Post Race Celebration Entertainment

August 24, 2023 – HAMPTON, VIRGINIA /ENDURANCE SPORTSWIRE/ – With over 2,500 runners expected to descend into Hampton the first weekend of October, the BayPort Foundation Crawlin’ Crab Half Marathon & 5K presented by Bon Secours is primed to be a spectacular experience. New for 2023 is a brand new and...

Events

Press Releases

Running

August 24, 2023

Ultra X Launch in the US

/ENDURANCE SPORTSWIRE/ – Global ultra-marathon events series, Ultra X launch their first race in the USA, a 5 day, 220km race around Red Rock Conservation Area and the Spring Mountain Recreation Area, adding to their collection of life-changing experiences. Ultra X Nevada is a multi-stage ultra-marathon taking place over five...

Events

Press Releases

Running

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

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