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

May 28, 2024

Asia Pacific Champs at Challenge Gunsan-Saemangeum

/ENDURANCE SPORTSWIRE/ – This weekend, Challenge Gunsan-Saemangeum will host the Challenge Family Asia-Pacific Championships over 226km with an international field of professional athlete and over 1,000 age group athletes. The course includes the world’s longest seawall with its unique eco-environment and spectacular scenery. The Asia Pacific Championship edition in 2024 will...

Events

Press Releases

Triathlon

May 28, 2024

International Field at OTSO Challenge Salou 2024

/ENDURANCE SPORTSWIRE/ – An international field of professional and age group athletes from 43 nations will descend on the popular Spanish holiday town of Salou this weekend for OTSO Challenge Salou, drawn by the golden sands, fast bike course on a closed motorway and flat run along the palm tree-lined...

Events

Press Releases

Triathlon

May 28, 2024

PTO Announce Dubai T100 Triathlon Course to Take Place at Meydan Racecourse and Surrounding Area For The Inaugural Weekend Event In November 2024

Dubai, United Arab Emirates, 28 May 2024/ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) and World Triathlon have announced the unique and renowned Meydan Racecourse, Crystal Lagoon of District One and the surrounding area, to host the new T100 Triathlon World Tour when it visits Dubai on 15-17 November this year....

Events

Press Releases

Triathlon

May 28, 2024

Over 1,200 Runners Expected to Complete the 2024 SoCal Triple Crown at America’s Finest City Half Marathon and 5K

SAN DIEGO, Calif. /ENDURANCE SPORTSWIRE/ – America’s Finest City Half Marathon and 5K is returning to San Diego on Aug. 18, where over 1,200 runners are poised to complete their SoCal Triple Crown challenge. These runners will have completed any distance offered in three of In Motion Events’ keystone races...

Events

Press Releases

Running

May 27, 2024

The Endless Mountains Adventure Race Returns

Burlington, Vermont /ENDURANCE SPORTSWIRE/ - In July 1609, renowned French explorer, cartographer, and navigator Samuel Champlain first encountered the moody waters of the eighth largest body of water in North America. Known among the Abenake nation as Pitawbagok and the Mohawks as Kaniatarakwà:ronte, the lake served as a major trading...

Cycling

Events

Press Releases

Running

Triathlon

May 26, 2024

Hug and Zimmermann Secure Wins at Challenge St Pölten

/ENDURANCE SPORTSWIRE/ - A thrilling finish in the women’s race and a successful title defense in the men’s marked Challenge St Pölten 2024 with Tom Hug (GER) taking the win in 3:52:48, and Laura Zimmermann (GER) securing victory in 4:27:06. Unique to Challenge St Pölten, the race started with the...

Events

Press Releases

Triathlon