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

September 29, 2022

Master Spas heads to the Big Island for World Championship events

Fort Wayne, Ind. – SEPTEMBER 29, 2022 /ENDURANCE SPORTSWIRE/ – Master Spas, the world’s largest swim spa manufacturer, is excited to announce that it will be supporting athletes during the most-iconic event in triathlon. From October 3 to 7, 2022, athletes will have the opportunity to meet Master Spas’ professional triathletes, swim...

Events

Press Releases

Sponsorship

Triathlon

September 28, 2022

XTERRA Worlds Saturday in Trentino

September 28, 2022 /ENDURANCE SPORTSWIRE/ – Off-road triathlon’s greatest day is just two days away at the 26th annual XTERRA World Championship on Saturday, October 1, in the Dolomites surrounding Lake Molveno in Trentino, Italy. The event will be streamed live on Facebook starting with the pre-race show at 8:40am CEST...

Events

Press Releases

Triathlon

September 28, 2022

New Kids of STEEL Programming during the EQT Pittsburgh 10 Miler Will Allow Parents to Run the Race on Nov. 6

PITTSBURGH (Sept. 28, 2022) /ENDURANCE SPORTSWIRE/ – For the first time, P3R will offer their award-winning Kids of STEEL programming during the EQT Pittsburgh 10 Miler, so that parents and guardians can run the race on Nov. 6. The program will be FREE to children for all parents and guardians participating...

Events

Press Releases

Running

September 28, 2022

Over Easy announced as Official Energy Bar of the Los Angeles Marathon

LOS ANGELES, CA/CHAGRIN FALLS, OH (September 28, 2022) /ENDURANCE SPORTSWIRE/ - The Los Angeles Marathon presented by ASICS today announced a new partnership with Over Easy as the Official Energy Bar of the 2023 event. Operated by the McCourt Foundation, the 38th running of the popular marathon will take place...

Events

Press Releases

Running

Sponsorship

September 28, 2022

‘Ante Up’ for the TransRockies Gravel Royale 2023 Event with Registration opening on Sept. 28

Panorama, B.C. (Sept. 28, 2022) /ENDURANCE SPORTSWIRE/ - TransRockies Race Series just completed a successful inaugural TransRockies Gravel Royale presented by Felt Bicycles. The event brought 200 athletes from eight countries and 22 states and provinces to explore the vast gravel roads of the Kootenay Mountains in British Columbia, Canada....

Cycling

Events

Press Releases

September 27, 2022

Top Professional Triathletes from Around the World Make Highly Anticipated Return to Kailua-Kona, Hawai`I For The 2022 VinFast IRONMAN World Championship

KAILUA-KONA, Hawai`i / TAMPA, Fla. (September 27, 2022) /ENDURANCE SPORTSWIRE/ - Triathlon’s top professional athletes will return to Kailua-Kona, Hawai`i for the first time in three years for the 2022 VinFast IRONMAN® World Championship triathlon. The most iconic endurance event in the world will bring together nearly 100 of the...

Events

Press Releases

Triathlon

September 27, 2022

Fifth Annual USABA National Blind Sports Week presented by Healthy Vision Association Slated for October 3-8

(Sept. 27, 2022) /ENDURANCE SPORTSWIRE/ – Join the U.S. Association of Blind Athletes for National Blind Sports Week presented by Healthy Vision Association (Oct. 3-8), a six-day celebration focused on participation and awareness of sports and opportunities available to athletes who are blind and visually impaired. The week culminates with the...

Events

Press Releases

September 27, 2022

U.S. Team Announced for Inaugural World Mountain & Trail Running Championship

/ENDURANCE SPORTSWIRE/ – Thirty-nine of the top off-road runners in the United States have been named to the 2022 U.S. Mountain & Trail Running Team scheduled to compete at the inaugural World Mountain & Trail Running Championships November 4-6 in Chiang Mai, Thailand. Hailing from twelve U.S. states, these talented athletes...

Events

Press Releases

Running