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

June 21, 2022

Tourism Grant Helps CampgroundViews.com Bring Virtual Site Tours to Arizona

LARAMIE, Wyo. (June 21, 2022) /ENDURANCE SPORTSWIRE/ - CampgroundViews.com, the company committed to taking the guesswork out of campsite selection, is developing virtual tours of up to 250 campgrounds in Arizona to make trip planning easy for RV and tent campers. With CampgroundViews.com’s proprietary 360-degree virtual tours and searchable database,...

Press Releases

Products

June 21, 2022

MTB Giveaways is acquired by Endurance Zone, owners of Win Your Dream Bike

/ENDURANCE SPORTSWIRE/ – Endurance Zone have acquired MTB Giveaways to bolster their Win Your Dream Bike brand. After the purchase of Rafflebike in January, this is their second acquisition in 6 months in the bike prize competition space. MTB Giveaways, founded in 2020, is a UK bike prize competition specialising in...

Business

Cycling

Press Releases

June 21, 2022

California’s First-Ever Non-Binary+ Division Over 25k Expected to Run The 45th Annual San Francisco Marathon

June 21, 2022, San Francisco, Calif./ENDURANCE SPORTSWIRE/ – Jumping Fences Inc., the official event producers of The 45th San Francisco Marathon, have officially announced California’s first-ever non-binary+ division and awards. This meaningful move comes at a time when numerous anti-LGBTQIA+ legislations are sweeping the nation, and other running races are being...

Events

Press Releases

Running

Trade Shows

June 20, 2022

Local Runners Dominate 15th Annual Whitefish Marathon Powered by Hammer

WHITEFISH, Mont. (June 20, 2022) /ENDURANCE SPORTSWIRE/ - Runners and walkers lined up for the 2022 Whitefish Marathon Powered by Hammer in cool temperatures but the competition heated up as participants raced in the shadows of Glacier National Park on Saturday, May 21. While the event attracted participants from more...

Events

Press Releases

Running

June 20, 2022

National Triathlon Week Presented by Nix Biosensors Starts Today

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – USA Triathlon today announced the start of the sixth annual National Triathlon Week Presented by Nix Biosensors, a nationwide initiative to celebrate the sport of triathlon and all its constituency groups. National Triathlon Week will take place today through Sunday, June 26. The social-media-based campaign brings together...

Events

Press Releases

Triathlon

June 20, 2022

Europe Gears Up for a Big Weekend of IRONMAN® and IRONMAN® 70.3® Racing Across Four Different Countries

LONDON, UK, June 20, 2022/ENDURANCE SPORTSWIRE/ The stage is set for a bumper weekend of swim-bike-run racing across Europe this weekend with two IRONMAN European Championship races in Frankfurt and Elsinore, as well as IRONMAN and IRONMAN 70.3 events taking place in Nice and Westfriesland. In Germany, a new male IRONMAN European...

Events

Press Releases

Triathlon

June 18, 2022

1,600 Runners Kick Off 2022 Leadville Race Series with Life Time Leadville Trail Marathon and Heavy Half Saturday

Leadville, Colo., June 18 /ENDURANCE SPORTSWIRE/ - The Life Time Leadville Trail Marathon and Heavy Half presented by La Sportiva welcomed a field of more than 1,600 runners to Leadville’s beautiful high country on Saturday. The marathon and half marathon events feature out-and-back courses that take runners across extreme singletrack...

Press Releases

Running

June 17, 2022

Expedition Ozark to draw international teams to Northwest Arkansas

BENTONVILLE, ARK. (June 16, 2022)/ENDURANCE SPORTSWIRE/ – Some of the world's best adventure racing teams will be in Northwest Arkansas April 3-8,2023 for a new race on the Adventure Racing World Series (ARWS) calendar of World Championship qualifiers, organizers announced Thursday. The Expedition Ozark race will be a new race on...

Events

Press Releases

June 17, 2022

Rootstock Racing to host The Endless Mountains Five-day Adventure Race in June 2022

Clarion, Pennsylvania/ENDURANCE SPORTSWIRE/ – Rootstock Racing is excited to announce the Endless Mountains Adventure Race, a five-day expedition race running June 20-25, 2022 through north central Pennsylvania. This new event builds upon Rootstock’s reputation as one of the premier adventure race organizations in the northeastern US. As the name suggests, Pennsylvania...

Events

Press Releases