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 (22)
) 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 530, 10

December 4, 2024

RunSedona Welcomes Northern Arizona Healthcare as the Presenting Partner for its 20th Annual Half Marathon Event

Sedona, Arizona /ENDURANCE SPORTSWIRE/ - RunSedona Events is delighted to announce that Northern Arizona Healthcare (NAH) has become the Presenting Partner for the much-anticipated Half Marathon event in Sedona, Arizona. Recognized as one of the "2024 Best Destination Races" by Runner’s World, the “RunSedona Half Marathon Presented by Northern Arizona Healthcare”...

Events

Press Releases

Running

Sponsorship

December 4, 2024

USA Triathlon and Rudy Project Renew Partnership Through 2028

COLORADO SPRINGS, Colo. (December 4, 2024) /ENDURANCE SPPORTSWIRE/ — USA Triathlon is pleased to announce a partnership extension with Rudy Project North America, a premier supplier of sunglasses, helmets, and prescription eyewear in North America for the multisport community. Rudy Project’s support of USA Triathlon started in 2005 and is...

Business

Press Releases

Sponsorship

Triathlon

December 3, 2024

Zoot new supplier to the German Triathlon Union

December 3 /ENDURANCE SPORTSWIRE/ - With immediate effect, Zoot will be the new exclusive outfitter of the German Triathlon Union (DTU) and the German national triathlon teams. In addition to the elite, junior and para squads, the renowned specialist for triathlon clothing will also provide the age group athletes with...

Press Releases

Sponsorship

Triathlon

November 20, 2024

Suunto Race S Titanium Courtney – The special glow-in-the-dark watch, designed with Courtney Dauwalter

VANTAA (19. November 2024). /ENDURANCE SPORTSWIRE/ - Courtney Dauwalter, the expert of ultra running, is known for her unmatched mental toughness. She breaks down races into manageable sections, focusing on the next milestone, and uses positive self-talk to stay driven. Phrases like "embrace the pain" and "right foot, left foot"...

Business

Products

Sponsorship

Trade Shows

November 20, 2024

Shamrock Run Fest Announces Embassy Suites as Official Host Hotel

PORTLAND – November 20, 2024 /ENDURANCE SPORTSWIRE/ – The Shamrock Half Marathon Run Fest, presented by Toyota, is thrilled to announce Embassy Suites by Hilton as the “Official Host Hotel” for the 2025 event. Scheduled for March 16, 2025, the Shamrock Run Fest invites runners and their families to experience not just...

Events

Press Releases

Running

Sponsorship

November 20, 2024

Austin International Half and EIGHT Beer Team Up Once Again

Austin, Texas, November 20, 2024 /ENDURANCE SPORTSWIRE/ – The Austin International Half, formerly the 3M Half Marathon is excited to continue its successful partnership with EIGHT Beer as the Official Beer for the third consecutive year. EIGHT Beer, an Austin-based independent brewery, will highlight the finish line festival's beer garden,...

Events

Press Releases

Running

Sponsorship

November 18, 2024

ASICS Joins Denver Colfax Marathon as the Official Shoe Sponsor

Denver, CO /ENDURANCE SPORTSWIRE/ – The Denver Colfax Marathon, presented by Cigna Healthcare, is proud to announce a new partnership with ASICS for its 2025 marathon weekend. ASICS will be the official shoe sponsor of Denver’s only marathon weekend, which will take place May 16 – 18th, 2025. “ASICS is...

Events

Press Releases

Running

Sponsorship

November 18, 2024

Pedal Imua: A Charity Ride on the Gran Fondo World Tour® Calendar

November 18th. /ENDURANCE SPORTSWIRE/ - The West Maui Loop, widely celebrated as one of the best cycling routes in the world, takes center stage with the annual Pedal Imua, a special charity ride on the Gran Fondo World Tour® schedule. Since 2022, this event has proudly closed the year-round Gran...

Cycling

Events

Press Releases

Sponsorship

November 18, 2024

The Running Event and The Magic Boost Partner to Empower Young Creators and Amplify Diverse Voices in Running Media

PORTLAND, Maine /ENDURANCE SPORTSWIRE/ - The Running Event (TRE), North America’s premier run and outdoor specialty retail conference and trade show, is thrilled to announce a collaboration with The Magic Boost, a professional development program for young content creators passionate about running. This partnership will connect emerging storytellers, known as Boosters,...

Press Releases

Sponsorship

Trade Shows