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

August 5, 2022

tentreeⓇ Recognized with the B Corps 2022 Best for the World™ Award in the Community Category

Vancouver, BC (August 5, 2022) /ENDURANCE SPORTSWIRE/ - tentreeⓇ is honored to be a recipient of the 2022 Best for the World™ Award, distributed by B Lab Global–the nonprofit network that certifies and mobilizes B Corporations™. This award recognizes Certified B Corps around the world whose verified B Impact Scores...

Awards

Business

Press Releases

August 5, 2022

XTERRA Racing Season Heats Up in August

August 5, 2022/ENDURANCE SPORTSWIRE/ – The XTERRA World Tour is in full swing with eight races in two weeks across Europe and the U.S. leading up to the XTERRA World Championship in Trentino, Italy on October 1, 2022. In the U.S., big names like Eric Lagerstrom and Heather Jackson are racing...

Events

Press Releases

Triathlon

August 5, 2022

Liv Celebrates Shirin Van Anrooij, White Jersey Winner of The Tour De France Femmes Avec Zwift

NEWBURY PARK, Calif. (Aug. 5, 2022)/ENDURANCE SPORTSWIRE/ –  Liv, the company dedicated to getting more women on bikes and sponsor of the ‘Best Young Rider Classification’ at the inaugural Tour de France Femmes avec Zwift, extends its congratulations to Shirin van Anrooij of team Trek-Segafredo.r of the White Jersey. “As a brand...

Cycling

Press Releases

Sponsorship

August 5, 2022

Marathon Tours & Travel Kicks Off 2023 with The Bermuda Triangle Challenge After a Two Year Wait

Boston, MA (August 5, 2022)/ENDURANCE SPORTSWIRE/ – Marathon Tours & Travel (MTT) once again was awarded the exclusive tour operator for the Chubb Bermuda Triangle Challenge (BTC), which will take place during the Martin Luther King Holiday Weekend (January 13-15). A VIP Package is available offering features that makes a runner’s race...

Events

Press Releases

Running

August 4, 2022

USA Cycling Announces 2022 Junior Track Worlds Team

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – USA Cycling announced today the four athletes that will be representing the United States at the 2022 UCI Junior Track World Championships in Tel Aviv, Israel on August 23-27. Last year at this event, Kaia Schmid (Marblehead, Mass.; Human Powered Health) dominated with three podiums,...

Cycling

Events

Press Releases

August 3, 2022

USA Cycling Announces 2022 Mountain Bike Worlds Team

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – USA Cycling announced today the athletes that will be representing the United States at the 2022 UCI Mountain Bike World Championships in Les Gets, France on August 22-28. After impressive results this past weekend at the UCI Mountain Bike World Cup in Snowshoe, W.V., the team...

Cycling

Events

Press Releases

August 3, 2022

IRONMAN 70.3 Boulder to shift dates on the calendar beginning in 2023

BOULDER, Colo. / TAMPA, Fla. (Aug. 3, 2022)/ENDURANCE SPORTSWIRE/ – IRONMAN today announced that the 2023 IRONMAN® 70.3®Boulder triathlon will be moving to a new date on the calendar beginning in 2023. A staple in Colorado and on the IRONMAN calendar since 2002, the long-standing event will now take place on...

Events

Press Releases

Triathlon

August 3, 2022

The RunnerBox and The RiderBox Keep it Fresh with Their Latest Editions

August 3, 2022 /ENDURANCE SPORTSWIRE/ – The RunnerBox and The RiderBox unveiled their latest editions which showcases featured picks to help subscribers stay fresh while turning up the heat on their late-summer workouts and races. Consistently named the top subscription box for athletes, The RunnerBox and The RiderBox deliver bi-monthly boxes to...

Cycling

Press Releases

Products

Running

Triathlon