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

July 13, 2023

Rock ‘N’ Roll Running Series Las Vegas Opens Registration for Feb. 24-25, 2024 Launching Inaugural “Yoga on The Strip” Immersive Experience and Finish Line Celebration During Ultimate Running Party Weekend

LAS VEGAS (July 13, 2023) /ENDURANCE SPORTSWIRE/ - The Rock ‘n’ Roll® Running Series today announced that registration for the 2024 Rock ‘n’ Roll® Running Series Las Vegas featuring a distance for everyone including a 5K, 10K and half marathon is now open by visiting, www.stripatnight.com. The 2024 Rock ‘n’...

Events

Press Releases

Running

July 13, 2023

IRONMAN and Visit Sacramento Extend Host Venue Agreement to Keep IRONMAN California Triathlon in Sacramento for an Additional Five Years

SACRAMENTO, Calif. / TAMPA, Fla. (July 13, 2023)/ENDURANCE SPORTSWIRE/ – IRONMAN and Visit Sacramento have agreed to a five-year host venue agreement to keep the IRONMAN® California triathlon in Sacramento, Calif. through 2028. The 2023 Kaiser Permanente IRONMAN® California triathlon, part of the VinFast IRONMAN North America Series, is scheduled for...

Events

Press Releases

Triathlon

July 13, 2023

Standard Chartered Singapore Marathon 2023 to finish at iconic National Stadium for the first time

SINGAPORE, 13 July 2023/ENDURANCE SPORTSWIRE/ – The Standard Chartered Singapore Marathon (SCSM) has announced that race participants of SCSM2023 will begin their run at the F1 Pit Building before finishing on the running track of the iconic National Stadium. This will mark the first time in the event’s history that runners...

Events

Press Releases

Running

July 13, 2023

EIGHT Beer Becomes Official Beer Sponsor of the Kerrville Triathlon

Kerrville, Texas, July 13, 2023 /ENDURANCE SPORTSWIRE/ – High Five Events, one of the largest privately owned event production companies in the United States, pens sponsorship deal with EIGHT Beer making it the Official Beer of the Kerrville Triathlon. This inaugural agreement means that EIGHT, an Austin-based company, will feature its...

Cycling

Events

Press Releases

Sponsorship

Triathlon

July 13, 2023

BibBoards Introduces Custom Shoe Charms, Elevating Race Day Swag for Event-Goers

BibBoards Launches Custom Shoe Charms, Enabling Race Goers to Personalize Their Race Day Swag San Ramon, 7/13/2023 - /ENDURANCE SPORTSWIRE/ – BibBoards, a leading provider of innovative event bib fasteners, is thrilled to announce the launch of their latest product: custom shoe charms. Designed specifically for race goers, these customizable charms...

Events

Press Releases

Products

Running

Triathlon

July 12, 2023

GFNY Super Sunday with two races a continent apart

/ENDURANCE SPORTSWIRE/ - Hosted by the town of Thann, GFNY Grand Ballon offered racers a mountainous 147.3 km long course with 4060m of climbing across the beautiful Vosges mountains in summer heat. 800 riders had to tackle legendary Grand Ballon first and a lead group of 35 formed up the...

Cycling

Events

Press Releases

July 12, 2023

USA Cycling Announces 2023 BMX Racing World Championship Teams

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – The 2023 UCI Cycling World Championships will make history in Glasgow, Scotland as the first World Championship where 13 events will be contested across 7 disciplines. 20 Americans will compete in the BMX Racing events on August 12-13, 2023 at the Glasgow BMX Centre. This event marks another...

Cycling

Events

Press Releases

July 12, 2023

A Strong Men and Women’s British Professional Line-Up to Battle It Out at IRONMAN 70.3 Swansea, Wales on Sunday whilst Spain Welcomes a Women’s Professional Field to Vitoria-Gasteiz

SWANSEA, Wales / VITORIA-GASTEIZ, Spain (July 12, 2023)/ENDURANCE SPORTSWIRE/ – The 2023 triathlon season continues in Europe this Sunday with men and women pros battling it out at IRONMAN 70.3 Swansea, and a professional women’s only field racing at IRONMAN Vitoria-Gasteiz. IRONMAN 70.3 Swansea Following in the footsteps of Alistair Brownlee...

Events

Press Releases

Triathlon