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

November 8, 2022

The Shenandoah Epic Adventure Race is back for 2023

/ENDURANCE SPORTSWIRE/- Adventure Enablers is excited to open registration for its 2023 running of the Shenandoah Epic 24-hour adventure race. The race is in its 11th year and is located in Front Royal, Virginia. The adventure race will start on April 15, 2023. Registration opened to VIP participants on October...

Events

Press Releases

November 8, 2022

Speedland Unveils GS:TAM, Its First Max Cushion Shoe

Portland, Oregon, November 8, 2022 /ENDURANCE SPORTSWIRE/ - Developed by industry experts Dave Dombrow and Kevin Fallon and tested by elite trail running athletes, Speedland unveils the GS:TAM, a highly cushioned, customizable shoe designed for maximum performance and comfort over any ultra marathon distance. The shoe features cutting-edge technology and...

Press Releases

Products

Running

Triathlon

November 8, 2022

Gruppo Announces Launch Of FuelFinder

Windsor, Ontario /ENDURANCE SPORTSWIRE/ – Gruppo Nutrition announces the launch of a tool that’ll make it easier for athletes to choose the nutrition product that best suits their needs, FuelFinder. Since 2006, Gruppo has been growing to encompass a wide array of sports nutrition and everyday protein drinks. That’s why they...

Cycling

Press Releases

Products

Running

Triathlon

November 7, 2022

Victoria Brumfield Named USA Triathlon Chief Executive Officer

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – Victoria Brumfield today was announced by USA Triathlon Board of Directors Chair Joel Rosinbum as the Chief Executive Officer for the National Governing Body. Brumfield, who has served as USA Triathlon’s interim CEO since early September, becomes the organization’s first female CEO in its 40-plus-year...

Business

Press Releases

Triathlon

November 6, 2022

Approximately 2,000 Athletes Converge in Florida’s Panhandle for the 2022 Visit Panama City Beach IRONMAN Florida, Part of The VinFast IRONMAN U.S. Series

PANAMA CITY BEACH, Fla. /ENDURANCE SPORTSWIRE/ - The beautiful beaches and emerald-green waters of Panama City Beach, Fla. provided a stunning backdrop for the 2022 Visit Panama City Beach IRONMAN Florida triathlon, part of the VinFast IRONMAN U.S. Series, on Saturday, Nov. 5. Approximately 2,000 athletes kicked off their IRONMAN...

Events

Press Releases

Triathlon

November 6, 2022

More than 4,100 Participants Celebrated the 10th Anniversary of the EQT Pittsburgh 10 Miler

PITTSBURGH (November 6, 2022) /ENDURANCE SPORTSWIRE/ – EQT Pittsburgh 10 Miler, the ‘most Pittsburgh race ever,’ celebrated its 10th anniversary today with more than 4,100 participants. The 10-mile and brand new 10K course featured local bands and Pittsburgh-themed miles, including the Mister Roger’s Mile, Pittsburgh Foods Mile and City of Champyinz...

Events

Press Releases

Running

November 5, 2022

CNO Financial Indianapolis Monumental Marathon Celebrates Its 15th Anniversary Event in Style

INDIANAPOLIS, Nov. 5, 2022 /ENDURANCE SPORTSWIRE/ - Athletes representing all 50 states and 12 countries from around the globe, converged in Indianapolis this morning for the 15th annual CNO Financial Indianapolis Monumental Marathon, Half Marathon, and 5K. Today’s event marked the 10th consecutive sellout of one of the country’s fastest-growing...

Events

Press Releases

Running

November 4, 2022

Stages Cycling Black Friday Deals Start Monday, November 7

Boulder, CO – 4 November, 2022 /ENDURANCE SPORTSWIRE/ – Starting Monday, Nov. 7, Stages Cycling will release deals with deep discounts and incredibly low prices on indoor bikes, GPS cycling computers and power meters. Stages SB20 Smart Bike for $1799 The smoothest, most realistic and immersive virtual cycling experience will be available for...

Cycling

Press Releases

Products