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

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

November 15, 2021

The IRONMAN Group Acquires Croatia’s Famed 4islands MTB Stage Race

CROATIA / LONDON / TAMPA, Fla. (November 15, 2021) /ENDURANCE SPORTSWIRE/ - The IRONMAN Group announced today the acquisition of Croatia’s famed 4Islands MTB Stage RaceTM. The event will expand The IRONMAN Group’s  global portfolio of Epic SeriesTM mountain bike stage races. The 4Islands MTB Stage Race set to take place...

Business

Cycling

Events

Press Releases

November 12, 2021

The Digital Swiss 5 – Marlen Reusser, Giro Stage Winner and E-Sports World Champion take to the start line

Zurich, Switzerland /ENDURANCE SPORTSWIRE/ Swiss Strength The current European Champion and Olympic silver medallist in the time trial, Marlen Reusser, will fight for every second at The Digital Swiss 5. “I am looking forward to competing in The Digital Swiss 5 together with different athletes in a cross-gender challenge.” With...

Cycling

Events

Press Releases