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

May 15, 2024

LA Tri-Series Announces Incorporation of IronBruin Collegiate Division into Fall Classic Event

LOS ANGELES, Calif. /ENDURANCE SPORTSWIRE/ – The LA Tri-Series is in the midst of its 42nd consecutive event, and has recently announced the addition of the IronBruin Collegiate Division into its Fall Classic event, taking place on Oct. 6. The Fall Classic is the second of three events that make...

Events

Press Releases

Triathlon

May 14, 2024

La Jolla Half Marathon Partners with HydraPak® and WaterMonster to Go Waste Free, Ditches Disposable Cups

OAKLAND, Calif. (May 14, 2024)/ENDURANCE SPORTSWIRE/ – In partnership with HydraPak®, global leader of high-performance hydration solutions, and water delivery services provider, WaterMonster, the La Jolla Half Marathon and 5K is excited to announce that it will remove disposable cups and transition to HydraPak's reusable SpeedCup at this year's race. The...

Events

Press Releases

Sponsorship

May 14, 2024

Empowering the Next Generation: Introducing the XTERRA Youth Tour

/ENDURANCE SPORTSWIRE/ – In 2024, XTERRA launched its inaugural Youth Tour designed to develop the next wave of world-class off-road triathletes. With over 40 events worldwide, the XTERRA Youth Tour connects young athletes to the world of cross-triathlon, offering a structured competitive path for anyone curious about the sport and...

Cycling

Events

Press Releases

Running

Triathlon

May 14, 2024

Chambers and Samosir win GFNY Kuala Lumpur

New York City, May 14, 2024 /ENDURANCE SPORTSWIRE/ – Kuala Lumpur hosted the second edition of the GFNY Kuala Lumpur this past Sunday. Riders from over 25 countries tackled the long racecourse of 129.1 km with 1726m of climbing. Malaysia’s Minister of Youth & Sports Malaysia Hannah Yeoh together with...

Cycling

Events

Press Releases

May 14, 2024

Largest Ever Field for The Championship 2024

/ENDURANCE SPORTSWIRE/ -It’s under a week until close to 2,000 athletes line up to be part of the largest ever Challenge Family The Championship at the x-bionic sphere near Bratislava in Slovakia. Over 100 of those athletes are some of the world’s top professionals as they race for the 100,000...

Events

Press Releases

Triathlon

May 14, 2024

Boulderthon Announces New All-Road Heart to Heart 5K Course Presented by Boulder Community Health

BOULDER, Colo. /ENDURANCE SPORTSWIRE/ – Ahead of their 2024 event, Boulderthon, one of the fastest-growing races in the U.S., has announced major changes to their 5K race to be held on Sept. 29, 2024. The Boulder Community Health (BCH) Heart to Heart 5K will feature an all-road, fast and flat...

Events

Press Releases

Running

May 13, 2024

Stoked Oats sponsors Madeline Wighardt for the 2024 100-Mile Western States Endurance Run

Calgary, Alberta, May 13, 2024 /ENDURANCE SPORTSWIRE/ – Stoked Oats (SO) is back for the third year as the Official Breakfast Sponsor of Western States Endurance Run, June 29-30 in Auburn, CA. Madeline Wighardt, the 22-year-old chemical engineering student who placed third in Leadville Trail 100 last year, will represent...

Events

Press Releases

Running

Sponsorship

May 13, 2024

Santa Barbara Wine Country Half Marathon Draws Thousands in Mother’s Day Weekend Tradition

Solvang, California /ENDURANCE SPORTSWIRE/ – Under overcast skies ideal for distance running, more than 2,000 athletes gathered in downtown Solvang on Saturday for the Santa Barbara Wine Country Half Marathon presented by Chumash Casino Resort. The 17th annual event, held traditionally each Mother’s Day weekend, is popular for its scenic route and...

Events

Press Releases

Running

May 13, 2024

Yuengling Shamrock Marathon Brings $22 Million Economic Impact to Virginia Beach

MAY 13, 2024 – VIRGINIA BEACH, VIRGINIA /ENDURANCE SPORTSWIRE/ – The annual Yuengling Shamrock Marathon held in Virginia Beach has once again proven to be a major economic driver for the city, bringing in an impressive $22 million in revenue. The event, which took place March 15-17, 2024 attracted over...

Business

Events

Press Releases

Running