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

October 13, 2021

The CAF Million Dollar Challenge Celebrates 15th Anniversary

SAN FRANCISCO – October 13, 2021 – Later this month, over 160 cyclists, including 20 individuals with permanent physical challenges will ride along the California Coast in support of Challenged Athletes Foundation 15th Annual Million Dollar Challenge presented by Sully Entertainment (MDC). This annual bike ride has earned a reputation...

Cycling

Giving

Press Releases

October 7, 2021

Road Runners Club of America Announces 2021 Kids Run the Nation Grant Recipients

ARLINGTON, Virginia – October 7, 2021 – The Road Runners Club of America (RRCA) is pleased to announce the 2021 Kids Run the Nation grant recipients. Since the grant fund’s inception in 2007, the RRCA has distributed more than $310,000 to youth running programs nationwide. This year, 17 programs from...

Giving

Press Releases

Running

October 7, 2021

CAF Brings Back High Fives and Finish Lines to Reunite the Community and Raise Millions of Dollars for Athletes with Physical Challenges

SAN DIEGO, CA — October 7, 2021 – Returning in-person this year, Challenged Athletes Foundation reignites its Community Challenge, powered by Strava and the 28th annual Aspen Medical Products San Diego Triathlon Challenge with an all-new location on October 22-24. This community weekend features an extraordinary series of events that...

Giving

Press Releases

Triathlon

October 6, 2021

Showcased

GiveSignup | RunSignup Announces GivingTuesday $50K Grants Giveaway

Moorestown, NJ (October 6, 2021) — GiveSignup | RunSignup is excited to announce the GivingTuesday $50K Grants Giveaway. The first 500 nonprofit organizations with a 501(c)(3) designation that raises at least $100 with their GivingTuesday campaign on the GiveSignup | RunSignup free platform on November 30, 2021 will receive a...

Giving

Press Releases

Running

October 1, 2021

Women Who Rally: Pensacola Sports Gears Up for 2021 Women’s Half Marathon

Pensacola, Fla. (October 01, 2021) – This one is for the ladies! Pensacola Sports and Rally Pensacola are gearing up for the annual Women’s Half Marathon, presented by Publix. Be a part of this unique event, dedicated to empowering women within the Gulf Coast running community. Taking place Sunday, Nov. 7,...

Events

Giving

Press Releases

Running

October 1, 2021

Booze and Tennis: 2021 Bud Light Tennis Challenge Is on The Horizon

Pensacola, Fla. – (October 01, 2021)) – Start warming up those backhand and topspin hits; Pensacola Sports is two weeks away from hosting the 16th annual Bud Light Tennis Charity Challenge This year’s event takes place October 15-16 at Roger Scott Tennis Center and consists of men and women team...

Events

Giving

Press Releases

September 30, 2021

Running In Solidarity to Bring Our Communities Together

San Francisco, CA – Established in 2011, the Japanese Community Youth Council (JCYC)’s SF Aloha Run annually takes place at San Francisco’s scenic Crissy Field.  As we continue to strive to move past the pandemic, this year’s SF Aloha Run will be both in-person and virtual.  The theme of the...

Giving

Press Releases

Running

September 29, 2021

Crohn’s & Colitis Foundation and Zwift Ride Series Begins this Friday

New York, NY - Zwift and the Crohn’s & Colitis Foundation have partnered for a weekend ride series taking place October 1-3, 2021. Riders will have the chance to ride with 4th place Tokyo Paralympic Triathlete Fran Brown and professional cyclist Cory Greenberg; both patients living with Crohn’s disease or...

Cycling

Giving

Press Releases