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

September 19, 2023

Challenge Sanremo celebrates international triathlon on the Italian Riviera

/ENDURANCE SPORTSWIRE/ – The celebration of sport that is Challenge Sanremo returns to the Italian Riviera this weekend, bringing together professional athletes, young people and amateurs on one of the circuit’s most spectacular but testing courses. With over 40 professional athletes on the start line, the spotlight is on Bart...

Events

Press Releases

Triathlon

September 19, 2023

Israman Joins Challenge Family Global Triathlon Series, Celebrates 25th Anniversary as Challenge Israman

/ENDURANCE SPORTSWIRE/ – Challenge Family is proud to announce Challenge Israman in its partnership with Israman in a ground-breaking move that marks a significant milestone in the event’s illustrious 25-year history. Since its inception in 1999, Israman has been synonymous with excellence, attracting athletes from all corners of the globe...

Events

Press Releases

Triathlon

September 19, 2023

Run Medford Partners with Kinomap to Expand Event Fundraising Reach

(Sept. 19, 2023) /ENDURANCE SPORTSWIRE/ - In an exciting addition to its second iteration, Run Medford is partnering with Kinomap for Races to film the Saturday, Sept. 23 five miler and bring the event to runners on treadmills or other cardio devices anywhere in the world. Not only will this...

Business

Events

Press Releases

September 19, 2023

Bike the Coast Returns for Another Year of Oceanfront Riding

San Diego, Calif. /ENDURANCE SPORTSWIRE/ – Bike the Coast, San Diego’s iconic oceanfront cycling event, will be returning for its annual ride on Nov. 4. The ride provides opportunities for participants of all levels to enjoy a memorable course that takes them along the scenic views and quaint communities along Highway...

Cycling

Events

Press Releases

September 19, 2023

One Month to go until the Adventure Racing World Championship in South Africa

/ENDURANCE SPORTSWIRE/ – With one month to go until the start of the 2023 Adventure Racing World Championship hosted by Expedition Africa, both the event organisers and the participating teams, volunteers and media are counting down the weeks and then days until they arrive at the Cape St. Francis Resort...

Cycling

Events

Press Releases

Running

September 18, 2023

USA Cycling Announces 2023 Gravel World Championships Team

September 18, 2023, COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ - The 2023 UCI Gravel World Championships are set to take place in Veneto, Italy on October 7-8, 2023. In the event’s second year, USA Cycling is sending a team with goals of a podium for the American racers. As part of the UCI’s...

Cycling

Events

Press Releases

September 18, 2023

A Record 1,574 Earned Their Wings at the 2023 FlyBy 5K and 2-Mile Fun Run/Walk at Pittsburgh International Airport

PITTSBURGH (Sept. 18, 2023) /ENDURANCE SPORTSWIRE/ – Perfect weather inspired a record number of 1,574 runners and walkers to race the runway and earn their wings at the 2023 FlyBy 5K and 2-Mile Fun Run/Walk presented by CNX Resources. This family-friendly race offered participants the rare opportunity to be up close...

Events

Giving

Press Releases

Running

September 18, 2023

Watch The 2023 XTERRA World Championship: The Biggest One Yet is Live From Trentino, Italy

/ENDURANCE SPORTSWIRE/ – A World Cup and World Championship Double-Feature Event In the heart of the Brenta Dolomites in Molveno, Italy, the stage is set for a showdown like no other. As XTERRA gears up for its 27th annual World Championship Off-Road Triathlon, the implications have never been higher, and...

Events

Press Releases

Triathlon

September 18, 2023

5th Annual Grand Canyon Trail Half Marathon Takes Place November 4, 2023

/ENDURANCE SPORTSWIRE/ - The Town of Tusayan and Run Tucson are pleased to announce that the 5th Annual Grand Canyon Trail Half Marathon and 5k will take place on November 4, 2023. With a loop course through the scenic Kaibab National Forest, the Trail Half Marathon will begin and end...

Events

Press Releases

Running