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 (11)
) 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 2220, 10

November 15, 2021

The IRONMAN Group Acquires Croatia’s Famed 4islands MTB Stage Race

CROATIA / LONDON / TAMPA, Fla. (November 15, 2021) /ENDURANCE SPORTSWIRE/ - The IRONMAN Group announced today the acquisition of Croatia’s famed 4Islands MTB Stage RaceTM. The event will expand The IRONMAN Group’s  global portfolio of Epic SeriesTM mountain bike stage races. The 4Islands MTB Stage Race set to take place...

Business

Cycling

Events

Press Releases

November 12, 2021

Ashworth Awards & Craft Apparel Announce their Partnership

/ENDURANCE SPORTSWIRE/ - Ashworth Awards & Craft Apparel are pleased to announce a new partnership.  This partnership offers Endurance Events the opportunity to source high quality medallions and awards manufactured by Ashworth Awards and event wearables from Craft Apparel in one seamless transaction with Ashworth Awards.  All design and decoration...

Awards

Business

Press Releases

Running

November 11, 2021

The Air Force Marathon’s military discount will extend to include veterans in 2022

WRIGHT-PATTERSON AIR FORCE BASE, Ohio – The 2022 Air Force Marathon is gearing up for registration on Jan. 1 with the new year arriving. Along with registration, veterans and active military service members will be offered a military discount. Veterans, active duty, reservists, National Guard and ROTC of all branches...

Business

Press Releases

Running

November 11, 2021

Austin Marathon, Ascension Seton Agree to Title Sponsor Extension

AUSTIN, Texas, November 11, 2021 /ENDURANCE SPORTSWIRE/ - The Austin Marathon and Ascension Seton have agreed to a long-term title sponsor extension. The agreement will allow the collaboration to continue to grow, further benefiting the fitness community. In addition to growing secondary community events and expanding content creation opportunities, Ascension...

Business

Events

Press Releases

Running

Sponsorship

November 11, 2021

Better Triathlete Launches Triathlon Coach Match Program

(TRAVERSE CITY, MICHIGAN.) November 11, 2021 /ENDURANCE SPORTSWIRE/ - Triathlon blog and online community, Better Triathlete, launches a coach match program that connects athletes with the triathlon coaches who best meet their training and racing objectives, as well as their coaching preferences. Since 2012, Better Triathlete has been a reputable...

Business

Press Releases

Triathlon

November 10, 2021

Saucony® Appoints Brian Moore as Senior Vice President Of Global Product

WALTHAM, MA (November 10, 2021) /ENDURANCE SPORTSWIRE/ - Saucony, a division of Wolverine Worldwide, Inc. (NYSE: WWW) and a leading global performance running and lifestyle brand, today announced the appointment of industry veteran Brian Moore to senior vice president of global product, effective immediately. In his new role, Moore will be...

Business

Press Releases

Running