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

August 11, 2025

Meet Boston Extends Partnership with Boston Triathlon as Host Partner Through 2028

BOSTON, MA (August 11, 2025) /ENDURANCE SPORTSWIRE/ – ethos, the mass participation event organization that presents the Boston Triathlon, today announced that Meet Boston, the official destination marketing and sales organization for the Greater Boston area, will continue as a Host Partner of the Boston Triathlon through 2028. This long-term...

Business

Press Releases

Sponsorship

Triathlon

August 7, 2025

WTA No. 1 Aryna Sabalenka Taps Electrolit as Official Hydration Partner

Houston, TX (August 7, 2025) /ENDURANCE SPORTSWIRE/ – Today, reigning WTA World No. 1 and three-time Grand Slam champion Aryna Sabalenka announces a new partnership with Electrolit – the preferred, premium hydration beverage and fourth-ranked sports drink in the U.S. The multiyear deal marks a powerful alignment between one of tennis’s...

Business

Press Releases

Sponsorship

August 6, 2025

H2O Audio and Zwift Debut Limited-Edition RIPT Ultra Headphones

SAN DIEGO / LONG BEACH, Calif. (Aug. 6, 2025) — ENDURANCE SPORTSWIRE - H2O Audio, the leader in high-performance sport headphones, has partnered with Zwift, the global online fitness platform for cyclists and runners, to launch a limited-edition Zwift x RIPT Ultra headphone—bringing immersive sound to gamified training. Built for athletes who...

Business

Press Releases

Products