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

May 26, 2024

Hug and Zimmermann Secure Wins at Challenge St Pölten

/ENDURANCE SPORTSWIRE/ - A thrilling finish in the women’s race and a successful title defense in the men’s marked Challenge St Pölten 2024 with Tom Hug (GER) taking the win in 3:52:48, and Laura Zimmermann (GER) securing victory in 4:27:06. Unique to Challenge St Pölten, the race started with the...

Events

Press Releases

Triathlon

May 23, 2024

Showcased

Spartans Conquer Cancer Together: GoFundraise and American Cancer Society Partner Again!

/ENDURANCE SPORTSWIRE/ – Building on the success of their 2023 partnership which raised over $140,000 GoFundraise and the American Cancer Society (ACS) are continuing to work together to empower Spartan Racers to raise critical funds in the fight against cancer. "We're thrilled to continue our partnership with ACS and empower...

Events

Giving

Press Releases

Running

May 23, 2024

GFNY Villard-de-Lans was 2023’s voted best course and happens again this Sunday

New York City, May 23, 2024 /ENDURANCE SPORTSWIRE/ - This Sunday, GFNY Villard de Lans offers riders a challenging 163,4 km race course with an elevation gain of 3973m.  Athletes will tackle a spectacular route in the mountainous Vercors region with the base at an altitude of 1050m. “Villard-de-Lans is...

Cycling

Events

Press Releases

May 23, 2024

18th Denver Colfax Marathon Celebrates a Record-Breaking Year in the Mile High

Denver, CO /ENDURANCE SPORTSWIRE/ - The 2024 Denver Colfax Marathon, presented by Cigna Healthcare, welcomed close to 25,000 runners over the weekend to its annual race event. The weekend, which hosts eight races over two days, saw twenty percent more runners than last year. Athletes from all 50 states plus...

Events

Press Releases

Running

May 22, 2024

Gran Fondo Hincapie announces official courses for new Bentonville event designed for cyclists of all ability levels

Greenville, S.C., (May 22, 2024) /ENDURANCE SPORTSWIRE/ - Gran Fondo Hincapie has been creating cycling experiences for over 12 years and today announces the official courses for their new Bentonville, Ark. event on Sept. 7-8. In partnership with Visit Bentonville, the Ozark Foundation, and Runway Group, the Hincapie-Bentonville event will...

Cycling

Events

Press Releases