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

February 28, 2023

Introducing Elevate 2028: USA Triathlon Foundation’s 2023-2028 Strategic Plan

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – The USA Triathlon Foundation today unveiled Elevate 2028, the organization’s 2023-2028 Strategic Plan, which outlines the path toward increasing philanthropic support, encouraging a culture of philanthropy, and providing a greater impact for donors and members of the multisport community. The USA Triathlon Foundation raises funds for...

Business

Press Releases

Triathlon

February 28, 2023

Showcased

MOTTIV Training App Reduces Subscription Fee by 65%

VANCOUVER, CANADA /ENDURANCE SPORTSWIRE/ - MOTTIV, an athlete-run company dedicated to ensuring endurance sports and the transformations they bring are accessible to everyone, today launched MOTTIV 2.0, an all-encompassing training and motivation app for runners at every level. After extensive beta testing, new functions have been added including an athlete...

Business

Press Releases

February 28, 2023

Yamaha Bicycles Adds Northwest Regional Field Sales and Marketing Rep

CYPRESS, Calif. /ENDURANCE SPORTSWIRE/ - Yamaha Bicycles continues its field sales and marketing team growth, most recently adding Nate Espinosa as the new representative for the northwest region of the United States. Espinosa, who has spent a lifetime in the bike industry with over two decades of retail, race mechanic...

Business

Cycling

Press Releases

February 28, 2023

Enabled Tracking to Provide Live GPS Tracking for the 2023 Endurance Hunter Trail Race

/ENDURANCE SPORTSWIRE/ Front Royal, VA - Enabled Tracking will be providing tracking for the Endurance Hunter Trail Run for the third year in a row. After expanding from tracking just the 100-mile distance in 2021, Enabled Tracking will provide tracking for the 100-mile and 100K distances in 2023, as they...

Business

Events

Press Releases