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

December 5, 2024

Greater Zion Will Host Final Edition of IRONMAN 70.3 St. George in 2025

ST. GEORGE, Utah / TAMPA, Fla. (Dec. 5, 2024) /ENDURANCE SPORTSWIRE/ – IRONMAN and the Greater Zion Convention & Tourism Office announced that following 15 years of IRONMAN® events in this iconic location, a chapter will close when the St. George area hosts their final IRONMAN® 70.3® triathlon in 2025....

Events

Press Releases

Triathlon

December 5, 2024

Striker® and Coors Light Team Up for Limited Edition Ice Fishing Suit

December 5, 2024 - Hudson, WI /ENDURANCE SPORTSWIRE/ - Striker, a trusted leader in premium ice fishing apparel, proudly announces the launch of the Limited Edition Coors Light Suit, a collaboration with Coors that blends legendary branding with cutting-edge ice fishing performance technology. This exclusive gear is designed for anglers...

Press Releases

Products

December 5, 2024

The Rock Fight Podcast Welcomes Industry Veteran Eoin Comerford as Regular Commentator

San Diego, CA – December 5, 2024/ENDURANCE SPORTSWIRE/ —The Rock Fight Podcast is excited to announce that Eoin Comerford, a seasoned leader and innovator in the outdoor industry, will join the show as a regular commentator. Comerford’s extensive experience and unique insights will elevate the podcast’s mission to provide deeper...

Business

Press Releases

December 5, 2024

Scimitar Sports Announced as Partner for Sold-Out Inaugural Triathlon Industry Conference (TIC24)

December 5, 2024 /ENDURANCE SPORTSWIRE/ - Organised in partnership with Running Industry Alliance following the merger in July, TIC24 has attracted triathlon’s most influential leaders, with a jam-packed itinerary of insightful discussions and networking opportunities. Featuring high-profile speakers and panellists from across the industry, the conference is set to tackle...

Business

Events

Press Releases

Trade Shows

Triathlon

December 5, 2024

Showcased

GoFundraise Signs as Official Charity Fundraising Partner for IRONMAN and IRONMAN 70.3 Races in the UK with New Multi-year Agreement

December 5. /ENDURANCE SPORTSWIRE/ - GoFundraise, a global leader in online and mass participation fundraising, is excited to announce a new multi-year partnership with IRONMAN and IRONMAN 70.3 events in the UK. This collaboration will continue to empower charities to raise funds through iconic IRONMAN® and IRONMAN® 70.3® triathlons in...

Events

Giving

Press Releases

Running

December 5, 2024

Sumarpo Unveils Eco-Friendly Neoprene Swimwear Collection with the Siren Limited Edition

December 5 /ENDURANCE SPORTSWIRE/ - Sumarpo, the trailblazer in sustainable triathlon and swim gear, is excited to announce the launch of its newest collection: Neoprene Swim Suits, now available in long sleeve and sleeveless designs. Combining cutting-edge performance technology with a commitment to environmental responsibility, these suits are perfect for...

Press Releases

Products

Triathlon

December 5, 2024

La Sportiva Extends Relationship with Iconic Life Time Leadville Race Series

BOULDER, Colo. (Nov. 5, 2024) /ENDURANCE SPORTSWIRE/ - La Sportiva announced today that it is extending its relationship with the Life Time Leadville Race Series for another three years. The Italian brand will be the presenting sponsor and official footwear sponsor for all of the running events in the series,...

Press Releases

Sponsorship

December 5, 2024

Colombia to Host Inaugural 2025 XTERRA South American Championship

PAIPA, BOYACÁ, COLOMBIA /ENDURANCE SPORTSWIRE/ - A landmark announcement for the future off-road triathlon’s expansion around the globe comes from the pioneers of the sport at XTERRA. The continent of South America, along with the host nation of Colombia invite triathletes and trail runners of all ages and expertise to...

Cycling

Events

Press Releases

Running

Triathlon

December 4, 2024

Standard Chartered Singapore Marathon 2024 draws over 55,000 participants from around the world for marquee race weekend

SINGAPORE/Tampa, FLA. (4 December 2024) /ENDURANCE SPORTSWIRE/ - The Standard Chartered Singapore Marathon (SCSM) 2024 concluded the weekend with record participation, a new finish line and refreshed routes, setting new benchmarks for endurance races in the region. As Asia’s only World Athletics Gold Label race, SCSM 2024 saw over 55,000...

Events

Press Releases

Running

December 4, 2024

2024 Polartec Apex Awards Winners Announced

Planet Earth, (December 4, 2024) /ENDURANCE SPORTSWIRE/ – Polartec®, a Milliken™ & Company brand and premium creator of innovative textile solutions for future thinking, sustainably-driven brands, is delighted to announce the winners of the 2024 Polartec Apex Awards, the annual design contest that celebrates the brands and designers who embody...

Awards

Business

Press Releases

Products