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

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

December 4, 2024

Encarnacion, Paraguay to Host Inaugural Ueno Bank 5150 Paraguay Triathlon in 2025

ENCARNACIÓN, Paraguay / TAMPA, Fla. (Dec. 4, 2024) /ENDURANCE SPORTSWIRE/ – IRONMAN has announced that the city of Encarnación, Paraguay will host the first-ever 5150™ triathlon in Paraguay in 2025. The new Ueno Bank 5150 Paraguay triathlon is set to take place on April 13, 2025 and will welcome athletes from...

Cycling

Events

Press Releases

Triathlon

December 4, 2024

SkyhoundMedia and Great Lakes Fishery Commission Unveil “THE FISH THIEF: A Great Lakes Mystery”

December 4, 2024—Ann Arbor, MI /ENDURANCE SPORTSWIRE/ —SkyhoundMedia, a celebrated production company specializing in exploring nature’s impact on society worldwide, and the Great Lakes Fishery Commission are proud to unveil “THE FISH THIEF: A Great Lakes Mystery.” This award-winning documentary tells the true story of the remarkable people tackling the...

Press Releases

Products

December 4, 2024

Wild Rye Announces Expansion Into Snow Outerwear For Fall-Winter 2025-26

Sun Valley, ID (Dec. 4, 2024) /OUTDOOR SPORTSWIRE/ - Wild Rye, the premiere active lifestyle apparel brand designed to empower women in the outdoors and beyond, announces its FW25-26 expansion into the snowsports outerwear category, complimenting the brand’s existing winter offerings of merino-wool baselayers and eco-synthetic insulation. Functional and minimalistic...

Business

Press Releases

Products

December 4, 2024

Gnara Announces Go Free™ Collection: Leggings and Shorts Featuring Patented GoFly® Zipper Technology

Gunnison, CO. (Dec. 4, 2024) /ENDURANCE SPORTSWIRE/ - Gnara, inventor of the award-winning GoFly® Pee Zipper Technology, is announcing the official launch of Go Free™ ⅞ Legging and Go Free™ 6” Shorts on their site (www.gnara.com) after a successful Kickstarter campaign this fall. It was the highest funded Kickstarter campaign...

Business

Press Releases

Products

December 4, 2024

Garmin Announced as Title Sponsor for Kilimanjaro Trails Festival

Kilimanjaro, Tanzania (December 4, 2024) /ENDURANCE SPORTSWIRE/  — Red Knot Racing Company is proud to announce Garmin as the title sponsor of the 7th Annual Garmin Kilimanjaro Trails Festival, scheduled to take place from 31st January to 2nd February 2025 on the scenic lower slopes of Mount Kilimanjaro. This partnership marks a...

Business

Cycling

Events

Press Releases

Running

Sponsorship

Trade Shows