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

November 17, 2021

ELITE & Zwift Partner up for Midweek Mountain Massif TT

FONTANIVA, ITALY, November 17th, 2021 /ENDURANCE SPORTSWIRE/ - Elite Cycling and Zwift Insider are teaming up for two Thanksgiving Eve throw-downs in the mountains and you're invited. Midweek Mountain Massif TT What do you get if you cross a mountain race and a time trial? An absolutely intense, but highly...

Cycling

Events

Press Releases

November 16, 2021

World’s Toughest Mudder Record Shattered in Laughlin, Nev.

BOSTON, Mass. /ENDURANCE SPORTSWIRE/ - Tough Mudder, the global leader in obstacle course adventures, announced the results of its World’s Toughest Mudder event in Laughlin Nev., including a new World’s Toughest Mudder record of 115 miles set by first place men’s podium finisher Mark Batres. The tenth running of the...

Events

Press Releases

Running

November 16, 2021

Turkey Trot Los Angeles presented by UAE-USA United expands commitment to community

/ENDURANCE SPORTSWIRE/ - Turkey Trot Los Angeles, presented by UAE-USA United, is expanding its commitment to community by focusing on a virtual and live event benefiting The Midnight Mission, the official nonprofit partner of this event. Turkey Trot Los Angeles has set a goal to raise $100,000 for The Midnight Mission....

Events

Giving

Press Releases

Running

November 16, 2021

Life Time and the Sea Otter Classic Introduce New Executive Gathering: Sea Otter Classic Summit April 5-7, 2022

MONTEREY, Calif. (Nov. 16, 2021) – Life Time Group Holdings, Inc. (“Life Time”) (NYSE: LTH), and the Sea Otter Classic are proud to introduce the Sea Otter Classic Summit, a brand-new global gathering of outdoor industry leaders focused on serving a diversified outdoor industry leadership group. The Summit will assemble...

Business

Events

Press Releases