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

May 1, 2024

IRONMAN Pro Series Start Lists Announced For Zafiro IRONMAN 70.3 Alcúdia-Mallorca

- The 2024 Zafiro IRONMAN 70.3 Alcúdia-Mallorca is the first IRONMAN Pro Series race in Europe, and will have a total event pro prize pot of $50,000 on the line - Winners will earn 2,500 points, with points decreasing as the race time increases, encouraging tight and exciting races -...

Events

Press Releases

Triathlon

May 1, 2024

FRESHJUNKIE Racing Celebrates Three Half Marathons Named Best in Their Respective States

BATON ROUGE, LA /ENDURANCE SPORTSWIRE/ – FRESHJUNKIE Racing is thrilled to announce that three of its marquee events have been recognized as the best half marathons in their respective states. The prestigious accolades were bestowed upon The Louisiana Marathon, the War Eagle Run Fest, and the Mississippi Gulf Coast Marathon,...

Awards

Events

Press Releases

Running

May 1, 2024

Olympic Legend Nelson Vails to Lead Team GFNY at Inaugural Gran Premio NYC

New York City, May 1, 2024 /ENDURANCE SPORTSWIRE/ - GFNY has announced that Olympic track cycling legend, and U.S. Bicycle Hall of Famer Nelson “The Cheetah” Vails will serve as the Directeur Sportif of Team GFNY in the inaugural Gran Premio NYC on May 19, 2024. Vails, who won the...

Cycling

Events

Press Releases

April 30, 2024

Coastal Beauty and Determination Mark the 37th Annual Big Sur International Marathon

CARMEL, CA /ENDURANCE SPORTSWIRE/ - The 37th Annual Big Sur International Marathon concluded with resounding success, as runners embraced the challenge of a new out-and-back course along the coast passing through scenic Point Lobos. Despite the unexpected course alteration due to a highway slip-out in March, participants displayed resilience and...

Events

Press Releases

Running

April 30, 2024

Champion Triathlete Timothy O’Donnell to Race at XTERRA Québec

/ENDURANCE SPORTSWIRE/ – The XTERRA Community is pleased to announce that Timothy O’Donnell (USA) will participate in the fifth stop of the 2024 XTERRA World Cup. The event will take place in Canada on July 14, 2024, at XTERRA Québec, featuring the world’s top off-road triathletes. Timothy O’Donnell, born on...

Events

Press Releases

Triathlon

April 30, 2024

RaceRaves announces Best Half Marathons in the U.S.

Los Angeles, CA (April 30, 2024)/ENDURANCE SPORTSWIRE/ – The runners have spoken and RaceRaves, the nation’s premier race finder & reviews community, has announced the much-anticipated results of its 2024 initiative to crown the best half marathon in every U.S. state. The company’s authoritative new guide, which features a profile of...

Awards

Events

Press Releases

Running

April 30, 2024

This Season On Zwift

/ENDURANCE SPORTSWIRE/ – Wherever you’re located in the world, the seasons are changing which can mean only one thing - it’s time to preview some of the new product features and benefits you can expect from Zwift over the coming months! This season will help Zwifters reach new fitness heights...

Cycling

Events

Press Releases

Products

April 30, 2024

Lassonde Renews Commitment to Canada Running Series & the Oasis ZooRun for a 19th Consecutive Year

TORONTO, APRIL 30, 2024 /ENDURANCE SPORTSWIRE/ – Canada Running Series proudly announces the renewal of its enduring partnership with Lassonde for an additional four-year term, solidifying their collaboration on the annual Oasis ZooRun and other CRS events through 2027. Since joining forces in 2006, Lassonde, through it’s Oasis Juice brand,...

Events

Press Releases

Running

Sponsorship

April 30, 2024

Chargel Fuels Runners with On-Site Sampling at The OC Marathon

Orange Country, Calif. (April 30, 2024)/ENDURANCE SPORTSWIRE/ – Chargel®, a first-of-its-kind, delicious Gel Drink that delivers convenient and delightfully unexpected instant pre-workout energy with zero caffeine, today announced it will be sampling its delicious half drink, half snack energy gels along the course of the Hoag OC Marathon Running Festival....

Events

Press Releases

Products

Running

Wire Syndication