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

August 24, 2022

Leah Reid prepares to take on her 100th Rock ‘n’ Roll Series Event at St. Jude Rock ‘n’ Roll Running Series Washington on September 3-4, 2022

BELLEVUE, Wash. (August 24, 2022)/ENDURANCE SPORTSWIRE/ – Thousands of runners are scheduled to participate in the St. Jude Rock ‘n’ Roll® Running Series Washington on Saturday and Sunday, September 3-4, 2022 as the Rock ‘n’ Roll Running Series makes its return to the Pacific Northwest. For one runner in particular, the...

Events

Press Releases

Running

August 24, 2022

American Criterium Cup event number nine: IU Health Momentum Indy: Mass Ave Criterium presented by First Internet Bank.

Wednesday, August 24, 2022 /ENDURANCE SPORTSWIRE/ – On Saturday, August 27th, as part of IU Health Momentum Indy, the Mass Ave Crit presented by First Internet Bank, returns to Indianapolis. Founded in 2007, the Mass Ave Crit is one of the Midwest's longest-running urban bike races. The high-energy urban race features first-rate...

Cycling

Events

Press Releases

August 24, 2022

GFNY Alpes Vaujany: 4000+ meters of climbing on legendary French cols

New York City, August 24, 2022 /ENDURANCE SPORTSWIRE/ – This Sunday, GFNY Alpes Vaujany offers racers a 119.6 km long course with 4023m of climbing across two major mountain passes and a mountain finish in Vaujany. Host town Vaujany is a charming mountain village in the French Alps surrounded by many...

Cycling

Events

Press Releases

August 24, 2022

Team USA Rides to Bronze in the Relay at Mountain Bike World Championships

LES GETS, France /ENDURANCE SPORTSWIRE/ – Team USA kicked off the first day of racing at the 2022 UCI Mountain Bike World Championships in Les Gets, France. The Team Relay is always one of the most exciting events at the World Championships bringing the nation together across all age categories. Federations...

Cycling

Events

Press Releases

August 23, 2022

Registration opens for 21st Little Rock Marathon Expo

LITTLE ROCK, ARK (Aug. 23, 2022) - Registration is now open for the Little Rock Marathon Health and Fitness Expo. The Expo serves as race headquarters for all athletes, volunteers and spectators, and is a key component of the weekend’s activities, Expo Director Brandy Dixon said. The 21st annual Little...

Business

Events

Press Releases

Running

Trade Shows

August 23, 2022

GFNY Day 2022: athletes from all around the World celebrated 3rd edition

New York City, August 23, 2022 /ENDURANCE SPORTSWIRE/ - Last Sunday August 21, the third annual GFNY Day was celebrated by thousands of athletes who joined the group rides and tuned in for the GFNY Day Virtual Conference from all around the world. There were more than 20 morning group...

Cycling

Events

Press Releases

August 23, 2022

Abbott World Marathon Majors and Mass Participation World partner to inspire a return to running

/ENDURANCE SPORTSWIRE/ – The Abbott World Marathon Majors (AbbottWMM) and Mass Participation World (MPW) have joined forces to launch #togetherwemove in a bid to encourage the world back to mass participation events after the industry hit some big hurdles during the COVID-19 pandemic. An inspirational video and marketing toolkit has been...

Events

Press Releases

Running

August 23, 2022

Dead Sea Marathon Israel

/ENDURANCE SPORTSWIRE/ - Tamar Regional Council invites you to a unique running experience in the lowest place in the world: DEAD SEA MARATHON; Friday - 3.2.2023 - Ein Bokek Israel The Dead Sea Marathon is being held for the fourth year and will offer participants a unique running experience in areas they...

Events

Press Releases

Running

August 23, 2022

Maryland Cycling Classic Announces Preliminary Riders Featuring Tour de France Stage Winners and Rising American Stars

BALTIMORE, Md. /ENDURANCE SPORTSWIRE/ – Team BikeExchange-Jayco’s dynamic duo of sprinters Michael Matthews of Australia and Dylan Groenewegen of the Netherlands, both stage winners at this year’s Tour de France, and young American stars Neilson Powless of team EF Education-EasyPost and Quinn Simmons of team Trek-Segafredo, as well as current U.S. National...

Cycling

Events

Press Releases

August 22, 2022

XTERRA Elites Showcase Speed, Skill in Short Track Showcase

August 22, 2022/ENDURANCE SPORTSWIRE/ – Professional XTERRA athletes from around the world put on an incredible show over two days of Short Track and full-distance off-road triathlon racing in Zittau, Germany on August 19-20. “It was really spectacular racing and so fun to watch,” said XTERRA Europe director, Nico Lebrun. “This is...

Events

Press Releases

Triathlon