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

August 2, 2023

Sofia Gomez Villafane, Sami Inkinen, and Holly Guymon Take Overall Wins at the Stages Cycling Leadville Stage Race produced by Life Time

Leadville, Colo. /ENDURANCE SPORTSWIRE/ - The Stages Cycling Leadville Stage Race, owned and produced by Life Time (NYSE: LTH) as part of the Leadville Race Series, took place this past weekend from July 28-30. The event’s stage race format spreads out the Stages Cycling Leadville Trail 100 MTB course over three...

Cycling

Events

Press Releases

August 2, 2023

Race Results for the 24th Molokaˈi-2-Oˈahu Paddleboard World Championship

HONOLULU, HI (August 2, 2023) – The 24th Molokaʻi-2-O’ahu Paddleboard World Championships (M2O), presented by the Hawai’i Tourism Authority returned to racing today after a three-year hiatus due to the pandemic. Racers were greeted with favorable conditions with trade winds blowing at 20 knots and wind swell at six feet....

Events

Press Releases

August 2, 2023

10 Years and Counting: haku Notches Anniversary Milestone

Miami, August, 2023 /ENDURANCE SPORTSWIRE/ –haku is thrilled to announce a momentous milestone as it celebrates its 10-year anniversary, commemorating a decade of excellence in providing comprehensive business solutions to event organizers. With an unwavering commitment to empowering organizers in their technology transformation journey, haku has redefined the landscape of how...

Business

Press Releases

August 2, 2023

UltraSignup Presents the Bentonville Dirt Circus 10K and 5K: With a $10,000 Prize Purse for the 10K Trail Race

August 2, 2023 – Nashville, TN/ENDURANCE SPORTSWIRE/ – UltraSignup, in collaboration with Rush Running Company and Visit Bentonville, is thrilled to announce the inaugural Bentonville Dirt Circus 10K and 5K races, set to take place on November 17-18, 2023, in the picturesque city of Bentonville, Arkansas. This groundbreaking event promises to be...

Events

Press Releases

Running

August 1, 2023

Sports Flooring Franchise, Innovative Sports Surfacing, Kicks Off Nationwide Sales Launch with New Territories Signed

Louisville, KY /ENDURANCE SPORTSWIRE/ - Innovative Sports Surfacing, a differentiated sports flooring franchise specializing in poured-in-place rubber, artificial grass installation, bonded rubber mulch, sports flooring, and more, has just kicked off its nationwide franchise launch with two new territories signed. The brand, which officially opened its franchise opportunity just weeks ago,...

Business

Press Releases

August 1, 2023

Sofia Gomez Villafane, Sami Inkinen, and Holly Guymon Take Overall Wins at the Stages Cycling Leadville Stage Race produced by Life Time

Leadville, Colo./ENDURANCE SPORTSWIRE/ - The Stages Cycling Leadville Stage Race, owned and produced by Life Time (NYSE: LTH) as part of the Leadville Race Series, took place this past weekend from July 28-30. The event’s stage race format spreads out the Stages Cycling Leadville Trail 100 MTB course over three...

Cycling

Events

Press Releases