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

September 12, 2023

Expedition Ozark Returns in April 2024

BENTONVILLE /ENDURANCE SPORTSWIRE/ – Ozark Foundation has announced the date of the 2nd annual Expedition Ozark, a multi-day, expedition level adventure race in Northwest Arkansas in April 2024. The race start coincides with the solar eclipse on April 8. Most of Arkansas will be on the total eclipse path providing a dramatic...

Events

Press Releases

Running

September 12, 2023

Combining Striking Style and Innovative Technology; Rudy Project North America Releases Groundbreaking Kelion Sunglasses

San Clemente, CA, September 12, 2023 /ENDURANCE SPORTSWIRE/ - Rudy Project, Italian designers of sports performance eyewear and helmets, announces the release of Kelion, a new premier, sports sunglass designed to elevate the performance of athletes. The Kelion features a sleek, wrap-around cylindrical lens with a 5.2 base curve for...

Cycling

Press Releases

Products

Running

Triathlon

September 12, 2023

The RunnerBox and The RiderBox Help Athletes Finish the Season Strong with Their Latest Edition

/ENDURANCE SPORTSWIRE/ – The RunnerBox and The RiderBox unveiled their latest editions which showcases featured picks to help subscribers finish strong as they take on their late-summer workouts and races. Consistently named the top subscription box for athletes, The RunnerBox and The RiderBox deliver bi-monthly boxes to subscribers that highlight...

Cycling

Press Releases

Products

Running

Triathlon

September 11, 2023

RACE RESULT Introduces Groundbreaking Timing System “Ubidium” to Redefine Race Timing Standards

/ENDURANCE SPORTSWIRE/ – RACE RESULT, the pioneering force in sports timing technology, has now officially launched "Ubidium", the most advanced and accurate timing system on the market. This cutting-edge solution promises to elevate the experience for timekeepers and event organizers alike, introducing numerous innovative features and streamlining the processes at...

Cycling

Events

Press Releases

Products

Running

Triathlon

September 11, 2023

B.A.A. Announces 2024 Bank of America Boston Marathon Official Charity Program Members

BOSTON /ENDURANCE SPORTSWIRE/ – The Boston Athletic Association (B.A.A.) has announced that 160 organizations have been selected for the 2024 Bank of America Boston Marathon® Official Charity Program. All organizations will raise valuable funds for worthy causes leading up to the 128th Boston Marathon presented by Bank of America on Monday,...

Giving

Press Releases

Running

September 11, 2023

XTERRA European Trail Run Championship: Haunschmidt, Merli Win Marathon Distance While Zizzamia, Borg Take Half Marathon Titles

/ENDURANCE SPORTSWIRE/ – In the heart of the Brenta Dolomites, a UNESCO World Heritage site, the XTERRA European Trail Run Championship unfolded against a backdrop of incredible views and intense competition. Starting from the serene Lake Molveno and traversing the central Brenta region, trail runners vied for a share of...

Events

Press Releases

Running

Triathlon

September 11, 2023

History Making Day In At The VinFast IRONMAN World Championship As The Event Takes Place Outside Of The United States For The First Time

- The 2023 VinFast IRONMAN World Championship hosted a men’s-only field in Nice - France’s Sam Laidlow becomes the first athlete from France to win the IRONMAN World Championship; Laidlow is the youngest athlete to win the pinnacle event NICE, France (Sep. 11, 2023)/ENDURANCE SPORTSWIRE/ – For the first time in...

Events

Press Releases

Triathlon

September 10, 2023

France’s Sam Laidlow Captures First IRONMAN World Championship Title on Home Soil At 2023 Vinfast IRONMAN World Championship in Nice, France

NICE, France (Sept. 10, 2023) /ENDURANCE SPORTSWIRE/ - History was made on Côte de Azur today, as the first-ever VinFast IRONMAN World Championship to take place in Europe unfolded in Nice, France. It was Sam Laidlow, racing for France, who enjoyed a dominant victory on home soil. Laidlow used a...

Events

Press Releases

Triathlon