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

August 15, 2022

XTERRA European Championship Rewind from Prachatice

/ENDURANCE SPORTSWIRE/ - Arthur Serrieres from France and Sandra Mairhofer from Italy captured the XTERRA European Championship in conjunction with the 18th annual XTERRA Czech off-road triathlon with winning times of 2:30:16 and 2:57:39, respectively, on Saturday, August 13, 2022, in Prachatice, then put their speed and skill on full...

Business

Events

Press Releases

Products

Triathlon

August 15, 2022

1,400 Participants Took on ODU’s Campus in the 9th Running of The Big Blue 5k

AUGUST 13, 2022 – NORFOLK, VIRGINIA /ENDURANCE SPORTSWIRE/ - Close to 1,400 participants strutted their Old Dominion University pride at the Big Blue 5K presented by Bon Secours. Participants weaved their way through ODU’s campus and were cheered on by the ODU Football, Lacrosse and Volleyball teams. One of the...

Events

Press Releases

Running

August 15, 2022

Big Sur Marathon Foundation Names New Executive/Race Director

August 15, 2022, CARMEL, CA /ENDURANCE SPORTSWIRE/ - Josh Priester has been named the new Executive Director/Race Director of the 36-year-old Big Sur Marathon Foundation (BSMF). Priester, who offers a wealth of experience in sports management, athlete coaching, and business development, is tasked with furthering the nonprofit organization’s mission to create...

Events

Press Releases

Running

August 12, 2022

Estonian ACE Adventure/La Sportiva are the new World #1 Ranked Adventure Racing Team

/ENDURANCE SPORTSWIRE/ – The update covers the past 4 months, which have been the busiest ever in the history of the AR World Series. Ranking points have been added from 6 World Series Qualifiers on 4 continents, and from one Demonstration race, and some teams are also adding ranking points for...

Events

Press Releases

August 12, 2022

Maryland Cycling Classic Supported by UnitedHealthcare Announces Seven Brand Ambassadors

12 August 2022, BALTIMORE, Md. /ENDURANCE SPORTSWIRE/ - The Maryland Cycling Classic supported by United Healthcare today announced a roster of six world class athletes as brand and community ambassadors for its weekend of events taking place September 1-4, 2022. Nelson Vails, an Olympic silver medalist in track cycling; Rahsaan Bahati,...

Cycling

Events

Press Releases

Sponsorship

August 11, 2022

XTERRA European Championship Saturday in Czech Republic

August 11, 2022/ENDURANCE SPORTSWIRE/ – The pinnacle event on the 2022 XTERRA European Tour takes place this Saturday, August 13, in Prachatice, as the Czech Republic plays host to the European Championship race for the second time. This is the 18th year of XTERRA racing in the Czech Republic, which produced...

Events

Press Releases

Triathlon

August 11, 2022

2022 Bayou Hills Run Highlights Fun-Filled Labor Day Weekend in Pensacola

Pensacola, FL – (August 11, 2022)/ENDURANCE SPORTSWIRE/ – Hit the ground running on Labor Day at one of Pensacola’s oldest racing events, the 2022 Bayou Hills Run. This long-established 5K and 10K race highlights an activity-filled Labor Day weekend in Pensacola that also includes live performances, music festivals, and more. This year’s...

Events

Press Releases

Running

August 11, 2022

First ever Ford GFNY Oaxaca this Sunday

/ENDURANCE SPORTSWIRE/ – Ford GFNY Oaxaca offers riders a long race course of 116.5km with an elevation gain of 1850m including Ixtepeji summit, one of the longest mountain passes in Mexico, considered an out of category climb. The first 5km of the race through downtown Oaxaca are mostly flat. Once out...

Cycling

Events

Press Releases

August 11, 2022

Solo Stove to be the Official Fire Pit of Spartan US

Grapevine, TX (August 11, 2022) /ENDURANCE SPORTSWIRE/ - Solo Stove is excited to announce a new partnership with Spartan, joining as an official sponsor of the Spartan Race US Series and provider of the Official Fire Pit for their events. Beginning August 13 in New England, the Spartan Race community...

Events

Products

Sponsorship