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

October 18, 2023

World Class Field Heads to Challenge Vieux Boucau

/ENDURANCE SPORTSWIRE/ – First of all, in the men’s race, Challenge Vieux Boucau has attracted a number of unparalleled French champions: Dorian Coninx, who just last month won the WTCS Finals in Pontevedra, comes to Vieux Boucau with only one goal: to win. Coninx, who is preparing for the 2024...

Events

Press Releases

Triathlon

October 18, 2023

Gladstone appoints Endurance Zone to revolutionise member engagement in the UK leisure industry

/ENDURANCE SPORTSWIRE/ – Gladstone, a leading leisure management solution provider for gyms, universities, and health clubs, has announced a strategic partnership with Endurance Zone, a global provider of reward and engagement solutions built for the sports, fitness, and health sector. This innovative collaboration aims to enhance member engagement and loyalty...

Business

Press Releases

Products

Running

October 18, 2023

Nine Athletes Vie For The Title As Super League Triathlon’s Championship Series Reaches Thrilling Climax In NEOM

LONDON, UK/ENDURANCE SPORTSWIRE/ – Titles, money and glory are all on the line as Super League Triathlon’s Championship Series builds to a thrilling finale in NEOM on Saturday (October 21). Four women and five men arrive in Saudi Arabia within touching distance of the coveted trophy, and a significant share...

Events

Press Releases

Triathlon

October 18, 2023

Sprint finish at 2nd edition of GFNY Bento Gonçalves

New York City, October 18, 2023 /ENDURANCE SPORTSWIRE/ - Bento Gonçalves, located in the heart of Brazil´s Sierra Gaúcha, hosted the 2nd edition of GFNY Bento Gonçalves, this past Sunday. The racecourse was 135.9km long with a tough 2721m of climbing. A group including GFNY Bento 2022 champion and pro...

Cycling

Events

Press Releases

October 17, 2023

Tri-Cities, Washington Becomes New Host Venue for IRONMAN 70.3 Washington Tri-Cities Triathlon

RICHLAND, Wash. / TAMPA, Fla. (Oct. 17, 2023) /ENDURANCE SPORTSWIRE/ - IRONMAN announced today that Tri-Cities, Washington, will become the host venue for the IRONMAN® 70.3® Washington Tri-Cities triathlon in 2024. The Tri-Cities area sits at the confluence of three rivers in southeast Washington where the cities of Richland, West...

Events

Press Releases

Triathlon

October 17, 2023

USA Cycling Partners with USC Masters Sports Science to Offer High Performance Internship Program

CARSON, Calif. /ENDURANCE SPORTSWIRE/ – USA Cycling, the national governing body for competitive cycling in the United States, is thrilled to announce a partnership with the University of Southern California (USC) Masters Sports Science Program. This collaboration is set to provide an educational opportunity for students in a high-performance cycling environment....

Business

Cycling

Press Releases

October 17, 2023

XTERRA Australia 2024: Dynamic Races Await in Dunsborough

DUNSBOROUGH, Western Australia /ENDURANCE SPORTSWIRE/ – The picturesque coastal town of Dunsborough is once again set to host XTERRA Australia in 2024. This event has rapidly gained a reputation as one of the premier off-road triathlons on the global circuit. Scheduled for April 20-21, it promises to be a blend of...

Events

Press Releases

Running

Triathlon

October 17, 2023

A New Novel Shows Young Girls Just How Strong They Can Be

/ENDURANCE SPORTSWIRE/ – The Strong Girl by Molly Hurford, author of the Shred Girls series, is hitting the shelves on October 17, 2023. This is Hurford’s first historical fiction novel and while it has a circus themed setting, the real focus is around the real strength that all girls possess....

Cycling

Press Releases

Products

Running

SWW Syndication

October 17, 2023

The 2023 IMT Des Moines Marathon Shatters Registration Targets For All Events

Des Moines, IA /ENDURANCE SPORTSWIRE/ – The 2023 IMT Des Moines Marathon race weekend smashed expectations for race organizers and participants of the IMT Des Moines Marathon & Half Marathon, the Bankers Trust Marathon Relay, the Principal 5K Road Race, and the MercyOne Children’s Hospital Kids Run. Held on Sunday, October...

Events

Press Releases

Running

October 17, 2023

Empowering The Athlete Within: Exercise Intelligence Partners with Supersapiens

Atlanta – 17 October 2023 /ENDURANCE SPORTSWIRE/ – Supersapiens, the world’s first glucose management system for athletes, is excited to announce its strategic partnership with Exercise Intelligence (EXI), an acclaimed health and exercise innovator. United in a shared vision, both entities aim to "awaken the athlete within everyone", harnessing the power...

Business

Press Releases