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

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 16, 2021

Mindfulness and Well-Being a Focus for 2022 Industry Conference

(Nov. 16, 2022) /ENDURANCE SPORTSWIRE/ - If you’ve ever touted your stress and anxiety levels as a badge of accomplishment, a keynote speaker at the 2022 Running USA Industry Conference presented by Race Roster may make you think twice. Internationally recognized mindfulness and meditation speaker Lee Papa will take the...

Press Releases

Trade Shows

November 15, 2021

Yamaha Bicycles Funds Santa Barbara’s First All Kids Bike Program

CYPRESS, Calif. – Nov. 15, 2021 /ENDURANCE SPORTSWIRE/ - Last month, Yamaha Bicycles sponsored Ride Santa Barbara 100, the premier century bike ride on California’s Central Coast. Through its sponsorship of the event’s Electric Bike category, Yamaha also donated $5,000 to provide the city of Santa Barbara, California with its...

Cycling

Giving

Press Releases