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

April 1, 2022

A Journey Through The Kingdom in the Sky – Lesotho Welcomes Expedition Africa

/ENDURANCE SPORTSWIRE/ - D-Day is here for the teams and Race Directors of ‘Expedition Africa’, who have waited for 2, long years for the 10th edition of their expedition adventure race to take place. Lesotho, The Kingdom in the Sky’, is set to welcome teams, volunteers, media and referees from 19 nations,...

Events

Press Releases

April 1, 2022

Fôrs™ Partners with Prolific Sport Climber Jonathan Siegrist

Las Vegas, NV, April 1. 2022 /ENDURANCE SPORTSWIRE/ - Fôrs, LLC, a market-leading human performance company led by renowned Physical Therapist, Scott Pensivy, is proud to announce its exclusive partnership with America’s most prolific sport climber, Jonathan Siegrist. Jonathan, globally recognized as an example of true elite-level athleticism, has been...

Press Releases

Products

Sponsorship

April 1, 2022

Registration opens for third History & Heritage race

WRIGHT-PATTERSON AIR FORCE BASE, Ohio /ENDURANCE SPORTSWIRE/ - The 2022 History & Heritage Race Series opened registration for the next virtual race April 1, featuring fast and famous aircraft F-4 Phantom II just in time for warmer running temperatures. The upcoming event marks the third of six virtual races as the series...

Events

Press Releases

Running

April 1, 2022

Garmin Partner With Super League Triathlon To Deliver Deeper Insights At Arena Games Triathlon powered by Zwift World Championship Series

/ENDURANCE SPORTSWIRE/ - Garmin will help deliver even more insights into the action at the Arena Games Triathlon powered by Zwift in 2022. Super League Triathlon today announced that the Garmin ecosystem will again play a vital role in delivering multisport’s most innovative race series, the Arena Games Triathlon powered...

Press Releases

Sponsorship

Triathlon

March 31, 2022

Joggin’ for Frogmen 5K Race Series, benefiting Travis Manion Foundation, Expanding to Five Cities in 2022

March 31, 2022 (Doylestown, PA) /ENDURANCE SPORTSWIRE/ -  The Joggin’ for Frogman 5K race series, honoring the sacrifices of service members and support families of fallen heroes, is expanding to a five-race national series in 2022. Registration is currently open for this year’s races including in-person events in Pittsburgh, PA (May 21),...

Events

Giving

Press Releases

Running

March 31, 2022

XTERRA Launches New Long Distance Race Format

March 31, 2022 /ENDURANCE SPORTSWIRE/ - XTERRA is set to introduce a brand-new event format – XTERRA Long Distance - with the first of four races kicking off at the ski resort of Super-Besse in the Massif Central region of France this July. An exciting addition to the European schedule, the Long...

Business

Events

Press Releases

Triathlon

March 31, 2022

The 2022 Bay Bridge Run is Set for November 13

/ENDURANCE SPORTSWIRE/ - After a successful return in 2021, Corrigan Sports Enterprises has announced that the Bay Bridge Run is scheduled once again for November 13, 2022.  Registration for the 2022 Bay Bridge Run will open for signups on Monday, April 4. The Bay Bridge Run is one of the...

Events

Press Releases

Running

March 31, 2022

GFNY returns to Puerto Rico

/ENDURANCE SPORTSWIRE/ - The competitive long distance of GFNY Puerto Rico starts and finishes at the spectacular El Conquistador Resort in Fajardo. The 92 miles long course with 6013 feet of climbing tackles the hilly roads on the eastern part of the island along El Yunque National Forest. The non-competitive...

Cycling

Events

Press Releases