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

January 20, 2022

Showcased

UNDRBUDR Announces Continuing and New Sponsorships for 2022

Montclair, NJ, January 20, 2022 /ENDURANCE SPORTSWIRE/ - UNDRBUDR, developer of high performance, nature-inspired skincare and recovery products, today announced sponsored team highlights for the 2022 season. The sponsorships are a continuation of UNDRBUDR’s mission to promote cycling across all men’s and women’s fields as well as amateur through elite...

Press Releases

Sponsorship

January 20, 2022

28th Annual 3M Half Marathon Ready to Run Austin’s Roads

AUSTIN, Texas, January 20, 2022 /ENDURANCE SPORTSWIRE/ - High Five Events, one of the largest privately owned event production companies in the United States, is putting the final touches on the 3M Half Marathon presented by Under Armour. More than 6500 participants have registered, with 48 states and 10 countries...

Events

Press Releases

Running

January 20, 2022

deboer wetsuits introduced the Flōh 2.0 wetsuit

Stamford, CT, Release: January 20, 2022 /ENDURANCE SPORTSWIRE/ - deboer wetsuits is proud to introduce the Flōh 2.0 wetsuit.  The Flōh 2.0 shares much of its DNA with the Fjord 2.0, the exception being the material used in the sleeves. The Flōh 2.0 utilizes 1.5mm UltraFlex™ sleeves for near zero...

Press Releases

Products

Triathlon

January 20, 2022

Showcased

GiveSignup | RunSignup Announces Alan Jones Timer Award Recipient

January 20, 2022 – Moorestown, NJ /ENDURANCE SPORTSWIRE/ -GiveSignup | RunSignup announces the 2021 Alan Jones Timer Award winner, Mary Anderson, founder of Anderson Race Management located in Eagan, Minnesota. The Alan Jones Timer Award recognizes an individual race timer who has shown exceptional efforts and who has had a significant...

Awards

Cycling

Press Releases

Running

Triathlon

January 20, 2022

Zoot Sports continues support of American athlete and 7x IRONMAN champion Ben Hoffman

Carlsbad, CA /ENDURANCE SPORTSWIRE/ - Zoot Sports, the industry leader in triathlon apparel, is excited to continue their 12th season with professional triathlete, Ben Hoffman. Hoffman turned professional in 2007 and has been a partner with Zoot Sports since 2011. As a top male World Champion contender, Hoffman will continue...

Press Releases

Sponsorship

January 19, 2022

Elite Ultrarunner Kelly Wolf Joins La Sportiva

January 19th, 2022 (BOULDER, Colo.) /ENDURANCE SPORTSWIRE/ - La Sportiva, makers of the world’s finest mountain footwear, today announces that elite ultrarunner and mountain athlete Kelly Wolf joins the La Sportiva ambassador team. Effective immediately, Wolf will be outfitted head-to-toe in La Sportiva footwear and apparel. The Crested Butte athlete...

Press Releases

Running

Sponsorship

January 19, 2022

Munich, London and Singapore will Host the First-Ever Esport Triathlon World Championship Series

/ENDURANCE SPORTSWIRE/ - World Triathlon & Super League Triathlon Announce Locations For Arena Games Triathlon World Championship Series powered By Zwift 2022 Following on from the recent news of a ground-breaking partnership between Super League Triathlon (SLT) and World Triathlon (WT) to grow a global esports World Championship series - Arena...

Events

Press Releases

Triathlon

January 19, 2022

Showcased

ROUVY and Garmin customers can now seamlessly sync their activities through new API integration

Prague, Czech Republic / January 18, 2022 /ENDURANCE SPORTSWIRE/ ROUVY, an indoor cycling platform, and Garmin® International, Inc., a global leader of GPS-enabled products, today announced API integration support between ROUVY and Garmin Connect™. The integration enables users to seamlessly sync their activities created in the ROUVY app directly to their...

Cycling

Press Releases

Products

Running

Triathlon

January 19, 2022

Experience Fayetteville to Sponsor Team USA Women’s World Championship Squad

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ - USA Cycling recently announced the 38-athlete roster heading to the 2022 UCI Walmart Cyclocross World Championships in Fayetteville, Ark. USA Cycling is excited that Experience Fayetteville is bringing a World Championship cycling event to the United States and is capitalizing on the opportunity to showcase...

Cycling

Press Releases

Sponsorship