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

July 27, 2022

BOA Nutrition Announces Official Brand Partnership With IRONMAN® Triathlon Series

RALEIGH, N.C. (July 27, 2022) /ENDURANCE SPORTSWIRE/ - Sports performance supplement company BOA Nutrition, inventor of the BOA Endure rapid sodium replenishment product, announced today that Endure has been selected as Official Endurance Salt of IRONMAN® in the North America region as well as the IRONMAN® World Championship and IRONMAN®...

Cycling

Events

Press Releases

Running

Sponsorship

Triathlon

July 27, 2022

BibRave Pumped to Launch Bike New York Ambassador Program

Portland, OR/ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, recently launched applications for the first-ever Bike New York ambassador program. “The Bike New York Roadies” will help spread excitement about the non-profit’s events and educational programming across the Tri-State area. Bike New York promotes and encourages bicycling and...

Cycling

Press Releases

Sponsorship

July 27, 2022

Bike Club’s Build-Your-Own Avatar program opens up unlimited possibilities for cyclists & brands

/ENDURANCE SPORTSWIRE/ – Bike Club opens up unlimited participation with their new Build-Your-Own avatar program, letting cyclists create their own Rider and giving brands unprecedented marketing opportunities. Traditional NFT projects use randomized art, which was Bike Club’s original plan, using characters created by world-renowned cycling artist Rich Mitch. But that method...

Cycling

Press Releases

Products

July 27, 2022

361° Announced as Presenting Sponsor of the Surf City Marathon

ORANGE COUNTY, Calif. – July 27, 2022/ENDURANCE SPORTSWIRE/ – 361°, an Irvine-based performance footwear brand, today announced a new partnership as the presenting sponsor of the Surf City Marathon. The 27th running of the Surf City Marathon and Half Marathon presented by 361° will take place in Huntington Beach on Sunday,...

Events

Press Releases

Running

Sponsorship

July 26, 2022

Saucony® Appoints Kathryn Pratt as Chief Marketing Officer

WALTHAM, MA (July 26, 2022)/ENDURANCE SPORTSWIRE/ – Saucony, a division of Wolverine Worldwide, Inc. (NYSE: WWW) and a leading global performance running and lifestyle brand, has announced the appointment of Kathryn Pratt to the position of Chief Marketing Officer, effective immediately. In this role, Pratt will be responsible for providing strategic development...

Business

Press Releases

July 26, 2022

Athleisure Eyewear Article One Unveils 2022 Summer ACTIVE Collection Debuting Industry-Leading Frame Technology

FLINT, Mich. (July 26, 2022) /ENDURANCE SPORTSWIRE/ – Article One, the independent eyewear brand championing craftsmanship to design heirloom, athleisure frames, today announced the launch of its ACTIVE collection. The five-piece collection blends Article One’s signature technical innovation with luxury and vintage styling by introducing a material that allows for more color...

Giving

Press Releases

Products

July 24, 2022

Cody Beals (Can) and Sarah True (USA) Claim Victories at the 2022 ViewSPORT IRONMAN Lake Placid North American TriClub Championship

LAKE PLACID, N.Y. (July 24, 2022) /ENDURANCE SPORTSWIRE/ - The Adirondack Mountains once again provided a picturesque backdrop for athletes from around the world for the 2022 ViewSPORT IRONMAN Lake Placid North American TriClub Championship triathlon on Sunday, July 24. This year’s version of the event saw athletes swim 2.4...

Events

Press Releases

Triathlon