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

January 18, 2025

RBC GranFondo Whistler Named North America’s Top GranFondo Event for 2024 – Again!

Whistler, BC (January 18, 2025) /ENDURANCE SPORTSWIRE/ – For the fifth time in the past six years, RBC GranFondo Whistler has been recognized as the NUMBER 1 GranFondo event in North America, cementing its place as the continent's premier cycling event. Held on September 7, 2024, the event celebrated its...

Cycling

Events

Press Releases

January 17, 2025

2004 U.S. Olympian Andy Potts to Lead USA Triathlon’s Paratriathlon Resident Team

COLORADO SPRINGS, Colo. (January 17, 2025) /ENDURANCE SPORTSWIRE/ — USA Triathlon today announced 2004 U.S. Olympian and Tokyo 2020 Paralympic guide Andy Potts as the new coach of the Paratriathlon Resident Team. The Paratriathlon Resident Team trains in a daily high performance environment at the Colorado Springs Olympic & Paralympic...

Business

Press Releases

Triathlon

January 17, 2025

Austin International Half Ready to Blaze Through Austin This Weekend

AUSTIN, Texas, January 17, 2025 /ENDURANCE SPORTSWIRE/ - The Austin International Half, formerly known as the 3M Half Marathon will host over 5,000 runners from 47 states and 14 countries for the 31st year of the annual event. This year's race is set to deliver a memorable celebration of running,...

Events

Press Releases

Running

January 17, 2025

Mankerlight Unveils MK39 II: The Ultimate High-Performance Flashlight with Extreme Long-Range and Brightness

/ENDURANCE SPORTSWIRE/ - Mankerlight, a pioneer in advanced lighting solutions, proudly announces the launch of the MK39 II, a cutting-edge, high-performance flashlight that combines extreme long-range spotlighting with an incredibly bright floodlight. Engineered with the latest LED technology, a powerful 24,000mAh 4680 lithium battery, and a robust aluminum housing, the...

Press Releases

Products

January 16, 2025

Strong Girl Publishing Celebrates National Girls & Women in Sports Day with Inspiring Books for Young Athletes

January 16, 2025 /ENDURANCE SPORTSWIRE/ - With National Girls & Women in Sports Day (NGWSD) coming up on February 5, 2025, Strong Girl Publishing is ready to celebrate with our collection of empowering middle grade and young adult books featuring girls who love to play. As we approach the 39th...

Press Releases

Products

January 16, 2025

deboer releases the FJORD 3.1: A Sleeveless Wetsuit Revolutionizing Open Water Performance

Gran Canaria (January 16, 2025) /ENDURANCE SPORTSWIRE/ - deboer, a leading innovator in high-performance wetsuits, announces the launch of the FJORD 3.1, a sleeveless wetsuit engineered to redefine freedom and efficiency in the water. Building on the legacy of the acclaimed Fjord 3.0 and 4.0, the FJORD 3.1 incorporates the...

Press Releases

Products

Triathlon

January 16, 2025

Cigna Healthcare Renews Title Sponsorship with Denver Colfax Marathon

Denver, CO. (January 16, 2025)  /ENDURANCE SPORTSWIRE/ – The Denver Colfax Marathon is proud to announce that Cigna Healthcare has renewed its title sponsorship for the 2025 race season. After a record-breaking 25,000 runners participated in the 2024 marathon weekend, this partnership continues to elevate the race’s profile nationwide. “Cigna...

Business

Events

Giving

Press Releases

Running

Sponsorship

January 16, 2025

French Riviera T100 Triathlon Amateur Events Go On General Sale

London, UK (January 16, 2025) /ENDURANCE SPORTSWIRE/ -  The Professional Triathletes Organisation (PTO) has announced that places went on general sale today for the amateur triathlon events at its new French Riviera T100 Triathlon on 27-29 June. Billed as a ‘French festival of multisport’ when the new T100 leg was...

Press Releases

Triathlon

January 16, 2025

World Titles On The Line As Kids Go Free To 2025 Supertri E World Triathlon Championship powered by MyWhoosh In London

LONDON, UK (January 16) /ENDURANCE SPORTSWIRE/ -  Supertri and World Triathlon are proud to announce that the 2025 Supertri E World Triathlon Championship powered by MyWhoosh will return to the London Aquatics Centre on Saturday, 5th April, bringing fans an electrifying evening of elite racing and developing the future of...

Events

Press Releases

Triathlon