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

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

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