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

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

September 12, 2022

New XTERRA Trail Run World Series Set to Launch in 2023

September 12, 2022 /ENDURANCE SPORTSWIRE/ – XTERRA is introducing an all-inclusive Trail Run World Series featuring more than 30 events across 20 countries on five continents in 2023. The new series unifies XTERRA Trail Runs worldwide, awards points to all runners at each race, and has its own custom-built global ranking...

Events

Press Releases

Running

September 12, 2022

Oiselle and Run4AllWomen Host 3rd Annual “Women Run the Vote” Virtual Relay

VIRTUAL /ENDURANCE SPORTSWIRE/ – In the lead up to the 2022 Midterm Elections, Oiselle and Run4AllWomen are teaming up to host the third annual “Women Run the Vote” Virtual Relay. Organizers and runners are driving registration now ahead of the virtual event in the Fall. “Running can be a political act,” said...

Events

Giving

Press Releases

Running

September 12, 2022

IRONMAN Returns to Belgium with the Inaugural IRONMAN 70.3 Knokke-Heist Triathlon Event

KNOKKE-HEIST, Belgium / LONDON, UK / TAMPA, Fla. (September 12, 2022) /ENDURANCE SPORTSWIRE/ –IRONMAN has announced the return to Belgium in 2023 with IRONMAN® 70.3® Knokke-Heist, Belgium set to take place on September 17, 2023. The inaugural IRONMAN 70.3 Knokke-Heist, Belgium will mark the return of the brand to Belgium for...

Events

Press Releases

Triathlon

September 12, 2022

Paraguay Prepares to Host the 18th Adventure Racing World Championship

/ENDURANCE SPORTSWIRE/ - The 18th Adventure Racing World Championship begins in Paraguay on Saturday, September 17th, and teams from around the world will be arriving in the capital city of Asunción in the coming days. The race will be hosted by Expedición Guaraní, which has been a member of the...

Events

Press Releases