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

July 21, 2023

2023 USA Cycling Collegiate Mountain Bike National Championships Head to Ride Rock Creek

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – The 2023 USA Cycling Collegiate Mountain Bike National Championships will take place at Ride Rock Creek in Zirconia, N.C. on October 12-15, 2023. The Collegiate Mountain Bike National Championship is the largest collegiate cycling event that USA Cycling hosts. The event will crown varsity and...

Cycling

Events

Press Releases

July 21, 2023

Moloka’i 2 O’ahu Paddleboard World Championships Welcomes New partner dryrobe®

HONOLULU, HI (July 21, 2023)/ENDURANCE SPORTSWIRE/ – The Moloka'i 2 O'ahu Paddleboard World Championships (M2O) is excited to return to Hawai'i later this month for the 24th annual race featuring top athletes in prone paddleboarding, SUP, and FOIL. The race is excited to introduce these world class watermen and women...

Events

Press Releases

Sponsorship

July 21, 2023

Louisiana Half Marathon Champion, Jarrett Leblanc, Sets Out to Break World Record and Raise Funds for Children’s Heart Health

Lafayette, LA/ENDURANCE SPORTSWIRE/ – Louisiana Half Marathon 2021 Champion and Ochsner cardiac sonographer, Jarrett Leblanc, is gearing up for an extraordinary feat as he attempts to overtake the world record for the fastest half-marathon run on a treadmill. The remarkable event is scheduled to take place at Red Lerille's Health and...

Giving

Press Releases

Running

July 20, 2023

XTERRA Lake Scanno this Saturday in Abruzzo

/ENDURANCE SPORTSWIRE/ – The 13th of 21 stops on the 2023 XTERRA EMEA Tour has built a reputation for being one of the most dream-worthy races in all of Europe. The challenge combines a 1.5K swim with a new and improved two-loop 30K mountain bike that climbs high into the...

Events

Press Releases

Triathlon

July 20, 2023

XTERRA World Championship will return to Trentino in 2024

/ENDURANCE SPORTSWIRE/ – “The support we’ve received from our local partners from Trentino and Dolomiti Paganella has been overwhelming, and for those who haven’t been yet, we want to give the XTERRA Family one last chance to qualify and experience the magic of the Dolomites,” said J-D Cousens, XTERRA VP...

Events

Press Releases

Triathlon

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

A Milestone in The Adirondacks: IRONMAN & Lake Placid, N.Y. Set Celebrate 25th Anniversary of Iconic IRONMAN Triathlon in 2024

LAKE PLACID, N. Y. (July 20, 2023) /ENDURANCE SPORTSWIRE/ – IRONMAN has announced that the 2024 edition of the Athletic Brewing IRONMAN® Lake Placid triathlon, part of the VinFast IRONMAN North America Series will celebrate its 25th anniversary, marking a quarter-century of unforgettable moments and incredible achievements for this iconic event...

Events

Press Releases

Triathlon

July 20, 2023

World Class Field on Show at Challenge London

London, UK /ENDURANCE SPORTSWIRE/ – The professional field for this year’s Challenge London has been announced, with an array of international triathlon talent set to head to the world’s biggest city centre triathlon. Amongst the highlights announced to race the event’s new Middle distance are Fenella Langridge (GBR), ranked 13th in the...

Events

Press Releases

Triathlon

July 20, 2023

The Running Event Announces Partnership with National Shoe Retailers Association

PORTLAND, Maine (July 20, 2023)/ENDURANCE SPORTSWIRE/ – The Running Event (TRE), North America’s premier specialty retail conference and trade show, today announced its partnership with the National Shoe Retailers Association (NSRA). The partnership will grow TRE’s support of the specialty retail industry by opening its doors to independent shoe retailers this November...

Press Releases

Running

Trade Shows