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

March 16, 2023

Pinarello Launches new Nytro E Road and Gravel E Bikes

/ENDURANCE SPORTSWIRE/ Pinarello is proud to announce the launch of the Pinarello Nytro E, an exciting range of road and gravel e-bikes designed without compromise to perform at a high-level and created with adventure in mind, allowing riders to tackle long rides and steep Alpine climbs with more agility and...

Cycling

Press Releases

Products

March 16, 2023

CORE partners with the women’s ZAAF cycling team in 2023

Zurich, Switzerland /ENDURANCE SPORTSWIRE/ – ZAAF is one of the newest UCI Women’s Continental Teams and CORE is partnering with the team in 2023, delivering heat management expertise and solutions. When racers get hot, their power output falls. The partnership brings the ZAAF cycling team real-time core body temperature monitoring and solutions...

Cycling

Press Releases

Products

March 16, 2023

Performance Hydration Leader Ready® Launches New Low-Calorie Sports Drink

Pittsburgh, PA., March 16, 2023/ENDURANCE SPORTSWIRE/ – Ready® (@ready nutrition), one of the fastest growing sports nutrition companies in America with co-owners and Ready® Athletes Aaron Donald and Giannis Antetokounmpo, today announced the launching of a light version of Ready® Sports Drink, its advanced and science-based line of performance products designed...

Press Releases

Products

March 16, 2023

Introducing Ommyx, the First-of-Its-Kind AI Health Tracking App

Miami, FL (March 16, 2023) /ENDURANCE SPORTSWIRE/ - Ommyx is excited to announce the launch of its AI health tracking app, an innovative platform that syncs with your wearables, integrates your health data, and sends custom recommendations that align with your goals straight to your calendar. To founder David Mehlman,...

Business

Cycling

Press Releases

Products

Running

Triathlon

March 15, 2023

Introducing PROLIDS: A New Bicycle Helmet Brand Designed Especially for Kids!

Tulsa, Oklahoma /ENDURANCE SPORTSWIRE/ – Effective this month, Brett Baker, company founder, announces the launch of PROLIDS, a bicycle helmet designer and manufacturer based in Tulsa, OK. PROLIDS was created with the goal of making fun, stylish, customizable helmets that kids could wear, and feel good about wearing. PROLIDS helmets will help...

Cycling

Press Releases

Products

Wire Syndication

March 15, 2023

Athletic Brewing Company Expands Canadian Retail Presence

MILFORD, Conn. and SAN DIEGO (March 15, 2023) /ENDURANCE SPORTSWIRE/ – Athletic Brewing, America’s leading producer of non-alcoholic craft beer, is proud to announce an expansion of its Canadian retail presence. A growing number of key retail partners across Canada – including Sobeys, Safeway, Loblaws, and Real Canadian Superstore – are...

Business

Press Releases

Products

March 15, 2023

Chargel Delivering Unexpected Energy Onsite At The Los Angeles Marathon Expo

Los Angeles, Calif (March 15, 2023)/ENDURANCE SPORTSWIRE/ - Chargel, the first-of-its-kind, pocket sized and easy to consume athletic Gel Drink, is kicking off the 2023 racing season onsite at the Los Angeles Marathon Expo. Athletes and spectators alike can expect to find Chargel Stations set up in sampling tents with...

Press Releases

Products

Running

Sponsorship

Triathlon

Wire Syndication