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

July 20, 2023

Full House of Team Ownership For Super League Triathlon’s 2023 Championship Series

/ENDURANCE SPORTSWIRE/ – After two successful years, the innovative concept is continuing to grow in 2023 with four Teams featuring five male and five female athletes, a full roster of Team Owners, an enhanced scoring system and new athlete recruitment procedures. The 2023 Teams are: Bahrain Victorious Scorpions managed by...

Business

Press Releases

Triathlon

July 20, 2023

SFIA and Running USA Announce Strategic Partnership

July 20, 2023/ENDURANCE SPORTSWIRE/ – The Sports & Fitness Industry Association (SFIA) and Running USA today announced an exciting strategic partnership that will benefit the members of both organizations. As the premier trade association for the sports and fitness industry, with a mission to promote participation and industry vitality, the SFIA...

Business

Press Releases

July 19, 2023

Carbitex Announces Leadership Appointments, Manufacturing Shift

KENNEWICK, Washington (July 19, 2023) /ENDURANCE SPORTSWIRE/ – Carbitex – the leader in flexible carbon fiber composites focused on footwear, travel, and accessories – is pleased to announce key updates that will further strengthen its position in the market and enhance the customer experience both in the United States and abroad....

Business

Press Releases

July 19, 2023

RBC GranFondo Whistler announces new military categories in support of Invictus Games Vancouver Whistler 2025

[Vancouver / Whistler, BC]/ENDURANCE SPORTSWIRE/ - In April 2022, Prince Harry, The Duke of Sussex, announced as the Founding Patron of the Invictus Games Foundation that the bid for the Invictus Games 2025 had been awarded to Canada. The Games will occur from February 6 to 17, 2025, in Vancouver...

Business

Cycling

Events

Press Releases

July 19, 2023

Triathlon Coach Jim Vance Joins 80/20 Endurance to Lead Coach Education Programs

Lehi, UT /ENDURANCE SPORTSWIRE/ – 80/20 Endurance, a leading provider of online training resources for endurance athletes, is pleased to announce the appointment of veteran triathlon coach Jim Vance as the company's Coach Education Leader. In this role, Vance will spearhead efforts to expand and manage the training, education, and support...

Business

Press Releases

Triathlon