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

January 3, 2022

HOKA® Reimagines The Run With The All-New Kawana

(GOLETA, Calif.), January 3, 2022 /ENDURANCE SPORTSWIRE/ - HOKA®, a division of Deckers Brands (NYSE: DECK), announces the launch of the all-new Kawana. A revolutionary new shoe for the start of a new year, the supremely versatile Kawana has been designed for runners and fitness enthusiasts seeking premium comfort in...

Press Releases

Products

December 30, 2021

ROUVY CAREER 2.0 – Training Motivation as a Fun Cycling Adventure Around the World

December 31, 2021 /ENDURANCE SPORTSWIRE/ - ROUVY releases a new and exciting Career format, one of the platform's top features and the 6th Career Edition. ROUVY CAREER 2.0. presents a new, motivating and gamified version of a multi-year ongoing progression for cycling indoors and outdoors. Numerous improvements and added features...

Cycling

Press Releases

Products

Triathlon

December 22, 2021

Believe in the Run and PUMA Partner On Activation of the Fast-R Nitro Debut

/ENDURANCE SPORTSWIRE/ - Believe in the Run, a media company centered on run and run culture, recently partnered with PUMA on a dual activation for the debut of PUMA’s newest racing shoe, the Fast-R Nitro Elite. The activation consisted of a shakeout run and live lunch podcast and took place...

Business

Events

Press Releases

Products

Running

Trade Shows

December 22, 2021

GO Sleeves Signs Partnership Deal with World Champion Runner Joseph Gray and World Champion Triathlete Josiah Middaugh

San Jose, CA /ENDURANCE SPORTSWIRE/ - GO Sleeves, the company that introduced the world’s first and only compression sleeve with built-in kinesiology strips, announced today the signing of World Champion Runner Joseph Gray and Professional Triathlete Josiah Middaugh to an ongoing partnership contract. “I couldn’t be more excited or proud...

Cycling

Press Releases

Products

Running

Sponsorship

Triathlon