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

August 14, 2023

Step Up To The Challenge: IRONMAN Announces 2024 IRONMAN Triathlon Race Schedule across the United States and Canada

TAMPA, Fla. (August 14, 2023) /ENDURANCE SPORTSWIRE/ – IRONMAN has announced its 2024 full-distance IRONMAN® triathlon race calendar combining some iconic locations along with athlete favorites for the VinFast IRONMAN North America Series. Athletes looking to complete an IRONMAN triathlon this coming year, will have the opportunity to step up to...

Events

Press Releases

Triathlon

August 14, 2023

The 2023 Edition of Itaú BBA IRONMAN 70.3 Fortaleza Triathlon Designated as IRONMAN 70.3 Latin American Championship

- The second oldest IRONMAN branded race in Brazil is scheduled to take place on November 19, 2023 at Iracema Beach in Fortaleza - General registration for the 2023 Itaú BBA IRONMAN 70.3 Fortaleza event is currently open at www.ironman.com/im703-fortaleza FORTALEZA, Brazil / TAMPA, Fla.  (August 14, 2023) /ENDURANCE SPORTSWIRE/ –...

Events

Press Releases

Triathlon

August 14, 2023

ASICS Falmouth Road Race Partners with Kinomap

FALMOUTH, Mass. (Aug. 14, 2023) /ENDURANCE SPORTSWIRE/ - Runners everywhere can soon experience the thrill of running one of New England’s favorite summer road races on the Kinomap app. The ASICS Falmouth Road Race will be available on the Kinomap for Races platform later this fall. “We’re thrilled to find...

Press Releases

Running

August 13, 2023

XTERRA Czech World Cup Weekend Wrap

/ENDURANCE SPORTSWIRE/ - Felix Forissier (FRA) and Solenne Billouin (FRA) won the XTERRA Czech Republic full-distance off-road triathlon elite titles in Prachatice on Saturday, August 12, 2023, and Billouin and Arthur Serrières (FRA) captured the XTERRA Czech Short Track titles on a beautiful blue sky day at Ktišský Lake on...

Business

Press Releases

Triathlon

August 13, 2023

City2Surf Brings The Party To The Streets Of Sydney

13 August 2023 /ENDURANCE SPORTSWIRE - The City2Surf set the streets of Sydney alive today as the world’s largest fun run returned with over 70,000 participants starting this year’s race. From 7:40am runners made their way along the iconic 14km course from the CBD to Bondi Beach as a wave of...

Events

Press Releases

Running

August 13, 2023

Ed Goddard and Niamh Allen Claim City2Surf Titles

13 August 2023 /ENDURANCE SPORTSWIRE/ - Ed Goddard and Niamh Allen have claimed victory in the men’s and women’s races at the City2Surf as the world’s largest fun run returned to the streets of Sydney this morning. Goddard, who finished as runner-up last year, impressed over the 14km course from start...

Events

Press Releases

Running

August 12, 2023

The Numbers Behind The 2023 City2Surf

12 August 2023 /ENDURANCE SPORTSWIRE/ - The City2Surf returns to the streets of Sydney tomorrow, Sunday 13 August, with tens of thousands of runners preparing to take part in the world-famous event. The 2023 City2Surf will be the 51st physical running of the event, and 53rd in total after going...

Events

Press Releases

Running

August 11, 2023

The Faroe Islands Welcomes the Nordic Islands Adventure Race

/ENDURANCE SPORTSWIRE/ – The fourth edition of the Nordic Islands Adventure Race starts on Sunday morning at the City Hall of Torshavn, the capital town of the Faroe Islands. The race is the 7th Adventure Racing World Series Qualifier of the year and has attracted teams from 11 visiting nations...

Events

Press Releases

Running

August 11, 2023

Obiri, Sisson to Face Off in ASICS Falmouth Road Race

FALMOUTH, Mass./ENDURANCE SPORTSWIRE/ – Two high-profile and highly-competitive women in distance running will headline the international elite field at next week’s ASICS Falmouth Road Race. Hellen Obiri and Emily Sisson, both making their Falmouth debut, will face off on the roads for the third time this year when they line up for...

Events

Press Releases

Running

August 11, 2023

XTERRA World Cup – Czech Republic this Weekend in Prachatice

/ENDURANCE SPORTSWIRE/ – The XTERRA World Cup rolls into the medieval town of Prachatice in the Czech Republic with full distance and XTERRA Short Track races this Saturday and Sunday, August 12-13. It’s the start of an intense set of five races in 15 days across three countries that could...

Business

Press Releases

Triathlon