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

June 25, 2024

AAA – Auto Club Group becomes an Official Partner of Tough Mudder US

BOSTON, MASS. /ENDURANCE SPORTSWIRE/ – Tough Mudder, the global extreme fitness brand, announces that AAA - The Auto Club Group (ACG) will become an official partner of Tough Mudder. This collaboration marks a significant milestone for both organizations, aiming to enhance the participant experience at select Tough Mudder events across the...

Press Releases

Running

Sponsorship

June 25, 2024

Garmin unveils its brightest and smartest cycling computer ever: the Edge 1050

OLATHE, Kan./June 25, 2024/ENDURANCE SPORTSWIRE/ – Garmin (NYSE: GRMN) today announced Edge® 1050, its brightest, smartest and most connected cycling computer ever. Boasting a vibrant touchscreen display, Edge 1050 combines superior navigation, performance tracking, cycling awareness and smart connectivity—all while impressively delivering up to 20 hours of battery life in...

Cycling

Press Releases

Products

Triathlon

June 24, 2024

IRONMAN Comes to Illinois for First Time with New IRONMAN 70.3 Triathlon to be Hosted in Rockford

- Inaugural IRONMAN 70.3 Rockford-Illinois triathlon is scheduled to take place on June 22, 2025 - General registration to open on July 1, 2024, at www.ironman.com/im703-rockford-illinois ROCKFORD, Ill. / TAMPA, Fla. (June 24, 2024) /ENDURANCE SPORTSWIRE/ – IRONMAN, the global leader in long-distance triathlon, announced today that it will host...

Events

Press Releases

Triathlon

June 24, 2024

Rouvier and Morvillo Win XTERRA Switzerland Amidst Challenging Conditions

VALLÉE DE LA BRÉVINE, SWITZERLAND /ENDURANCE SPORTSWIRE/ – XTERRA Switzerland marked the 11th stop of the 2024 XTERRA EMEA Tour on June 22, 2024. Valentin Rouvier (FRA) and Bianca Morvillo (ITA) were victorious in the valley beneath the Neuchâtel mountains. The two-day event attracted both local and international competitors offering...

Cycling

Events

Press Releases

Running

Triathlon

June 24, 2024

Smiles Shine Through Rain-Soaked 2024 Boston 10K presented by Brigham and Women’s Hospital

BOSTON /ENDURANCE SPORTSWIRE/ – More than 8,100 athletes took part in today’s 2024 Boston 10K presented by Brigham and Women’s Hospital persevering through intermittent downpours to reach the finish at Boston Common. Sabastian Sawe (Kenya) and Melknat Wudu (Ethiopia) each won their first B.A.A. event, breaking the tape in 27:42...

Events

Press Releases

Running

June 24, 2024

Don’t Be Sorry, Be Better wins 2024 Teton Ogre Adventure Race

/ENDURANCE SPORTSWIRE/ – With several fast teams battling for the win amongst the 180 racers on several dozen teams, dot-watchers at home using the live-tracking system were on the edge of their seats until the final minutes of the race. This year’s 24-hour course, in Swan Valley, Idaho, on Saturday,...

Events

Press Releases

June 23, 2024

Lionel Sanders and Paula Findlay Lead a Canadian Sweep at the 2024 IRONMAN 70.3 Mont-Tremblant Triathlon

MONT-TREMBLANT, Quebec, Canada (June 23, 2024) /ENDURANCE SPORTSWIRE/ - On a rainy day in Canada’s Laurentian Mountains, the European-style ski village of Mont-Tremblant played host to the IRONMAN 70.3 Mont-Tremblant triathlon and the ninth stop of the IRONMAN Pro Series™. The race saw a Canadian sweep of the top spot...

Events

Press Releases

Triathlon

June 23, 2024

Bitados and Derron Triumph at Challenge Kaiserwinkl-Walchsee

/ENDURANCE SPORTSWIRE/ - It was a maiden win for Panagiotis Bitados (GRE) today at Challenge Kaiserwinkl-Walchsee as he crossed the line in first place in 3:41:42 after a blistering 1:09:24 run. Julie Derron (SUI) took her second win of the year in 4:03:38 with the next race on her schedule,...

Events

Press Releases

Triathlon