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

November 8, 2021

2022 DeSatnick Real Estate Escape the Cape Triathlon Sells Out In 7 Days

/ENDURANCE SPORTSWIRE/ - The 2022 DeSatnick Real Estate Escape the Cape Triathlon and Open Water Classic, presented by Inspira Health, reached capacity in just 7 days, selling out with 2,000 triathletes and swimmers. Athletes from 40 states, including 373 first time triathletes, will make the journey to Lower Township, NJ to...

Events

Press Releases

Triathlon

November 8, 2021

Pic2Go Partners with The Williams Route 66 Marathon to deliver Race Day Photos to Participants!

/ENDURANCE SPORTSWIRE/ - The Williams Route 66 Marathon in Tulsa, Oklahoma, announced a renewed collaboration with Pic2Go for taking photos of this year’s runners. Pic2Go’s unique solution not only auto-tag and brand the marathon photos, but also deliver rich finisher galleries to the participants while driving massive social sharing –...

Events

Press Releases

Products

Running

Sponsorship

November 8, 2021

The RunnerBox and RiderBox Unveil Highly Anticipated Limited Edition Holiday Boxes

November 8, 2021 /ENDURANCE SPORTSWIRE/ - The Runner and The RiderBox, leaders in the endurance sport gift industry, have released a Limited-Edition Holiday Box which will be available for sale on a first-come, first-served basis. This limited run box is an annual favorite and has sold out every year it...

Cycling

Press Releases

Products

Running

November 7, 2021

AbbottWMM Series XIII Champions Crowned

/ENDURANCE SPORTSWIRE/ - The Abbott World Marathon Majors (AbbottWMM) declared its first ever joint champions today after a thrilling finish to Series XIII at the TCS New York City Marathon. Kenyan duo Joyciline Jepkosgei and Peres Jepchirchir were named joint winners of the series after finishing level on points with...

Events

Press Releases

Running

November 7, 2021

3,700 Runners Ran through the Streets at the 2021 EQT Pittsburgh 10 Miler

PITTSBURGH (November 7, 2021) /ENDURANCE SPORTSWIRE/ - Thousands of runners returned to the live start line of the ‘most Pittsburgh race ever’ for the first time in two years at the 2021 EQT Pittsburgh 10 Miler Sunday morning. Participants from 36 states and four countries completed the 10-mile course that...

Events

Press Releases

Running

Sponsorship

November 6, 2021

Record-Breaking Day at The CNO Financial Indianapolis Monumental Marathon

INDIANAPOLIS, November 6, 2021 /ENDURANCE SPORTSWIRE/ - The 14th annual CNO Financial Indianapolis Monumental Marathon, Half Marathon, and 5K were held this morning in downtown Indianapolis in spectacular record-breaking style. The event marked the return of an in-person experience after pivoting to virtual in 2020 and drew over 13,000 registrants...

Events

Press Releases

Running

November 5, 2021

Advocate Alison Mariella Désir Launches Street Style Collection with Oiselle

Seattle, WA /ENDURANCE SPORTSWIRE/ - Oiselle, a by woman for woman athletic apparel company, partners with Alison Mariella Désir, an activist and founder of Harlem Run, on a three-piece collection inspired by Harlem street style. The AMD Collection features a boxy tee, long sleeve, and lounge pants. The AMD Collection...

Press Releases

Running