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

May 31, 2022

UTMB World Series partners with BUFF®, COMPRESSPORT and CAMELBAK as Official Suppliers

(Chamonix, France) 31 May 2022/ENDURANCE SPORTSWIRE/ – UTMB® World Series organizers UTMB Group and The IRONMAN Group, have confirmed they have joined forces with three new Official Suppliers to further bolster the Series’ offering to runners through the provision of best-in-class products across a variety of essential categories. 2022 marks the...

Press Releases

Running

Sponsorship

May 31, 2022

Thorne, Arrowhead Water, and Amazfit Join as New Partners for 2022 Escape from Alcatraz™ Triathlon

SAN FRANCISCO (May 31, 2022) /ENDURANCE SPORTSWIRE/ - IMG, a global leader in sports, events, media, and fashion, today announced new partnerships with Thorne, Arrowhead Water, and Amazfit for the 2022 Escape from Alcatraz Triathlon. The iconic race is set to take place on Sunday, June 5, in San Francisco.,...

Events

Press Releases

Sponsorship

Triathlon

May 26, 2022

Yamaha Bicycles Increases its Support of Ride Santa Barbara 100 and the Santa Barbara Cycling Community

CYPRESS, Calif. – May 26, 2022/ENDURANCE SPORTSWIRE/ – Yamaha Bicycles today announced its expanded support of Ride Santa Barbara 100, the premier century bike ride on California’s Central Coast. The pioneering e-Bike brand has signed on as the Official E-Bike Sponsor of this year’s event, scheduled for October 22. It will also...

Cycling

Giving

Press Releases

Sponsorship

May 26, 2022

Natural Grocers Grant Subsidizes Women’s Entries Fees for the Upcoming Jesse Blancarte Time Trial in Gardner, KS

LAKEWOOD, Colo. (May 26, 2022)/ENDURANCE SPORTSWIRE/ – The Natural Grocers® Cycling Team (with the support of their title sponsor, Natural Grocers by Vitamin Cottage, Inc.) is proud to support women’s bike racing at the 2022 edition of the Jesse Blancarte Memorial 10k Time Trial on May 29th, 2022, near Gardner, Kansas....

Cycling

Press Releases

Sponsorship

May 25, 2022

Showcased

100% and MLB All-Star Fernando Tatis, Jr. Debut 2022 Limited-Edition Sport Performance Eyewear Collection

SAN DIEGO, Calif. – May 25, 2022/ENDURANCE SPORTSWIRE/ – 100%®, the San Diego-based sports performance company, professional baseball All-Star and MVP Sports Group client, Fernando Tatis, Jr. have once again joined forces for their 2nd limited edition eyewear collaboration. Like Tatis, the 2022 100% x Tatis 23 Limited-Edition Eyewear Collection is sure to turn heads — featuring the energizing pinks and glowing yellows, colors that El Niño is well-known...

Press Releases

Products

Sponsorship