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

July 23, 2024

Local Run Clubs & J&A Racing Raise $3000 For Chartway Promise Foundation

VIRGINIA BEACH, VIRGINIA /ENDURANCE SPORTSWIRE/ – On Saturday July 20, 2024, the community came together for a successful Community Run at Murphy’s Irish Pub in Virginia Beach. Run clubs from across the area joined forces to raise funds for the Chartway Promise Foundation, which provides support and wishes to children...

Events

Giving

Press Releases

Running

July 23, 2024

Excitement Builds for Challenge Turku Race Weekend

/ENDURANCE SPORTSWIRE/ – The Challenge Turku race weekend is set to take place in the heart of historic Turku on 27/28 July. It will feature Junior, Sprint, Challenge4All, and Middle-Distance events. With its fast and course and exciting pro field, this event promises an exhilarating experience for both participants and...

Events

Press Releases

Triathlon

July 23, 2024

Enabled Tracking to Provide Live GPS Tracking for July 2024 Endurance Events

Front Royal, VA – July 2024 /ENDURANCE SPORTSWIRE/ - Enabled Tracking, the timing and tracking division of Adventure Enablers, is pleased to unveil its advanced live GPS tracking services designed for a variety of past and upcoming endurance events this month. Whether navigating rugged terrains or conquering multi-day challenges, Enabled...

Business

Events

Press Releases

July 23, 2024

Close Battle in Challenge Family Pro Athlete World Bonus

/ENDURANNCE SPORTSWIRE/ - It’s been a busy couple of weekends with Challenge Family’s World Bonus with the high-scoring DATEV Challenge Roth, plus the inaugural SAIL Challenge Cap Québec both shaking things up in the pro athlete standings. The men’s league has a clear leader with Jack Moody, while the women’s...

Events

Press Releases

Triathlon

July 23, 2024

OOFOS Names Footwear Industry Veteran Erin Flynn Head of Sales

Braintree, MA /ENDURANCE SPORTSWIRE/ – OOFOS, the global leader in Active Recovery has hired Erin Flynn as the new head of sales for OOFOS. Erin is a 20-year veteran of the athletic footwear industry and has an impressive track record of driving strategy, growth and innovation for top brands and retailers....

Business

Press Releases

July 23, 2024

Alive in Death Valley: A Collaboration to Survive The World’s Toughest Foot Race

Melbourne, Victoria (July 22, 2024) /ENDURANCE SPORTSWIRE/ - Australian brand, 2XU, the global leader in compression apparel, and Los Angeles-based District Vision have collaborated on a new limited edition collection inspired by the Badwater 135 ultramarathon. The collaboration features three outfits from 2XU matched with a pair of ultra lightweight...

Business

Press Releases

Products

Running

Wire Syndication

July 22, 2024

The Countdown is on to Leadville Trail 100 MTB

Leadville, Colorado /ENDURANCE SPORTSWIRE/ – The Life Time Grand Prix presented by Mazda returns on Saturday, August 10th with the Life Time Leadville Trail 100 MTB presented by Kenetik. The renowned Colorado event – also known as the Race Across the Sky – is celebrating its 30th anniversary this year and...

Cycling

Events

Press Releases

July 22, 2024

Ahotu and The Feed announce new partnership to enhance athlete experience

/ENDURANCE SPORTSWIRE/ – As part of this partnership, the Ahotu Nutrition Club at The Feed will be launched, which offers significant savings on sports nutrition products. This initiative is tailored to help athletes fuel their journeys with high-quality nutrition, ensuring they perform at their best at every event. Club members...

Business

Press Releases