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 (16)
) 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 3550, 10

February 27, 2022

Rock ‘N’ Roll Running Series Las Vegas’ 5k And Encore Entertainment Concert Shined Bright at New Downtown Location

LAS VEGAS, Nev. /ENDURANCE SPORTSWIRE / - The 12th running of the Rock ‘n’ Roll® Running Series Las Vegas is underway and with it a brand-new, reimagined experience including major upgrades to Saturday night’s festivities at the new Fremont Street Experience location in Downtown Las Vegas for the Rock ‘n’...

Events

Press Releases

Running

February 27, 2022

Unforgettable Weekend of Running Returns to Iconic Vegas Strip with The 2022 Rock ‘n’ Roll Running Series Las Vegas

LAS VEGAS, Nev. (Feb. 27, 2022)/ENDURANCE SPORTSWIRE/ - The Rock ‘n’ Roll® Running Series returned to the Vegas Strip for the first time in over two years as participants got back into the groove for the “World’s Largest Running Party” at the 12th edition of Rock ‘n’ Roll Running Series Las Vegas....

Events

Press Releases

Running

February 26, 2022

Team USA Animates Race With Three Riders in Top 10 at Esports World Championships

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ - Today was the second edition of the UCI Esports World Championships on Zwift. The team raced on the 54.9km New York Knickerbocker course doing 2 laps plus another short lap up the final climb. Women’s Race 89 women took to the virtual starting line first with...

Cycling

Events

Press Releases

February 25, 2022

XTERRA names Steve Andurs U.S. Tour Manager

February 25, 2022 (Portland, OR) /ENDURANCE SPORTSWIRE/ - XTERRA Global, LLC, owners and producers of the XTERRA World Tour, today announced Steve Andrus as the new manager for the XTERRA U.S. Tour, effective March 1, 2022. Andrus previously served as the Director of Sales and Events at Snowbasin Resort in...

Business

Events

Press Releases

Running

Sponsorship

Triathlon

February 25, 2022

XTERRA Whistler joins 2022 World Tour

/ENDURANCE SPORTSWIRE/ - XTERRA returns to one of the most magical mountain towns in the world, Whistler, B.C., Canada, this June 11-12, with a weekend full of off-road triathlon, trail running, and swimming events for every age group and skill level. “We’re stoked to be joining the XTERRA Family,” said...

Events

Press Releases

Triathlon

February 25, 2022

Aid to Ukraine – #RideForUkraine with ROUVY

Vimperk, Czech Republic / 25 February 2022 /ENDURANCE SPORTSWIRE/ - The Czech company ROUVY is actively participating in efforts to provide humanitarian aid to people in Ukraine. ROUVY has launched "Ride for Ukraine", an initiative that can be joined by all users of the ROUVY indoor bike training application. ROUVY will send...

Cycling

Events

Giving

Press Releases

Triathlon

February 25, 2022

50 Elite Runners to Compete in New Half Marathon Elite Series Kicking Off at Rock ‘N’ Roll Running Series Las Vegas

LAS VEGAS, Nev. /ENDURANCE SPORTSWIRE/ - When Rock ‘n’ Roll® Running Series Las Vegas makes it return this weekend following a two-year hiatus, 50 elite runners from around the world will be vying for a share of the $15,000 prize purse as well as Elite Beat Rankings (EBR) in the...

Events

Press Releases

Running