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

March 14, 2022

XTERRA USA Championship Rotates to Colorado

/ENDURANCE SPORTSWIRE/ - The 21st annual XTERRA USA Championship off-road triathlon will be held in conjunction with the new family-friendly and community focused weekend of events in Avon, Colorado on July 15-17, 2022. It’s the first-time XTERRA has hosted its national championship in the Colorado Rockies, following 12 seasons at Snowbasin...

Events

Press Releases

Running

Triathlon

March 14, 2022

The Ride for Mental Health Inspires Meaning and Purpose for Riders

/ENDURANCE SPORTSWIRE/ - The Ride for Mental Health, June 25-26 in New Paltz, N.Y., is a weekend of cycling, camaraderie and fundraising in New York’s picturesque Hudson Valley just 90 minutes north of New York City. The Ride was founded in 2017 by Brooklyn-based attorney Mac Dorris who lost his son,...

Cycling

Events

Giving

Press Releases

March 13, 2022

World Series CEO Heidi Muller Talks about Life, Family and Adventure Racing

/ENDURANCE SPORTSWIRE/ - Careful consideration doesn’t always play a part when choosing what you do in life.  Sometimes it’s all about emotion, ambition, and taking the opportunities that come your way. When Heidi Muller first went adventure racing 24 years ago, without really knowing what she was getting into, it...

Business

Events

Press Releases

Sponsorship

March 11, 2022

Virginia’s Blue Ridge to Host 2022 USA Cycling Amateur Road National Championships

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ - USA Cycling announced today that Visit Virginia’s Blue Ridge, with support from the City of Roanoke and Botetourt County, will host the 2022 USA Cycling Amateur Road National Championships. Several hundred athletes from all over the country will compete for a chance to earn national titles...

Cycling

Events

Press Releases

March 11, 2022

Run Local® & Salomon Renew Official Footwear & Apparel Partnership

San Francisco, CA (March 11, 2022) /ENDURANCE SPORTSWIRE/ - Run Local® welcomes the return of the Salomon Group to its Bay Area community. The innovative running brand will support Run Local ® Bay Area’s 2022 year-long collection of locally-themed events known as the Run the Bay Challenge Series – the San Jose...

Events

Press Releases

Running

Sponsorship