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

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

August 10, 2022

Kayaking Team Breaks Record With One-Day Descent of Bridge Creek and the Stehekin River

LOS ANGELES /ENDURANCE SPORTSWIRE/ - Nick Terry, Rob Scanlon, Non Worasilpchai, Austin Amon, and Sage Ebel successfully completed a one-day kayaking descent of North Cascades National Park’s Bridge Creek, setting the fastest known time for the route. Typically completed over three days with opportunities for sleep and recovery, the team...

Events

Press Releases

Products

Sponsorship

August 10, 2022

1500 racers at GFNY Championship Asia in Bali

New York City, August 10, 2022/ENDURANCE SPORTSWIRE/ – The 4th edition of GFNY Bali took place on “The Island of the Gods” last Sunday, with a record participation of 1500 cyclists from 14 countries. Supported by hundreds of Bali’s Police monitoring intersections along the entire course, both long and medium course...

Cycling

Events

Press Releases

August 10, 2022

Memorial Hermann IRONMAN Texas, part of the VinFast U.S. Series selected to host 2023 IRONMAN Americas Championship

THE WOODLANDS, Texas / TAMPA, Fla. (August 10, 2022)/ENDURANCE SPORTSWIRE/ – IRONMAN today announced that the 2023 Memorial Hermann IRONMAN® Texas triathlon has been selected to host the IRONMAN Americas Championship for 2023. After hosting the IRONMAN North America Championship for multiple years, The Woodlands, Texas now expands their designation to...

Events

Press Releases

Triathlon

August 10, 2022

BibRave Orchestrates One-of-A Kind Event with Nuun and Take the Bridge in Tracktown USA

Portland, OR /ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, recently conceived and helped launch the first-ever Take the Bridge race in Tracktown USA, held during the also-first-ever World Athletics Championships on U.S. soil, bringing together marquee brands, elite runners, and fans of the sport. Elevating Nuun Hydration...

Events

Press Releases

Running

August 9, 2022

GFNY announces second race in Colombia

NEW YORK CITY, August 9, 2022 /ENDURANCE SPORTSWIRE/ – GFNY Global Endurance Sports Series announces GFNY Colombia Tunja, scheduled for August 27, 2023. The competitive long distance stretches over 125.6km with 2023m of climbing. Start and finish will be hosted at the Plaza Bolivar. Tunja is located in the state of...

Cycling

Events

Press Releases