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

May 31, 2022

Showcased

Andrea Peet Becomes First Person Diagnosed With ALS To Finish 50 Marathons in 50 States

PRINCE OF WALES, Alaska /ENDURANCE SPORTSWIRE/ -  Andrea Peet has become the first person diagnosed with ALS to finish 50 marathons in 50 states, following her completion of the ​​Prince of Wales Island Marathon on Saturday. Peet’s journey began in 2016 at the Shamrock Marathon in Virginia Beach, Va., though...

Events

Giving

Press Releases

Running

May 29, 2022

Quinn Simmons and Kira Payer win Iron Horse Bicycle Classic Coca Cola Road Race

Durango, Colo. (May 29, 2022) /ENDURANCE SPORTSWIRE / - Quinn Simmons and Kira Payer won the Iron Horse Bicycle Classic Coca Cola Road Race this morning in Silverton. The road race and non-competitive, gran fondo-style McDonalds Citizen’s Tour saw 2,200 riders in total across all age group categories, with the...

Cycling

Events

Press Releases

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