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

February 13, 2023

Big Weekend of Triathlon Ahead with Challenge Wānaka 2023

/ENDURANCE SORTSWIRE/ - A packed weekend of international triathlon is set to kick off the Challenge Family 2023 season in New Zealand this weekend with the longstanding Integrity Homes Challenge Wānaka, now in its 17th year. No less than 11 events will take place as part of the world’s most...

Events

Press Releases

Triathlon

February 13, 2023

Sea, Air & Space Challenge Announced for 2023 U.S. Military Races

WRIGHT-PATTERSON AFB, OH | February 13, 2023 /ENDURANCE SPORTSWIRE/ – In honor and celebration of the collaborative efforts of the branches of the U.S. Armed Forces, the 2023 Coast Guard Marathon, Air Force Marathon and Space Force T-Minus 10-Miler once again announce the first-of-its-kind, cross-race challenge for their 2023 events. Created...

Events

Press Releases

Running

February 12, 2023

Brazil Multisport Win the South American Adventure Racing Championship in Paraguay

/ENDURANCE SPORTSWIRE/ - Team Brazil Multisport defended their title as the Adventure Racing World Series South America champions at the 200km La Gesta race in Paraguay. The team, ranked #3 in the world, crossed the finish line in Hernandarias to win a hard fought race in which the lead changed...

Events

Press Releases

February 10, 2023

Space Force T-Minus 10-Miler Race Registration Opens May 4

CAPE CANAVERAL SPACE FORCE STATION, Fla. /ENDURANCE SPORTSWIRE/ – Registration for the second-annual United States Space Force T-Minus 10-Miler race, in-person and virtual events, starts May 4, 2023, at https://runspaceforce.com/. The second-annual United States Space Force T-Minus 10-Miler will feature the XSM-64 Navaho rocket. The Navaho missile was built as a...

Events

Press Releases

Running

February 10, 2023

Run Catalina Reveals Finisher Medals For 2023 Catalina Island Marathon

AVALON, Calif. /ENDURANCE SPORTSWIRE/ - The 2023 Hi-Tec Run Catalina series has revealed the finisher awards that await runners of the Catalina Island Marathon, which will take place on Mar. 11. The 26.2-mile trail race is California’s oldest trail marathon and will celebrate its 46th anniversary this year. Registration is...

Events

Press Releases

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