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 (22)
) 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 120, 10

July 27, 2024

Gentle Back on Top as She Wins London T100 Triathlon

London, UK /ENDURANCE SPORTSWIRE/ - Australian Ashleigh Gentle returned to winning ways at the London T100 Triathlon, to claim her second T100 race of the season and take her back to the top of the series standings. She finished ahead of Swiss star Imogen Simmonds and Britain’s Kat Matthews. Winner...

Awards

Cycling

Events

Press Releases

Running

Sponsorship

Trade Shows

Triathlon

July 25, 2024

Zoot Sports Welcomes 5x World Champion Craig “Crowie” Alexander as Brand Ambassador

Carlsbad, CA /ENDURANCE SPORTSWIRE/ - Zoot Sports, the industry leader in triathlon apparel, is excited to announce that Craig "Crowie" Alexander, a 5x World Champion and triathlon legend, has joined the company as a brand ambassador. With Alexander’s experience and expertise in the sport, he will play a pivotal role...

Press Releases

Sponsorship

Triathlon

July 19, 2024

supertri Partners With Europe Triathlon’s Rising Stars Initiative To Develop ‘NXT Gen’ Of Elite Athletes

LONDON, UK/ENDURANCE SPORTSWIRE/ – supertri can today announce a partnership with Europe Triathlon to support the development of the next wave of Olympic champions. supertri is officially backing the Rising Stars programme, which enables junior athletes from across the continent to have the chance to make a leap from amateur...

Press Releases

Sponsorship

Triathlon

July 19, 2024

Verge Sponsors Chicago Grit with a Stunning New Leader Jersey Design

NEW YORK, JULY 19, 2024 /ENDURANCE SPORTSWIRE/ – Verge, the innovative leader in custom cycling apparel, is proud to announce its sponsorship of Chicago Grit, formerly known as Intelligentsia Cup, the most exciting 10-day criterium race series in Chicagoland and the largest road racing series in America. Verge has closely...

Cycling

Events

Press Releases

Sponsorship

July 18, 2024

BMW Joins as Official Partner for Challenge New Jersey State Triathlon

MERCER COUNTY, NJ – July 18, 2024 /ENDURANCE SPORTSWIRE/ - The Challenge Family and Motiv Sports today announced BMW as the official automotive partner for the Challenge New Jersey State Triathlon, taking place this weekend, July 20-21, 2024. This partnership brings a new level of prestige to one of the...

Events

Press Releases

Sponsorship

Triathlon

July 17, 2024

Foil Race Kicks Off 25th Anniversary Molokaʻi 2 Oʻahu Paddleboard World Championships

Now over two weekends, the open ocean challenge begins on Sunday, July 21 with the foil race, followed by the prone and standup paddleboard race on July 28, 2024. Foil athletes will break in a new longer and faster course that will finish off the shore of Kaimana Beach in...

Events

Press Releases

Sponsorship