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

May 9, 2023

Emerging Brand KINeSYS Sunscreen invited to Runchella 2023

/ENDURANCE SPORTSWIRE/ – KINeSYS Performance Sunscreen is honoured to be invited to Runchella 2023, the Running Industry Association’s membership summit, as an emerging brand. Runchella is being held in Chicago from 8 - 11 May and combines educational programming, collaborations and brand presentations. It is open to RIA members only. Lisa and...

Press Releases

Products

Running

Trade Shows

May 9, 2023

Showcased

New Book, Ultrarunning Europe, Guides Runners Through the Continent’s Most Scenic Trails

Columbus, OH, May 9, 2023/ENDURANCE SPORTSWIRE/ – Ultrarunning enthusiasts, adventure seekers, and nature lovers now have the ultimate guide to exploring Europe's most stunning trail running destinations with the release of Ultrarunning Europe. Written by seasoned ultrarunner and adventurer Luke Tuttle, this comprehensive guidebook offers readers a unique and detailed look...

Press Releases

Products

Running

May 9, 2023

MOTTIV Announces Free Version of their App with new a Basic Plan

/ENDURANCE SPORTSWIRE/ – MOTTIV, an athlete-run company dedicated to ensuring endurance sports and the transformations they bring are accessible to everyone has announced it now has a free price tier of their training app. Research has shown that while 30 percent of endurance athletes work with a coach, 60 percent...

Cycling

Press Releases

Products

Running

SWW Syndication

Triathlon

May 9, 2023

Vittoria’s NEW Corsa PRO: Feel What the Pros Feel

/ENDURANCE SPORTSWIRE/ – Compared to the previous Tour-winner version, Corsa PRO tubeless-ready clincher and tubular offer increased speed, wet & cornering grip, puncture resistance and comfort. Corsa PRO uses Vittoria latest developed graphene & silica compound, and a new electrical vulcanization process, allowing a seamless application of the tread to the...

Cycling

Press Releases

Products

May 5, 2023

Skratch Labs Introduces Seasonal Flavor of Hydration Sport Drink Mix: Mango + Tangerine

Boulder, CO /ENDURANCE SPORTSWIRE/ - Skratch Labs, an innovator in performance nutrition, announces the release of a new, limited time flavor of Hydration Sport Drink Mix: Mango + Tangerine. This seasonal flavor brings a refreshing, tropical twist to their sport drink mix. Made with real fruit, sugar and the optimal...

Cycling

Press Releases

Products

Running

May 4, 2023

Showcased

Any Distance Launches Social Network to Encourage Healthy, Active Lifestyles for All

Any Distance launches a brand new social network designed for your active life focused on positivity, inclusion and motivation. No algorithms, no ads, no competition or comparison. Featured by Apple as one of the best running apps, it’s new close friend network is designed to help tackle the global epidemic...

Cycling

Press Releases

Products

Running

Triathlon

May 3, 2023

Pirelli Launches the P ZERO Race 4S TLR Road Bicycle Tire, The All Season Tubeless Tire that Performs in any Weather Condition

Milan (Italy), May 3, 2023 /ENDURANCE SPORTSWIRE/ – Pirelli presents the P ZERO Race 4S TLR road bicycle tire, the tubeless version of the Pirelli all season tire, produced in the renovated Milano-Bollate facility. The new all-round tire follows the success of the P ZERO Race 4S clincher version. The new tire has...

Cycling

Press Releases

Products

Triathlon