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

December 13, 2021

Rock ‘N’ Roll Running Series Announces 2022 Tour Schedule and 24-Hour Global Winter Sale

TAMPA, Fla. (Dec. 13, 2021) /ENDURANCE SPORTSWIRE/ - The Rock ‘n’ Roll® Running Series, the world’s largest road running series today announced its 2022 Tour Schedule covering 14 destinations. To celebrate the holidays and the launch of the 2022 Rock ‘n’ Roll Running Series Tour Schedule, a 24-hour Winter Sale...

Events

Press Releases

Running

December 10, 2021

Meet Your 2022 Life Time Grand Prix Race Series Athletes

BOULDER, Colo., Dec. 10, 2021 — Life Time (NYSE: LTH), owner and producer of more than 30 renowned athletic events across the nation, today announced the 60 athletes who have been selected to compete in the 2022 Life Time Grand Prix series, which includes events such as Garmin Unbound Gravel...

Cycling

Events

Press Releases

December 10, 2021

US Trail Running Conference heads to Mukilteo, WA in 2022

Estes Park, CO /ENDURANCE SPORTSWIRE/ - Active at Altitude, organizers of the US Trail Running Conference has announced that the tenth edition of the industry-leading Conference will be held in Snohomish County, Washington, in the city of Mukilteo, October 19 - 22, 2022. Snohomish County, located in northwest Washington State...

Events

Press Releases

Running

December 10, 2021

History and Heritage Race Series Returns for Second Year

/ENDURANCE SPORTSWIRE/ - The J-3 Piper Cub will be the first historical aircraft featured in the 2022 History & Heritage Race Series, powered by the Air Force Marathon, beginning January 1. The upcoming event marks the first of six virtual races as the series returns for a second season. While the...

Events

Press Releases

Running

December 9, 2021

Tokyo Paralympic Goalball Coaches and Athletes to Lead L.A. Clinic Dec. 11

Los Angeles, CA (December 9, 2021) /ENDURANCE SPORTSWIRE/ - Team USA head coaches and athletes will conduct two clinics on the Paralympic sport of goalball on Saturday, December 11, at the Expo Center (3980 Bill Robertson Lane) in Los Angeles. The clinics are part of USA Goalball Day and are...

Events

Press Releases

December 9, 2021

“TOKYO VR Racing 2021” – Cycle or Run in the heart of the capital of Japan from home

Tokyo, Japan / December 9th, 2021 /ENDURANCE SPORTSWIRE/ - Tokyo Metropolitan Government (TMG) uses ROUVY's digital technology to recreate the marathon course of Tokyo 2020 Paralympic Games in virtual reality (VR). This enables athletes and visitors to experience a new kind of fun in sports and enjoy the tourist attractions...

Cycling

Events

Press Releases

Running

Triathlon