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

April 11, 2023

First top seeds announced for The Championship 2023

/ENDURANCE SPORTSWIRE/ – It’s almost showtime at The Championship: more than sixty professional athletes will compete for the win at Challenge Family's flagship event on 21 May at the x-bionic® sphere in Šamorín, Slovakia. Once again, many world class triathletes will line up with their eye on the coveted titles in...

Events

Press Releases

Triathlon

April 11, 2023

TCS Toronto Waterfront Marathon Earns Evergreen Certification for Commitment to Sustainability and Community Impact

TORONTO April 11, 2023 /ENDURANCE SPORTSWIRE/ - The TCS Toronto Waterfront Marathon (TWM), Canada's premier running event, has been newly awarded with an Evergreen certification by the Council for Responsible Sport, earning the race the highest distinction possible for outstanding social, environmental, economic and community impact. TWM's successful efforts to...

Awards

Events

Press Releases

Running

April 11, 2023

Course Records, Qualifiers, and Impressive Results Highlight Picture-Perfect Carmel Marathon Weekend

CARMEL, Ind. (April 11, 2023) /ENDURANCE SPORTSWIRE/ - Under sunshine and ideal racing conditions, the 2023 Carmel Marathon Weekend started with a full capacity participant field and finished with five course records. More than 4,000 participants crossed the start line after traveling to Carmel, Ind. from 40 states and six...

Events

Press Releases

Running

April 10, 2023

RunSignup Announces RaceJoy’s 10 Year Anniversary

April 11, 2023 - Moorestown, NJ /ENDURANCE SPORTSWIRE/ - RunSignup, the leading registration and technology provider for U.S. endurance events, announces RaceJoy’s ten year milestone. RaceJoy is RunSignup’s interactive race day mobile app with more than 1.7 million users at more than 6,300 events during the last 10 years. RaceJoy...

Business

Cycling

Events

Press Releases

Products

Running

Triathlon

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 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