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

October 18, 2023

Challenge Egnazia Tri Kicks Off in Spectacular Puglia This Weekend

/ENDURANCE SPORTSWIRE/ – In the men’s race, Menno Koolhaas, among others, is at the start of Challenge Egnazia: the Dutchman became European Champion Long Distance at Challenge Almere-Amsterdam last month, but experienced an off-day at Challenge Peguera-Mallorca last weekend, where he still finished tenth nevertheless. Fighting for the best possible...

Events

Press Releases

Triathlon

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

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

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

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

Key West Half Marathon & Runfest Reveals Shirts and Medals for 2024 Race

KEY WEST, Fla. /ENDURANCE SPORTSWIRE/ – The Key West Half Marathon & Runfest, rated a top 10 half marathon by USA Today, is back on Jan. 14, 2024. The event has unveiled new race day shirts that feature artwork by local artist Taylor Hale. Participants will also receive a newly designed...

Events

Press Releases

Running

October 16, 2023

Over 1,300 Registered Runners Took on Kodiak Ultra Marathons by UTMB Over Three Days

BIG BEAR LAKE, Calif. /ENDURANCE SPORTSWIRE/ - The 2023 UTMB® World Series continued with the 2023 Kodiak Ultra Marathons by UTMB® on Oct. 13 - 15. The 10th anniversary of the race featured over 1,300 registered runners from 40 States and 27 countries, regions, and territories as they descended on...

Events

Press Releases

Triathlon