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

May 24, 2022

Debut of Run Show USA for North American Running Community Set to Begin

LONDON (May 24, 2022)/ENDURANCE SPORTSWIRE/ – Raccoon Events, the dynamic UK-based events business with extensive experience in organizing and executing consumer expos worldwide, is set to bring their popular National Run Show to North American audiences with the inaugural Run Show, Chicago on June 4-5 at the DES Convention Center in Rosemont,...

Press Releases

Running

Trade Shows

May 24, 2022

Showcased

Ashley Addiction Treatment Invites Public to Movement For Recovery Event with Ultramarathoner Charlie Engle

HAVRE DE GRACE, Md. /ENDURANCE SPORTSWIRE/ - Ashley Addiction Treatment (Ashley), one of the world’s most recognized and respected names in the substance use disorder treatment industry, invites the public to join The Penguin: Movement for Recovery, a celebration of movement for and through recovery. On July 23 and 24,...

Events

Press Releases

May 24, 2022

Columbia Threadneedle Investments Boston Triathlon Signs Partnership with ZONE3 USA for 2022

BOSTON, MA – May 24, 2022/ENDURANCE SPORTSWIRE/ – ethos, the mass participation event organization that oversees the Columbia Threadneedle Investments Boston Triathlon, has renewed its partnership with ZONE3 USA. The company is once again the Official Swim Partner of the 2022 Columbia Threadneedle Investments Boston Triathlon. The annual event will return to...

Events

Press Releases

Sponsorship

Triathlon

May 24, 2022

Camp Alligator Training Announced as Event Registration Soars

Saint Augustine Beach, Florida/ENDURANCE SPORTSWIRE/ – Salty Sports Society has announced Camp Alligator, a training camp weekend designed to provide swimmers with swim technique, training outline, and event details needed to successfully navigate the World-Famous Swim for Alligator Lighthouse open water event in September. This announcement comes just as the event...

Events

Press Releases

May 23, 2022

Ultra Trail Runner Runner Ryan Montgomery Signs to Gnarly Nutrition Athlete Team

Salt Lake City, UT (May 23, 2022)/ENDURANCE SPORTSWIRE/ – Gnarly Nutrition is excited to announce the official signing of ultra trail runner Ryan Montgomery to its athlete team. “I am excited to be supported by Gnarly because its products align with so many activities of my life each day–whether I need...

Press Releases

Running

Sponsorship

May 23, 2022

Iden and Perez Sala Crowned Champions of The Championship 2022

/ENDURANCE SPORTSWIRE/ – An incredible day of racing at The Championship saw Gustav Iden (NOR) and Sara Perez Sala (ESP) crowned the Champions of The Championship 2022 on a day that tested with strong winds and high temperatures alongside a highly competitive field. Before the race, Iden was quick to downplay...

Awards

Events

Press Releases

Triathlon

May 23, 2022

ROUVY Ghosts’ Comeback – 10 Virtual Pace Bots to make the indoor cycling session more fun

Prague, Czech Republic / May 23, 2022 /ENDURANCE SPORTSWIRE/ – ROUVY, is an application and platform that turns what was formerly known as mundane stationary training into a fun and motivating virtual adventure around the world. The overlaid 3D avatars and objects, atop the real-life geo-synced video footage, create a realistic...

Cycling

Press Releases

Products

Triathlon

May 23, 2022

2023 UTMB® World Series to broaden offering to runners with the confirmation of a brand-new event in Thailand

Chamonix, France. 23 May 2022 /ENDURANCE SPORTSWIRE/ – With the inaugural UTMB World Series now in full swing with 25 events scheduled in 2022 and thousands of runners across the world signed up and ready to compete, the organizers are already looking ahead to 2023 and the continued expansion of the...

Events

Press Releases

Running