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

January 31, 2023

General Registration for 2023 IRONMAN 70.3 Chattanooga Triathlon Officially Sold Out

CHATTANOOGA, Tenn. (Jan. 31, 2023) /ENDURANCE SPORTSWIRE/ – IRONMAN® announced today that general registration for the 2023 IRONMAN® 70.3® Chattanooga triathlon has officially sold out. Limited entries still remain available through the IRONMAN Foundation and Enhanced Athlete Event Experiences powered by NIRVANA. The event, which is scheduled for Sunday, May 21,...

Events

Press Releases

Triathlon

January 31, 2023

Wiley X Opens New State-of-the-Art Headquarters in Frisco, Texas

Frisco, Texas — January 31, 2023 /ENDURANCE SPORTSWIRE/ – As Wiley X celebrates its 35th Anniversary, the company opened the doors to its expansive, state-of-the-art new headquarters in Frisco, located just north of Dallas, Texas. The 65,000-square-foot facility has everything the family-owned, premium protective eyewear brand needs to run its expanding global...

Business

Press Releases

January 31, 2023

Catherine Blizzard and Daniel Widtfeldt keep their cool to Win Too Cold to Hold Half Marathon

DALLAS /ENDURANCE SPORTSWIRE/ – Known for chilly forecasts over its more than 25-year history, the Too Cold To Hold Half Marathon, 10K and 5K at White Rock Lake had unseasonably mild temperatures Saturday. Close to 2000 runners joined Run Project for their second race of the year. Daniel Widtfeldt and Catherine...

Events

Press Releases

Running

January 31, 2023

Shamrock Run Portland benefiting OHSU Doernbecher Children’s Hospital

PORTLAND, Ore. – January 31, 2023 /ENDURANCE SPORTSWIRE/ - The Shamrock Run Portland named OHSU Doernbecher Children’s Hospital as their primary beneficiary in 2002, and since then has raised nearly $600,000 for the world-class institution. This year, the Shamrock Run Portland is celebrating 45 years running on Sunday, March 12,...

Events

Giving

Press Releases

Running

January 31, 2023

A pioneer of gravel events, the Old Man Winter Rally prepares for a sellout event amid wintry weather.

/ENDURANCE SPORTSWIRE/ - Now in its 9th year, this ‘Epic Winter Adventure’ has become the annual kickoff event for adventurous runners and riders from all over the country. Need to know: 1,500 riders and runners from 27 states will take the start line in Lyons, Colorado on Sunday 2/5/23. Elite...

Business

Cycling

Events

Press Releases

Running

January 31, 2023

US Trail Running Conference 2022 session recordings now available

Nailsworth, England /ENDURANCE SPORTSWIRE/ - The Industry leading US Trail Running Conference provides high quality content, innovative perspectives, networking and actionable practices to help race directors create and develop successful trail races. If you missed the 2022 event, you can now secure session recordings. A majority of the Conference sessions...

Press Releases

Running

January 31, 2023

RunSignup Announces 2023 Technology Development Roadmap for Endurance and Ticket Events

January 31, 2023 - Moorestown, NJ /ENDURANCE SPORTSWIRE/ - RunSignup, the leading registration and technology solution for US endurance events, announces its 2023 technology product roadmap. RunSignup technology development plans focus on supporting the needs of its customer base of 28,000 events, including running, walking, triathlon, cycling, water and other...

Business

Cycling

Events

Press Releases

Products

Running

Triathlon

January 31, 2023

MudGear to be the Official Performance and Lifestyle Sock of Spartan and Tough Mudder U.S., Canada, and the U.K.

BOSTON, MASS. (January 31, 2023) /ENDURANCE SPORTSWIRE/ – Spartan and Tough Mudder, the world’s leading endurance sports and extreme wellness brands, announced that MudGear will become an official sponsor, to offer their top-of-the-line performance socks to racers through the 2023 and 2024 race seasons in the U.S, Canada, and the U.K....

Press Releases

Running

Sponsorship