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

June 16, 2024

Matt Burton (AUS) And Hannah Berry (NZL) Claim Cairns Airport IRONMAN Asia-Pacific Championship Cairns Titles in Paradise

CAIRNS, Australia (June 16, 2024) /ENDURANCE SPORTSWIRE/ - The picture perfect Tropical North Queensland played host to the Cairns Airport IRONMAN Asia-Pacific Championship Cairns triathlon, the eighth stop and first in Oceania of the IRONMAN Pro Series™. The race saw Matt Burton (AUS) and Hannah Berry (NZL) claim the IRONMAN...

Events

Press Releases

Triathlon

June 14, 2024

Challenge Family Announces Return to China with Challenge Beijing

14 June 2024 /ENDURANCE SPORTSWIRE/ – Challenge Family has announced Challenge Beijing, set to take place on 7 and 8 September 2024 over the Olympic and Sprint distances in the Beijing Expo Park, situated in the popular holiday region of Yanqing. Challenge Beijing has been certified as an A+ level...

Events

Press Releases

Triathlon

June 13, 2024

IRONMAN Pro Series Heads to Australia For The First Time for Cairns Airport IRONMAN Asia-Pacific Championship Cairns on Sunday, June 16

- The eighth stop for the IRONMAN Pro Series™ will see a number of the world’s top professional triathletes head to Cairns, Australia, to race for a piece of the $150,000 total event pro prize purse in the first Pro Series event in Oceania  - Free Live coverage of Sunday’s event...

Events

Press Releases

Triathlon

June 13, 2024

Challenge Family World Bonus Standings Released

/ENDURANCE SPORTSWIRE/ – With five months of Challenge Family racing already completed for 2024, the Challenge Family Pro Athlete World Bonus standings are showing a close-run battle for the end of season bonus. New Zealander, Jack Moody, leads the men’s standings with 750 points after his wins at Challenge Taiwan...

Events

Press Releases

Triathlon

June 13, 2024

A Premier Middle-Distance Race with an International Lineup at Lotto Challenge Gdańsk

/ENDURANCE SPORTSWIRE/ – Lotto Challenge Gdańsk is set to return with its spectacular middle-distance race, drawing international athletes from around the globe to the beautiful Baltic coast this Sunday. The 2024 edition of Challenge Gdańsk boasts a strong international field featuring top-tier professional athletes from various countries. In the men’s...

Events

Press Releases

Triathlon

June 13, 2024

GFNY Super Sunday: two races an ocean apart

/ENDURANCE SPORTSWIRE/ GFNY Pennsylvania York (USA) GFNY Pennsylvania York offers riders a 67.8 mile race course with an elevation gain of 6053 ft. Race week activities, race start & finish and post-race festivities will take place at York Expo. It includes the fun GFNY group ride on Friday and Saturday...

Cycling

Events

Press Releases