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

October 22, 2021

Run Show USA Selects Dylan Bowman, Ultra Runner and Founder of Pyllars Podcast, to Host the Trail Running and Ultra Stage

Boston, MA /ENDURANCE SPORTSWIRE/ - The Run Show USA has added a Trail Running and Ultra Stage, hosted by Dylan Bowman, to its Boston event taking place at the Hynes Convention Center, January 29-30. Dylan is a professional ultrarunner from Portland, Oregon. Racing professionally for twelve years, Dylan has earned...

Events

Press Releases

Running

Trade Shows

October 22, 2021

GFNY launches Marathon running

/ENDURANCE SPORTSWIRE/ - GFNY Endurance Sports Series is back in the United States with the inaugural running event, GFNY Marathon Florida Sebring. The course is USATF certified and the flat and fast route makes it the perfect race for runners wanting to score a personal best. GFNY Marathon Florida also...

Events

Press Releases

Running

October 22, 2021

GFNY announces GFNY Waco

/ENDURANCE SPORTSWIRE/ - GFNY Waco is the latest addition to the GFNY Endurance Sports Series, making it the fourth GFNY cycling race in the United States. Scheduled for June 26, 2022, riders will get to ride a 86-mile double-looped course on open county roads passing farmland, cattle ranches and dairies....

Cycling

Events

Press Releases

October 21, 2021

Jennifer Valente Claims Second Bronze Medal at 2021 Track Worlds

ROUBAIX, France /ENDURANCE SPORTSWIRE/ - On the second day of the 2021 Tissot UCI Track World Championships, Team USA started the morning off with the Women’s Sprint tournament. In the evening competed in the Women’s Scratch Race and Men’s Elimination Race. Women’s Elimination Race Jennifer Valente (San Diego; TWENTY24 Pro Cycling)...

Cycling

Events

Press Releases

October 21, 2021

The IRONMAN Group Adds Indoor Cycling App Fulgaz Expanding and Enhancing Connected Fitness Offerings

TAMPA, Fla. / MELBOURNE, Australia (October 21, 2021) /ENDURANCE SPORTSWIRE/ - The IRONMAN Group is excited to announce the acquisition of indoor virtual cycling app, FulGaz™, marking the company’s first major step towards delivering enhanced services to athletes throughout their entire athletic journey. Following the success of the IRONMAN® Virtual Racing™...

Business

Cycling

Press Releases

Triathlon

October 21, 2021

Jennifer Valente Rides to Team USA’s First Medal at 2021 Track Worlds

ROUBAIX, France /ENDURANCE SPORTSWIRE/ - After winning Olympic gold in the Women’s Omnium, Jennifer Valente (San Diego; TWENTY24 Pro Cycling) is back on the track for the 2021 Tissot UCI Track Cycling World Championships. Valente started off the championship racing the Women’s Scratch Race. She rode to silver in this event...

Cycling

Events

Press Releases

October 21, 2021

USABA’s Breakfast with Champions to Highlight On-the-Court, Off-the-Court Accomplishments of Goalball Paralympians

Colorado Springs, Colo. (October 21, 2021) /ENDURANCE SPORTSWIRE/ - As a wrap up to a fantastic Paralympic year, the United States Association of Blind Athletes will be hosting its 12th Annual Breakfast with Champions presented by Anthem on Friday, October 29, at the U.S. Olympic and Paralympic Museum in Colorado Springs with a virtual option for...

Events

Press Releases

October 21, 2021

Olympic Medallist Signs with MANA

/ENDURANCE SPORTSWIRE/ - Olympic and Commonwealth Games medalist Henri Schoeman has joined the growing roster of MANA Sports & Entertainment Group athletes. Schoeman has won for South Africa a bronze medal at the 2016 Rio Olympic Games and gold at the 2018 Commonwealth Games. He is also the top-ranked triathlete...

Press Releases

Sponsorship

Triathlon

October 21, 2021

Showcased

MarathonPhotos launches LIVE in Canada

October 21, 2021 /ENDURANCE SPORTSWIRE/ - MarathonPhotos.Live isn’t wasting any time in conquering the world. On the same day the world-leading endurance photo company launched its ground-breaking service in Canada, teams were also photographing events live in the UK and Europe. With the traditional Scotiabank Toronto Waterfront Marathon shortened this...

Events

Press Releases

Products

Running

October 21, 2021

ROUVY takes Workouts to another level by combining them with beautiful augmented route videos of your choice

ROUVY is a well known and popular indoor app that enables cyclists and triathletes to ride anywhere in the world from home, be it an exotic or iconic cycling location or the next race. Less talked about is the number of features and the other training options of the platform....

Cycling

Press Releases

Products

Triathlon