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

April 22, 2024

supertri Announces Synergy Wetsuits as Official Wetsuit Partner for 2024 Mass Participation Races

/ENDURANCE SPORTSWIRE/ – supertri, the leading provider of world class triathlon events, can today announce Synergy Wetsuits as the official wetsuit partner for the highly anticipated 2024 Long Beach Legacy Triathlon and the 2024 Chicago Triathlon. As well as supplying high-performance wetsuits, Synergy Wetsuits will also provide convenient rental options...

Events

Press Releases

Sponsorship

Triathlon

April 22, 2024

Bank of America Chicago 13.1 Receives Evergreen Certification from the Council for Responsible Sport

CHICAGO /ENDURANCE SPORTSWIRE/ – The Bank of America Chicago 13.1 and Council for Responsible Sport announced today the event earned Evergreen Certification, a recognition reserved for sporting events that demonstrate the highest possible commitment to environmental and social responsibility. The Chicago 13.1 debuted in 2022 with the vision to reimagine...

Events

Press Releases

Running

April 22, 2024

Swenson and Villafane Crowned El Campeons de Fuego at Sea Otter

Monterey, CA (Monday, April 22)/ENDURANCE SPORTSWIRE/ – History repeated itself in the opening race of the 2024 Life Time Grand Prix presented by Mazda, with Keegan Swenson winning his third consecutive Fuego XL 100k presented by Continental and Sofia Gomez Villafane also repeating her success of 2023. Swenson led from...

Cycling

Events

Press Releases

April 22, 2024

Lizzie Orchard and Benjamin Forbes Clinch XTERRA Australia Crowns

DUNSBOROUGH, AUSTRALIA /ENDURANCE SPORTSWIRE/ – The fourth stop on the XTERRA APAC Tour concluded with a closely contested elite women’s race, where Elizabeth “Lizzie” Orchard (NZL) narrowly secured victory, finishing just 27 seconds ahead of Hannah-Lee Young (AUS) alongside Ben Forbes (AUS) in the men’s race, emerging victorious at XTERRA...

Cycling

Events

Press Releases

Running

Triathlon

April 22, 2024

Iestyn Harrett and Marta Lagownik Secure First Professional Victories at Anfi Challenge Mogán Gran Canaria

/ENDURANCE SPORTSWIRE/ – Today’s Anfi Challenge Mogán Gran Canaria race was nothing short of spectacular. The race, featuring over 40 elite triathletes, witnessed intense competition from start to finish in both the men’s and women’s races with Iestyn Harrett (GBR) and Marta Lagownik (POL) both taking maiden professional wins in...

Events

Press Releases

Triathlon

April 19, 2024

Tour of Somerville: A Celebration of Community, Cycling, and Unbridled Thrills Enters its 79th Year

Somerville, NJ /ENDURANCE SPORTSWIRE/ - The adrenaline-fueled excitement of competitive cycling is poised to take center stage in Somerville as the iconic "Tour of Somerville" gears up for its 79th-year edition. Organized by Arts on Division and Long Tail Productions, this event has evolved into a community-wide celebration that invites...

Cycling

Events

Press Releases

April 19, 2024

Molokaʻi-2-Oʻahu Paddleboard World Championships Sells Out

HONOLULU, HI (April 19th, 2024) /ENDURANCE SPORTSWIRE/ – Molokaʻi-2-Oʻahu Paddleboard World Championships presented by the Hawai‘i Tourism Authority(M2O) is officially SOLD OUT for the 32-mile race across the Kaiwi channel, connecting the Hawaiian Islands of Moloka‘i and O‘ahu. The prestigious race attracts over 250 of the world’s best paddlers from 25+...

Events

Press Releases