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

October 6, 2021

Akagiyama Hill Climb Race Hosts a 2nd Virtual Edition on ROUVY On Oct 9th

Maebashi City, Japan / Oct 6th 2021 - Akagiyama Hill Climb Race hosts its second open virtual edition on ROUVY, on October 9th, with the pro riders, Takahiro Koyama and Kazuki Nagatomi, from Team Griffin. Mountain Akagiyama provides the best cycling during a beautiful autumn season in October and November....

Cycling

Events

Press Releases

October 6, 2021

IRONMAN Announces Mossel Bay in South Africa as New Host City for IRONMAN 70.3 Triathlon

NELSON MANDELA BAY / LONDON / TAMPA (October 6, 2021) - IRONMAN announced today that it will add a brand-new event to its 2022 global race calendar with the IRONMAN® 70.3® Mossel Bay triathlon in South Africa. The inaugural IRONMAN 70.3 Mossel Bay triathlon will take place on Sunday, November 6,...

Events

Press Releases

Triathlon

October 6, 2021

Atlanta Track Club and haku Take Memberships to the Next Level Through Innovative Solutions

Effective membership programs have shifted from brands simply driving revenue to a value model where they invest in benefitting their communities – such as access, knowledge, information, experience, and belonging. Over the years, Atlanta Track Club has proven to be one of the most forward-thinking, innovative organizations that puts its...

Business

Events

Press Releases

Running

October 6, 2021

Inaugural WineShine Half Marathon to Debut in the Napa Valley Next Summer

NAPA, CA – The nonprofit Napa Valley Marathon, Inc., is thrilled to announce the launch of a new summer race in wine country, the WineShine Half Marathon & 3.9-Miler. The inaugural race, which starts and finishes at the Silverado Resort & Spa, will be held on July 16, 2022. Registration...

Events

Press Releases

Running

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