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

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

August 9, 2022

The ITERA Expedition Adventure Race returns to the Highlands of Scotland

/ENDURANCE SPORTSWIRE/ – The ITERA Expedition Adventure Race returns to the Highlands of Scotland from August 14th -19th, and will once again be part of the Adventure Racing World Series. Teams from the UK, Sweden, Holland, USA, France, Poland, Ireland, Canada and Denmark will be among the 34 teams to assemble...

Events

Press Releases

August 8, 2022

Approximately 1,000 Athletes Converge in Juneau, Alaska for The Inaugural IRONMAN ALASKA Triathlon, Part of The Vinfast US Series

JUNEAU, Alaska /ENDURANCE SPORTSWIRE/ - Alaska, the Northernmost State in the U.S., and its capital city of Juneau, played host to the inaugural IRONMAN Alaska triathlon on Sunday, August 7 as part of the VinFast IRONMAN U.S. Series. Approximately 1,000 athletes traveled far and wide from 46 States and 30...

Events

Press Releases

Triathlon

August 8, 2022

Morro Bay, California Welcomes East Coast Fitness Celebrity For A First-Of-Its-Kind Event At The Iconic Morro Rock

Morro Bay, CA /ENDURANCE SPORTSWIRE/ - The Morro Bay Chamber of Commerce is excited to announce that as part of their brand-new reimagined and rebranded 2022 Avocado Margarita Food and Drink Festival, Friday, Sept. 9 - Sunday, Sept 11, the event will feature satellite stage events at the iconic Morro...

Events

Press Releases

August 6, 2022

Matthew Sharpe (Can) And Rach McBride (Can) Claim Victories at 2022 IRONMAN 70.3 Boulder

BOULDER, Colo. (Aug. 6, 2022) /ENDURANCE SPORTSWIRE/ - Scenic Boulder, Colorado and the majestic Flatirons provided a stunning backdrop for the 20th edition of the IRONMAN® 70.3® Boulder triathlon. With some of triathlon’s best on hand, a pair of Canadians took honors on the day. Matthew Sharpe (CAN) won the men’s professional...

Events

Press Releases

Triathlon

August 5, 2022

The Global Marathon goes big for Autumn 2022

MEDIA ALERT Monday 5 August /ENDURANCE SPORTSWIRE/ –  The AbbottWMM Global Run Club launched the fourth edition of the Global Marathon today which is set to be bigger and better this autumn. Kicking off on Sunday 25 September with the BMW-BERLIN Marathon, the virtual event is open until Sunday 6 November when...

Events

Press Releases

Running

August 5, 2022

XTERRA Racing Season Heats Up in August

August 5, 2022/ENDURANCE SPORTSWIRE/ – The XTERRA World Tour is in full swing with eight races in two weeks across Europe and the U.S. leading up to the XTERRA World Championship in Trentino, Italy on October 1, 2022. In the U.S., big names like Eric Lagerstrom and Heather Jackson are racing...

Events

Press Releases

Triathlon