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

January 9, 2024

XTERRA European Trail Run Championship 2024: The Sky’s the Limit in Andorra

Key Points: Arinsal, La Massana, and towering peaks of the Pyrenees, offer the backdrop for an unparalleled championship weekend. The 24K Half Marathon and 36K Marathon races will crown the XTERRA European Trail Run Champions. 116 slots each for Half and Full Marathons to qualify for the XTERRA Trail Run...

Events

Press Releases

Running

January 9, 2024

RunSignup Releases 2023 Year In Review

January 9, 2024 /ENDURANCE SPORTSWIRE/ – RunSignup, the leading technology solution for US endurance events, reported strong growth in their 2023 Year In Review. The company’s key metric is how much revenue they help customers generate from events and related fundraising. Since its inception, RunSignup customers have raised $2.3 billion. Overall,...

Business

Press Releases

Running

January 9, 2024

Pat Tillman Foundation Opens Registration For 20th Annual Pat’s Run, Presented by Teksystems

CHICAGO (Jan. 9, 2024) /ENDURANCE SPORTSWIRE/ - Registration opened today for the 20th Annual Pat’s Run, the Pat Tillman Foundation’s marquee fundraising event, presented by TEKsystems. Pat’s Run, a 4.2-mile run / walk with a .42-mile Kids Run, will take place in-person and virtually on April 13, 2024. The in-person...

Events

Giving

Press Releases

Running

January 9, 2024

Cheers to Round Two: 3M Half Marathon Welcomes Back EIGHT Beer

Austin, Texas, January 9, 2024 /ENDURANCE SPORTSWIRE/ – High Five Events, a leading private event production company in the United States, is delighted to announce the continuation of its successful partnership with EIGHT Beer as the Official Beer for the second consecutive year at the upcoming 3M Half Marathon in Austin, Texas....

Events

Press Releases

Running

Sponsorship

January 9, 2024

The 2023 Vinfast IRONMAN World Championship Documentary Special Now Available For Free Internationally on IRONMAN’S YouTube Channel

TAMPA, Fla. /ENDURANCE SPORTSWIRE/ - After premiering on Outside Watch on December 30, 2023, the 2023 VinFast IRONMAN® World Championship documentary special is now available globally on IRONMAN’s YouTube channel. The annual IRONMAN World Championship special chronicles triathlon’s pinnacle event, which for the first time in the iconic event’s 45-year...

Press Releases

Triathlon

January 9, 2024

SFuels successfully delivered official on-course nutrition, and post-race recovery shake, for 43rd running of Avalon 50 Mile/50K ultra

RALEIGH, North Carolina, January 09, 2024 /ENDURANCE SPORTSWIRE/ - In five short years, SFuels has taken it to the much older incumbent high-sugar nutrition players – delivering the industry’s most innovative nutrition stack for aerobic development, threshold and Vo2Max endurance performance. While a newcomer, SFuels products are packing a punch in...

Press Releases

Running

Sponsorship