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

July 22, 2022

Team Toyota Tundra Takes Out 2022 Maine Summer Adventure Race

/ENDURANCE SPORTSWIRE/ - Team Toyota Tundra, which has been on a tear throughout the U.S. in 2022 following its win at the 2021 U.S. Adventure Racing Association National Championship, took the win at the 2022 Maine Summer Adventure Race. The adventure race took place for the sixth time in New...

Events

Press Releases

July 22, 2022

Kayakers Make Final Preparations To Attempt Record-Breaking One-Day Descent of the Bridge Creek

LOS ANGELES /ENDURANCE SPORTSWIRE/ - The inaugural recipients of the Punch Gunk Go Get It Grant have announced that they will be soon embarking on their expedition to set the fastest known time for a kayaking descent of North Cascades National Park’s Bridge Creek. Nick Terry, Rob Scanlon, Non Worasilpchai,...

Events

Press Releases

Products

Sponsorship

July 22, 2022

Maryland Cycling Classic Supported by UnitedHealthcare Releases Full Schedule of Weekend Events

BALTIMORE, Md./ENDURANCE SPORTSWIRE/ – The Maryland Cycling Classic supported by UnitedHealthcare today announced its schedule of events for Labor Day weekend beginning Thursday, September 1 and culminating with America’s top-ranked professional road cycling race on Sunday, September 4, 2022, in Baltimore, Md. Featuring a wide range of activities for the entire family...

Cycling

Events

Press Releases

July 22, 2022

Team UCAN Runners Shine at World Athletics Championships

/ENDURANCE SPORTSWIRE/ – Team UCAN runners had a successful showing competing against the best in the world, with three Top-10 finishes at the 2022 World Athletic Championships in Eugene, OR. Sara Hall and Emma Bates led the charge for the American women in the marathon, finishing 5th and 7th respectively. They...

Events

Press Releases

Running

Sponsorship

July 21, 2022

2021 Intermountain Healthcare IRONMAN World Championship Presented By Utah Sports Commission Documentary Special Airing On NBC and Peacock, July 23 AT 3:00 P.M. ET

TAMPA, Fla. (July 21, 2022) /ENDURANCE SPORTSWIRE/ - A documentary special highlighting the 2021 Intermountain Healthcare IRONMAN® World Championship presented by Utah Sports Commission will premiere on Saturday, July 23 at 3:00 p.m. ET on NBC, Peacock, NBC Sports App and NBCSports.com/Live. The IRONMAN World Championship special will chronicle triathlon’s...

Events

Press Releases

Triathlon

July 21, 2022

Life Time Releases Details for 2022 Chicago Triathlon, Aug. 27-28

CHICAGO – (July 21, 2022)/ENDURANCE SPORTSWIRE/ – The Life Time Chicago Triathlon, one of the most recognized endurance races in the world, is returning to the waterways and streets of the Windy City August 27 and 28. The Life Time Chicago Triathlon, owned and produced by the nation’s premier healthy lifestyle...

Events

Press Releases

Triathlon

July 20, 2022

Juvenile Arthritis Awareness Month Inspires Cyclists Training for “Ride of a Lifetime”

LOS ANGELES – July 20, 2022/ENDURANCE SPORTSWIRE/ – July is Juvenile Arthritis Awareness Month, and it is stoking the fire of cyclists preparing to take on a 525-mile ride in September. Juvenile idiopathic arthritis and other pediatric rheumatic diseases affect nearly 300,000 kids and teens in the United States. Many of the...

Cycling

Events

Giving

Press Releases