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

June 14, 2022

Stack Sports Powers The Boldest Show on Earth with BOLDERBoulder Huge Turnout

Boulder, Colorado /ENDURANCE SPORTSWIRE/ – One of the largest road races in the nation, and America's All-time Best 10K was back again this year with a massive turnout. After creating a unique variation of its event last year, this year BOLDERBoulder was back at 5,391’ above sea level. In the Pro Race...

Events

Press Releases

Running

June 13, 2022

Pic2Go Partners with The Steamboat Marathon 2022 to deliver Race Day Photos to Participants!

/ENDURANCE SPORTSWIRE/ – Through the Pic2Go powered photo activation, participants could easily access and share their personal Rich Finisher Galleries to social media, and keep them in their personal RunPage account. Pic2Go’s race photography platform use patented 2D barcodes technology to  auto-tag race photos and deliver race day photos to participants during...

Events

Press Releases

Products

Running

Sponsorship

June 13, 2022

Serrieres wins third in a week at XTERRA Belgium

/ENDURANCE SPORTSWIRE/ – Arthur Serrieres and Marta Menditto captured the sixth annual XTERRA Belgium off-road triathlon elite titles at the Port of Beez in Namur on Saturday, June 11, 2022, with winning times of 2:27:22 and 2:55:05, respectively. It's the 17th career XTERRA World Tour win for Serrieres (FRA) and the...

Events

Press Releases

Triathlon

June 12, 2022

Iowa’s Matt Hanson (USA) And Utah’s Skye Moench (USA) Claim Victories at the 2022 Certified Piedmontese Beef IRONMAN North American Championship Des Moines Triathlon

DES MOINES, Iowa (June 12, 2022) /ENDURANCE SPORTSWIRE/ - Central Iowa played host to the 2022 Certified Piedmontese Beef IRONMAN North American Championship Des Moines triathlon on Sunday, June 12. Over 1,000 athletes, including professionals and age-group athletes took on streets of Des Moines for the first full-distance IRONMAN triathlon...

Events

Press Releases

Triathlon

June 12, 2022

Cody Beals (CAN) And Sarah True (USA) Claim Victories At 2022 IRONMAN 70.3 Eagleman

CAMBRIDGE, Md. (June 12, 2022) – Cambridge, Maryland and Dorchester County provided a stunning backdrop for the 2022 IRONMAN 70.3 Eagleman. With some of triathlon’s best on hand, Cody Beals (CAN) took the men’s top honors with a finishing time of 3:41:47 while Sarah True (USA) earned the topped the...

Events

Press Releases

Triathlon

June 11, 2022

Break the Record, Break the Cycle

YAKIMA, WA /ENDURANCE SPORTSWIRE/ - Athlete and activist Rosalie Fish is running the Downtown Yakima Mile on July 2nd to “demonstrate that every single one of us can make an impact in ending domestic violence.” Fish will begin running at the sound of the starting gun fired for the first...

Awards

Events

Giving

Press Releases

Running

Sponsorship

June 10, 2022

Tough Mudder to Host First-Ever 24-Hour OCR World Championships

BOSTON, Mass. (June 10, 2022)/ENDURANCE SPORTSWIRE/ – Tough Mudder, the global leader in obstacle course adventures, today announced that World’s Toughest Mudder (WTM) has been sanctioned as the 24-Hour OCR (Obstacle Course Racing) World Championships. The event will take place in Atmore, Ala. on Nov. 12 - 13, 2022, and will...

Events

Press Releases

Running

June 9, 2022

Virtual Challenge Family’s Month of Iconic Races to pre-ride on ROUVY:

Almere, Netherlands / June 9th, 2022/ENDURANCE SPORTSWIRE/ – Challenge Family and ROUVY announce a month full of Challenge Family virtual races in various iconic locations. Roth, Kaiserwinkl-Walchsee, St Polten, Wales and Gunsan-Saemangeum are all available as prep-rides for the official races. Those athletes, racing outdoors, have a great opportunity to train...

Cycling

Events

Press Releases

Triathlon