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

July 26, 2023

Huairasinchi Celebrates 20 years of Adventure Racing in Ecuador

/ENDURANCE SPORTSWIRE/ – The 2023 Huairasinchi adventure race is a significant milestone for the team at Proyecto Aventura, who organize the Adventure Racing World Series event in Ecuador. This year’s race will be the 20th edition of one of the oldest and most respected events in the world adventure racing...

Cycling

Events

Press Releases

Running

July 25, 2023

The ITERA-lite Adventure Race Will Explore the Scottish Borders

/ENDURANCE SPORTSWIRE/ – The inaugural ITERA-lite Adventure Race, staged by Durty Events, will see competitors arriving in Selkirk in the Scottish Borders from all around the UK, France, The Netherlands, Sweden, New Zealand and Ireland. They will gather at Selkirk Rugby Club on Thursday and Friday, and the 345km race...

Cycling

Events

Press Releases

Running

July 25, 2023

Athletes to Watch at 24th Moloka‘i-2-O‘ahu Paddleboard World Championships

HONOLULU, HI /ENDURANCE SPORTSWIRE/ – After a three-year hiatus due to the pandemic, the 24th edition of the Moloka‘i-2-O‘ahu Paddleboard World Championships (M2O), presented by the Hawai‘i Tourism Authority through the Signature Events Program returns to the Ka‘iwi Channel with a sold-out international field on Sunday, July 30, 2023. Only 250...

Events

Press Releases

July 24, 2023

Squirt Cycling Products Partners with Adventure Racing World Series

/ENDURANCE SPORTSWIRE/ -The primary disciplines of the sport of Adventure Racing include trekking, mountain biking and paddling with map-and-compass navigation to bring them all together. It is in this environment that Squirt Cycling Products are well suited, making them a perfect partner for the Adventure Racing World Series (ARWS). Squirt’s...

Business

Cycling

Events

Press Releases

Products

Sponsorship

July 24, 2023

Competitors Battle Early Rain and Mud to Break Course Records at 8-Hour Dream Endurance Race

CARMEL, Ind. (July 24, 2023) /ENDURANCE SPORTSWIRE/ - The ninth annual 8-Hour Dream Endurance Race started with rain sprinkles but ended with sunshine and new course records on Saturday, July 15 in Indianapolis. The unique ultra distance event, created and managed by CRRG Events, is the largest endurance running event...

Events

Press Releases

Running