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 (8742)
) 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 5570, 10

March 21, 2022

#RideforUkraine – Charitable Challenge generated 25K Euro for UNICEF

Prague, Czech Republic / March 21, 2022 /ENDURANCE SPORTSWIRE/ - Risen from the active Czech and international athletic community, the team at ROUVY always takes action on whatever challenge comes its way. Having once helped the most badly-hit Italian area by the COVID-19 pandemic with #RideforItaly, ROUVY took a stand to...

Cycling

Events

Giving

Press Releases

Triathlon

March 21, 2022

A citizen’s race with nearly 2,500 participants will take place following the elite race and utilize the neighborhood streets of Summerhill as well as Cheney Stadium to cover its 5K course.

ATLANTA – March 21, 2022/ENDURANCE SPORTSWIRE/ - Olympians, a defending NCAA Champion and hometown stars will headline the first ever elite field at the Northside Hospital Atlanta Women’s 5K. Atlanta Track Club announced the all-women’s lineup today that will race on the streets of downtown Atlanta and Summerhill on Saturday morning....

Events

Press Releases

Running

March 21, 2022

361° Europe Launch The Fierce 2 – A Do-It-All Trainer For Under £105

/ENDURANCE SPORTSWIRE/ - 361° have designed the Fierce 2 for all runners, who are seeking performance with style and comfort in a functional shoe they can wear throughout the day. The upper has been reimagined to improve breathability, stretch, and support to allow the foot to perform all day. A...

Press Releases

Products

Running

Triathlon

March 20, 2022

25,000 Runners Celebrate The 50th Running of The Yuengling Shamrock Marathon Weekend

March 20, 2022- Virginia Beach, Virginia /ENDURANCE SPORTSWIRE/ - The sun was shining in Virginia Beach as 25,000 runners celebrated the Golden Year of the Yuengling Shamrock Marathon weekend.  The energy from everyone involved from the runners, volunteers, to the poster carrying cheerleaders on the sidelines was felt miles away. ...

Press Releases

Running

March 18, 2022

Sea Otter Australia Announces 2023 Dates

/ENDURANCE SPORTSWIRE/ - The team at Sea Otter Australia has been working full throttle behind the scenes to re-shape the event so that Sea Otter will provide a more contemporary and more impactful experience. Our commitment to design and deliver a truly unique community cycling festival is resolute. As a...

Cycling

Events

Press Releases

March 18, 2022

Gourdy’s Pumpkin Run Partners with Girls On The Run For Third Year

NEW YORK /ENDURANCE SPORTSWIRE/ - The fall-favorite race has again teamed up with Girls on the Run for a third year in a row, after raising a combined total of over $400,000 for the National Charity Partner in the previous two years. Gourdy’s Pumpkin Run will continue donating $1 per...

Events

Giving

Press Releases

Running