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

August 20, 2025

X T-shirt Launches Color-Changing Medals and Color-Changing Shirts for Endurance Events

August 20, 2025 /ENDURANCE SPORTSWIRE/ - X T-shirt, the creator of Magic Race Shirts and innovative race medals, is redefining the way endurance events engage participants and sponsors. With apparel and medals that change color in real time during a race, X T-shirt transforms standard race merchandise into memorable experiences...

Newswire Syndication

Press Releases

Products

Running

Sponsorship

August 19, 2025

Precision Fuel & Hydration To Become The Title Partner of The 2025 IRONMAN 70.3 World Championship Triathlon In Marbella

TAMPA, FL / CHRISTCHURCH, UK (19 August 2025) /ENDURANCE SPORTSWIRE/ – IRONMAN, the global leader in triathlon, and Precision Fuel & Hydration (PF&H) are proud to announce Precision Fuel & Hydration as the Title Partner for the 2025 IRONMAN® 70.3® World Championship triathlon taking place in Marbella, Spain on November...

Events

Press Releases

Sponsorship

Triathlon

August 19, 2025

SHOKZ Canada becomes latest brand to join the 2025 TCS Toronto Waterfront Marathon

August 19, 2025 /ENDURANCE SPORTSWIRE/ - Canada Running Series is thrilled to announce that Shokz Canada will be joining the 2025 TCS Toronto Waterfront Marathon as an official partner! Shokz is renowned for its innovative open-ear headphone technology, designed to keep runners connected to their surroundings while delivering exceptional sound...

Events

Press Releases

Sponsorship

August 15, 2025

British Triathlon and TrainingPeaks Extend Long-Standing Partnership

Louisville, Colo. /ENDURANCE SPORTSWIRE/ - British Triathlon and TrainingPeaks are extending their long-standing partnership, with TrainingPeaks continuing as the official training software supplier to British Triathlon through to the Los Angeles 2028 Games. Since the partnership began in 2014, TrainingPeaks’ software has played a key role in supporting British Triathlon’s...

Business

Press Releases

Sponsorship

August 15, 2025

Sportstats Powers the T100 Triathlon Series with RACE RESULT Technology

August, 15 2025) /ENDURANCE SPORTSWIRE/ – Sportstats is proud to highlight its partnership with RACE RESULT in delivering timing solutions for the T100 Triathlon World Tour following four completed events in Singapore, San Francisco, Vancouver, and London. RACE RESULT’s technologies, including Ubidium, Loop Boxes, and Track Boxes, have supported precise...

Cycling

Events

Press Releases

Products

Running

Sponsorship

Triathlon

August 13, 2025

10th Anniversary of the Keesler Federal Mississippi Gulf Coast Marathon Moves Athlete Village to Gulfport’s Centennial Plaza

GULFPORT, MS (August 13, 2025) /ENDURANCE SPORTSWIRE/ – As the Keesler Federal Mississippi Gulf Coast Marathon celebrates its 10th anniversary, organizers are making a major move to elevate the participant experience and expand community involvement. The event’s Athlete Village—the heartbeat of race weekend festivities—will now call Centennial Plaza in Gulfport,...

Business

Events

Press Releases

Running

Sponsorship

August 12, 2025

REIGN Total Body Fuel™ Unveils Luke Kuechly and Nick Chubb as Newest Ambassadors

Corona, CA (August 12, 2025) /ENDURANCE SPORTSWIRE/ — REIGN Total Body Fuel™, the leading zero-sugar performance energy drink, is proud to unveil its newest two Ambassadors: Luke Kuechly, seven-time Pro Bowl linebacker and defensive mastermind, and Nick Chubb, All-Pro running back known for his elite strength, speed, and determination. These...

Business

Press Releases

Sponsorship

August 12, 2025

Mascot Sports Ranks No. 908 on the 2025 Inc. 5000 List of America’s Fastest-Growing Private Companies

NEW YORK (August 12, 2025) /ENDURANCE SPORTSWIRE/ - Inc., the leading media brand and playbook for the entrepreneurs and business leaders shaping our future, today announced that Mascot Sports is No. 908 on the annual Inc. 5000 list, the most prestigious ranking of the fastest-growing private companies in America. The...

Awards

Business

Press Releases

Running

Sponsorship