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

November 13, 2024

Professional Triathletes Organisation Announce Frejus & St Raphael As Location For New French Riviera T100 Triathlon

London, UK (November 13th) /ENDURANCE SPORTSWIRE/ -  The Professional Triathletes Organisation (PTO) has confirmed the idyllic port towns of Frejus and St Raphaël will be the hub for the new French Riviera T100 Triathlon, when the world’s best triathletes come to the Côte d'Azur on 16-18 May next year. Billed...

Events

Press Releases

Triathlon

November 13, 2024

Ascension Seton Austin Marathon Welcomes PNC Bank as the 2025 Health and Fitness Expo Presenting Sponsor

Austin, TX – November 13, 2024 /ENDURANCE SPORTSWIRE/ – The 2025 Ascension Seton Austin Marathon, Half Marathon, & 5K® is excited to announce the Health and Fitness Expo is now presented by PNC Bank. Kicking off Presidents’ Day weekend, the Health and Fitness Expo will be held at the spacious...

Events

Press Releases

Running

Sponsorship

Trade Shows

November 13, 2024

Bringing Innovation and Sun Protection Back to TRE: Introducing the New KINeSYS Pro Sport Range

13 November 2024. Vancouver, Canada /ENDURANCE SPORTSWIRE/ - KINeSYS Performance Sunscreen is excited to announce its return to The Running Event (TRE) in Austin, TX, from November 19–21 2024. This marks the first time since 2017 that KINeSYS will be exhibiting at the premier industry gathering. “With 2025 shaping up to be...

Press Releases

Products

Trade Shows

November 13, 2024

“Power Comes from Within” Thermore Launches First Consumer Campaign

Milan, Italy/ENDURANCE SPORTSWIRE/ - Thermore, an Italian manufacturing firm that has been innovating in the apparel insulation sector for over 50 years, announces the launch of its first consumer campaign. Imagined by global creative team, Innocean Italy, “Power Comes from Within,” is a brand manifesto highlighting the quality and versatility of...

Business

Press Releases

Products

November 13, 2024

Lake Sonoma 100-Mile Relay “Shit Show” – Registration Now Open!

/ENDURANCE SPORTSWIRE/ - The Lake Sonoma “Sufferfest” 100-Mile Relay, affectionately dubbed the “Shit Show,” is here, and it’s all about the run club scene. But don’t be fooled—this isn’t your grandma’s relay (unless she’s a total badass). It’s an intense yet insanely fun way to get in on the action,...

Press Releases

Running

November 13, 2024

Kinomap Launches Personal Goals Feature, Empowering Users to Set Customized Fitness Targets

Nov. 13, 2024 /ENDURANCE SPORTSWIRE/ – Kinomap, the leading fitness app for interactive training on real-world routes, is excited to announce its latest feature: Personal Goals. This innovative feature is designed to help users stay motivated and progress at their own pace by setting tailored fitness targets across cycling, running,...

Press Releases

Products

November 13, 2024

Thousands of riders tackled 11th GFNY Cozumel

New York/ENDURANCE SPORTSWIRE/ - Thousands of riders from around the globe participated in the 11th edition of GFNY Cozumel, Latin America’s largest running cycling race. Riders tackled the 157.5 km challenging course under pouring tropical rain. Irrespective of the heavy rainfall, the race started off fast as always. Right from...

Cycling

Events

Press Releases

November 13, 2024

Sumarpo Embraces Top Portuguese Talent to Drive Innovation in Triathlon Gear

November 13th. /ENDURANCE SPORTSWIRE/ - Sumarpo has officially partnered with Hugo Figueiredo, a leading figure in Portugal’s triathlon community and the current Portuguese National Champion. The partnership underscores both Sumarpo’s and Figueiredo’s dedication to advancing excellence, innovation, and sustainability in triathlon sportswear. A Journey of Dedication and Success Hugo’s journey...

Business

Press Releases

Sponsorship

Triathlon

November 12, 2024

The Best Just Got Bolder: The James Brand × Timex Automatic GMT Emerald Edition

Portland, OR (November 12, 2024) /OUTDOOR SPORTSWIRE/ - Travel rarely goes the way you plan it; that’s what transforms it into adventure. The James Brand ventured deep into the headlands of Nova Scotia and found inspiration for its most recent collaboration with legendary watchmaker, Timex. Evoking the deep, lush tones...

Business

Press Releases

Products