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

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

September 7, 2021

Ascent Protein Gains Distribution at Hannaford Supermarkets

DENVER, COLORADO - September 7, 2021 - Ascent, one of America’s fastest growing sports nutrition companies, announces distribution at Hannaford Supermarkets. Ascent Protein’s Recovery Water® is now available at 130 Hannaford’s supermarkets throughout the Northeast. Hannaford will carry Recovery Water® in Orange Mango, Fruit Punch and Pineapple Coconut flavors. Since...

Press Releases

Products