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

January 9, 2024

Pat Tillman Foundation Opens Registration For 20th Annual Pat’s Run, Presented by Teksystems

CHICAGO (Jan. 9, 2024) /ENDURANCE SPORTSWIRE/ - Registration opened today for the 20th Annual Pat’s Run, the Pat Tillman Foundation’s marquee fundraising event, presented by TEKsystems. Pat’s Run, a 4.2-mile run / walk with a .42-mile Kids Run, will take place in-person and virtually on April 13, 2024. The in-person...

Events

Giving

Press Releases

Running

January 9, 2024

Cheers to Round Two: 3M Half Marathon Welcomes Back EIGHT Beer

Austin, Texas, January 9, 2024 /ENDURANCE SPORTSWIRE/ – High Five Events, a leading private event production company in the United States, is delighted to announce the continuation of its successful partnership with EIGHT Beer as the Official Beer for the second consecutive year at the upcoming 3M Half Marathon in Austin, Texas....

Events

Press Releases

Running

Sponsorship

January 9, 2024

The 2023 Vinfast IRONMAN World Championship Documentary Special Now Available For Free Internationally on IRONMAN’S YouTube Channel

TAMPA, Fla. /ENDURANCE SPORTSWIRE/ - After premiering on Outside Watch on December 30, 2023, the 2023 VinFast IRONMAN® World Championship documentary special is now available globally on IRONMAN’s YouTube channel. The annual IRONMAN World Championship special chronicles triathlon’s pinnacle event, which for the first time in the iconic event’s 45-year...

Press Releases

Triathlon

January 9, 2024

SFuels successfully delivered official on-course nutrition, and post-race recovery shake, for 43rd running of Avalon 50 Mile/50K ultra

RALEIGH, North Carolina, January 09, 2024 /ENDURANCE SPORTSWIRE/ - In five short years, SFuels has taken it to the much older incumbent high-sugar nutrition players – delivering the industry’s most innovative nutrition stack for aerobic development, threshold and Vo2Max endurance performance. While a newcomer, SFuels products are packing a punch in...

Press Releases

Running

Sponsorship

January 8, 2024

Gold’s Gym Thousand Oaks Redefines Fitness with Unveiling of State-of-the-Art Remodel and Exclusive Features

Thousand Oaks, CA (January 8, 2024) /ENDURANCE SPORTSWIRE/ – Gold’s Gym Thousand Oaks is excited to announce the successful completion of its extensive remodel and expansion, marking a significant milestone in its commitment to providing an unparalleled fitness experience in Southern California. The transformative project introduces exclusive facilities and state-of-the-art equipment,...

Business

Press Releases

January 8, 2024

Supply Chain Sources Will Represent Three Popular Wellness Brands At CES 2024

PLANO, TX, Jan. 8, 2024 /ENDURANCE SPORTSWIRE/ – Supply Chain Sources (SCS) will represent at CES 2024 three popular wellness brands: KingSmith Fitness and a full line of WalkingPad products (Venetian Expo, Halls A-D, Booth #54208), LifeSmart PowerTouch Fitness (Venetian Expo, Halls A-D, Booth #54508) and AiWorks Global (LVCC, North Hall,...

Business

Press Releases

Trade Shows

Wire Syndication