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 (22)
) 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 1070, 10

February 25, 2022

XTERRA names Steve Andurs U.S. Tour Manager

February 25, 2022 (Portland, OR) /ENDURANCE SPORTSWIRE/ - XTERRA Global, LLC, owners and producers of the XTERRA World Tour, today announced Steve Andrus as the new manager for the XTERRA U.S. Tour, effective March 1, 2022. Andrus previously served as the Director of Sales and Events at Snowbasin Resort in...

Business

Events

Press Releases

Running

Sponsorship

Triathlon

February 24, 2022

Elite Cycling Announces WorldTour Team Sponsorships for 2022

FONTANIVA, ITALY, February 24th, 2022 /ENDURANCE SPORTSWIRE/ - Elite Cycling is pleased to announce their roster of sponsored WorldTour cycling teams for the 2022 race season. The list of top-WorldTour teams who will be making use of the Elite ecosystem of cycling products includes team INEOS Grenadiers, and UAE Team...

Business

Cycling

Press Releases

Sponsorship

February 24, 2022

Aquasphere Welcomes World Class Triathlete Sam Long to the Global Team

SOPHIA ANTIPOLIS, France (February 24, 2022) /ENDURANCE SPORTSWIRE/ - Aquasphere, the premier swimming and triathlon brand, today announce 70.3 World Championship silver medalist Sam Long is joining its growing roster of world class athletes. As part of the partnership, Long will train and compete utilizing Aquasphere’s range of industry-leading products...

Press Releases

Sponsorship

Triathlon

February 23, 2022

Triathletes Mirinda Carfrae, Timothy O’Donnell Join InsideTracker Endurance Team Following Harrowing “Widowmaker” Heart Attack

CAMBRIDGE, Mass.—Feb. 23, 2022 /ENDURANCE SPORTSWIRE/ - InsideTracker, the leading personalized performance and nutrition system, today announced a partnership with professional triathletes Tim O’Donnell and three-time IRONMAN World Champion, Mirinda “Rinny'' Carfrae. The athletes are recognized as two of the world’s most successful and experienced long-course triathletes on their own merit, and,...

Press Releases

Sponsorship

Triathlon

February 22, 2022

Orbiter announced as Presenting Sponsor for US Trail Running Conference

/ENDURANCE SPORTSWIRE/ - Active at Altitude, organizers of the US Trail Running Conference, has announced that Orbiter will be the presenting sponsor of the 2022 Conference. Orbiter is an easy-to-use and cost-effective RFID unattended and automated trail run timing system, with fast setup and an extremely mobile portable or fixed installation...

Press Releases

Running

Sponsorship

February 17, 2022

Destination Sport Experiences Announce Partnership with Saint Piran Professional Cycling Team

/ENDURANCE SPORTSWIRE/ - The new partnership promises both fans and the team itself enhanced experiences at both UK and European races thanks to the expertise of the Destination Sport Experiences team. Fans will be able to access exclusive experiences at races both at home and overseas with dedicated ‘fan zones’ at...

Cycling

Press Releases

Sponsorship