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

March 15, 2022

Pikes Peak Apex Welcomes Back Rockshox as Presenting Sponsor

Colorado Springs, CO, March 15, 2022 /ENDURANCE SPORTSWIRE/ - Sports Strategies announces a two-year partnership between SRAM and Pikes Peak APEX. The iconic RockShox brand will return as presenting sponsor of the event for 2022 and 2023. “We are very proud,” said Micah Rice, Executive Director of Pikes Peak APEX....

Cycling

Events

Press Releases

Sponsorship

March 15, 2022

Tough Mudder and Contiki Team Up to Offer Sweepstakes Giveaway for an Adventure-Filled Weekend

BOSTON, Mass. (March 15, 2022)/ENDURANCE SPORTSWIRE/ - Contiki, the social travel operator, has teamed up with Tough Mudder, the global leader in obstacle course adventures, to host a sweepstakes giveaway for an adventure-filled weekend. Running today through April 5, 2022, the sweepstakes offers a chance for you and a friend to...

Events

Press Releases

March 14, 2022

Registration opens for 2022 Mississippi Gulf Coast Marathon

Biloxi, Ms. /ENDURANCE SPORTSWIRE/ - Runners who missed last year’s Mississippi Gulf Coast Marathon have another chance to #soakuptherun. Registration for the race in Dec. 2022 officially opens Monday offering the best deals and exclusive gear for a limited time. Runners who register before Mar. 22 will not only receive...

Business

Events

Press Releases

Running

Sponsorship

Studies

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