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

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

Epic Winter Adventure Awaits in Colorado at 8th Annual Old Man Winter Rally

BOULDER, CO (November 11, 2021) – Adventure Fit Productions, announces open-registration for the 8th annual Old Man Winter Bike and Run Rally on February 6th, 2022. Known throughout the cycling and running community as an “epic winter adventure,” Old Man Winter 2022 is placing a strong focus on welcoming more...

Cycling

Events

Press Releases

Running

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 11, 2021

USA Triathlon is launching Remote National Championships on November 11

COLORADO SPRINGS /ENDURANCE SPORTSWIRE/ – USA Triathlon, in collaboration with Predictive Fitness and ROUVY, is launching the first-ever Remote National Championships, an opportunity for athletes from across the United States to compete for an Olympic and sprint-distance national championship regardless of their location. The Remote National Championships will last 10...

Events

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

November 10, 2021

St. Jude supporters to strike a joyful chord in Music City for annual St. Jude Rock ‘n’ Roll Running Series Nashville

NASHVILLE, Tenn. (Nov. 10, 2021) /ENDURANCE SPORTSWIRE/ - More than 1,300 St. Jude Heroes® are stepping up to lend their support for kids at  St. Jude Children’s Research Hospital® on Saturday, Nov. 20, at the 21st annual St. Jude Rock ‘n’ Roll Running Series Nashville. This year marks a decade...

Events

Giving

Press Releases

Running

November 10, 2021

Rock ‘n’ Roll Running Series Las Vegas Moves Race Weekend Concert Featuring Symphonic Rockshow To Downtown Las Vegas Event Center

LAS VEGAS, Nev. (November 9, 2021) /ENDURANCE SPORTSWIRE/ - Known as the ultimate running party with non-stop entertainment, Rock ‘n’ Roll® Running Series Las Vegas has unveiled the Symphonic Rockshow as its headliner who will be performing at Downtown Las Vegas Event Center, a new venue for the pre-race concert....

Events

Press Releases

Running

November 10, 2021

7.8 Million Impressions for Pic2Go’s Race Photos at the TTP Cambridge Half Marathon

/ENDURANCE SPORTSWIRE/ -  Pic2Go race photography solution has generated 7.8 Million impressions for sponsored participants’ photos, shared via the platform to social media, at the TTP Cambridge Half Marathon! Pic2Go’s patented race photo tagging technology enabled processing of 430,000 race day photos (taken by the Pic2Go UK team).  The automated...

Press Releases

Products

Running