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 (11)
) 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 420, 10

April 26, 2024

Denver Colfax Marathon Introduces New “Colfax FLY Feet” Program

Denver, CO /ENDURANCE SPORTSWIRE/ - The 18th Denver Colfax Marathon, presented by Cigna Healthcare, is thrilled to introduce a new youth-focused element to its race weekend in May. In its inaugural year, the “Colfax FLY Feet” program, is a platform for at-risk Colorado kids to participate in Denver’s largest running...

Business

Events

Giving

Press Releases

Running

Sponsorship

April 25, 2024

PTO Teams Up With Spalk To Give Brazilian Triathlon Fans Their Own Commentary For The Singapore T100

London, UK/ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) teamed up with virtual sportscasting studio, Spalk, to give Brazilian triathlon fans their very own commentary feed for the recent Singapore T100 Triathlon (13-14 April, 2024), which took place around the stunning Marina Bay in the heart of the city. “Every...

Business

Press Releases

Triathlon

April 24, 2024

Strava Ushers in Its Next Era with Appointments of New Chief Product Officer and Chief Technology Officer

SAN FRANCISCO – April 24, 2024 /ENDURANCE SPORTSWIRE/ - Strava, the leading digital community for active people with more than 125 million athletes, today announced the hiring of two new executives to its executive team: Matt Salazar, chief product officer, and Rob Terrell, chief technology officer. Both bring extensive experience...

Business

Cycling

Press Releases

Running

April 24, 2024

Gold’s Gym Brings the Best Workouts in the World to Long Beach with New State-of-the-Art Club at The Pike

Los Angeles, CA /ENDURANCE SPORTSWIRE/ - This month, Gold’s Gym SoCal – the home of the best workouts in the world – opens the doors to its very first Long Beach club, a 35,000 sq. ft. state-of-the-art facility conveniently located at The Pike. As the only gym at The Pike,...

Business

Press Releases