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 (8742)
) 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 6570, 10

September 21, 2021

Yamaha Bicycles Presents e-Bike Class at Ride Santa Barbara 100

SANTA BARBARA, Calif. – September, 2021 – Ride Santa Barbara 100 (RideSB100), the premier cycling event on the American Riviera, is announcing its 2021 e-Bike class presented by Yamaha Bicycles. As part of the Yamaha Bicycles sponsorship, Yamaha is funding the activation of an All Kids Bike program in Santa...

Cycling

Events

Giving

Press Releases

September 20, 2021

2,500 Cyclists ‘Revel in the Woods’ At 38th Annual Chequamegon MTB Festival

CABLE, Wis., Sept. 18 – Life Time played host to cyclists from around the country in the remote Wisconsin towns of Hayward and Cable Wisconsin this weekend during the 38th annual Chequamegon MTB Festival, which featured $10,000 in prize purse winnings for 2021. The event’s signature distance features 40-miles of...

Cycling

Events

Press Releases

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

InsideTracker Partners with Shalane Flanagan on World Marathon Majors Feat, Project Eclipse

CAMBRIDGE, Mass.— Sept. 20, 2021— Shalane Falanagan today announced Project Eclipse, a mission to run all six World Marathon Majors, starting September 26 in Berlin and concluding November 7 in New York City, at the site of her 2017 championship win. InsideTracker, the leading truly personalized performance and nutrition system...

Press Releases

Running

Sponsorship

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

Nearly 40 Teams Prepare to Take on the 2021 GAP Relay presented by UPMC Health Plan

PITTSBURGH (September 20, 2021) – The 2021 GAP Relay presented by UPMC Health Plan opened registration with its brand-new experience for runners on the Great Allegheny Passage from Pittsburgh to Cumberland, Md. There are currently 38 teams registered for this year’s event. Previously, the event ran in the opposite direction...

Events

Press Releases

Running

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

Kerrville Triathlon Expects Record Numbers for 10th Anniversary Celebration

AUSTIN, Texas, September 20, 2021 -- The Kerrville Triathlon Festival is ready to welcome the largest field in its 10-year history for triathlon’s return to the Texas Hill Country. With close to 1800 registrants from 20 states bringing their friends and families, Kerrville Tri continues to showcase why it’s a...

Events

Press Releases

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