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

December 2, 2024

The New Collocated Boston Run Show & Boston Outdoor Expo 2025 Unveils Exciting Speaker Agenda

Boston, MA – March 1-2, 2025 /ENDURANCE SPORTSWIRE/ - The Boston Run Show returns to the Boston Convention & Exhibition Center March 1-2, 2025, offering an event packed with running inspiration and a motivating experience for runners of all levels. The next expo will collocate with The Boston Outdoor Expo,...

Events

Press Releases

Running

December 2, 2024

Step into the Future of Winter Trail Running with Ulu at ISPO 2024

Munich, Germany – [Monday 2nd December 2024] /ENDURANCE SPORTSWIRE/ – Ulu Outdoor, a pioneer in winter-ready athletic footwear, proudly announces its debut at ISPO Munich 2024 with the launch of the groundbreaking Amak Arctic Stride Winter Trail Running Shoes. Recently honored with the prestigious ISPO Award, the Amak Arctic Stride embodies Ulu’s...

Press Releases

Products

Running

Trade Shows

December 2, 2024

Biggest Sale of The Season; Rock ‘N’ Roll Running Series Announces 24-Hour Winter Sale

TAMPA, Fla. (Dec. 2, 2024) /ENDURANCE SPORTSWIRE/ – To celebrate the holidays and provide participants the opportunity to achieve fitness goals for the new year, the Rock ‘n’ Roll® Running Series has announced its 24-hour Winter Sale beginning at midnight Pacific time on Wednesday, Dec. 4, 2024, offering the lowest prices...

Events

Press Releases

Running

December 2, 2024

Rider Resilience – The Film

KENDAL, United Kingdom December 2. /ENDURANCE SPORTSWIRE/ – Rider Resilience – The Film, an inspiring documentary about the power of cycling to overcome life’s greatest challenges, premiered to a sold-out audience at the Kendal Mountain Festival’s Bike Night. The film, which received an overwhelmingly positive response, highlights the resilience and...

Cycling

Giving

Press Releases

December 2, 2024

Traverse Tanzania GRVL Joins Gran Fondo World Tour® Gravel Series 2025

December 2. /ENDURANCE SPORTSWIRE/ - Since its inception in 2016, the series has continually grown, offering the most sought-after destinations for gravel enthusiasts. Traverse Tanzania GRVL represents a significant step forward in providing tailored, all-inclusive events that cater to gravel travelers seeking adventure and challenge. "At Gran Fondo World Tour®,...

Business

Cycling

Events

Press Releases

December 1, 2024

Gregory Barnaby (ITA) And Marta Sanchez (ESP) Claim IRONMAN 70.3 Western Australia Asia-Pacific Championship Titles and Maximum Points

Gregory Barnaby’s win in Busselton moves the Italian to the top of the IRONMAN Pro Series with just one race to go Barnaby claims his first IRONMAN 70.3 triathlon title, while Marta Sanchez secures her second of the year. As race winners, Barnaby and Sanchez earn the maximum 2,500 IRONMAN...

Events

Press Releases

Triathlon

November 29, 2024

Explore Exciting Roles at the Austin Marathon Recruitment Event

AUSTIN, Texas, November 29, 2024 /ENDURANCE SPORTSWIRE/ - High Five Events, the parent company behind the Ascension Seton Austin Marathon and other premier endurance events, invites individuals passionate about event production to join a recruitment session for prospective team members on Saturday, December 7, 2024, at 10:00am. The event will...

Business

Cycling

Events

Press Releases

Running

Triathlon

November 28, 2024

Datasport Germany to time the 2025 Regensburg and Luxembourg Marathons using MYLAPS technology

November 18 /ENDURANCE SPORTSWIRE/ - Datasport Germany GmbH, a company specializing in sports timing, accurately times a wide range of sporting events in Germany and its surrounding countries. In 2025, they will provide timing services for two additional marathons using MYLAPS BibTag technology. The Regensburg Marathon and the Luxembourg Marathon,...

Business

Press Releases

Products

Running

November 28, 2024

Turkey Tri Wraps Up the 2024 LA Tri-Series

LOS ANGELES, Calif. /ENDURANCE SPORTSWIRE/ - The LA Tri-Series hosted triathletes of all experience levels at the third and final event of the 2024 series. The race, referred to as the “Turkey Tri,” took place ahead of Thanksgiving weekend, and was the only triathlon in California during the holiday week....

Press Releases

Triathlon