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

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 11, 2023

Showcased

Applications Now Open for 2023 KINeSYS Brand Ambassador Program

11th February 2023 /ENDURANCE SPORTSWIRE/ – Applications for the 2023 KINeSYS brand ambassador program are now open. After another well-received campaign in 2022, leading sun protection brand, KINeSYS Sunscreen, is accepting nominations for its 2023 Ambassador Program, known as KINeSYS Champions. The program will feature a select group of loyal KINeSYS fans...

Press Releases

Sponsorship

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

EIGHT Beer and Austin Marathon Brew Up Partnership

AUSTIN, Texas, February, 2023 /ENDURANCE SPORTSWIRE/ – The Ascension Seton Austin Marathon, Half Marathon and 5k and EIGHT Beer have signed a partnership agreement making it the Official Beer of the event. This inaugural agreement means that EIGHT will feature its low-calorie, low-carb light lager at the finish line festival’s beer...

Press Releases

Running

Sponsorship