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

February 4, 2022

Paraguay Prepares to Host the 2022 Adventure Racing World Championships

/ENDURANCE SPORTSWIRE/ - Expedicion Guarani will be this year’s Adventure Racing World Championships and the organisers are looking forward to welcoming teams from around the world to Paraguay, to explore their country and meet their people. The race takes its name from the Guarani people, and language (Spanish and Guarani are...

Events

Press Releases

February 3, 2022

National Downhill Series Calendar Sees Three Returning Events for 2022

COLORADO SPRINGS, Colo  /ENDURANCE SPORTSWIRE/ - USA Cycling announced on Thursday the dates and locations for the 2022 National Downhill Series. The NDHS, formally known as the Pro Gravity Tour (Pro GRT), saw great success in 2021, despite several races canceling due to outside factors, including COVID. “We are slated...

Cycling

Events

Press Releases

February 3, 2022

Registration Open for Inaugural Heineken® 0.0 Pittsburgh Earth Day Run

PITTSBURGH (February 3, 2022)  /ENDURANCE SPORTSWIRE/ - Runners are invited to celebrate Earth Day this year with the first-ever Heineken 0.0 Pittsburgh Earth Day Run. The highly sustainable 5K race, scheduled for April 9, will encourage runners to practice eco-friendly running habits while celebrating Earth Day. Aiming to be one...

Events

Press Releases

Running

February 3, 2022

2022 Brazilian Virtual Cycling Championships – 11 Tours Visit The Main Cities of Brazil on ROUVY

Brasilia, Brazil / February 3, 2022/ENDURANCE SPORTSWIRE/ - The Brazilian Virtual Cycling Championships is supported by the Brazilian Confederation of Electronic Sports - CBDEL and the Brazilian Confederation of University Sports - CBDU. It is also being recognized by the World Consortium of Electronic Sports - WESCO (World Esport Consortium). Once...

Cycling

Events

Press Releases

February 3, 2022

Introducing PEAR® Studio: Pioneering Fully Customizable, Multi-Screen Digital Fitness Programming for Studios and Fitness Facilities

NEWPORT BEACH, CA /ENDURANCE SPORTSWIRE/ - Today PEAR® announces the launch of PEAR Studio, a premium digital fitness platform for studio and fitness facilities. PEAR Studio provides customers a visual workout experience that is flexible and focused on strengthening community and member retention for both in-studio and at-home workouts. Having...

Events

Press Releases

Products

February 3, 2022

Join Liv Ladies AllRide: Powered by SRAM Mountain Bike Skills Camps Returns for 8th Season

BEND, Ore. (Feb. 3, 2022) /ENDURANCE SPORTSWIRE/ - Ladies of all mountain bike skill levels, from beginner to seasoned rider are invited to join Ladies AllRide for its eighth season of mountain bike skills camps in inspiring destinations around the country this spring through fall. Registration is now open at...

Cycling

Events

Press Releases

February 3, 2022

With 8” of snow early in the week, Old Man Winter Rally is sure to deliver Epic Winter Adventure for cyclists and runners.

BOULDER, CO (February 3, 2022) /ENDURANCE SPORTSWIRE/ - Ask any outdoor event director what their biggest worry is and many will answer with two words: “The weather”. Though Josh Kravetz, Race Director of the Old Man Winter Rally and founder of Adventure Fit Productions, might say the same thing, his...

Cycling

Events

Press Releases

Running

February 3, 2022

17th Annual CapCenter Cap2Cap Presented by Dominion Energy Returns to the Virginia Capital Trail

RICHMOND, Va /ENDURANCE SPORTSWIRE/ - The CapCenter Cap2Cap Presented by Dominion Energy welcomes riders back to the Virginia Capital Trail on May 6th and 7th.  Celebrating its 17th year, this family-friendly event features a paved course with scenic views, multiple distances, and a post-ride party with a live DJ and local...

Cycling

Events

Press Releases

February 2, 2022

UTMB® World Series ready to run into inaugural year, with addition of three events to confirmed 2022 calendar

(Chamonix, France) 2 February 2022 /ENDURANCE SPORTSWIRE/ - Just eight months after the concept was first launched, UTMB Group and The IRONMAN Group, organizers of the UTMB World Series® have today confirmed a final calendar of 25 events across 16 different countries in Asia, Oceania, Europe, and the Americas for 2022....

Events

Press Releases

Running

February 2, 2022

Hospital Hill Run Announces Charity Challenge, benefiting Children’s Mercy Hospital

February 2, 2022 /ENDURANCE SPORTSWIRE/ - For 2022, The Hospital Hill Run is partnering with its Official Charity Partner, Children’s Mercy Hospital to provide a health-oriented program for area businesses and organizations to encourage health, wellness, and physical fitness, along with an avenue to fundraise for the “I Love Children’s...

Events

Giving

Press Releases

Running