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

September 21, 2021

Marathon-Photos LIVE reaches USA

September 21, 2021 /ENDURANCE SPORTSWIRE/ -- Hot on the heels of its Live photography launch in the UK, world-leading endurance photo company MarathonPhotos.Live has launched its ground-breaking new service in the United States. Runners in San Francisco Marathon had their photos online within seconds of passing photographers – both on...

Press Releases

Products

Running

Triathlon

September 21, 2021

Lucyd SMART Eyewear Launches Lyte Sport

Miami, FL: Lucyd, the brand of Bluetooth-enabled sunglasses announces today the launch of its lineup of SMART eyewear designed for the sports market. In addition to its current assortment of lifestyle-focused designs, Lucyd is rolling out the “Lyte Sport” capsule collection of its popular Lyte frames, which offer a sleek...

Press Releases

Products

September 20, 2021

Introducing The Lyric™ Therapeutic Massager, An Evolution in Self-Care

SANTA MONICA, Calif., Sept. 20, 2021 – Today marks an evolution in self-care with the launch of the new Wi-Fi-enabled Lyric™ therapeutic massager. Say goodbye to ugly, aggressive and heavy massage guns made only for elite athletes. The stylishly designed Lyric was developed with everybody – and every body –...

Business

Press Releases

Products

September 20, 2021

Gold-medal rowers turn to Myovolt technology during Olympic preparation

In preparation for this year's Olympic Games, getting treatments for warm-up or recovery physiotherapy was often limited to a Zoom session. Add to this the stress of being in travel quarantine and it’s clear that many athletes were forced out of their comfort zone, with  stark changes to their routines....

Press Releases

Products

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