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

February 10, 2023

Best Women’s Field in European Triathlon History at Roth

ROTH /ENDURANCE SPORTSWIRE/ – There has never been such a top field at a long distance race outside Hawaii. With Anne Haug, Daniela Ryf and the reigning Kona winner Chelsea Sodaro, three world champions and two Roth winners will fight for the title at DATEV Challenge Roth powered by hep 2023. Laura...

Events

Press Releases

Triathlon

February 10, 2023

RunSignup Releases 2022 Top 100 Largest Road Races

February 10. 2023 - (Moorestown, NJ) /ENDURANCE SPORTSWIRE/ - RunSignup, the leading registration and technology provider for races in the U.S., releases a list of the top 100 Largest Road Races in the United States. This report is compiled in an effort to build an improved understanding of the top...

Business

Events

Press Releases

Running

February 9, 2023

Rock ‘N’ Roll Running Series to Celebrate 25 Years of Bringing Fun to The Run During 2023 Season

TAMPA, Fla. (Feb. 9, 2023) /ENDURANCE SPORTSWIRE/ - In 1998, the Rock ‘n’ Roll® Running Series was born on an idea of bringing music, running and community together as nearly 20,000 participants took to the start line of the first Rock ‘n’ Roll Running Series event in San Diego, California....

Events

Press Releases

Running

February 9, 2023

Sportive Breaks announce launch of gravel cycling portfolio

9th February 2023 - Manchester UK /ENDURANCE SPORTSWIRE/ – Sports travel experts Sportive Breaks offer bespoke premium travel packages for cyclists looking to take part in Europe’s most prestigious cycling events, cycling breaks and weekenders. Whether you are looking for your next big endurance challenge or simply some time away cycling with...

Business

Cycling

Events

Press Releases

February 9, 2023

The Outdoorist Oath Celebrates One Year and Exceptional Community Growth

(Feb 8, 2023) /ENDURANCE SPORTSWIRE/ - The Outdoorist Oath (The Oath), an organization designed to educate and unite outdoor communities with a shared commitment to take action for planet, inclusion and adventure, is proud to announce its one year anniversary, and upcoming first workshop of 2023. The Oath is directed...

Business

Events

Giving

Press Releases

February 9, 2023

Inaugural GFNY Kuala Lumpur this Sunday

/ENDURANCE SPORTSWIRE/ -This Sunday, GFNY Kuala Lumpur offers racers a 135.6 km long course which will take riders from the heart of the city, into the hilly outskirts and back to Merdeka Plaza for a total of 1531m of climbing. The finish line will be at the iconic Sultan Abdul...

Cycling

Events

Press Releases

February 9, 2023

Carmel Marathon Welcomes Purdue University Staff and Employees in 2023 as a New Event Partner

CARMEL, Ind. (February 9, 2023) /ENDURANCE SPORTSWIRE/ - Spectators and fellow race participants can expect to see more gold and black at the start line of the 2023 Carmel Marathon Weekend thanks to a new partnership with Purdue University’s Healthy Boiler Wellness Program. Employees and their family members will receive...

Events

Press Releases

Running

February 8, 2023

45 Years of IRONMAN; Iconic Triathlon Brand to Celebrate with a Global Sweepstakes

TAMPA, Fla. (Feb. 8, 2023) /ENDURANCE SPORTSWIRE/ – On Saturday, February 18, IRONMAN® will celebrate the 45th anniversary of its very first triathlon event, which took place on the Island of O’ahu, Hawai`i in 1978. In celebration of this milestone anniversary, IRONMAN will be randomly selecting 45 daily prize winners over...

Events

Press Releases

Triathlon

February 8, 2023

Aros and Otero win GFNY Puerto Rico

New York City, February 8, 2023 /ENDURANCE SPORTSWIRE/ – San Juan, Puerto Rico hosted the second edition of GFNY Puerto Rico this past Sunday over 133.1 km with 1550m of climbing. Under clear skies with perfect temperatures, Team 305ycle (Miami) were the first to make a move with two of their...

Cycling

Events

Press Releases