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

April 21, 2022

Lizard Skins Re-Launches Old Favorite: The Lever Grip

American Fork, Utah (March 21, 2022)/ENDURANCE SPORTSWIRE/ – Lizard Skins, long renowned for focusing on rider contact points and protecting your bike, has just reintroduced one of their earliest products: a new take on an old favorite, now called the DSP Lever Grip. Plus it’s considerably improved from the original, which...

Cycling

Press Releases

Products

Triathlon

April 21, 2022

Racecheck and eventrac Ramp Up Reviews

/ENDURANCE SPORTSWIRE/ – The exciting growth of the Racecheck review platform continues, with this latest announcement of an API integration with eventrac - the first partnership of its kind for the industry. Connecting a Racecheck account with eventrac will enable users to benefit from eventrac’s inbuilt email service to schedule...

Cycling

Press Releases

Products

Running

Triathlon

April 21, 2022

Kane Footwear releases ocean-inspired Revive to celebrate Earth Day

Westport, CT (April 21, 2022) /ENDURANCE SPORTSWIRE/ - Kane Footwear, the footwear brand promoting health for your body and the planet, released a limited edition Tropic/Dark Earth Speckle colorway to celebrate ocean health and their commitment to sustainable practices. The lifecycle of Kane’s flagship Revive slip-on – from harvesting the...

Business

Press Releases

Products

April 20, 2022

Get Hy With Essential Elements For All Day Endurance, Hangover Remedy and Added Hydration Boost

LOS ANGELES (April. 20, 2022)/ENDURANCE SPORTSWIRE/ –Essential Elements (Ee) – the premium, science-backed sports nutrition brand – has announced their new ‘Get Hy’ campaign in honor of the 4/20 holiday.  The Hydration ACV electrolyte product aids in hydration during the celebrated consumption day as well as the return to music...

Press Releases

Products

April 20, 2022

Strength Running Celebrates 5 Million Podcast Downloads

DENVER, CO (April 19, 2022) /ENDURANCE SPORTSWIRE/ - Strength Running is excited to announce that it has achieved a key milestone: the Strength Running Podcast has been downloaded more than 5 million times. “The growth of the podcast is thanks to our listeners, who keep showing up every week for...

Press Releases

Products

Running

April 19, 2022

West Slope Unveils New Line of Innovative Packs Designed for Outdoor Adventure

STEAMBOAT SPRINGS, Colo. (April 19, 2022)  /ENDURANCE SPORTSWIRE/ West Slope, the company dedicated to reimagining how to make spending time outdoors better, today introduced a new line of packs that gives outdoor adventure enthusiasts unrivaled access to all their essentials. From new slim designs to the first conversion product, West...

Press Releases

Products