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

September 15, 2021

Mountain Hardwear Releases Two New Backcountry Ski Packs; Snoskiwoski 40™ and Powabunga 32™

Richmond, Calif. (September 15, 2021) - Mountain Hardwear, a leader in performance equipment and apparel for climbers, mountaineers, and athletes, has introduced the new snowsports-focused Snoskiwoski 40™ and Powabunga 32™packs. After nearly seven years of product development in conjunction with Mountain Hardwear athletes, the two packs are designed with ski...

Press Releases

Products

September 14, 2021

Saucony® Unveils New Endorphin Pro+

WALTHAM, MA (September 14, 2021) – Today, global performance running lifestyle brand Saucony announces that fast just got faster with the launch of the Endorphin Pro+, the latest iterative advancement in the brand’s award-winning Endorphin Collection. Now with a reengineered ultra-light upper, Saucony’s fastest carbon-plated shoe will be unveiled by...

Press Releases

Products

September 14, 2021

LEOMO Launches Running Performance Clinic in U.S.

Boulder, CO (September 14, 2021) — LEOMO Inc., a company that helps runners and triathletes of all levels improve their technique and form with products and direct-to-customer services that enable faster, stronger, more efficient, injury-free running, has launched its Running Performance Clinic service in the U.S. In most running form...

Cycling

Press Releases

Products

Running

Triathlon

September 13, 2021

Rewire Fitness Launches First-To-Market Neuro Performance Mobile Platform for Athletes

NEW YORK, Sept. 13, 2021 – Rewire Fitness today announced the launch of its first-to-market neuro performance mobile platform designed to holistically quantify athlete readiness, build mental resilience, and improve mind/body recovery. To further elevate the athlete experience, Rewire’s training hardware solution will be available for preorder later this month...

Cycling

Press Releases

Products

Running

Triathlon

September 8, 2021

Kryptonite Lock Launches Comprehensive, Retailer-Focused Education Guide For E-Bike Users

Canton, MA, USA – Kryptonite®, a brand of Allegion and manufacturer of class-leading locks, lights and security solutions for the bicycle industry, has launched a comprehensive online and in-store resource guide to help e-bike owners maintain the security of their valued purchase. The guide, which will be displayed through in-store...

Cycling

Press Releases

Products