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 (11)
) 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 790, 10

November 20, 2023

Marathonfoto/Sportograf Announced as The Official Sponsor of the 2023 Mass Participation World Conference

Ho Chi Minh City, Vietnam /ENDURANCE SPORTSWIRE/ - MarathonFoto and Sportograf, the world’s leading race photography group, are proud to announce their sponsorship of the 2023 Mass Participation World Conference (MPW23) as the official photography partner for the next three years. This partnership is set to enhance the overall experience...

Business

Events

Press Releases

Running

November 16, 2023

Destination Sport Experiences launches ultimate training camps programme, with seven world-class sports resorts

16th November 2023 - Manchester, UK/ENDURANCE SPORTSWIRE/ – Destination Sport Experiences takes athletes to participate in the best cycling, running and triathlon events all over the world. For 2024 it launches a programme of training camps at seven top sports resorts to help them prepare in the perfect environment. These work...

Business

Cycling

Press Releases

Running

Triathlon

November 16, 2023

IMBA Welcomes BikeInsure as Official Mountain Bicycle Insurance Partner

Boulder, Colorado / November 16, 2023 /ENDURANCE SPORTSWIRE/ – BikeInsure and IMBA announce a partnership bringing affordable, opt-in bicycle insurance to IMBA members. BikeInsure is a specialty bicycle insurance company that offers coverage to all adult residents in the United States. IMBA lives into its mission to create, enhance, and protect...

Business

Cycling

Press Releases

November 16, 2023

The Brand Leader Makes Outside Magazine’s ‘Best Places to Work’ List for 3 Consecutive Years

Greenville, SC – November 16, 2023 . The Brand Leader, a renowned branding and creative integrated marketing agency, is again in the spotlight for its exceptional workplace culture. The agency has been honored with the prestigious "Best Places to Work" award by Outside magazine, securing the 33rd spot on the...

Awards

Business

Press Releases

November 15, 2023

B.A.A. Announces Dr. Cheri Blauwet as new Board Chair

BOSTON – Dr. Cheri Blauwet has been elected as the new Chair of the Board of Governors of the Boston Athletic Association (B.A.A.), succeeding Dr. Michael O’Leary, who has served as Chair for the last six years. Dr. Blauwet has been a Board member since 2016 and is a marathon...

Business

Press Releases

Running