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 (16)
) 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 2960, 10

August 28, 2022

Athletes TRI-umph at 39th Running of Life Time Chicago Triathlon Aug. 27-28

CHICAGO (August 28, 2022)/ENDURANCE SPORTSWIRE/ – Nearly 7,000 triathletes descended upon the Windy City this weekend to swim, bike and run in the Life Time Chicago Triathlon. Competitors kicked off the weekend of racing on Saturday with the Chicago Kids Tri and SuperSprint races at Foster Beach, followed on Sunday by...

Events

Press Releases

Triathlon

August 26, 2022

Canadians McBride and Britton Take the Pot in the First TransRockies Gravel Royale

Panorama, B.C. (August 26, 2022) /ENDURANCE SPORTSWIRE/ – TransRockies Race Series just completed a successful inaugural TransRockies Gravel Royale presented by Felt gravel stage race. The event brought 200 athletes from eight countries and 22 states/provinces with all different riding experience and abilities to enjoy the Kootenay Mountains on two-wheels. The...

Cycling

Events

Press Releases

August 26, 2022

XTERRA USA Champs Returns to CO in August 2023

August 26, 2022/ENDURANCE SPORTSWIRE/ – The 22nd annual XTERRA USA Championship off-road triathlon will return to Beaver Creek Resort in conjunction with a community festival at Harry A. Nottingham Park in Avon, Colorado on August 25-27, 2023. XTERRA will host full-distance, sprint, relay, and beginner-friendly off-road triathlons along with trail runs,...

Events

Press Releases

Running

Triathlon

August 25, 2022

Team USA Rides to Two Top-10 Finishes in Junior Cross-Country World Championships

August 25, 2022, LES GETS, France /ENDURANCE SPORTSWIRE/ - Day two of the 2022 UCI Mountain Bike World Championships brought on Junior Cross-Country racing and the Downhill Qualifications. Junior Women’s Cross-Country The Junior Women had a four-lap race with Bailey Cioppa (Durango, Colo.; Bear National Team) taking the first call-up for...

Awards

Cycling

Events

Press Releases

August 25, 2022

Community BIKE JAM Kicks Off Maryland Cycling Classic Weekend

BALTIMORE, Md. /ENDURANCE SPORTSWIRE/ –  The Maryland Cycling Classic, supported by UnitedHealthcare, kicks off its full weekend of events with a community enrichment day on Thursday, September 1, 2022, highlighted by a City of Baltimore Community Bike Jam at Patterson Park near the Pulaski Monument, from 4:30 p.m. to 7 p.m. ET,...

Cycling

Events

Press Releases

August 25, 2022

Showcased

Ann Arbor Marathon Offers Corporate Wellness Program to Local Companies

Ann Arbor, MI (August 25, 2022) /ENDURANCE SPORTSWIRE/ – The 11th annual Probility Ann Arbor Marathon will feature a new promotional opportunity for local businesses: Epic Races’ Corporate Wellness Program. This health and wellness-focused initiative allows companies to promote their businesses at the Marathon and beyond while encouraging a focus on...

Events

Press Releases

Running

August 25, 2022

The 2022 Giant Race presented by Alaska Airlines welcomed more than 5,000 participants to Oracle Park

August 25, 2022 (San Francisco, California): Giants Enterprises, the development and entrepreneurial arm of the San Francisco Giants Major League Baseball franchise, hosted the 13th Annual San Francisco Giant Race last weekend, welcoming more than 5,000 runners, walkers and families to Oracle Park to take part in exciting activations plus...

Events

Press Releases

Running

August 25, 2022

BibRave Brightens Knockaround Brand Experience at Outside Lands

Portland, OR /ENDURANCE SPORTSWIRE/ – BibRave, the endurance, fitness, and lifestyle marketing agency was recently tapped to help create and execute an engaging brand activation for Knockaround Sunglasses during Outside Lands, a San Francisco-based, three-day festival celebrating music, food, wine, beer, art, and more. BibRave, in partnership with Knockaround’s corporate leadership, managed...

Events

Press Releases

Products