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

March 24, 2023

Explore Three Countries and the Western Carpathians with Rajd Beskidy Expedition Race

/ENDURANCE SPORTSWIRE/ – The new Rajd Beskidy, based in Poland, is an ARWS Demonstration race this year and offers the unique opportunity to race through 3 countries and 3 mountain ranges, and up until the end of March the cost for a team of 4 is a remarkable 1700EUR. Teams are...

Events

Press Releases

March 23, 2023

USA Blind Soccer Debuts with Two Victories Over Canada

Colorado Springs, Colo. (March 23, 2023) /ENDURANCE SPORTSWIRE/ – With just over five years until the team makes its Paralympic Games debut in Los Angeles, the USA Blind Soccer Men’s National Team dipped its toes into the international competition waters with a pair of friendlies against its neighbor to the north, Canada....

Events

Press Releases

March 23, 2023

Performance Run by Ciele Athletics

MONTREAL (Mar, 23, 2022) /ENDURANCE SPORTSWIRE/ – Ciele Athletics, the high-end technical performance running brand from Montréal, Québec, is proud to announce the launch of Performance Run (PR), a new collection of elevated essentials designed for every runner - regardless of pace, speed or destination. PR: First-in-class performance and protection for...

Press Releases

Products

Running

March 23, 2023

RunSignup Concludes Initial Roadshow, Announces Additional Stops

Moorestown, NJ /ENDURANCE SPORTSWIRE/ - RunSignup, the leading registration and technology solution for U.S. endurance events, wrapped up their inaugural Winter Roadshow in Moorestown, NJ on 3/14. However, with the initial series complete, RunSignup announces that the Roadshow will continue onto more locations throughout 2023. RunSignup opted to forego their...

Business

Cycling

Events

Press Releases

Products

Running

March 23, 2023

Showcased

PRIME to be the Official Hydration Sports Drink of Tough Mudder U.S.

BOSTON, MASS. (March 23, 2023) /ENDURANCE SPORTSWIRE/ - Tough Mudder, the global leader in obstacle course adventures, announces that PRIME will become an official sponsor and offer their top-of-the-line hydration products to participants throughout the 2023 event season. “We are excited to name PRIME as our Official Hydration Sports Drink...

Events

Press Releases

Running

Sponsorship

March 23, 2023

2nd GFNY Cannes this Sunday

/ENDURANCE SPORTSWIRE/ – This Sunday, GFNY Cannes offers riders a challenging 111.3 km race course with an elevation gain of 2013 m. Riders will tackle a spectacular route from the shores of Cannes at the Côte d’Azur onto curvy and hilly hinterland roads with two significant climbs: Col du Tanneron with...

Cycling

Events

Press Releases

March 23, 2023

Team Kona 2023 Open for Applications

DALLAS, TX – March 23, 2023 /ENDURANCE SPORTSWIRE/ – Women from around the world are invited to apply for Team Kona 2023, a women’s racing team that exists to support and empower female athletes as they attempt to qualify and prepare for the 2023 IRONMAN World Championship in Kona, HI on October...

Events

Press Releases

Triathlon

March 23, 2023

Registration launches for the 2023 Mississippi Gulf Coast Marathon and the 2024 Louisiana Marathon

BATON ROUGE, LA. /ENDURANCE SPORTSWIRE/ - The tandem of the Mississippi Gulf Coast Marathon and the Louisiana Marathon have launched registration and are off to a great start. The weekend-long events bookend the holiday season with Coastal Mississippi hosting on December 9-10, 2023, and Baton Rouge hosting on January 13-14,...

Business

Events

Press Releases

Running

March 23, 2023

Tamalpa Headlands 50k presented by UltraRunning Magazine

/ENDURANCE SPORTSWIRE/ – UltraRunning Magazine, the “Voice of the Sport” for over 40 years, is proud to announce our first foray into race production and management with the historic Tamalpa Headlands 50k on Saturday, August 19, 2023 in the Marin Headlands and Mount Tamalpais State Park, just a stone’s throw across the...

Events

Press Releases

Running