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

August 20, 2024

USA Triathlon Secures BikeInsure as Official Bicycle Insurance Partner

Colorado Springs, Colo. – August 20, 2024 /ENDURANCE SPORTSWIRE/ – USA Triathlon, the National Governing body for the sport of triathlon in the United States, has selected BikeInsure as the organization's Official Bicycle Insurance partner, bringing affordable, opt-in bicycle insurance to USA Triathlon members. BikeInsure is a specialty bicycle insurance...

Cycling

Press Releases

Products

Sponsorship

Triathlon

August 19, 2024

Themagic5 Announces The World’s First Custom Kids Goggles

BROOKLYN, NEW YORK, USA, AUGUST 2024 /ENDURANCE SPORTSWIRE/ - THEMAGIC5 announces the development of custom goggles for kids–the first in the world. The kids goggles will extend THEMAGIC5 experience to younger swimmers aged 10 and up. Younger swimmers (ages 10+) experience the same struggles with traditional goggles as adults do:...

Business

Press Releases

Products

Triathlon

August 16, 2024

RunSignup Launches New Release of RaceDay Mobile Timing App as Part of Its RaceDay Real-Time Product Suite

Moorestown, NJ – August 16, 2024/ENDURANCE SPORTSWIRE/ – RunSignup, the leading registration and technology provider for endurance events in the United States, announces significant advancements to its RaceDay Mobile Timing App, a key component of the RaceDay Real-Time technology suite. These improvements further empower timers and event organizers with versatile solutions...

Cycling

Press Releases

Products

Running

Triathlon

August 14, 2024

Podium Racing Announces Official Partnership with Nix Biosensors for Personalized Hydration Strategies

Old Saybrook, Connecticut/ENDURANCE SPORTSWIRE/ – Podium Racing, a leading triathlon coaching and racing organization, and the first team in supertri’s new franchise ownership model, is thrilled to announce its partnership with Nix, the leading provider of cutting-edge hydration monitoring technology. Podium athletes will integrate Nix’s professional group biosensing platform, Nix Pro,...

Press Releases

Products

Sponsorship

Triathlon

August 13, 2024

Outdoor Tech Launches into New Era of Innovation and Sustainability

August 13, 2024 (Oakland, NJ)/ENDURANCE SPORTSWIRE/ – Outdoor Tech, an industry leader in modern electronics that complement and enhance outdoor active lifestyles, proudly announces significant advancements following its acquisition in April 2023 by Dialectic, a leading consumer electronics distributor based in New Jersey. Under the new leadership of General Manager Katy...

Business

Press Releases

Products