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

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

August 11, 2024

Fuel Goods and Team Charlotte Swimming Unveil The SwimmerBox to Simplify Swim Nutrition for Athletes and Parents

August 12, 2024—Asheville, NC /ENDURANCE SPORTSWIRE/ - Fuel Goods, a leading sports nutrition marketplace, has partnered with Team Charlotte Swimming (TEAM) to launch The SwimmerBox, a comprehensive nutrition solution designed to make swim nutrition simple and effective for meets and everyday training. The collaboration between Fuel Goods and Team Charlotte Swimming...

Press Releases

Products

Triathlon

August 9, 2024

Outdoor Vitals Celebrates 10 Year Anniversary With Black Friday Level Sale

CEDAR CITY, Utah (August 9, 2024) /ENDURANCE SPORTSWIRE/ – Outdoor Vitals, the Utah-based performance outdoor brand, announced the dates for their 10th anniversary celebration this summer. The celebration will include a sitewide sale on all their performance gear that mimics Black Friday discount levels. This sale event will be on...

Business

Press Releases

Products