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

September 8, 2023

The IRONMAN Foundation Announces Service Project and Community Giveback for 2023 VinFast IRONMAN World Championship

NICE, France (September 8, 2023)/ENDURANCE SPORTSWIRE/ – The IRONMAN Foundation, Inc., a non-profit organization aiming to create positive, tangible change in race communities through grants and volunteerism efforts, has continued its philanthropic efforts at the men’s edition of the 2023 VinFast IRONMAN® World Championship triathlon taking place in Nice, France on...

Giving

Press Releases

Triathlon

September 8, 2023

The Boston Run Show is shortlisted for the 2023 TSNN Innovation Awards

/ENDURANCE SPORTSWIRE/ – Raccoon Media Group has been shortlisted for this year’s Trade Show News Network (TSNN) Innovation Awards. The Boston Run Show has been recognized and is shortlisted as a finalist for the Consumer Shows category. The awards program will celebrate and honor the “Best of Innovation” – shows...

Awards

Press Releases

Running

Trade Shows

September 8, 2023

MYLAPS welcomes John Hovius

HAARLEM (September, 2023) /ENDURANCE SPORTSWIRE/ – MYLAPS Sports Technology is pleased to announce that John Hovius joined the company on 1 September. John will be part of the MYLAPS team to add knowledge and help us to continually raise the level of our timing and online services for sports events. Next...

Business

Press Releases

September 8, 2023

LOGE Camps Teams Up with Specialized Bikes to Deliver the Ultimate Two-Wheel Hotel Perk

8 September 2023 (NORTH BEND, WASHINGTON)/ENDURANCE SPORTSWIRE/ – LOGE Camps, the hotel that gets you outdoors, officially announced a partnership with Specialized Bicycles to bring a line of its Mountain, Kids, and Comfort bikes to all LOGE properties. Specialized joins other brands like Yeti, Rumpl, Biolite, and Traeger Grills as part...

Business

Cycling

Press Releases

September 8, 2023

OutThere USA Partners with Adventure Racing World Series

/ENDURANCE SPORTSWIRE/ – A backpack is a fundamental piece of equipment in Adventure Racing. It carries a variety of gear for sections of the race, from climbing harnesses and carabiners to mountain bike spares and crampons. Together with cold-weather gear, personal care, foot care and first aid kits, bivvy bags,...

Business

Cycling

Press Releases

Products

Running

September 8, 2023

6,000 Runners Ready to Race at 2023 Volvo Santa Monica Classic

SANTA MONICA, CA – September 08, 2023 /ENDURANCE SPORTSWIRE/ – The stage is set, registration is sold-out and an exhilarating day of running and breathtaking views are in store for more than 6,000 runners as the Volvo Santa Monica Classic presented by ASICS returns this Sunday, September 10. Featuring three distances...

Events

Press Releases

Running

September 7, 2023

B.A.A. Announces Expanded Para Athletics Divisions & Enhanced Prize Money Awards for 2024 Events

BOSTON /ENDURANCE SPORTSWIRE/ – The Boston Athletic Association (B.A.A.) today announced plans for an enhanced prize money structure across B.A.A. events in 2024, as well as the introduction of two new Para Athletics Divisions for athletes competing with coordination impairments (T35-T38) and intellectual impairments (T20) as well as more inclusive upper...

Events

Press Releases

Running

September 7, 2023

Island Optics Offers a New Perspective on Superior Polarized Sunglasses

Boca Raton, FL, USA, September 7, 2023/ENDURANCE SPORTSWIRE/ - Island Optics, a new sunglass company from a family steeped in the tradition of quality optical craftsmanship since 1922, is excited to announce its bold venture into the world of high-quality polarized sunglasses. With a commitment to excellence spanning over five...

Press Releases

Products

September 7, 2023

Do you own a road bike? Come and try the 2023 Cycling Time Trials Road Bike Championships

/ENDURANCE SPORTSWIRE/ – The team at Cycling Time Trials (CTT) are excited to share that FTP Racing (Fulfill The Potential) will be hosting the 2023 edition of their Road Bike Championships; an inclusive event which welcomes all cyclists to take part - all you need is a road bike, helmet,...

Cycling

Events

Press Releases