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

March 4, 2022

Shamrock Run Portland Returns for 44th year

PORTLAND, Ore. – March 4, 2022 /ENDURANCE SPORTSWIRE/ - For those who love lacing up their running shoes and pounding the pavement, imagine Beantown minus the Boston Marathon. Think of the Big Apple missing the New York City Marathon. For two years, that’s what it’s been like for the Portland...

Events

Press Releases

Running

March 4, 2022

US Trail Running Conference Webinar Offers Guidelines to Increase Diversity for Trail Races

Estes Park, CO /ENDURANCE SPORTSWIRE/ - The second webinar in a seven-webinar series produced by the US Trail Running Conference and presented by Marathon Printing, the leading producer of custom printed items for endurance sports, was live on Thursday, February 24. The session subject for was: Diversity and Inclusion, focused on...

Events

Press Releases

Running

March 3, 2022

Showcased

Tucson Bicycle Classic THIS WEEKEND Brings Pro Teams, Novices Together for 3-Day Stage Race

March 3, 2022, Tucson, AZ /ENDURANCE SPORTSWIRE/ - The Tucson Bicycle Classic is excited to bring pro and novice cyclists together this weekend (March 4-6) for a challenging 3-day stage race! This race is in its 34th year, and has a reputation within the cycling community for being challenging, well-run...

Cycling

Events

Press Releases

March 3, 2022

Virtual Tour of Africa by Giant & Liv welcomes all to explore Southern Africa with its prominent riders

South Africa/March 3rd, 2022  /ENDURANCE SPORTSWIRE/ - A big adventure awaits everyone in the vast deserts, steep mountain passes and rugged coastlines of Namibia, South Africa and Lesotho. Africa is really an amazing place and absolutely worth exploring. Though, for many reasons, it is not always very easy to scout it...

Cycling

Events

Press Releases

March 3, 2022

Showcased

Speed Hound to Be Recovery Partner for Clash Miami

Menlo Park, CA (March 3, 2022)/ENDURANCE SPORTSWIRE/ - Speed Hound is proud to announce a partnership with Clash Endurance and named the official recovery sponsor for the Clash Miami event. While athletes swim, bike, and run their way through the south Florida terrain, they’ll have the full support of Speed Hound...

Events

Press Releases

Sponsorship

Triathlon

March 3, 2022

Everything Set for The Citroën Ë-Tour by Bkool, The First Virtual Cycling Stage Race

Madrid, March 3, 2022 /ENDURANCE SPORTSWIRE/  Starting March 7, the Citroën ë-Tour by BKOOL will take place in four stages of between 14 and 25 km each, set on the virtual streets and highways of Spain and Portugal. There will be prizes for every participant who finishes at least one...

Cycling

Events

Press Releases

Sponsorship

Triathlon