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 (16)
) 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 20, 10

December 19, 2024

New Year, New You: IRONMAN Announces 2025 Commitment Day Aimed at Encouraging Athletes to Find Their IRONMAN or IRONMAN 70.3 Finish Line

TAMPA, Fla. (Dec. 19, 2024) /ENDURANCE SPORTSWIRE/ - IRONMAN® Commitment Day is returning in 2025, kicking off on January 1 and encouraging athletes to pledge to the goal of completing an IRONMAN and or an IRONMAN® 70.3® triathlon. The toughest part of the journey is committing, and 2025 IRONMAN Commitment...

Events

Press Releases

Triathlon

December 19, 2024

Avalon Benefit 50 Mile/50K Run Sells Out Ahead of 2025 Event

AVALON, Calif. (December 19, 2024) /ENDURANCE SPORTSWIRE/ – The Avalon Benefit 50 Mile/50K Run, produced by Spectrum Sports Management, is returning for its annual event on Jan. 11, 2025. The 2025 event sold out its 1,000 registrations almost 3 months ahead of the event date, a month earlier than the previous...

Events

Press Releases

December 18, 2024

Double Bridge Run filling up quick!

Pensacola, FL (Dec. 18, 2024) /ENDURANCE SPORTSWIRE/ - Runner registration is filling up fast for the 2025 Pensacola Double Bridge Run presented by Publix. The race, limited to 4,000 runners, is a local favorite that draws runners from all over the U.S. Dubbed “the race with a view,” the Pensacola...

Events

Press Releases

SWW Syndication

December 18, 2024

Kids of STEEL Goes Global: First International Site Inspires Movement in South Africa

PITTSBURGH, PA (Dec. 18, 2024) /ENDURANCE SPORTSWIRE/ - Kids of STEEL, P3R’s acclaimed youth fitness program, is making its international debut in Kempton Park, South Africa. This expansion showcases the universal appeal of the program, which inspires families to move together through fun and engaging activities. Kids of STEEL offers...

Events

Press Releases

Running

December 18, 2024

Professional Triathletes Organisation Confirms First Contracted Athletes For 2025 T100 Triathlon World Tour

London, UK (December 18, 2024) /ENDURANCE SPORTSWIRE/ - The Professional Triathletes Organisation (PTO) has confirmed the first athletes who will be racing on the 2025 T100 Triathlon World Tour, from those who automatically qualified by placing in the top 10 positions of this season’s competition. Both T100 World Champions, American...

Events

Press Releases

Triathlon

December 18, 2024

Ready for the ultimate Aussie Challenge? 2025 packages for TCS Sydney Marathon presented by Asics and Kangaroo Island Marathon now available

18th December 2024, Boston US /ENDURANCE SPORTSWIRE/ - Now an official Abbott World Marathon Major, the 2025 iteration of TCS Sydney Marathon takes place on Sunday 31st August. As one of only seven World Marathon Majors, it promises an electric atmosphere, world-class competition, and the chance to run past some...

Business

Events

Press Releases

Running

December 18, 2024

2025 XTERRA Borneo Sarawak Debuts Off-Road Adventure in Malaysia

BORNEO, SARAWAK, MALAYSIA (December 18, 2024) /ENDURANCE SPORTSWIRE/ — Standing tall as the fourth stop on the 2025 XTERRA APAC Tour, the first-ever XTERRA Borneo Sarawak will take place on May 3-4, 2025. Supported by the Ministry of Tourism Sarawak, the two-day event aims to reinforce the region’s reputation as...

Cycling

Events

Press Releases

Running

Triathlon

December 18, 2024

BMC extends as official bike of GFNY USA 2025

New York City, December 18, 2024 /ENDURANCE SPORTSWIRE/ - BMC and GFNY are excited to announce their continued partnership for the 2025 season, with BMC serving as the Official Bike for all GFNY USA events. This collaboration will provide riders with the opportunity to experience BMC’s cutting-edge road bikes, including...

Cycling

Events

Press Releases

December 18, 2024

The Marathon Project Is Back

CHANDLER, Ariz., December 18, 2024 /ENDURANCE SPORTSWIRE/ - The Marathon Project ownership group announced today that the race will return in 2025 as an annual event for amateurs and professionals. The event will take place at Wild Horse Pass Resort in Chandler, Ariz. on the exact same criterium-style course that...

Business

Events

Press Releases

Running