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

November 21, 2022

ROUVY drops the best deal of the year on a Black Friday Week

November 21st, 2022 /ENDURANCE SPORTSWIRE/ – It is time for great deals, and ROUVY’s indoor cycling platform is no exception. Providing a great service and marquee events all year round non-stop, ROUVY always offers some options of small discounts here and there, which are devoted to various specific cycling and tri...

Cycling

Press Releases

Products

Triathlon

November 21, 2022

2023 Air Force Marathon Registration Opens Cyber Monday

/ENDURANCE SPORTSWIRE/ - Holiday shopping deals will not end after Thanksgiving weekend as Air Force Marathon participants will have the chance to earn early savings on their 2023 event registrations Cyber Monday. Registration opens for the Air Force Marathon at 9 a.m. Nov. 28 with participants receiving an early bird...

Events

Press Releases

Running

November 21, 2022

3M Half Marathon Continues Partnership with Nuun

AUSTIN, Texas /ENDURANCE SPORTSWIRE/ – High Five Events, one of the largest privately owned event production companies in the United States, welcomes back Nuun as the Official Hydration of the 3M Half Marathon. The agreement means Nuun will hydrate runners chasing their half marathon Personal Records (PR) through 2023. The 29th...

Press Releases

Running

Sponsorship

November 20, 2022

3,000 Runners hit the streets of Norfolk for the 9th Annual Chartway Norfolk Harbor Half Marathon

NOVEMBER 20, 2022 – NORFOLK, VIRGINIA /ENDURANCE SPORTSWIRE/ –  Over 3,000 runners made their way down the historic streets of Norfolk during the Chartway Norfolk Half Marathon presented by Bon Secours. Runners from 35 states crossed the finish line both Saturday and Sunday. Runners began their weekend with packet pickup on Friday...

Events

Giving

Press Releases

Running

November 20, 2022

Joe Skipper (GBR) and Sarah True (USA) Victorious at the 2022 Biostarks IRONMAN Arizona Triathlon, part of the VinFast IRONMAN U.S. Series

TEMPE, Arizona (November 20, 2022) /ENDURANCE SPORTSWIRE/ – The Valley of the Sun and Tempe played host to the 17th edition of the Biostarks IRONMAN Arizona triathlon, part of the VinFast IRONMAN U.S. Series on Sunday, Nov. 20. This year’s edition of the event saw athletes swim 2.4 miles, bike 112...

Events

Press Releases

Triathlon

November 18, 2022

Côte d’Azur in Southern France Welcomes Two Challenge Family Races for 2023

/ENDURANCE SPORTSWIRE/ - Challenge Frèjus and Challenge Cagnes-sur-Mer, both on the Côte d’Azur, have joined the Challenge Family race calendar for 2023, bringing two new middle distance races to the south of France next summer. On 13-14 May, Ekoï Challenge Fréjus is a two-day family triathlon festival with five races...

Events

Press Releases

Triathlon

November 18, 2022

Former Owners of Jackpot Ultra Running Festival Issue Statement Regarding Course Length for the 2022 USATF 100-Mile Championship Race

LAS VEGAS, NEVADA – November 18, 2022 /ENDURANCE SPORTSWIRE/ – In response to recent media reports and comments made by USATF officials suggesting the course run during the 2022 USATF 100 Mile Championship race hosted during the Jackpot Ultra Running Festival yielded less than 100 miles, Beyond Limits Running, the prior owner...

Events

Press Releases

Running

November 18, 2022

GU Energy Labs and The McCourt Foundation Announce Multi-Year Partnership

LOS ANGELES & BERKELEY, Calif. – November 18, 2022 /ENDURANCE SPORTSWIRE/ – GU Energy Labs and The McCourt Foundation (TMF) today announced that GU will be the official Energy Gel of The McCourt Foundation events beginning with The Rose Bowl Half Marathon & 5K in January and continuing with the 2023 Los Angeles...

Press Releases

Running

Sponsorship