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

September 28, 2023

Showcased

The La Valette Marathon: Running History Alongside the Mediterranean Waves

/ENDURANCE SPORTSWIRE/ – Calling all runners, athletes, and running enthusiasts! Get ready to embark on an epic journey through 7000 years of history while enjoying the stunning Mediterranean coastline. The highly-anticipated third edition of the La Valette Marathon, a full or half marathon event, is set to take place on...

Events

Press Releases

Running

September 28, 2023

Super Sunday: two flat and fast GFNY races on same day

/ENDURANCE SPORTSWIRE/ - The inaugural edition of GFNY Cambridge Maryland starts in the heart of Cambridge downtown and offers racers a 92.4 mile long course with 481 ft of climbing, making it the flattest and likely fastest race of the GFNY circuit. It’s Maryland’s first ever mass participation cycling race....

Cycling

Events

Press Releases

September 27, 2023

Diplo, Chace Crawford, Trixie Mattel & More to Participate In Malibu Triathlon to Raise Funds for Children’s Hospital Los Angeles

MALIBU, Calif. – Sept. 27, 2023/ENDURANCE SPORTSWIRE/ – The Malibu Triathlon, presented by Super League Triathlon, announced the star-studded lineup for its Celebrity Division race that will take place on Sunday, Oct. 1 at Zuma Beach. Diplo, Chace Crawford, Trixie Mattel, Daniela Ruah, Jesse Metcalfe, Timothy Olyphant, Ben Higgins, ChefRush and more...

Events

Giving

Press Releases

Triathlon

September 27, 2023

Maine Marathon Partners with Kinomap, Highlighting Beautiful Fall Half Marathon Course and Fundraising Opportunities

PORTLAND, Maine (Sept. 27, 2023) /ENDURANCE SPORTSWIRE/ – Kinomap for Races continues its filming tour of standout North American events with the 2023 Gorham Savings Bank Maine Half Marathon this weekend. The Maine Marathon is not only a great local race but supports important fundraising causes. Kinomap is excited to help...

Events

Giving

Press Releases

Running

Wire Syndication

September 27, 2023

Annual Cycling Event in California Raises Over $1 Million to Fight Arthritis, Impacting Nearly 60 Million Adults and Hundreds of Thousands of Children in the U.S.

LOS ANGELES – September 27, 2023/ENDURANCE SPORTSWIRE/ – The 23rd annual California Coast Classic Bike Tour presented by Amgen, kicks off this coming Saturday in San Francisco en route to Los Angeles. Two hundred cyclists will embark on the eight-day, 525-mile tour while raising funds and awareness for the Arthritis Foundation...

Cycling

Events

Giving

Press Releases

September 27, 2023

Women’s Professional Athlete Field Announced for VinFast IRONMAN World Championship in Kailua-Kona, Hawai`I

- For the first time in the 40-plus year history of triathlon’s pinnacle event, professional and age group women will have their own edition of the VinFast IRONMAN World Championship triathlon in Kailua-Kona, Hawai`i on October 14 - Defending IRONMAN World Champion Chelsea Sodaro (USA) headlines the field in a...

Events

Press Releases

Triathlon

September 27, 2023

12th Annual Kerrville Triathlon Festival Sets New Records

AUSTIN, Texas, September 27, 2023 /ENDURANCE SPORTSWIRE/ – The Kerrville Triathlon Festival marked its 12th year this past weekend on September 23-24, 2023. A record setting 2,100 triathletes from 27 states, an all-time high for the event, flocked to the scenic backdrop of Kerrville, Texas. As with previous years, the breathtaking...

Events

Press Releases

Triathlon

September 27, 2023

Sprint finish at GFNY Chile

New York City, September 27, 2023 /ENDURANCE SPORTSWIRE/ - Viña Veramonte hosted the 5th edition of GFNY Chile this past Sunday. The race course was 127.9km long with 1832m of climbing. The race started off fast and right from the beginning at km 6, Eyair Astudillo (Chile) took the lead....

Cycling

Events

Press Releases

September 26, 2023

Georgia Multisports announces new half and international triathlon in Kentucky

Lawrenceburg, Kentucky – September 26 /ENDURANCE SPORTSWIRE/ - Georgia Multisports announced that Lawrenceburg, Anderson County will be home to a new, challenging half and international distance triathlon September 21, 2024. The race consists of a swim, bike and run and will span three counties in Central Kentucky, although most of...

Events

Press Releases

Triathlon