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

June 18, 2023

Stunning Wins from Stępniak and Reischmann at Lotto Challenge Gdańsk

/ENDURANCE SPORTSWIRE/ - In a stunning day’s racing that saw fierce and close battles for the podium in both the men’s and women’s races, Kacper Stępniak (POL) and Anne Reischmann (GER) ultimately took top honours at Lotto Challenge Gdańsk in 3:44:25 and 4:12:58. Menno Koolhaas (NED) started his bid for...

Events

Press Releases

Triathlon

June 18, 2023

Loanne Duvoisin, Arthur Forissier win XTERRA Switzerland

/ENDURANCE SPORTSWIRE/ - Loanne Duvoisin (SUI) and Arthur Forissier (FRA) won the XTERRA Switzerland off-road triathlon elite races in Lac des Taillères on Saturday, June 17, 2023, with winning times of 2:47:25 and 2:19:42, respectively. It’s the third big full-distance XTERRA win for Duvoisin, her second in as many weeks...

Events

Press Releases

Triathlon

June 17, 2023

Tierra Indomita in Chile is a new Adventure Racing World Series Race for 2024

/ENDURANCE SPORTSWIRE/ - The Tierra Indomita Adventure Race, set in the stunning Cordillera de Fuego of the Chilean Andes is a new addition to the Adventure Racing World Series next year! Prepare your senses for an unparalleled experience in one of the most beautiful and wild landscapes on the planet....

Events

Press Releases

June 17, 2023

The Temiscamingue International Raid Joins the Adventure Racing World Series

/ENDURANCE SPORTSWIRE/ - The Temiscamingue International Endurance Aventure Raid in Quebec is the first stage race to join the Adventure Racing World Series. The race will take place from September 8-10th in the magnificent territory of the Anishinaabe Nation, and the location is a paradise for outdoor enthusiasts and lovers...

Events

Press Releases

June 16, 2023

FRESHJUNKIE Racing Introduces Groundbreaking Profit-Sharing Plan for Employees and Contract Staff

Baton Rouge, LA /ENDURANCE SPORTSWIRE/ - FRESHJUNKIE Racing, a leading event production company known for its exceptional race experiences, is proud to announce its revolutionary profit-sharing plan designed to include employees and event contract staff. This innovative approach aims to enhance employee incentives, foster team retention, and solidify FRESHJUNKIE Racing's...

Business

Events

Press Releases

Running

June 15, 2023

Lake Sonoma Race Series Proves Elite Performance, Community and Diversity can Co-Exist on the Trails

/ENDURANCE SPORTSWIRE/ – This year’s 50-Mile event boasted a record high participation rate for female runners, with a forty percent uptick from previous years. The race also raised thousands of dollars for local vineyard workers children scholarships – all while serving as the selection race for the USATF World Mountain Running...

Events

Press Releases

Running

June 15, 2023

Super League Triathlon Announce Fifth Anniversary Championship Series With Star Athlete Line-Ups

/ENDURANCE SPORTSWIRE/ – Super League Triathlon (SLT) has unveiled the dates of its fifth anniversary Championship Series and the first superstar athletes who will deliver the fastest racing on the planet. Super League has revolutionised triathlon with its unpredictable formats and innovations, exciting courses, Teams format and action-packed broadcasts that were...

Events

Press Releases

Triathlon

June 15, 2023

Annual Crown City Classic 4th of July Run Celebrates 50 Years Running

/ENDURANCE SPORTSWIRE/ - Celebrating its 50th year running, Coronado's annual 4th of July run returns with a remarkable display of consistency. The beloved event, renowned as one of the finest 4th of July running events in the country, invites runners of all ages and abilities to participate in a variety...

Awards

Events

Press Releases

Running