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

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

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

August 22, 2023

U.S. Air Force Special Warfare to Partner With Spartan

BOSTON, MASS. (08/22/2023)/ENDURANCE SPORTSWIRE/ – Spartan, the world’s leading endurance sports and extreme wellness brand, announced that the U.S. Air Force Special Warfare will return as an Official Partner of select races in August 2023 to April 2024. “At Spartan, we pride ourselves on promoting the same traits military recruiters...

Events

Press Releases

Running

Sponsorship

August 21, 2023

Miami Nights Crowned Champions of the NCL Cup Series After Electrifying Weekend of Racing in Atlanta

ATLANTA /ENDURANCE SPORTSWIRE/ – The National Cycling League (NCL) wrapped up its thrilling three-part race series this weekend in Atlanta. On Saturday, Aug. 19, fans gathered at Bearings Bike Works for the Team Qualifier. The event was an embodiment of community spirit, where families came together to watch competitors push their...

Cycling

Events

Press Releases

August 21, 2023

XTERRA Costa Rica joins 2024 Americas Tour

/ENDURANCE SPORTSWIRE/ – XTERRA, the global leader in off-road triathlon, is pleased to announce the addition of XTERRA Costa Rica, presented by Coopenae, to the 2024 XTERRA Americas Tour. The three-day outdoor sports festival will be held August 23-25, 2024, at Las Catalinas, a beautiful car-free beach town in the...

Events

Press Releases

Triathlon