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

January 20, 2022

Fourth Annual DeLuna’s Open Water Swim Registration is Now Open

Pensacola, FL. (January 20, 2022) /ENDURANCE SPORTSWIRE/ - Pensacola Sports and Salty Sports Society invites both locals and visitors alike to participate in the 4th annual DeLuna’s Open Water Swim on Saturday, April 23, along Pensacola Beach. Early registration is now open to the public. Participants can choose to swim...

Events

Press Releases

Triathlon

January 20, 2022

IRONMAN Announces Rubavu in Rwanda As New Host City for IRONMAN 70.3 Rwanda

TAMPA / LONDON / RUBAVU (January 20, 2022) /ENDURANCE SPORTSWIRE/ IRONMAN announced today that it will add a brand-new event to its 2022 race calendar with the IRONMAN® 70.3® Rwanda in Africa. The inaugural IRONMAN 70.3 Rwanda triathlon will take place on Sunday, August 14, 2022. General Registration will open on...

Events

Press Releases

Triathlon

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