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

April 19, 2023

USATF U18 Mountain Running Team Announced

/ENDURANCE SPORTSWIRE/ - Eight athletes have been named to the 2023 USATF U18 Mountain Running Team slated to compete in the 16th edition of the International U18 Mountain Running Cup in Annecy, France on Saturday, May 27. The race will be held at Semnoz Ski Resort, approximately 30 minutes from...

Events

Press Releases

Running

Sponsorship

April 18, 2023

Multisport Athletes to Compete at 2023 USA Triathlon Multisport National Championships Festival in Irving, Texas, This Weekend

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – More than 3,000 registrants will compete in swim-bike-run, run-bike-run, run-swim-run and swim-bike multisport races this Wednesday through Sunday in Irving, Texas, at the 2023 USA Triathlon Multisport National Championships Festival. The Multisport National Championships Festival returns for the second consecutive year to Irving, Texas, bringing to Irving the...

Events

Press Releases

Triathlon

April 18, 2023

British Cycling partners with travel specialists Destination Sport Travel and Sportive Breaks

/ENDURANCE SPORTSWIRE/ – British Cycling is pleased to announce a new long-term commercial partnership with travel specialists Sportive Breaks and Destination Sport Travel. British Cycling members will have access to the best cycling travel experiences via Sportive Breaks, and the Great Britain Cycling Team will be supported with business travel and...

Business

Cycling

Press Releases

Sponsorship

April 18, 2023

Virginia’s Blue Ridge TWENTY24 Victorious at 2023 Redlands Bicycle Classic

ROANOKE, Virginia — April 18, 2023  /ENDURANCE SPORTSWIRE/ – Virginia’s Blue Ridge TWENTY24 pro cycling team could not have written a better outcome for the 37th edition of the Redlands Bicycle Classic, presented by San Manuel Band of Mission Indians. After five stages, Emily Ehrlich stood atop the GC podium in...

Cycling

Events

Press Releases

April 18, 2023

Cycling Time Trials (CTT) launches major update to recognise road bike time trialling as its own category

/ENDURANCE SPORTSWIRE/ – Cycling Time Trials (CTT) today launches major new website functionality that will seamlessly integrate road bikes into all events, but crucially separate them into their own category in the results. Riders who choose a standard road bike with drop handlebars and spoked wheels over a dedicated TT bike...

Cycling

Press Releases

Products

April 18, 2023

Saris Announces New Rack Products and Innovations for Spring/Summer 2023

MADISON, Wis. (April 18, 2023) /ENDURANCE SPORTSWIRE/ - Saris, manufacturer of world-class bike racks, trainers, storage and infrastructure, announces a number of new product offerings and a few additions to their most popular collections for the spring/summer season. Just in time for warmer temps, Saris products can now accommodate an...

Cycling

Press Releases

Products

Triathlon

April 18, 2023

GSI Outdoors Supports La Jolla Kelp Restoration Initiative with SeaTrees Partnership and Contest Giveaway

Spokane, Wash. — April 18, 2023  /ENDURANCE SPORTSWIRE/ – GSI Outdoors, a premium camp kitchen, cookware, dining, and hydration gear company, is proud to announce its partnership with SeaTrees to support the La Jolla Kelp Restoration Initiative during Earth Month. GSI Outdoors and its partner brands share a stewardship for our...

Business

Giving

Press Releases