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

April 23, 2024

Boston Triathlon to Add New Global Professional Race

BOSTON, MA – April 23rd, 2024/ENDURANCE SPORTSWIRE/ – ethos, a mass participation event organization that produces the Columbia Threadneedle Investments Boston Triathlon and Kids Day at the Boston Tri today announced the addition of supertri Boston to their weekend of exciting racing this coming August. The Boston Triathlon is excited to...

Business

Events

Press Releases

Triathlon

April 23, 2024

Over 8,000 Athletes Head to Asia’s Largest Triathlon at Challenge Taiwan

/ENDURANCE SPORTSWIRE/ - Selling out in hours with over 8,000 athletes, Asia’s must-do triathlon, Challenge Taiwan, returns this weekend on 27/28 April with an international pro race over the middle distance and a true celebration of age group sport at every age and level. Last year’s men’s champion, Caleb Noble...

Events

Press Releases

Triathlon

April 22, 2024

Kia America Returns as Official Automotive Partner of the 2024 Hoag OC Marathon Running Festival

ORANGE COUNTY - (April 22, 2024) /ENDURANCE SPORTSWIRE/ – The Hoag OC Marathon Running Festival today announced Kia America has returned as Official Automotive Partner of the event and sponsor of the Kia Recovery Zone. Set for the weekend of May 3-5, 2024, the Hoag OC Marathon Running Festival has...

Events

Press Releases

Running

Sponsorship

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