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 (22)
) 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 430, 10

December 4, 2023

Thousands of Tiger Fans Finish on the 50

Baton Rouge, LA. /ENDURANCE SPORTSWIRE/ - Nearly 5,000 runners and walkers descended upon Tiger Stadium for the 6th Annual Our Lady of the Lake Health Tiger 10K. Passionate fans eager for their opportunity to Finish on the 50-yard line contributed to the record-breaking field size. 21-year-old William Ellender from Baton...

Events

Press Releases

Running

Sponsorship

November 30, 2023

Memorial Hermann and IRONMAN Agree to Multi-Year Extension of Title Partnership for IRONMAN Texas Triathlon

THE WOODLANDS, Texas / TAMPA, Fla. (Nov. 30, 2023) /ENDURANCE SPORTSWIRE/ – IRONMAN® and Memorial Hermann have entered into a multi-year extension to continue as the title partners of the Memorial Hermann IRONMAN® Texas triathlon, part of the VinFast IRONMAN North America Series. Registration for the 2024 Memorial Hermann IRONMAN North...

Events

Press Releases

Sponsorship

Triathlon

November 28, 2023

The San Diego Crew Classic Extends Partnership with RegattaCentral

/ENDURANCE SPORTSWIRE/ - The San Diego Crew Classic has extended its partnership with RegattaCentral, the leading online solutions provider for the rowing community. For the next five years, RegattaCentral will remain the Official Registrar for the event. For almost 20 years, this partnership has played a crucial role in the...

Events

Press Releases

Sponsorship

November 21, 2023

Canyon CLLCTV Rider Brad Simms Releases “Take Flight” Video Series

/ENDURANCE SPORTSWIRE/ – ANNOUNCEMENT: In collaboration with Brad Simms, Canyon Bicycles will release a new 4-part mini-series, "Take Flight," on November 21st at 17:00 CET. All four "Take Flight" episodes will be available for binge-watching on Canyon's YouTube channel, @CanyonBicycles. SERIES DESCRIPTION: Renowned BMX rider and Canyon CLLCTV rider Brad...

Cycling

Press Releases

Sponsorship

November 21, 2023

Showcased

The Duel In The Desert: A Union Of Cycling Legends – Specialized Cactus Cup And Belgian Waffle Ride Arizona

Cave Creek and Fountain Hills, AZ /ENDURANCE SPORTSWIRE/ - In a soon to be historic collaboration, two iconic cycling races, the Specialized Cactus Cup and the Belgian Waffle Ride (BWR), are set to merge for a thrilling back-to-back cycling extravaganza, the "Duel in the Desert." Taking place on consecutive Saturdays, March...

Awards

Cycling

Events

Press Releases

Sponsorship

November 20, 2023

Synergy is Created as USA Triathlon Partners with Synergy Wetsuits

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – USA Triathlon is proud to announce its partnership with Synergy Wetsuits, as the organization’s exclusive wetsuit partner beginning in 2024. The partnership will support USA Triathlon’s high-performance programming with high quality products including wetsuits, swimskins, and swim caps. USA Triathlon members will also have access to Synergy’s...

Press Releases

Sponsorship

Triathlon

November 16, 2023

GROSCHE to be the Official Drinkware of Spartan U.S. and Canada

BOSTON, MASS. (November 16, 2023) — Spartan, the world’s leading endurance sports and extreme wellness brand, announced that GROSCHE is an official sponsor, and designated GROSCHE water bottles will be the official drinkware of Spartan U.S. and Canada. “We are excited to be Partnering with GROSCHE for a number of...

Press Releases

Running

Sponsorship

November 14, 2023

USA Triathlon Chooses Nirvana as Exclusive Travel Management Partner

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – USA Triathlon today announced it has partnered with Nirvana as the organization’s exclusive travel management services partner for athlete and national office travel through specialized travel services designed to seamlessly integrate with USA Triathlon’s travel needs. Nirvana will also support USA Triathlon’s National Championship events in collaboration...

Press Releases

Sponsorship

Triathlon