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

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

PR Newswire Syndication

Press Releases

Products

Running

Sponsorship

September 10, 2024

Xtracycle Unveils The Hopper: Compact E-Cargo Bike Combines 500-lb Payload With Premium Ride Quality

MILL VALLEY, CA/ENDURANCE SPORTSWIRE/ – Xtracycle, pioneers in cargo bike design for over 25 years, announces the debut of its newest electric cargo bike, the Hopper. Designed to be the most intuitive, compact family cargo bicycle on the market, the Hopper combines Xtracycle's renowned ride quality with accessibility, versatility, and impressive...

Press Releases

Products

September 9, 2024

Ultimate Sport Service and MYLAPS join forces

NYBORG / HAARLEM (September 2024)/ENDURANCE SPORTSWIRE/ – Ultimate Sport Service and MYLAPS Sports Technology announce a strategic partnership. The companies, based in Denmark and The Netherlands, join forces to leverage expertise on sports timing and event services. This means that all races timed by Ultimate, will be timed with MYLAPS...

Business

Cycling

Press Releases

Products

Running

Triathlon

September 9, 2024

Wattbike launches Proton -– the most versatile smart bike for fitness enthusiasts

/ENDURANCE SPORTSWIRE/ – Designed for Effective and Efficient Training - Whatever the Goal. The Wattbike Proton can be easily and extensively adjusted without the use of tools, allowing users to seamlessly customise their position and optimise their workouts according to their individual training goals. Effective and time efficient training is...

Cycling

Press Releases

Products

September 6, 2024

deboer announces pre-order of FJORD 4.0: A Breakthrough in Wetsuit Technology

Norwalk, CT /ENDURANCE SPORTSWIRE/ – deboer, a leading innovator in wetsuit design, has announced the upcoming launch of their FJORD 4.0, representing the next evolution in wetsuit technology for triathletes and open water swimmers. Building on the success of its predecessor, the FJORD 4.0 incorporates advanced features that promise to...

Press Releases

Products

Triathlon