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

May 27, 2022

California Coast 500 presented by REI Summer Mileage Challenge Returns in Support of Eat. Learn. Play.

San Francisco, Calif. (May 27, 2022) /ENDURANCE SPORTSWIRE/ - Returning for its third year, Bay Area-based event production company Run Local® is welcoming participants from around the world for another edition of the fan favorite California summer mileage challenge – the California Coast 500 presented by REI. From Memorial Day,...

Cycling

Events

Press Releases

Running

May 26, 2022

Sub7 & Sub8 athletes announce the final pacemakers to their teams

Sydney, Australia 26 June 2022 /ENDURANCE SPORTSWIRE/ - The Pho3nix Foundation today revealed the remaining pacemakers selected by Alistair Brownlee, Kristian Blummenfelt, Nicola Spirig, and Kat Matthews for the Pho3nix Sub7 and Sub8 Project, Powered by Zwift. To break the seven-hour and eight-hour mark over the full distance of triathlon,...

Events

Press Releases

Triathlon

May 26, 2022

Adventure Race Croatia – A Remarkable Race For Every Team

Adventure Race Croatia is one of the most popular races in the Adventure Racing World Series, and this year welcomed 48 teams, with racers from 5 continents, including past winners and the current World Champion team. The race took place in the Gorski Kotar and Kvarner regions, on a 590km course,...

Events

Press Releases

May 26, 2022

New Event Record Set at the 2022 Denver Colfax Marathon

Denver, CO – A new event record was set at the 2022 Denver Colfax Marathon. 35-year-old Tyler McCandless of Fort Collins, CO, ran the high-altitude marathon in 2:21:07, breaking the previous marathon course record by three minutes. McCandless recently came in 4th at the Los Angeles Marathon and has qualified...

Awards

Events

Press Releases

Running

May 26, 2022

Olympians and World Champions Lead Field of Professional Triathletes Set to Compete in 2022 Escape from Alcatraz Triathlon

SAN FRANCISCO – (May 26, 2022) /ENDURANCE SPORTSWIRE/ - IMG, a global leader in sports, events, media and fashion, today announced the pro field for the 41st Escape from Alcatraz Triathlon, set to take place June 5, in San Francisco. The line-up includes Olympian Ben Kanute (USA), 2016 IRONMAN World...

Events

Press Releases

Triathlon