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

August 1, 2024

Electrolit Named Official Hydration Partner of Spartan Race Canada for 2024 Season

[Toronto, Ontario] /ENDURANCE SPORTSWIRE/ – Electrolit®, Canada’s newest premium hydration beverage, is thrilled to announce its partnership with Spartan Race Canada as the Official Hydration Partner for the 2024 season. This strategic collaboration brings together two forces committed to promoting an active lifestyle, pushing boundaries, and ensuring optimal performance for...

Events

Press Releases

Sponsorship

August 1, 2024

GFNY Brasil back in Conservatória

New York City, August 1, 2024 /ENDURANCE SPORTSWIRE/ – This Sunday, “The City of Serenades” in the State of Rio and just three hours from Rio de Janeiro will host GFNY Conservatória after a five year hiatus. The race course with its 130.1 km and an elevation gain of 2533m...

Cycling

Events

Press Releases

August 1, 2024

Kiptoo, Chebet Win Quad-City Times Bix 7, Second PRRO Circuit 2024-25 Stop

DAVENPORT, IA /ENDURANCE SPORTSWIRE/ – On a warm, sunny Saturday morning on July 27, at the 50th Quad-City Times Bix 7, the second stop on the PRRO Circuit 2024-25, Wesley Kiptoo of Kenya and Rachel Chebet of Uganda won the golden edition over the challenging 7 mile course, clocking 32...

Events

Press Releases

Running

July 31, 2024

The IRONMAN Group Promotes Michelle Pepper to Managing Director of Oceania

SYDNEY, Australia / TAMPA, Fla. (July 31 2024) /ENDURANCE SPORTSWIRE/ - The IRONMAN Group is pleased to announce that Michelle Pepper has been promoted to the role of Managing Director for Oceania. Pepper is taking over the role from Geoff Meyer who has retired as of the end of July....

Business

Events

Press Releases

Triathlon

July 30, 2024

Get your entry in for the Cycling Time Trials (CTT) 2024 Closed Circuit Championships: A Festival of Cycling for all, hosted at Goodwood Motor Circuit on Sunday 11th August 2024

30th July 2024/ENDURANCE SPORTSWIRE/ – Entries to the Cycling Time Trials (RTTC) Closed Circuit Championships closes at midnight on Tuesday 30th July, so riders looking to race the iconic Goodwood Motor Circuit should get their names down now. The event, on Sunday 11 August, is perfect for cyclists of all...

Cycling

Events

Press Releases

July 30, 2024

All-Star Field and $100,000 Prize Purse Confirmed for Challenge Beijing

/ENDURANCE SPORTSWIRE/ – Challenge Family’s newest event, Challenge Beijing in China, has confirmed a US$100k prize purse with a world-class field of professional athletes already secured to attend the non-drafting Olympic distance race on 8 September. Among those racing is top-ranked New Zealand athlete, Kyle Smith, winner of The Championship...

Events

Press Releases

Triathlon