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

February 16, 2024

SNO-GO Carves Through Winter with Record-Breaking Season

Salt Lake City, UT /ENDURANCE SPORTSWIRE/ - SNO-GO, the global leader in ski bikes, is shredding its way to success, hitting major milestones and sharing the good vibes with a limited-time price drop on its best-selling Shift model. Starting today, anyone can purchase Shift for $1,699 at www.sno-go.us and participating...

Business

Press Releases

February 15, 2024

The McCourt Foundation Partners with Runna for 2024 Los Angeles Marathon

Los Angeles, California – February 15, 2024 /ENDURANCE SPORTSWIRE/ – The McCourt Foundation, renowned for its commitment to empowering communities to build a healthier world, is proud to announce a new partnership with Runna as the preferred digital training app for the 2024 Los Angeles Marathon presented by ASICS. “Runna is...

Events

Press Releases

Running

Sponsorship

February 15, 2024

Showcased

Mountain Hardwear Secures Two Prestigious ISPO Awards

Richmond, Calif. [February 15, 2024] /ENDURANCE SPORTSWIRE/ – Mountain Hardwear, a leader in performance equipment and apparel for climbers, mountaineers and outdoor athletes, is thrilled to announce its recent wins at the ISPO Awards 2023. The Specter™ 15F Sleeping Bag and the Alpine Light™ Roll Top 45L Pack, have been recognized...

Awards

OSW Syndicated

Press Releases

Products

February 15, 2024

USA Triathlon Partners with Air Force Special Warfare as Official Partner of Excellence

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – USA Triathlon today announced a partnership with the Air Force Special Warfare as the organization’s Official Partner of Excellence. Air Force Special Warfare is the quiet professional force conducting global air, space, and cyber-enabled special operations across the spectrum of engagements with joint service and partner nations. They...

Press Releases

Sponsorship

Triathlon

February 15, 2024

The IRONMAN Foundation Announces Race For Change Scholarship Program to Increase Inclusivity in the Sport of Triathlon

TAMPA, Fla. (February 14, 2024)/ENDURANCE SPORTSWIRE/ – The IRONMAN® Foundation announced its Race For Change™ Scholarship aimed to support individuals from underrepresented communities who have the desire to participate in an IRONMAN® or IRONMAN 70.3® triathlon race. Up to three Race For Change Scholarships, each valued up to $10,000 USD, will...

Giving

Press Releases

Triathlon

February 15, 2024

Focused on Fitness Innovation, Kinomap Redefines the Exercise Experience

February 15, 2024/ENDURANCE SPORTSWIRE/ – Are you ready to revolutionize the way you exercise? Kinomap, a cutting-edge fitness application, seamlessly combines technology and fitness to create a dynamic platform that transcends traditional workout routines. Kinomap goes beyond the conventional boundaries of home and gym-based fitness, offering users an immersive and interactive journey...

Cycling

Press Releases

Products

Running

February 15, 2024

UTMB World Series Welcomes Suunto as Official GPS Watch and Technical Partner

/ENDURANCE SPORTSWIRE/ – Sharing the same passion for sports and the outdoors, UTMB® World Series and Suunto, known for their world-renowned GPS multisport watches and training tools, have announced a global partnership, that will see the two companies work together to contribute to the positive development of trail running and...

Press Releases

Running

Sponsorship

February 15, 2024

Garmin Expands Relationship with Professional Triathletes Organisation and New T100 Triathlon World Tour

London, UK/ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) has announced that Garmin will renew its contract as the Official Transition Sponsor of the PTO and the upcoming T100 Triathlon World Tour. The relationship will build on its successful first year that saw it activate across broadcast, social media and worldwide...

Press Releases

Sponsorship

Triathlon