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 930, 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

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 12, 2024

Enabled Tracking to Provide Live GPS Tracking for November 2024 Endurance Events

Front Royal, VA – November 2024 /ENDURANCE SPORTSWIRE/ – Enabled Tracking, a division of Adventure Enablers specializing in timing and tracking solutions, is excited to unveil its state-of-the-art live GPS tracking services. These advanced solutions will be available for both upcoming and ongoing endurance events. Designed to support participants as...

Business

Events

Press Releases

November 12, 2024

Silverback celebrates a record breaking 6 months producing and supporting major live events in San Francisco and abroad.

San Francisco, California (November 12, 2024) /ENDURANCE SPORTSWIRE/ - Silverback, a west-coast leader in large-scale production and event management closes out the third quarter supporting 20 clients and over 1,500,000 participants, attendees and spectators across the last 6 months of unique and iconic events. The dynamic SF based production agency...

Business

Events

Press Releases

Running

November 12, 2024

Short and Long Course Athletes to Go Head to Head at Challenge Canberra

/ENDURANCE SPORTSWIRE/ - Challenge Canberra is delivering a full festival of sport to Australia’s capital city this weekend, 16/17 November, with no less than six event over two days, including the Pro Open combining the Standard and Sprint distances, and age group worlds qualifying events. The Pro Open will be...

Events

Press Releases

Triathlon

November 11, 2024

Pike on a Bike: Pi Kapa Alpha Fraternity Brothers Complete 8,423 Minutes Stationary Bike Ride, Raising $48,318 in Honor of The 8,423 Cyclists and Pedestrians Killed Last Year By Riders

November 11th. /OUTDOOR SPORTSWIRE/ - BOULDER, CO — In a powerful demonstration of endurance and purpose, Pi Kappa Alpha fraternity brothers completed an extraordinary 8,423-minute stationary bike ride – one minute for every cyclist and pedestrian killed on U.S. roads in 2023. Their wheels never stopped turning during the six-day...

Cycling

Events

Giving

Press Releases