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

January 20, 2022

Heath Pearce Named President of For Soccer Ventures

NEW YORK AND LOS ANGELES January 20, 2022 /ENDURANCE SPORTSWIRE/ - For Soccer Ventures (FSV), the largest independent soccer media and experiences company in the United States, announced that former United States Men’s National Team Player and three-time Major League Soccer All-Star Heath Pearce has been named as President of...

Business

Press Releases

January 20, 2022

Challenge Family Enters the World of Virtual Sports with ROUVY

20 January 2022 /ENDURANCE SPORTSWIRE/ - ROUVY will combine animated 3D avatars, both cycling and running, with real-life video footage of Challenge Family destinations to create a new level of interactive home training. The new partnership aims to continue development of a strong online community through virtual group rides, race-specific...

Business

Press Releases

Triathlon

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