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

July 27, 2023

The Legend Adventure Race Takes to the Great Ocean Road for 2024

/ENDURANCE SPORTSWIRE/ – The Legend expedition adventure race was launched by Wild&Co in February this year as part of the Adventure Racing World Series. In the first race teams crossed the Alpine mountains, forests and lakes of the Snowy Mountains of New South Wales. It was a spectacular 500km route...

Cycling

Events

Press Releases

Running

July 26, 2023

Rutgers University to Host Blind Soccer National Coaching Summit

New Brunswick, N.J. (July 26, 2023) /ENDURANCE SPORTSWIRE/ - In partnership with Reader’s Digest Partners for Sight Foundation, the U.S. Association for Blind Athletes (USABA) and Rutgers University Department of Kinesiology and Health and Center for Disability Sports, Health and Wellness, will host a blind soccer coaching summit for blind...

Events

Press Releases

July 26, 2023

ASICS Falmouth Road Race Renews Numbers for Nonprofits Partnership with Iconic Massachusetts Charities

FALMOUTH, Mass. /ENDURANCE SPORTSWIRE/ – As the ASICS Falmouth Road Race on Aug. 20 draws near, the Dana-Farber Cancer Institute and the Jimmy Fund has partnered with the event again to present the Numbers for Nonprofits Program (NFNP). This collaboration powers the fundraising efforts of more than 3500 runners who choose...

Events

Giving

Press Releases

Running

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