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

September 20, 2021

Sports Photography makes a splash in Hyde Park at the Children with Cancer UK Swim Serpentine

Photography of mass sporting events has taken a leap forward thanks to a new space-enabled service used at the prestigious Children with Cancer UK Swim Serpentine. While swimmers taking part would have in the past expected to wait days for pictures from the event organisers, thousands of photos were today...

Events

Press Releases

Products

September 20, 2021

Supersapiens Launches New Real-Time Data Display Wearable, The Supersapiens Energy Band

ATLANTA, 20 September 2021 — Supersapiens ecosystem, powered by Abbott’s Libre Sense Glucose Sport Biosensor, announced today the first Supersapiens glucose display wearable designed specifically for athletes. The Supersapiens Energy Band, Version Zero is the first and only wearable device that can read sport glucose data directly from Abbott’s Libre...

Cycling

Press Releases

Products

Running

Triathlon

September 20, 2021

Mongoose Resurrects Legendary Designs In Classics Collection

MADISON, Wis. (September 20, 2021) – Few bikes have defined a generation of innovation and design the way Mongoose’s iconic designs of the 1970’s and 1980’s did for BMX. The brand’s Supergoose and California Special inspired generations of cyclists with new technologies, unique styling, and the professional athletes who rode them....

Cycling

Press Releases

Products

September 16, 2021

TrainerRoad Announces Adaptive Training Open Beta and Free Trial, Providing Cyclists Early Access to the Future of AI-Powered Training

RENO, Nevada (September 16, 2021) – TrainerRoad, cycling’s most complete & effective training system and the market leader in making athletes faster, is excited to announce the open beta availability of their new Adaptive Training system, offering personalized training powered by advanced machine learning for every cyclist. TrainerRoad now offers...

Business

Cycling

Press Releases

Products

September 16, 2021

Ventum Launches the All-New Ventum One

HEBER CITY, Utah  – Ventum, a leader in high-performance gravel, road and triathlon bikes, is launching the All-New Ventum One, a revamped version of its flagship triathlon bike, the Ventum One. Developed over four years, the All-New Ventum One is the most aerodynamic bike the company has ever engineered and...

Cycling

Press Releases

Products

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