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

July 13, 2022

BOA Endure Earns NSF Certified for Sport® Designation

RALEIGH (July 13, 2022) /ENDURANCE SPORTSWIRE/ - BOA Endure, the rapid hydration oral aerosol from BOA Nutrition, recently earned certification from NSF’s Certified for Sport® Program. NSF is a global public health organization that tests and certifies products to help protect athletes and consumers from potentially harmful ingredients and athletic...

Business

Press Releases

Products

July 13, 2022

Natural Grocers Supports Colorado Mountain Bike Championship, Hosted by Rattler Racing, July 16th, 2022

LAKEWOOD, Colo., July 13, 2022/ENDURANCE SPORTSWIRE/ – Natural Grocers® will be onsite support the Colorado Mountain Bike Championship, hosted by Rattler Racing on July 16, 2022 in Bailey, CO. Based in Colorado, Rattler Racing has had an amazing season so far with some stellar spring races, an action packed gravel weekend over...

Cycling

Events

Press Releases

Sponsorship

July 13, 2022

Kane Footwear partners with Hilary Knight to launch athlete-designed shoe

Westport, CT (July 13, 2022) /ENDURANCE SPORTSWIRE/ - Kane Footwear is thrilled to announce the release of their Kane x Knight shoe, designed by hockey star Hilary Knight in honor of her journey in women’s sports. The Antique White/Blue colors remind Knight of her childhood, and how much she’s overcome...

Business

Press Releases

Products

Sponsorship

July 12, 2022

Alchemy Bikes Moves to Golden, CO; Offers New Purchase Program with Free Overnight Stay, On-Site Bike Pickup

Golden, Colorado (July 12, 2022)/ENDURANCE SPORTSWIRE/ – Alchemy Bikes, a leading boutique bike manufacturer with a direct-from-fabricator-to-rider business model, has relocated its entire U.S. operations from its original facility in Denver to a brand new headquarters in Golden, Colorado. To celebrate the new facility they’re partnering with the Origin Hotel Red Rocks...

Business

Cycling

Press Releases

Triathlon

July 12, 2022

Stages Cycling Celebrates 10 Year Anniversary Of Stages Power Meter

(Boulder, CO – July 12, 2022) /ENDURANCE SPORTSWIRE/ – Stages Cycling, a leading cycling technology company, is celebrating the 10th anniversary of Stages Power meters. Stages launched its first power meter for outdoor bikes July 12, 2012. Since then Stages Cycling has produced millions of power meters and has grown from...

Business

Cycling

Press Releases

July 12, 2022

An action-packed weekend for the UTMB World Series in Europe

/ENDURANCE SPORTSWIRE/ - The first of two UTMB World Series Majors this year, Val d’Aran by UTMB, saw more than 3,700 runners from over 70 countries take on some of the most spectacular trails in Europe, with its flagship race – the VDA-161km – witnessing a double victory for French athletes...

Events

Press Releases

Running

July 12, 2022

GoFundraise to be the Official Fundraising Platform of Spartan

BOSTON, MASS. (July 12, 2022) /ENDURANCE SPORTSWIRE/ - Spartan, the world's leading endurance sports and extreme wellness brand, announced GoFundraise will be the Official Fundraising Platform for Spartan Race. The American Red Cross and the American Cancer Society serve as the inaugural Gold Charity Partners for Spartan Race. “Spartans around...

Giving

Press Releases

Running

Sponsorship

July 12, 2022

Mountain Magic at Raid in France – Savoie Mont Blanc

/ENDURANCE SPORTSWIRE/ - Raid in France returned to the international stage and the Adventure Racing World Series this year, with their 11th edition in the majestic Savoie Mont Blanc region of the Alps. It was the first Raid in France since the organisation staged the AR World Championship on Reunion...

Events

Press Releases

July 12, 2022

Super League Triathlon delivers New Audiences for the sport with Huge Broadcast Numbers

/ENDURANCE SPORTSWIRE/ – Super League Triathlon (SLT) is delivering on its promise to make triathlon a spectator sport as it releases broadcast viewing figures which show that 21.7 million people watched Arena Games Triathlon powered by Zwift. The first ever esports World Championship Series for triathlon, a mix of real life...

Events

Press Releases

Triathlon