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

June 6, 2023

Challenge Geraardsbergen Gears Up for Great Race Weekend

/ENDURANCE SPORTSWIRE/ – This coming weekend a great battle awaits at Challenge Geraardsbergen. Dutch defending champion Diede Diederiks returns hoping to win again and in the men's race Joe Skipper, Ruben Zepuntke and Menno Koolhaas are ready for a head-to-head. Challenge Geraardsbergen is not only a beautiful, but also a very...

Events

Press Releases

Triathlon

June 6, 2023

Eric Engemann introduced as the new Sales Director for FRESHJUNKIE Racing

Baton Rouge, LA /ENDURANCE SPORTSWIRE/ - FRESHJUNKIE Racing (FJR), a leading sports event management company, is thrilled to announce the appointment of Eric Engemann as the Sales Director. With a diverse background in event management, leadership, and community engagement, Eric joins FJR full-time after successfully leading Franciscan High School as...

Business

Events

Press Releases

Sponsorship

June 6, 2023

Enabled Tracking continues to support events with live tracking

June 6, 2023, Front Royal, Va. /ENDURANCE SPORTSWIRE/ - As June begins, Adventure Enablers' live tracking wing, Enabled Tracking, is excited to welcome new and returning customers who seek live event tracking services for their logistical needs, participant safety, online engagement, and sponsor exposure. Mark Harris, the owner of Enabled Tracking,...

Business

Events

Press Releases

Products

June 6, 2023

Fun-Filled Virtual Community Event Focused on People Living with Parkinson’s

/ENDURANCE SPORTSWIRE/ - As an organization dedicated to research, education and raising funds to support people with Parkinson’s and their caregivers, the Davis Phinney Foundation is delighted to bring our supporters a virtual event for all abilities. Run, ride, practice yoga, swim, you name it. We are excited to get...

Cycling

Events

Press Releases

Running

June 5, 2023

25 Years and Running: 27,000 Registered Runners Take on the 25th Edition of Rock ‘N’ Roll Running Series San Diego, The Largest Marathon and Half Marathon Weekend on The West Coast

SAN DIEGO, Calif./ENDURANCE SPORTSWIRE/ - The 25th running of the Rock ‘n’ Roll® Running Series San Diego showcased it is as popular as ever, hosting over 27,000 registered runners from all 50 states and 42 countries, regions, and territories for the largest marathon and half marathon weekend on the West...

Events

Press Releases

Running

June 4, 2023

Noble and Nieuwoudt dominate at Challenge Gunsan-Saemangeum

/ENDURANCE SPORTSWIRE/ - Professional long distance racing returned to South Korea this weekend with Challenge Gunsan-Saemangeum and it was Australia’s Caleb Noble who took out the men’s win in 8:01:23 and Magda Nieuwoudt took the women’s in 9:00:51, both with convincing wins. Noble was out of the water neck and...

Events

Press Releases

Triathlon

June 4, 2023

Margirier and Thek Take the Wins at OTSO Challenge Salou

/ENDURANCE SPORTSWIRE/ - Perfect conditions greeted the athletes at OTSO Challenge Salou on a day that delivered stunning racing from Mathis Margirier (FRA) and Grace Thek (AUS) who took the wins under the hot Spanish sun in front of a crowd of thousands on Spain’s Costa Daurada. The day started...

Events

Press Releases

Triathlon

June 4, 2023

Keegan Swenson and Carolin Schiff win Garmin UNBOUND Gravel 200 presented by Craft Sportswear

Emporia, Kan., /ENDURANC ESPORTSWIRE/ - Keegan Swenson and Carolin Schiff won the 2023 edition of Life Time’s (NYSE: LTH) Garmin UNBOUND Gravel presented by Craft Sportswear. Featuring the largest field size in the event’s history, approximately 4,000 riders took on grueling courses through the Flint Hills region completing 25-mile, 50-mile, 100-mile,...

Cycling

Events

Press Releases