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

November 21, 2023

The Running Summit 2023: A Premier Gathering for Running Coaches, Athletes and Enthusiasts

November 21, 2023 , Rock Hill, SC /ENDURANCE SPORTSWIRE/ - The much-anticipated Running Summit is set to take place on December 9th - 10th, 2023, conveniently located near Charlotte, NC, at Winthrop University in Rock Hill. This two-day event is for runners, coaches, and fitness enthusiasts seeking insights, expertise, and...

Business

Events

Press Releases

Running

Triathlon

November 21, 2023

Team Magic Rebrands to Magic Sports: A New Era in Sport Event Production

Nashville, Tennessee – [November 21, 2023] /ENDURANCE SPORTSWIRE/ - Team Magic, a pioneering force in the world of endurance sports event production since its founding in 1985, is excited to announce its transformation into Magic Sports. This rebranding reflects the company's commitment to innovation, growth, and a continued dedication to...

Business

Press Releases

November 21, 2023

Iconic Cross Channel Swim from Nevis to St. Kitts Under New Ownership

London, November 2023 /ENDURANCE SPORTSWIRE/ – Sponge Marketing & Events, in partnership with SwimTrek, is delighted to announce the new ownership of the Nevis to St. Kitts Cross Channel Swim. Jane Hansom (founder of Sponge) and SwimTrek will be jointly taking over this extraordinary island-to-island crossing from Winston Crooke, who founded and...

Business

Press Releases

Triathlon

November 20, 2023

Ciele Athletics welcomes Scott Gravatt as the new head of sales for US and Canada

MONTREAL (Nov. 20, 2023)/ENDURANCE SPORTSWIRE/ – Ciele Athletics, the high-end technical performance-running brand from Montreal, Quebec, is proud to announce a new head of sales for the U.S. and Canada. Ciele Athletics welcomes Scott Gravatt, running-industry veteran, joining the company following a 15-year tenure at Nike. In a pivotal 2018 meeting,...

Business

Press Releases

Running

November 20, 2023

SOLE Fitness, Kinomap Announce Partnership to Further Fitness

SALT LAKE CITY (Nov. 20, 2023) /ENDURANCE SPORTSWIRE/ - SOLE Fitness, one of the largest fitness home equipment brands in the world, today announces it is partnering with Kinomap to improve and personalize the experience of SOLE cardio equipment users everywhere. Kinomap and SOLE Fitness are working together to elevate...

Business

Press Releases

Products

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