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

April 3, 2024

ROUVY Takes Challenge Family The Championship Live with Free Global Broadcast

/ENDURANCE SPORTSWIRE/ - 3 April 2024. All the action from Challenge Family The Championship, featuring many of the world’s top athletes, can be enjoyed by triathlon fans around the world for free via a live stream in partnership with ROUVY. While the full professional field is yet to be announced,...

Events

Press Releases

Triathlon

April 3, 2024

GP NYC adds 9th Pro Team to stacked field

NEW YORK CITY, April 3, 2024 /ENDURANCE SPORTSWIRE/ – The inaugural UCI 1.2 men elite pro race Gran Premio New York City will be held on May 19, 2024 on the same course and same day as the 12th annual mass participation race Michelob ULTRA GFNY World Championship NYC. The...

Cycling

Events

Press Releases

April 3, 2024

Denver Colfax Marathon Partners with CommonSpirit Health

Denver, CO /ENDURANCE SPORTSWIRE/ - The Denver Colfax Marathon, presented by Cigna Healthcare, is partnering with CommonSpirit Health in Colorado to offer runners more resources throughout the race season. This new collaboration will give registered runners complimentary race day photos during the May 2024 marathon weekend. “CommonSpirit’s support has allowed...

Business

Events

Press Releases

Running

Sponsorship

April 2, 2024

Embark on a once-in-a-lifetime adventure with Marathon Tours & Travel’s inaugural Arctic Marathon package

2nd April 2024 /ENDURANCE SPORTSWIRE/ – Responding to the overwhelming demand from Seven Continents Club® (SCC) Members and Antarctica Marathon® Alumni, Marathon Tours & Travel has curated a meticulously planned itinerary that guarantees an unparalleled experience. With over half of the available slots filled, interested participants are urged to secure their...

Events

Press Releases

Running

April 2, 2024

USA Cycling Announces 2024 UCI BMX Racing World Championships Team Competing in Rock Hill, S.C.

ROCK HILL, S.C. /ENDURANCE SPORTSWIRE/ – The 2024 UCI BMX Racing World Championships will return to Rock Hill, S.C., U.S.A. May 12-18. The upcoming event will mark the venue's second time hosting the UCI World Championships, following its successful debut in 2017. At the 2017 race, American’s Corben Sharrah (Tucson, Arizona;...

Cycling

Events

Press Releases

April 2, 2024

Boston Road Runners and Next Generation Donation Support Run on Movemint

SAN FRANCISCO /ENDURANCE SPORTSWIRE/ - Movemint, the platform for athletic events, is thrilled to announce its partnership with Boston Road Runners and the launch of next generation donation support. The Boston Road Runners is an organization committed to fostering a vibrant and inclusive running community for people of all backgrounds...

Business

Events

Press Releases

Products

Running

April 2, 2024

Dave McGillivray To Compete In 52nd Consecutive Boston Marathon During The Day

BOSTON, Mass. /ENDURANCE SPORTSWIRE/ – After 36 years of running the Boston Marathon presented by Bank of America at night and being the final finisher of the race, Dave McGillivray will take to the race course during the daylight hours this year. He plans to join the field of 30,000...

Events

Giving

Press Releases

Running

April 1, 2024

Natural Grocers® Debuts “Spin & Blend” Fitness Classes…Coming Soon???

LAKEWOOD, Colo., Apr. 1, 2024 /ENDURANCE SPORTSWIRE/ - Natural Grocers®, America's Nutrition Education ExpertsSM and the largest family-operated organic and natural grocery retailer in the U.S., is proud to introduce its free community “Spin & Blend” fitness classes…just in time for April Fools’ Day. The revolutionary spinning classes combine short bursts of...

Business

Cycling

Events

Press Releases