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

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

September 13, 2022

Bank of America Chicago Marathon will host the 2023 AbbottWMM Wanda Age Group World Championships

13 SEPTEMBER 2022, CHICAGO, USA /ENDURANCE SPORTSWIRE/- The 2023 AbbottWMM Wanda Age Group World Championships is heading to North America and will be held as part of the 2023 Bank of America Chicago Marathon. After two consecutive Championships in London, the Chicago Marathon will welcome a larger field size of...

Events

Press Releases

Running

September 12, 2022

The McCourt Foundation Welcomes 6,000 Runners to Santa Monica

SANTA MONICA – September 11, 2022 /ENDURANCE SPORTSWIRE/ - The 6,000 runners and walkers who stepped to the starting line for the 17th running of the Santa Monica Classic presented by ASICS were treated to the quintessential Southern California vibe: palm trees swaying, waves crashing, the Ferris wheel and party...

Events

Press Releases

Running

September 12, 2022

Arthritis Foundation President and CEO Steven Taylor Rides Out with 22nd Annual California Coast Classic Presented by Amgen

SAN FRANCISCO – September 12, 2022 /ENDURANCE SPORTSWIRE/ - Arthritis Foundation President and Chief Executive Officer Steven Taylor joined riders of The California Coast Classic + Arthritis Challenge Experience presented by Amgen as it rolled out from Fisherman’s Wharf last Saturday. The ride is making its way down Highway 1...

Cycling

Events

Giving

Press Releases