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

March 21, 2023

H2O Audio Releases PLAYLIST+™, Groundbreaking Audio Technology Never-Seen-Before in Headphones, PRO Series Products, and a New App

SAN DIEGO, March 21, 2023 /ENDURANCE SPORTSWIRE/ - H2O Audio, a 20-year pioneer in developing superior waterproof audio products, is proud to debut its latest innovation. PLAYLIST+™ is groundbreaking technology that loads and stores content from any popular streaming app into the memory of headphones for offline play back later...

Press Releases

Products

Running

Triathlon

March 21, 2023

Tim and Rinny Launch Coaching Business Leveraging TriDot

DALLAS, TX – March 21, 2023 /ENDURANCE SPORTSWIRE/ - Mirinda (“Rinny”) Carfrae and Tim O’Donnell announced the launch of their coaching business that will leverage TriDot’s Optimized Triathlon Training®, technology driven by data and artificial intelligence. Their coaching business will focus on triathlon enhancing the lives of athletes through proper life...

Business

Press Releases

Products

Triathlon

March 20, 2023

Pirelli Presents The New P ZERO Race TLR, The Fastest Tubeless Tire of The Road Bike Range

Milan, Italy, 20th March 2023 /ENDURANCE SPORTSWIRE/ – Pirelli is launching its new P ZERO Race TLR, the tubeless version of its clincher tire for road bikes. This product has been redesigned with new technologies and is manufactured in the modernized and innovative Pirelli plant in Milan-Bollate. The new tubeless ready...

Cycling

Press Releases

Products

Triathlon

March 20, 2023

Wattbike appoint Greg Nieuwenhuys as Chairman

March 2023 /ENDURANCE SPORTSWIRE/ – Wattbike, leaders in indoor cycling, announces the appointment of Greg Nieuwenhuys as Chairman to help drive the brand’s next phase of growth, effective immediately. An experienced CEO and non-executive Director, Nieuwenhuys is currently Chairman of Mammut Sports Group, a leading Swiss mountain brand, and was previously CEO...

Business

Cycling

Press Releases

March 20, 2023

New Event: Museum Mile set for May 2023

WRIGHT- PATTERSON AIR FORCE BASE, Ohio /ENDURANCE SPORTSWIRE/ – Registration for the inaugural Museum Mile, honoring the National Museum of the U.S. Air Force’s 100th anniversary, is now open. Powered by the Air Force Marathon, this 1-mile, family-friendly event will take place May 11 at the museum and showcase three races:...

Events

Press Releases

Running

March 20, 2023

Adventure Racing World Series North America Calendar Announced

/ENDURANCE SPORTSWIRE/ – The inaugural year of Adventure Racing World Series - North America circuit officially gets underway this weekend with the Extreme Break Up Adventure Race in Manhattan, Kansas, U.S.A. on Saturday, March 18th. The ARWS North America calendar is a collection of the best mid-distance adventure races across the...

Events

Press Releases

March 20, 2023

Brits dominate in Chile: Tom Bishop and Lucy Byram win Bci Challenge Puerto Varas

/ENDURANCE SPORTSWIRE/ - Brits Tom Bishop and Lucy Byram have taken victories at Bci Challenge Puerto Varas in 03:45:01 and 04:15:52 respectively, both beating the course records set at last year’s inaugural event. After the swim in Lago Llanquihue, Bishop was second best in the water, behind local Vicente Trewhela...

Events

Press Releases

Triathlon

March 19, 2023

20,000 Shamrock Participants took to the streets at The Virginia Beach Oceanfront for The 51st Annual Shamrock Marathon.

MARCH 19, 2023 – VIRGINIA BEACH, VIRGINIA /ENDURANCE SPORTSWIRE/ – The Yuengling Shamrock Marathon Weekend finished its 51st year Sunday with the half marathon and full marathon. Runners from all 50 states and 11 countries toed the line together and took to the streets of Virginia Beach with the same goal…cross...

Events

Press Releases

Running

March 17, 2023

Maxim Chane, Marta Menditto win XTERRA Oman

/ENDURANCE SPORTSWIRE/ - Maxim Chane from France and Marta Menditto from Italy won the inaugural XTERRA Oman off-road triathlon on a hot and sunny day at the Khasab Fort in Oman’s Musandam Governorate on Saturday, March 18, 2023. It’s the fifth career XTERRA World Tour win for Chane, and the...

Events

Press Releases

Triathlon

March 17, 2023

IRONMAN Athletes’ Choice Awards Announced for IRONMAN and IRONMAN 70.3 Triathlons around the Globe

TAMPA, Fla. (March 17, 2023) /ENDURANCE SPORTSWIRE/ – IRONMAN today announced the global results for the IRONMAN® and IRONMAN® 70.3® Athletes’ Choice Awards, highlighting the highest-scoring events in a variety of categories based on athlete surveys from all the 2022 IRONMAN® and IRONMAN 70.3® races from around the world. Out of...

Events

Press Releases

Triathlon