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 (21085)
) 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 100, 10

September 18, 2024

Introducing the greatest in on-the-go recovery

FORT WAYNE, Ind. — September 18, 2024 /ENDURANCE SPORTSWIRE/ – Master Spas, a leading manufacturer of hot tubs and swim spas, is proud to announce the latest product from Michael Phelps Chilly GOAT Cold Tubs. The Chilly GOAT GO! is perfect for athletes, fitness enthusiasts, and wellness seekers who are...

Press Releases

Products

September 17, 2024

GOREWEAR Unveils New Technical and Thermal Run and Bike Styles for Fall 2024

Elkton, MD (September 17, 2024) /ENDURANCE SPORTSWIRE/ - GOREWEAR, the leading innovator in high-performance running and cycling apparel, introduces its new Fall/Winter 2024 product lineup, including updates to the brand’s popular Concurve and Spinshift collections. Each collection expands upon its technical performance adding new fall/winter specific thermal styles. Starting with...

Press Releases

Products

September 17, 2024

Maven Adds To Its C Series Spotting Scope Line With The CS.2A

LANDER, Wyo. (Sept. 17, 2024) /ENDURANCE SPORTSWIRE/ - Maven, a Wyoming-based direct-to-consumer brand known for offering world-class optics at affordable prices, has added to its award-winning line of C Series spotting scopes with the CS.2A. The CS.2A is the brand’s first expansion of the C series spotting scopes since the...

Press Releases

Products

September 13, 2024

IRONMAN Launches Brand-New Docuseries: AN IRON WILL

- Season 1 of ‘AN IRON WILL’ launches today with five episodes available to view now on the IRONMAN YouTube channel www.youtube.com/@ironmantriathlon, on Outside TV and DAZN - As a prelude to the 2024 IRONMAN World Championship season, ‘AN IRON WILL’ follows five of the world’s best professional triathletes –...

Press Releases

Products

Triathlon

September 12, 2024

Vittoria redefines tire support for e-MTB with the launch of Air-Liner Protect e-Bike

Bentonville, AR – 09/12/2024 /ENDURANCE SPORTSWIRE/ - Vittoria proudly announces the release of the Air-Liner Protect E-Bike insert, a revolutionary tire insert specifically designed for electric mountain bikes. Built to withstand the challenges posed by the heavier weight of e-bikes, this innovative product offers cyclists unmatched support and peace of...

Cycling

Press Releases

Products

September 12, 2024

Vittoria unveils the ultimate MTB tire insert, the Air-Liner Protect Trail

Bentonville, AR – 09/12/2024 /ENDURANCE SPORTSWIRE/ - Vittoria revolutionizes mountain biking again with the launch of its latest innovation, the Air-Liner Protect Trail insert. This cutting-edge MTB insert is designed to cater to the diverse needs of riders, striking the ideal balance between protection, performance, and lightweight design. Dedicated to...

Cycling

Press Releases

Products

September 11, 2024

Chargel Continues On-Site Samplings and Sponsorships with UCLA Football and Surf City 10

IRVINE, Calif. (September 11, 2024) /ENDURANCE SPORTSWIRE/ - Chargel®, a first-of-its-kind, delicious Gel Drink that delivers convenient and delightfully unexpected instant pre-workout energy before any workout with zero caffeine, today, announced its September competitive event station lineup. Chargel will showcase its half drink, half snack, all delicious energy source at...

Business

Events

Giving

Press Releases

Products

Running

Sponsorship

Wire Syndication