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

October 5, 2021

World-Class Athletes Head to Inaugural Challenge Budva-Montenegro

Following last year’s cancellation due to COVID, CHALLENGEBUDVA-MONTENEGRO is ready to go this Sunday with a strong field of world-class athletes ready to compete against each other in spectacular Montenegro. From Nils Frommhold (DEU) and Magnus Ditlev (DEN) to Patrick Lange (DEU), recently the winner of DATEV CHALLENGEROTH, each has...

Events

Press Releases

Triathlon

October 4, 2021

Professional Triathletes Organisation Announces Deal with Eclat Media Group for Collins Cup Highlights Coverage Across Asia

4th October 2021 - The Professional Triathletes Organisation and Eclat Media Group have announced a deal that will see The Collins Cup highlights show as well as the Beyond Human documentary televised across 16 markets in Asia. Eclat Media Group is aiming to fill the gap left by the closure of...

Events

Press Releases

Sponsorship

Triathlon

October 4, 2021

World Champions Crowned in London

More than 3,300 World Championship finishers from 82 countries World’s most competitive marathon lineup ever The inaugural AbbottWMM Wanda Age Group World Championships took place as part of the 41st Virgin Money London Marathon today with World Champion status the goal for more than 3,300 runners. The camaraderie between these...

Events

Press Releases

Running

October 4, 2021

Gravel Riders and Runners Take on a New Off-Road Adventure in Life Time’s The ‘Rad Dirt Fest

Trinidad, Colo., (October 4, 2021) – The first-ever edition of Life Time’s The ‘Rad Dirt Fest took place this weekend in Trinidad, Colo. Off-road athletes either took on the three distances of the gravel race or two distances of the running event while some athletes took on both events in the...

Cycling

Events

Press Releases

Running

October 4, 2021

12th annual Northshore Half Marathon and 10-miler return to St. Tammany Sunday

BATON ROUGE, La. - The 12th annual Northshore Half Marathon and 10-miler return to St. Tammany on Sunday, Oct. 10 as one of the first events the parish will host since Hurricane Ida made landfall in August. Over 800 participants from 14 different states will flock to the historic streets...

Events

Press Releases

Running

October 4, 2021

Keegan Swenson finishes 7th in 2021 Marathon MTB World Championships

ELBA ISLAND, Ita. – The 2021 Marathon Mountain Bike World Championships took on the island of Elba in Tuscany. Almost every part of this course is demanding single track with challenging climbs. The men raced 71 miles with 14,000 feet of climbing. The women raced 50 miles with over 10,000...

Cycling

Events

Press Releases