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

April 8, 2023

Wahoo Fitness and The Wahooligan Tour Raise Over $200K for the Davis Phinney Foundation for Parkinson’s

LOUISVILLE, COLORADO /ENDURANCE SPORTSWIRE/ - The Davis Phinney Foundation garnered over $200K in a partnership with Wahoo Fitness and its indoor cycling event, The Wahooligan Tour, previously called the Tour of Sufferlandria. Over 1500 riders from 45 countries participated in the seven-day virtual tour from Sunday, March 12, through Saturday,...

Business

Cycling

Events

Press Releases

Products

April 8, 2023

Your Bike, Your Way

Minneapolis, MN/ENDURANCE SPORTSWIRE/ - Erik’s Bike Shop, Inc., the largest independent bicycle retailer in the U.S. is now an official online partner with Specialized Bicycles. Previously, Specialized Bicycles were only available to ship directly to riders through the Specialized consumer direct site. “Specialized has been ERIK’S number one brand partner...

Business

Cycling

Press Releases

Sponsorship

April 7, 2023

XTERRA Short Track for Amateurs, First-time this Sept in Trentino

/ENDURANCE SPORTSWIRE/ For the first-time ever, the exciting new XTERRA Short Track off-road triathlon racing format will be open to amateur athletes of all ages and skill levels in Trentino, Italy, on Sunday, September 24, 2023, the day after the XTERRA World Championship. The exhibition relay race will welcome 50...

Events

Press Releases

Triathlon

April 7, 2023

Kidanu, Chelangat Claim PRRO Championship Crowns at Credit Union Cherry Blossom 10 Mile

/ENDURANCE SPORTSWIRE/ WASHINGTON, DC – Under cool, sunny, windy conditions on Sunday, April 2, Tsegay Kidanu of Ethiopia and Sarah Chelangat of Uganda won the 50th Credit Union Cherry Blossom 10 Mile as well as PRRO Championship titles in 46 minutes, 8 seconds and 52:04, respectively. Each 21-year-old winner earned...

Events

Press Releases

Running

April 7, 2023

50th Anniversary Hospital Hill Run Celebrates Milestone with Half Marathon Prize Money

/ENDURANCE SPORTSWIRE/ Kansas City, Missouri – April 7, 2023 – The Hospital Hill Run, Kansas City's Grandfather of all Kansas City road races, is celebrating its 50th anniversary on Saturday, June 3, 2023, at 7 AM in Crown Center. To commemorate this milestone, the event's organizers are pleased to announce...

Events

Press Releases

Running

April 6, 2023

Challenge Family Adds Challenge Malaysia to the 2023 Race Calendar

/ENDURANCE SPORTSWIRE/ - The futuristic smart metropolis of Forest City is the latest destination for Challenge Family with today’s announcement of Challenge Malaysia, set for 2 September 2023. Challenge Malaysia will take place almost entirely within the limits of this fascinating city which stands on reclaimed land across four man-made...

Events

Press Releases

Triathlon

April 6, 2023

Iron Horse Bicycle Classic Announces Mountain Bike Race Details

Durango, Colo. (March 6, 2023) /ENDURANCE SPORTSWIRE/ This year’s Iron Horse Bicycle Classic Subaru Mountain Bike Race will harken back to the past, using similar trails as the 2001 UCI World Cup course. The 5-mile lap will start and end at Chapman Hill and loop around the prominent mesa just east...

Cycling

Events

Press Releases

April 6, 2023

Attaquer Launches ATQ Out of Office Project

SYDNEY, Australia /ENDURANCE SPORTSWIRE/ Inspired by the incredible things its community gets up to wearing its kit, Attaquer is announcing the ATQ Out Of Office Project. They are putting out a tender to pitch for anyone who wants to document a crazy ride, big adventure, or unique creative concept. If...

Cycling

Press Releases

Products