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

May 7, 2024

Showcased

INFINIT Nutrition Introduces Personal Nutrition Coaching Services for Athletes

CINCINNATI, OHIO - May 7, 2024 /ENDURANCE SPORTSWIRE/ – INFINIT Nutrition, the trailblazer in customized nutrition solutions for athletes, proudly unveiled its new suite of Nutrition Coaching services, designed to improve athletic performance through personally tailored nutrition plans designed by a certified sports dietitian. With a focus on eliminating guesswork...

Business

Press Releases

Products

May 7, 2024

The Boston Triathlon Signs Partnership with Synergy in 2024

BOSTON, MA – May 7, 2024 /ENDURANCE SPORTSWIRE/ – ethos, the mass participation event organization that oversees the Columbia Threadneedle Investments Boston Triathlon and Kids Day at the Boston Tri today announced a partnership with Synergy, one of the world’s top wetsuit brands. For the first time, Boston Triathlon participants...

Business

Press Releases

Triathlon

May 7, 2024

Broken Arrow Skyrace Partners with Sister Race DDM Trail and Run the Alps

Olympic Valley, CA /ENDURANCE SPORTSWIRE/ – The message at the Broken Arrow Skyrace is "whether you finish first or last, YOU are a rockstar." This ethos is core to the identity of the three-day, nine-distance event held at Palisades Tahoe each June, and is paramount to the type trail running...

Business

Events

Press Releases

Running

May 3, 2024

Mongoose Launches National Partnership with DICK’S Sporting Goods

Madison, Wis. (May 2, 2024)/ENDURANCE SPORTSWIRE/ – Mongoose, the pioneering off-road bike brand founded in 1974, today announces a new partnership with DICK’S Sporting Goods (NYSE: DKS) to offer Mongoose bikes in over 650 storefronts nationwide as well as online at dicks.com. Available now, the assortment includes a complete range of mountain,...

Business

Cycling

Press Releases

May 2, 2024

Enabled Tracking to Provide Live GPS Tracking for May 2024 Endurance Events

Front Royal, VA /ENDURANCE SPORTSWIRE/ - Enabled Tracking, the timing and tracking division of Adventure Enablers, is excited to announce its comprehensive live GPS tracking services for a range of endurance events throughout May 2024. Whether you’re racing through rugged trails or conquering multi-day challenges, Enabled Tracking ensures safety, enhances...

Business

Events

Press Releases