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

January 4, 2022

Juice Plus+ Launch Perform – A Food Supplement Shake that Works as Hard As You Do

/ENDURANCE SPORTSWIRE/ - Leading health and wellness company Juice Plus+ are excited to announce the launch of the latest addition to their plant-based nutrition portfolio, Juice Plus+ Perform, a fruit-fusion flavoured food supplement shake designed to support multiple aspects of your fitness regime. Juice Plus+ Perform is an all-in-one protein performance...

Press Releases

Products

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