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

August 3, 2022

Virtual Badges Meh! Get Physical Rewards with Healthi and meSNAPS

/ENDURANCE SPORTSWIRE/ - Reward Your Weight Loss with Healthi and MeSnaps Diet and weight loss company, Healthi, offers clients a mobile app with six unique weight loss plans. Each curated weight loss plan addresses some the most common goals and hurdles that people face when trying to lose weight. Healthi has...

Press Releases

Products

August 2, 2022

IRONMAN Announces New IRONMAN 70.3 Morro Bay Triathlon in The Central Coast of California

MORRO BAY, Calif. / TAMPA, Fla. (Aug. 2, 2022) /ENDURANCE SPORTSWIRE/ - The IRONMAN Group, announced today that the seaside city of Morro Bay, California and the central California coastline will play host to the newest IRONMAN® 70.3® triathlon. The new IRONMAN 70.3 Morro Bay triathlon is schedule to take...

Events

Press Releases

Triathlon

August 2, 2022

Mazama Designs Launches New Soft Bottles

Bend, OR – August 2nd, 2022/ENDURANCE SPORTSWIRE/ – Mazama Designs, outdoor-products development company located in Bend, Oregon, recently announced the release of their new Soft Bottles to complement their ever-growing arsenal of hydration solutions for outdoor enthusiasts. Mazama is launching new soft bottles today on Amazon.com and their own website, www.mazamadesigns.com....

Press Releases

Products

August 2, 2022

GFNY back in Bali this Sunday

New York City, August 2, 2022/ENDURANCE SPORTSWIRE/ – This Sunday, the GFNY Championship Asia is held at GFNY Bali Element Camp on the ‘Island of the Gods’. The 136.9 km racecourse boasts 2126m of climbing in one of the most sought after travel destinations in the world. “The mere mention of...

Cycling

Events

Press Releases

August 2, 2022

Saucony® Launches All-New Endorphin 3 Collection

WALTHAM, MA (August 2, 2022)/ENDURANCE SPORTSWIRE/ – As the popularity of carbon-plated running shoes continues to surge, global performance running lifestyle brand Saucony announces the launch of the highly anticipated Endorphin 3 Collection, engineered with the brand’s signature SPEEDROLL™ Technology and high-performance PWRRUN PB™ foam cushioning. Leading the new generation Endorphin 3...

Press Releases

Products

Running

August 2, 2022

Tottenham Hotspur and Science in Sport Announce Industry-Leading Partnership

/ENDURANCE SPORTSWIRE/ – Tottenham Hotspur is pleased to announce Science in Sport (SiS) as the Club’s first Official Performance Solution Partner, working closely with the Nutrition and Sports Science teams for the next four seasons.  SiS have already played a part in shaping the Men’s First Team’s preparation for the upcoming...

Press Releases

Products

Sponsorship

August 2, 2022

The Running Event Opens Registration for 2022 Conference and Trade Show

PORTLAND, Maine (August 2, 2022)/ENDURANCE SPORTSWIRE/ – The Running Event (TRE), North America’s premier run specialty conference and trade show, today announced registration is open for its event taking place November 29 to December 1, 2022 at the Austin Convention Center in Austin, TX. “The Running Event’s mission has always been...

Press Releases

Running

Trade Shows

August 2, 2022

Ex-NFL Nutrition and Strength Coach Pratik Patel Joins Nix Biosensors As Director of Human Performance

BOSTON, MASS. — AUGUST 2, 2022/ENDURANCE SPORTSWIRE/ – Nix, the biosensor company delivering health and wellness data to consumers, today officially welcomes Pratik Patel, former Director of Performance Nutrition and Assistant Strength & Conditioning Coach for the New York Giants, to its rapidly growing team. As Nix’s Director of Human Performance, Patel...

Business

Cycling

Press Releases

Running

Triathlon

August 1, 2022

‘La Vuelta Virtual 22’ Warm-Up Racing Weekend #4 – August

Madrid, Spain / August 1st, 2022/ENDURANCE SPORTSWIRE/ – La Vuelta calls on cyclists and fans, of all fitness levels, to ride with the pros from Equipo Kern Pharma and Elisa Scarlatta to explore Spain. Elisa Scarlatta is a passionate Italian amateur cyclist, an influencer and a multi-brand ambassador on social media,...

Cycling

Events

Press Releases