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

September 15, 2022

ROUVY: La Vuelta Virtual ‘22 Summary – 7K riders worldwide, a winner from Belgium and 5K Euro for inclusive cycling

Madrid, Spain / September 15th, 2022 /ENDURANCE SPORTSWIRE/ – La Vuelta Virtual on ROUVY, last weekend, had a magnificent wrap up in Madrid. Everyone witnessed the amazing story of Ward Simons who became the first winner of La Vuelta Virtual ‘22 at the in-person Grand Final. The pharmacist from Belgium managed...

Cycling

Events

Press Releases

September 14, 2022

IRONMAN 70.3 Perú returns to Lima, Peru for 2023

Lima, Perú (September 14, 2022)/ENDURANCE SPORTSWIRE/ – IRONMAN announced today that IRONMAN® 70.3® Perú triathlon will return to Lima, Perú for the first time since 2019. The fourth edition of IRONMAN 70.3 Perú triathlon is scheduled to take place on Sunday, April 23, 2023. Registration for the event opens on Thursday,...

Events

Press Releases

Triathlon

September 14, 2022

Gran Fondo Maryland Announced as USA Cycling Gran Fondo National Championship for 2023

Gettysburg, PA – September 14, 2022)/ENDURANCE SPORTSWIRE/ – Gran Fondo National Series is proud to announce that the 2023 USA Cycling Gran Fondo National Championships will be held in conjunction with Gran Fondo Maryland. The date for the Championships in Frederick, Maryland, will be September 17, 2023. Gran Fondo National Series...

Cycling

Events

Press Releases

September 14, 2022

Athletic Brewing Company Announces Return of Oktoberfest

MILFORD, Conn. and SAN DIEGO (September 14, 2022)/ENDURANCE SPORTSWIRE/ – Athletic Brewing Company, the leading non-alcoholic craft brewer in the U.S., today announced the return of its beloved Oktoberfest Non-Alcoholic Festbier for a fourth year. As the seasons change and fall festivities return, Athletic Oktoberfest pairs perfectly with all of your...

Events

Press Releases

Products

September 13, 2022

Challenge Family continues with virtual racing – The digital twin of the Italian Sanremo is set for Sep 15th, one week before the actual race

Almere, Netherlands / September 13th, 2022 /ENDURANCE SPORTSWIRE/ - Challenge Family and ROUVY continue to digitize the best triathlon locations around the world. Now with the Challenge Almere behind, the next stop is the middle-distance triathlon in the Ligurian region. The international tri community and Sanremo participants are set to...

Events

Press Releases

Triathlon

September 13, 2022

The Ride For Mental Health Surpasses Million-Dollar Mark, Opens Registration For 2023

NEW YORK and BOSTON /ENDURANC SPORTSWIRE/ - In 2017, when New York City attorney and avid cyclist Mac Dorris founded the Ride for Mental Health in New Paltz, N.Y., it was a way to find hope, healing and purpose after the sudden and tragic loss of his son, Eric. At...

Cycling

Events

Giving

Press Releases

September 13, 2022

INEOS Grenadiers Rider Cameron Wurf To Compete At Super League Triathlon Malibu

/ENDURANCE SPORTSWIRE/ – Wurf, the Australian pro cyclist who has also reached the pinnacle of long distance triathlon winning Ironman events and qualifying for the World Championships in Kona, Hawaii, will be taking on the kings of short course on the shores of Zuma Beach. The 39-year-old will go head-to-head with...

Events

Press Releases

Triathlon

September 13, 2022

GFNY expands in Asia with Krabi Thailand

/ENDURANCE SPORTSWIRE/ – GFNY Global Endurance Sports Series adds GFNY Krabi, scheduled for February 26, 2023. The competitive long distance is 135.4km long with 2115m of climbing. Start and finish will be hosted directly aside Krabi´s most famous, central and prominent beach: Ao Nang. “GFNY’s expansion in Asia had been paused...

Cycling

Events

Press Releases

September 13, 2022

Swim for Alligator Lighthouse a Huge Success

Saint Augustine Beach, Florida /ENDURANCE SPORTSWIRE/ - Once again the island of Islamorada in the Florida Keys played host to the Annual Swim for Alligator Lighthouse on September 10, 2022, the fourth stop on the Speedo SALT Series. 450 athletes from thirty-six (36) States and three (3) countries took part...

Events

Press Releases