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

October 2, 2023

SPORTIME Clubs and Hornig Capital Partners Partner to Develop Pickleball Facilities

New York, October 2, 2023/ENDURANCE SPORTSWIRE/ – SPORTIME Clubs and Hornig Capital Partners announced today that they have signed a partnership agreement to establish a new company, SPORTIME Pickleball, LLC, that will develop and operate state-of-the-art, standalone, pickleball facilities in the tri-state area under the SPORTIME brand. The joint venture is...

Business

Press Releases

October 2, 2023

Experiencing ‘Goa Beyond Beaches’ at India’s 2nd National Adventure Racing Championship.

/ENDURANCE SPORTSWIRE/ - India successfully hosted a 2nd National AR Championship in Goa. The race was themed as “Goa Beyond Beaches” and explored a destination which is famous for its beaches and as an exclusive water sports adventure destination. Adventure Racing in India is growing rapidly with many new teams...

Events

Press Releases

October 2, 2023

Approximately 11,000 Runners Took to The Streets of Speed City, USA for The 2023 United Airlines Rock ‘N’ Roll Running Series San Jose

SAN JOSE, Calif. /ENDURANCE SPORTSWIRE/ - Approximately 11,000 registered participants took the to the streets of Speed City, USA as the United Airlines Rock ‘n’ Roll® Running Series San Jose returned over the weekend. The Rock ‘n’ Roll Running Series is a best-in-class running series Bringing Fun to the Run®...

Press Releases

Running

October 1, 2023

Coppi, Patterson Win XTERRA Trail Run World Championship Marathon; Tomajczyk, Wacker Crowned Half Marathon Champions

October 1, 2023 /ENDURANCE SPORTSWIRE/ – The 14th XTERRA Trail Run World Championship was the first time individual runners earned a qualifying slot through the inaugural XTERRA Trail Run World Series. XTERRA launched its Trail Run World Series ahead of the 2023 season, spanning five continents with 38 qualifying events in...

Events

Press Releases

Running

September 30, 2023

Alexey Vermeulen and Lauren De Crescenzo win 2023 Life Time ‘The Rad Dirt Fest’ presented by Wahoo

Trinidad, Colo., (Saturday, Sept. 30, 2023) – Life Time’s (NYSE: LTH) The Rad Dirt Fest presented by Wahoo took place this weekend in Trinidad, Colo. Going into the third year of the event and the newest addition to the Life Time Grand Prix presented by Mazda, the town was buzzing...

Cycling

Events

Press Releases

September 29, 2023

Valencia, Spain To Join The IRONMAN 70.3 Triathlon Circuit Beginning In April 2024

Inaugural edition of IRONMAN 70.3 Valencia triathlon to take place on April 21, 2024 with general registration opening on October 5, 2023 at www.ironman.com/im703-valencia Qualifying slots for the 2024 VinFast IRONMAN 70.3 World Championship triathlon in Taupō New Zealand will be available - First time ever that a triathlon operated...

Events

Press Releases

Triathlon

September 29, 2023

Ahotu is thrilled to announce a collaboration with Garmin

/ENDURANCE SPORTSWIRE/ – Ahotu, the world’s largest and most comprehensive calendar for endurance sports, are delighted to announce a collaboration with Garmin, a leading global provider of smartwatches and GPS-enabled devices across diverse markets. A new service to discover and train for events Users can easily discover events in the Garmin Connect™...

Business

Cycling

Events

Press Releases

Running

September 29, 2023

Stars Set To Collide As Super League Triathlon Heads To Malibu For Decisive Race

/ENDURANCE SPORTSWIRE/ – The stars of triathlon are set to collide at the stunning Zuma Beach in Malibu, USA, on Saturday, September 30, as Super League Triathlon’s Championship Series reaches a pivotal stage. With the majority of the sport’s short course aces having raced in either London or Toulouse in...

Events

Press Releases

Triathlon