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

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

May 23, 2024

Showcased

Spartans Conquer Cancer Together: GoFundraise and American Cancer Society Partner Again!

/ENDURANCE SPORTSWIRE/ – Building on the success of their 2023 partnership which raised over $140,000 GoFundraise and the American Cancer Society (ACS) are continuing to work together to empower Spartan Racers to raise critical funds in the fight against cancer. "We're thrilled to continue our partnership with ACS and empower...

Events

Giving

Press Releases

Running