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 7960, 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 5, 2021

Showcased

Liv Unveils New Alight Disc Range

NEWBURY PARK, Calif. (Oct. 5, 2021) - Liv, the company dedicated to getting more women on bikes, today introduced its new Alight Disc range. Featuring the Alight DD Disc series and the Alight Disc series, the range incorporates Tensio, Liv’s proprietary visual technology that encompasses industrial and graphic design to...

Cycling

Press Releases

Products

October 5, 2021

Panaracer and BUCK!T Announce Collaboration

OSAKA, JAPAN (October 5, 2021) — Panaracer Corporation of Osaka Japan and BUCK!T bags of Girona, Spain are collaborating on a handlebar and saddle bag produced using factory rejected Panaracer Gravelking tires. Both bags have lined interiors and are highly water resistant - reflecting the quality that the BUCK!T brand...

Business

Cycling

Press Releases

Products

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

Silicon Valley Welcomes Back San Jose’s Largest Running Block Party for the 2021 United Airlines Rock ‘N’ Roll Running Series San Jose

SAN JOSE, Calif. – Following a two-year hiatus due to the COVID-19 pandemic, Rock ‘n’ Roll Running Series events returned in San Jose over the weekend commemorating one of northern California’s most celebrated running events. This weekend’s event marked the 15th edition of the United Airlines Rock ‘n’ Roll Running Series...

Press Releases

Running