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

March 28, 2023

UltraSwim 33.3 – multi-day point-to-point adventure swim races

/ENDURANCE SPORTSWIRE/ – UltraSwim 33.3 is a new global swimming series being launched this year with the aim of developing multi-day, point-to-point ‘off-road’ open water adventure races. It’s a new format that is positioned perfectly between the many one-day 10km marathon or shorter races, and the super-long distance challenge swims, such...

Events

Press Releases

Triathlon

March 28, 2023

18th Cap2Cap Returns to the Virginia Capital Trail on May 12th & 13th

RICHMOND, Va /ENDURANCE SPORTSWIRE/ – One of the region's biggest cycling events, the Virginia Credit Union Cap2Cap presented by Dominion Energy, is back for its 18th year on May 12 and 13. Participants will enjoy breathtaking views on a fully supported course as they roll along the scenic Virginia Capital Trail,...

Cycling

Events

Press Releases

March 27, 2023

Maccabi USA Seeking Jewish Runners, Cyclists and Triathletes for Pan American Maccabi Games

Philadelphia, PA, March 27, 2023 /ENDURANCE SPORTSWIRE/ – Maccabi USA is seeking qualified Jewish runners, cyclists and triathletes to represent the USA delegation at the XV Pan American Maccabi Games in Buenos Aires, Argentina from December 26, 2023 to January 4, 2024. Maccabi USA is currently recruiting for the following teams:...

Cycling

Events

Press Releases

Running

Triathlon

March 27, 2023

Athletic Brewing IRONMAN Lake Placid Triathlon, Part of The VinFast IRONMAN North America Series Latest Event to Sell Out General Registration; Limited Entries Remain for a Number of 2023 IRONMAN and IRONMAN 70.3 Triathlons In North America

TAMPA, Fla. (March 27, 2023) /ENDURANCE SPORTSWIRE/ – IRONMAN announced today that general registration for the Athletic Brewing IRONMAN® Lake Placid triathlon, part of the VinFast IRONMAN North America Series has now sold out while several other IRONMAN and IRONMAN 70.3 triathlons across North America are nearing sell out status. Athletic...

Events

Press Releases

Triathlon

March 27, 2023

Showcased

Kim Conley and Drew Wartenburg Launch Next Best Run, an Online Coaching Service for Runners

FLAGSTAFF, ARIZONA .ENDURANCE SPORTSWIRE/ - U.S. Olympian Kim Conley and track and field coach Drew Wartenburg have announced the official launch of Next Best Run. This comprehensive online service allows runners of all backgrounds and abilities to receive personalized coaching across all events and distances. Conley is a professional runner...

Business

Events

Press Releases

Running

March 27, 2023

Athletic Brewing Company continues partnership with Canada Running Series, Named Official Non-Alcoholic Beer of 3 Marquee Races

TORONTO, CAN (March 27, 2023) /ENDURANCE SPORTSWIRE/ – Athletic Brewing Company, America’s leading producer of non-alcoholic craft beer, has renewed its partnership with Canada Running Series (CRS), today announcing its return as the official non-alcoholic beer partner of the 2023 TCS Toronto Waterfront Marathon, and the 2023 Vancouver Half Marathon. Additionally,...

Events

Press Releases

Running

Sponsorship

March 24, 2023

Credit Union Cherry Blossom 10 Mile Hosts 26th PRRO Championship

WASHINGTON, DC /ENDURANCE SPORTSWIRE/ – Nicholas Kosimbei and Susanna Sullivan could earn big paydays by defending their titles at the 50th anniversary edition of the Credit Union Cherry Blossom 10 Mile in Washington, DC on Sunday, April 2. In addition to the event’s generous guaranteed prize purse of $65,000 ($40,000 in...

Events

Press Releases

Running

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