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

November 3, 2022

Pumpkin Spice Half celebrates seven years of fall fun in Fort Worth

FORT WORTH, Texas /ENDURANCE SPORTSWIRE/ – Running season and pumpkin spice season pair perfectly at the Pumpkin Spice Half Marathon, 10K and 5K, which will return to the streets of Fort Worth on Nov. 19. The event is a part of Run Project, Texas’ premier race series, and over 2500 runners...

Events

Giving

Press Releases

Running

November 3, 2022

Spring racing at 2nd GFNY Colonia-Uruguay this Sunday

/ENDURANCE SPORTSWIRE/ – This Sunday, GFNY Colonia Uruguay offers racers a fast long course of 148.2km with 1122m of climbing where the wind will be the main challenge aside from the high pace. Colonia del Sacramento is an irresistibly picturesque town enshrined as a Unesco World Heritage site. Its Barrio Histórico,...

Cycling

Events

Press Releases

November 3, 2022

Ten Athletes Named to First-Ever USA Blind Soccer Men’s National Team

November 3, 2022/ENDURANCE SPORTSWIRE/ – The U.S. Association of Blind Athletes (USABA) today announced the 10 athletes chosen for the first-ever USA Blind Soccer Men’s National Team that will begin international competition in 2023, the first step on the journey to competing at the Los Angeles 2028 Paralympic Games. The team was...

Events

Press Releases

Running

November 2, 2022

Rootstock Racing’s Abby Perkiss, Brent Freedland divulge secrets ahead of 2023 Endless Mountains Adventure Race

/ENDURANCE SPORTSWIRE/ - The 2022 Endless Mountains Adventure Race introduced the Adventure Racing World Series to the little known and underappreciated PA Wilds, the remote and rugged wilderness that makes up some of the most undeveloped land on the east coast of the United States. This inaugural edition was the...

Events

Press Releases

November 2, 2022

United Airlines Rock ‘n’ Roll Running Series Washington D.C. Announces New Course Updates For The 11th Year Of Running In The Nation’s Capital

WASHINGTON, D.C. / TAMPA, Fla. (November 2, 2022) /ENDURANCE SPORTSWIRE/ – The United Airlines Rock ‘n’ Roll® Running Series Washington D.C. is returning to the District on March 18, 2023 and will be debuting a new course. Celebrating the start of a new decade running in D.C., the course promises to bring...

Events

Press Releases

Running

November 2, 2022

Happy Hippie Harvest Run Names Ed Robichaud Honorary Race Starter

LAS VEGAS, NEVADA – November 2, 2022 –/ENDURANCE SPORTSWIRE/ Beyond Limits Running today announced Ed Robichaud has been named the Honorary Race Starter for the 4th Annual Happy Hippie Harvest Run taking place November 5, 2022 at the non-profit Gilcrease Orchard in Las Vegas, Nevada. Mr. Robichaud, who is blind,...

Events

Press Releases

Running

November 2, 2022

Team Chipesti are the First Adventure Racing Champions of the ARWS Oceania Region

/ENDURANCE SPORTSWIRE/ The first ever Oceania Adventure Racing Championship was held at Gold Coast and in the city’s hinterland hills and parks, and it delivered an innovative and tough course, world class racing, and a weekend to remember! The weather was the wild card, as it has been at so...

Events

Press Releases

Triathlon

November 2, 2022

Athletic Brewing Honors Veterans with Ready Front IPA

MILFORD, Conn. and SAN DIEGO (November 2, 2022) /ENDURANCE SPORTSWIRE/ - Athletic Brewing Company, America’s leading non-alcoholic craft brewer, today announced the re-release of Ready Front IPA, a limited-time offering that gives back to military veterans. Developed with a team of veterans and using the “Veterans Blend” of five different...

Cycling

Events

Giving

Press Releases

Products

Running

Trade Shows

Triathlon