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

September 16, 2022

Challenge Family World Bonus Lead Under Threat Following Challenge Almere-Amsterdam

/ENDURANCE SPORTSWIRE/ - Can Sam Long hold onto his lead in the Challenge Family’s US$125k Pro Athlete World Bonus? Following Niek Heldoorn’s second place at Challenge Almere-Amsterdam at the weekend, Long is in danger of losing his season-long lead and a US$25k payout. Heldoorn’s performance at the European Triathlon Long...

Press Releases

Triathlon

September 16, 2022

Run Medford Gets Star-Struck For Mayor’s Celebrity Mile

Sept. 14, 2022, BOSTON – Nearly 20 celebrities will be toeing the line this Sunday at Run Medford, a brand new weekend-long celebration of community, running, and the City of Medford produced by DMSE Sports and hosted by the Dave McGillivray Finish Strong Foundation. Members of the media, sports legends,...

Events

Press Releases

Running

September 15, 2022

Long Beach Marathon Prepares for Take Off with Long Beach Airport

LONG BEACH – September 15, 2022 /ENDURANCE SPORTSWIRE/ – Ahead of more than 15,000 runners hitting the pavement at the Long Beach Marathon and Half Marathon in October, Long Beach Airport (LGB) and race organizers today announced a renewed partnership for the 2022 event. The premier fall marathon in Southern California...

Events

Press Releases

Running

September 15, 2022

Chicago Half Marathon Celebrates 25 Years on September 25 with ‘All Things Chicago’ Theme

CHICAGO – (September 15, 2021) /ENDURANCE SPORTSWIRE/ – The HOKA Chicago Half Marathon produced by Life Time will celebrate its 25th anniversary as the Windy City’s most established and iconic half marathon on September 25. In recognition of the historic milestone, race organizer Life Time has created an ‘All Things Chicago’...

Events

Press Releases

Running

September 15, 2022

Strong Pro Field Expected in Colorado Springs for 3rd Annual Pikes Peak APEX Presented by RockShox

Colorado Springs, CO, September 15, 2022 /ENDURANCE SPORTSWIRE/ – Sports Strategies announces another stacked race for the 4-day mountain bike challenge on the slopes of Pikes Peak. $25,000 is up for grabs, split evenly between the men and women’s top finishers. With defending champ Keegan Swenson having to withdraw after being selected for...

Cycling

Events

Press Releases

September 15, 2022

BikeExchange Taps New US Head, Head of US Sales; Shuffle Other Key Positions

Asheville, North Carolina (September 15, 2022)/ENDURANCE SPORTSWIRE/ – Continuing to exceed expectations in growth and expansion in North America (NA), BikeExchange/Kitzuma Cycling Logistics – now operating under the same umbrella after merging last December – has added/shuffled some key North American positions for BikeExchange, including naming Cameron Simpson to Head of North...

Business

Cycling

Press Releases

Triathlon

September 15, 2022

ROUVY: La Vuelta Virtual ‘22 Summary – 7K riders worldwide, a winner from Belgium and 5K Euro for inclusive cycling

Madrid, Spain / September 15th, 2022 /ENDURANCE SPORTSWIRE/ – La Vuelta Virtual on ROUVY, last weekend, had a magnificent wrap up in Madrid. Everyone witnessed the amazing story of Ward Simons who became the first winner of La Vuelta Virtual ‘22 at the in-person Grand Final. The pharmacist from Belgium managed...

Cycling

Events

Press Releases

September 15, 2022

The Running Event Announces “For Every Run Film Festival” in Partnership with Pacers Running

PORTLAND, Maine (September 15, 2022)/ENDURANCE SPORTSWIRE/ – The Running Event (TRE), North America’s premier specialty retail conference and trade show, has partnered with Washington, DC-based retailer Pacers Running to present the first annual For Every Run Film Festival. The festival will take place December 1 at The Running Event in Austin, TX....

Press Releases

Running

Trade Shows

September 15, 2022

The AbbottWMM Global Run Club App is here!

MEDIA ALERT Thursday 15 September 2022 /ENDURANCE SPORTSWIRE/ – The Abbott World Marathon Majors (AbbottWMM) Global Run Club launched their first ever mobile App today bringing the virtual training and racing hub into the palm of thousands of runners’ hands around the world. The Global Run Club launched in 2020 to keep...

Press Releases

Products

Running

September 15, 2022

Spivey Hoping For Redemption As She Returns Home For Super League Triathlon Malibu

/ENDURANCE SPORTSWIRE/ - Taylor Spivey is hoping for redemption as she returns home to California, USA, for Super League Triathlon Malibu on Saturday (13:00 local time) with a chance of taking pole position in the race for the 2022 Championship Series. The American has been a resurgent force this year,...

Press Releases

Triathlon