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 (22)
) 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 980, 10

July 27, 2023

Kerrville Tri and Super Coffee Energize Partnership Deal

Kerrville, Texas, July 27, 2023 /ENDURANCE SPORTSWIRE/ - Kerrville Triathlon Festival and Super Coffee have partnered for the third year in a row. The Austin based company, Super Coffee, is the Official Coffee of Kerrville Tri, “The Most Scenic Triathlon in Texas.” The event is owned and produced by High...

Press Releases

Sponsorship

Triathlon

July 25, 2023

OOFOS Teams Up with The Historic Appalachian League as their Official Recovery Footwear Partner

Braintree, MA – July 25, 2023/ENDURANCE SPORTSWIRE/ – Ahead of the Appalachian League All-Star game tonight, OOFOS announced today it will be the Official Recovery Footwear of the Appalachian Baseball League. The Boston-based company has joined forces with one of the nation’s premier amateur baseball leagues for the 2023 summer season to...

Press Releases

Sponsorship

July 24, 2023

Electrolit Set to Hydrate Fans at Iconic Music Festivals All Year Long

Cerritos, Calif. (Jul 24, 2023) /ENDURANCE SPORTSWIRE/ - Electrolit – the preferred, premium hydration beverage made from high-quality ingredients – is set to keep festival-goers hydrated throughout 2023. Building on successful activations at The Governors Ball Music Festival, Sueños and Day Trip, Electrolit will expand its reach to major U.S....

Press Releases

Sponsorship

July 24, 2023

Squirt Cycling Products Partners with Adventure Racing World Series

/ENDURANCE SPORTSWIRE/ -The primary disciplines of the sport of Adventure Racing include trekking, mountain biking and paddling with map-and-compass navigation to bring them all together. It is in this environment that Squirt Cycling Products are well suited, making them a perfect partner for the Adventure Racing World Series (ARWS). Squirt’s...

Business

Cycling

Events

Press Releases

Products

Sponsorship

July 24, 2023

SFuels expands partnership with Run Catalina series through 2025

AVALON, Calif. /ENDURANCE SPORTSWIRE/ - The Hi-Tec Run Catalina series and SFuels have announced a new two-year partnership, making SFuels the Official Nutrition Sponsor of all three storied island running events. The collaboration will cover nutrition and hydration needs for runners throughout their race day experience in each event, as...

Business

Press Releases

Running

Sponsorship

July 21, 2023

Moloka’i 2 O’ahu Paddleboard World Championships Welcomes New partner dryrobe®

HONOLULU, HI (July 21, 2023)/ENDURANCE SPORTSWIRE/ – The Moloka'i 2 O'ahu Paddleboard World Championships (M2O) is excited to return to Hawai'i later this month for the 24th annual race featuring top athletes in prone paddleboarding, SUP, and FOIL. The race is excited to introduce these world class watermen and women...

Events

Press Releases

Sponsorship

July 19, 2023

Darn Tough Vermont ® Announced as Official Sock Partner for US Trail Running Conference

/ENDURANCE SPORTSWIRE/ – Active at Altitude, organizers of the US Trail Running Conference, have announced that Darn Tough Vermont will continue as the Official Sock Partner of the 2023 Conference. Darn Tough Vermont is an American manufacturer of premium all-weather running, outdoor, and lifestyle socks, backed up by the industry's original...

Press Releases

Running

Sponsorship

July 18, 2023

SaltStick Electrolytes, Nix Biosensors Team Up with 8x IRONMAN Winner Ben Hoffman and Others for Education Campaign Around Sweat Testing & Hydration Science

THOUSAND OAKS, CALIF.— July 18, 2023 /ENDURANCE SPORTSWIRE/ – SaltStick, a leading electrolyte brand, and Nix Biosensors, a cutting-edge health biosensing company, have joined forces to educate endurance athletes about the growing use of sweat testing in sport. Titled Sweat Science, the three-month digital campaign will follow the journey of...

Cycling

Press Releases

Products

Running

Sponsorship

Triathlon

July 17, 2023

UltraSwim 33.3 x Precision Fuel & Hydration Partnership

/ENDURANCE SPORTSWIRE/ – We want every UltraSwim 33.3 participant to be a winner and that's why we've teamed up with Precision Fuel & Hydration to provide our participants with the education, tools and products to help them perform at their best. With their guided expertise, you'll be better prepared to nail...

Events

Press Releases

Sponsorship