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 (8742)
) 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 4580, 10

September 20, 2022

Itaú BBA IRONMAN® 70.3® Rio de Janeiro debuts New Course in 2023

RIO DE JANEIRO, Brazil (September 20, 2022) /ENDURANCE SPORTSWIRE/ – It was announced today that the Itaú BBA IRONMAN® 70.3® Rio de Janeiro event scheduled for July 9, 2023, will debut a new race course in the heart of “Cidade Maravilhosa” (Wonderful City). There will be 1,900 meters (1.2 miles) of...

Events

Press Releases

Triathlon

September 20, 2022

2022 AKTIV Against Cancer Award Luncheon Honors adidas

NEW YORK, September 20, 2022 /ENDURANCE SPORTSWIRE/ – AKTIV Against Cancer, the organization co-founded by legendary runner Grete Waitz and Helle Aanesen, today announced it will honor adidas and Olympic Champion Chaunté Lowe for outstanding contributions to the field of Exercise Oncology at their eighth annual awards luncheon. The reception will be...

Awards

Press Releases

Running

September 20, 2022

Triathlon Industry Icon Bob Babbitt joins SFuels

Raleigh, North Carolina (September 20, 2022)/ENDURANCE SPORTSWIRE/ – SFuels LLC, a leader in endurance sport nutrition is honored to announce that triathlon industry icon Bob Babbitt has joined the advisory board. As one of the sport’s most recognized figures, Bob will be instrumental in facilitating commercial growth plans, accelerating market awareness, and...

Business

Cycling

Press Releases

Running

Triathlon

Wire Syndication

September 20, 2022

Lake Sonoma Race Series Gets Bigger and Better for 2023, Adding Prize Money, New Women-Only Half Marathon and Fall Races

/ENDURANCE SPORTSWIRE/ – The Lake Sonoma Race series returns in 2023 bigger and better than ever with enhanced offerings designed to enliven the runner experience, heighten the spectacular feeling of community inherent in trail running and drive inclusiveness and diversity. The Lake Sonoma 50 Mile (LS50) and Marathon returns to its...

Events

Press Releases

Running

September 20, 2022

Stages SB20 Smart Bike Lowest Price Ever

(Boulder, CO – 20 September, 2022)/ENDURANCE SPORTSWIRE/ – The Stages SB20 Smart Bike will be on sale for $1999 from September 22 through October 3, providing customers with the best price ever on the leading smart bike from Stages Cycling. The SB20 Smart Bike is nearly silent and connects with all...

Cycling

Press Releases

Products

September 20, 2022

Master Spas adds pro triathlete Ben Kanute to roster of brand ambassadors

FORT WAYNE, Ind. — SEPTEMBER 20, 2022 /ENDURANCE SPORTSWIRE/ – Master Spas, the world's largest swim spa manufacturer, is excited to announce a partnership with professional triathlete Ben Kanute. “We could not be more excited to announce Ben as the newest addition to Team Master Spas,” says Kevin Richards, Vice President of Sales...

Press Releases

Sponsorship

Triathlon

September 20, 2022

The 2023 Belgian Waffle Ride Events Schedule Announced

San Diego, CA - September 20, 2022 /ENDURANCE SPORTSWIRE/ – Monuments of Cycling (MoC), a premier cycling events producer best known for its iconic Monument of Gravel, the Belgian Waffle Ride (BWR), has announced its burgeoning BWR calendar for the first half of 2023 with a North American expansion into Canada,...

Cycling

Events

Press Releases

September 19, 2022

Life Time Foundation Commits to ‘Get Kids Moving’ with more than $600,000 in Grants to Nineteen Youth Organizations Across the Nation

Chanhassen, Minn., (Sept. 19, 2022) /ENDURANCE SPORTSWIRE/ – Life Time Foundation, the 501(c)(3) charitable arm of Life Time (NYSE: LTH), announces nineteen grant recipients from its Get Kids Moving initiative, a new program launched in November 2021 to spark exercise and healthy movement in nation’s youth. The program complements the Life Time...

Giving

Press Releases