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

March 1, 2023

IRONMAN Announces 2023 IRONMAN and IRONMAN 70.3 Broadcast Schedule

TAMPA, Fla. (March 1, 2023) /ENDURANCE SPORTSWIRE/ – IRONMAN announced today its broadcast schedule for the 2023 season. The 2023 full-distance IRONMAN® triathlon broadcast schedule will feature 12 stops around the globe including both the men’s and women’s 2023 VinFast IRONMAN World Championship, which will be available on IRONMAN.com/LIVE, and IRONMAN...

Events

Press Releases

Triathlon

March 1, 2023

Caliente Pizza & Draft House Named Official Pizza of The Pittsburgh Marathon

Pittsburgh, PA (February 28, 2023) /ENDURANCE SPORTSWIRE/ – Pizza and sports fans in Pittsburgh have a new reason to celebrate as Caliente Pizza & Draft House has been named the Official Pizza of The Pittsburgh Marathon. The announcement comes after an exciting 2022 that included the successful launches of Caliente locations...

Events

Press Releases

Running

Sponsorship

March 1, 2023

The City of Auburn and beyond spread their wings as they #FlyToThe50 for the 2nd Annual War Eagle Run Fest

AUBURN, AL. /ENDURANCE SPORTSWIRE/ – The 50-yard line of Jordan-Hare Stadium saw over 3,330 registered runners fly across on Sunday morning for the second annual running of the 2023 War Eagle Run Fest Half Marathon, 5K, and Kid’s Mile. Tiger fans, students, faculty, and community experienced the glory of crossing the...

Events

Press Releases

Running

March 1, 2023

Life Time and OZ Brands Announce $65,000 Prize Purse for Little Sugar MTB

CHANHASSEN, Minn., (March 1, 2023) /ENDURANCE SPORTSWIRE/ – Life Time (NYSE: LTH), the nation’s premier healthy lifestyle brand and owner and producer of 30 premier athletic events, announces a $65,000 total prize purse for the Life Time Little Sugar MTB presented by Mazda, set to debut Oct. 15 in Northwest Arkansas....

Cycling

Events

Press Releases

March 1, 2023

Denver Disruptors Cycling Club Announces 2023 Race Schedule and Team Sponsors

Denver, Colorado – March 1, 2023 /ENDURANCE SPORTSWIRE/ – The Denver Disruptors Cycling Club, one of the premier professional teams in the National Cycling League, today announced their 2023 competition schedule as well as the list of world-class sponsors supporting their ride to the top of professional cycling in the United...

Cycling

Events

Press Releases

Sponsorship

March 1, 2023

Molveno, Italy to Host 2023 XTERRA European Trail Run Championship

March 1, 2023 /ENDURANCE SPORTSWIRE/ – The first-ever XTERRA European Trail Run Championship will be held September 9, 2023 in Molveno, Italy at the majestic Brenta Dolomites mountain range, a UNESCO Heritage site in the northern Italian Alps. The half-marathon and full-marathon championship races will award €5,200 in prize money, continental...

Events

Press Releases

Running

March 1, 2023

Blue Streak Time Trial Celebrates 25 Years

WRIGHT- PATTERSON AIR FORCE BASE, Ohio /ENDURANCE SPORTSWIRE/ – Today marks the start of registration for the 2023 Blue Streak Time Trial while also commemorating the 25th anniversary of the annual event. Time trials will occur on the second Tuesday of each month from April to October. The first time trial...

Cycling

Events

Press Releases

February 28, 2023

2023 Kaiser Permanente Napa Valley Marathon & Half Marathon at Full Capacity as Runners Gear Up for Race Weekend

Napa, California /ENDURANCE SPORTSWIRE/ – The 2023 Kaiser Permanente Napa Valley Marathon & Half Marathon has officially sold out, with runners from around the world gearing up for the highly anticipated race. The event, scheduled for March 5th, has drawn runners of all abilities who are ready to tackle the scenic...

Events

Press Releases

Running