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 (8742)
) 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 1260, 10

April 18, 2024

Mortal Hydration Becomes The Official Sports Beverage and Hydration Partner of The IRONMAN and IRONMAN 70.3 North American Triathlon Series

TAMPA, Fla. / BOULDER, Colo. (April 18, 2024) /ENDURANCE SPORTSWIRE/ – IRONMAN and Mortal Hydration today announced Mortal Hydration as the official sports beverage and hydration partner for the IRONMAN® and IRONMAN® 70.3® North American Triathlon Series. Varieties of the Mortal Hydration Drink Mix will be available on-course, giving athletes...

Events

Press Releases

Sponsorship

Triathlon

April 18, 2024

HydraPak® Sunsets Polar Bottle® Brand, Hops Back into the Saddle with Bike-Specific Squeeze Bottles

OAKLAND, Calif. (April 18, 2024) /ENDURANCE SPORTSWIRE/ - HydraPak®, global leader of high-performance hydration solutions, will be sunsetting its Polar Bottle product line, and relaunching newly designed bottles under the HydraPak brand. Today, it unveiled the first squeeze bottle in its cycling collection, Breakaway™. HydraPak leveraged its lightweight, integrated filter...

Press Releases

Products

April 18, 2024

Article One and Ciele Athletics Offer Runners Vintage-Inspired Frames in Sophomore Sunglasses Collaboration

FLINT, Mich. (April 18, 2024)/ENDURANCE SPORTSWIRE/ – Article One, the independent eyewear brand creating handcrafted active and optical frames, and leading performance-running brand Ciele Athletics are thrilled to debut the sophomore edition of the Article One x Ciele GTGlass performance sunglasses, an award-winning collaborative frame launched in 2020. Having earned several...

Press Releases

Products

Running

April 18, 2024

OOFOS Unveils One-of-a-Kind Recovery Sponsorship at Boston Marathon Finish Line

BRAINTREE, MA /ENDURANCE SPORTSWIRE/ – OOFOS, the Boston-based global leader in Active Recovery footwear, confirms its commitment to recovery by implementing a completely unique sponsorship initiative that supports and celebrates “Real People” in their recovery journey following the Boston Marathon. With a pop-up retail store located by the Boston Marathon...

Events

Press Releases

Running

Sponsorship

April 18, 2024

Inaugural Michelob Ultra GFNY Miami this Sunday

/ENDURANCE SPORTSWIRE/ - This Sunday, Michelob Ultra GFNY Miami offers riders an entirely flat and fast racecourse of 70.7 miles completely closed to traffic. The North American Championship race starts and finishes at Miccosukee Resort & Casino on the western edge of Miami at the portal to the Everglades. Race...

Cycling

Events

Press Releases

April 17, 2024

Waymo is Official Pace Car and Autonomous Technology Partner for 2024 Bay to Breakers

San Francisco, CA /ENDURANCE SPORTSWIRE/ - Bay to Breakers (www.baytobreakers.com) welcomes everyone: costumed, costumedless and yes, driverless. The iconic annual race spanning San Francisco proudly announces its partnership with Waymo (www.waymo.com) as the official pace car and autonomous technology partner for the upcoming event taking place on Sunday, May 19....

Press Releases

Running

Sponsorship

April 17, 2024

Riviera Nayarit, Mexico Set To Host New IRONMAN 70.3 Triathlon

- Organizers of the IRONMAN 70.3 Acapulco, IRONMAN 70.3 Campeche, IRONMAN 70.3 Cozumel, IRONMAN 70.3 Monterrey, and IRONMAN Cozumel races to host new event - The inaugural IRONMAN 70.3 Riviera Nayarit triathlon is scheduled to take place on Sunday, Nov. 10, 2024; Registration is now available by visiting www.ironman.com/im703-riviera-nayarit MEXICO...

Events

Press Releases

Triathlon

April 17, 2024

Chevron Joins the Denver Colfax Marathon as the 2024 Race Volunteer Sponsor

Denver, CO /ENDURANCE SPORTSWIRE/ – The Denver Colfax Marathon, presented by Cigna Healthcare, welcomes Chevron as the 2024 race volunteer program sponsor. This partnership will allow for the marathon to continue its support of more than a thousand volunteers during the race weekend in May. “Our volunteers are a major...

Events

Press Releases

Running

Sponsorship