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 (8742)
) 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 5100, 10

August 31, 2022

2XU Malibu Triathlon Welcomes the Return of Corporate Wellness with Record Setting Amount of Company Teams Competing the Weekend of September 17-18th, 2022

Malibu, CA /ENDURANCE SPORTSWIRE/ - 2XU Malibu Triathlon announced today it is still accepting registration for 2022 until it sells out. The iconic event will take place across the weekend of September 17-18, with the Olympic distance event on Saturday along with the Super League Triathlon Championship Race, and the...

Press Releases

Triathlon

August 30, 2022

DAZN To Broadcast Super League Triathlon With Deal Until End of 2023

/ENDURANCE SPORTSWIRE/ - Super League Triathlon (SLT) has agreed a deal with DAZN, the leading global sports streaming platform, to broadcast all events live across its global platform until the end of 2023. The contract covers Super League’s biggest ever Championship Series in 2022, which kicks off in London on...

Business

Press Releases

Triathlon

August 30, 2022

American Criterium Cup event number ten: Gateway Cup

Wednesday, August 30, 2022 /ENDURANCE SPORTSWIRE/ - On Sunday, September 4th, our final race in the American Criterium Cup takes place at the Giro Della Montagna criterium, part of the four-day Gateway Cup. The tenth and last stop for the ACC, the Giro became the cornerstone of the Gateway Cup in...

Cycling

Events

Press Releases

August 30, 2022

GFNY Alpes Vaujany: Schuller and Alleman take the win after 4000+ meters of climbing

New York City, August 30, 2022 /ENDURANCE SPORTSWIRE/ – The third annual GFNY Alpes Vaujany in the French Alps had a 119.6 km long course with 4023m of climbing including the legendary Col de la Croix de Fer and Col du Glandon on the menu. GFNY Alpes Vaujany started from the bottom...

Cycling

Events

Press Releases

August 30, 2022

Nutrition Coaching App, Fuelin, Announces Integration with Final Surge

(San Francisco, CA)/ENDURANCE SPORTSWIRE/ – Fuelin and Final Surge announced the integration of Fuelin’s nutrition coaching app with Final Surge’s sports technology platform. This gives all Final Surge athletes the ability to connect their training program to the daily nutrition and fueling programs available from Fuelin so they know how to...

Cycling

Press Releases

Products

Running

Triathlon

August 29, 2022

Registration Open for the 2022 Running USA Accelerator Series

(August 29, 2022) /ENDURANCE SPORTSWIRE/ - Running USA and Race Roster are excited to announce the dates and cities for three Fall 2022 Accelerator Series events. Registration is now open! The half day workshops with timely and practical content for the running industry for events of all sizes will be...

Events

Press Releases

Running

August 29, 2022

Registration Open for Inaugural Rush to Crush Cancer Benefiting UPMC Hillman Cancer Center

PITTSBURGH (August 29, 2022) /ENDURANCE SPORTSWIRE/ – Registration is now open for the first-ever Rush to Crush Cancer benefitting UPMC Hillman Cancer Center. This inaugural event is expected to bring hundreds of participants to the Pittsburgh region to help raise awareness and dollars to support innovative research that will someday lead...

Cycling

Events

Giving

Press Releases

August 29, 2022

Outside Interactive, Inc. Names New Leader of its Cycling Group

Boulder, Colorado (August 29, 2022)/ENDURANCE SPORTSWIRE/ – Outside Interactive, Inc., the world's leading creator of active lifestyle content, services, events, and experiences, today announced the promotion of Alan Crisp to Vice President and General Manager of its Cycling Group. Formerly the group’s Senior Sales Director, Crisp assumes leadership of the world’s largest...

Business

Cycling

Press Releases