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 (21084)
) 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 460, 10

September 21, 2021

Arthritis Foundation’s California Coast Classic Bicycle Tour Presented by Amgen is Back for 2021

SAN FRANCISCO – September 21, 2021 /ENDURANCE SPORTSWIRE/ -- The Arthritis Foundation’s California Coast Classic (CCC) Bike Tour presented by Amgen left San Francisco on Saturday morning for its annual 525-mile eight-day bicycle tour to raise $1 million for the Arthritis Foundation. As of Monday morning, the CCC’s 165 in-person...

Cycling

Events

Giving

Press Releases

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 16, 2021

Running legend and global health and wellness advocate Meb Keflezighi joins Kilter Board of Advisors to connect active lifestyles with important causes

MADISON, WI (September 16, 2021) -- Meb Keflezighi, the only athlete ever to win the Boston and New York City Marathons and an Olympic marathon medal, will join the Kilter Board of Advisors, it was announced today by Seth Braddock, Kilter Founder & CEO. The newly created Kilter Board of...

Business

Events

Giving

Press Releases

Running

September 13, 2021

IRONMAN Foundation to Support Local Initiatives in St. George, Utah in Conjunction with 2021 Intermountain Healthcare IRONMAN 70.3 World Championship Presented by Utah Sports Commission

GEORGE, Utah. / TAMPA, Fla. (September 13, 2021) – The IRONMAN Foundation® will distribute more than $45,000 in giveback to charitable initiatives and groups in the greater St. George region in conjunction with the 2021 Intermountain Healthcare IRONMAN® 70.3® World Championship presented by Utah Sports Commission, including a service project...

Giving

Press Releases