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

October 19, 2021

“Show Your St. Jude Spirit” campaign to rally global community for 20th annual St. Jude Memphis Marathon Weekend

MEMPHIS, Tenn. (October 19, 2021) /ENDURANCE SPORTSWIRE/ - St. Jude Memphis Marathon® Weekend presented by Juice Plus+® today announced a new Show Your St. Jude Spirit campaign to celebrate 20 years running and unite St. Jude supporters in Memphis and beyond to generate funds for the lifesaving mission of St....

Giving

Press Releases

Running

October 18, 2021

Ride Santa Barbara 100 Celebrates 10th Anniversary This Weekend

SANTA BARBARA, Calif. – Oct. 18, 2021 /ENDURANCE SPORTSWIRE/ - After a pandemic-forced hiatus in 2020, Ride Santa Barbara 100 (RideSB100), the premier cycling event set on California’s Central Coast, returns to Leadbetter Beach this Saturday October 23, 2021, with its largest event in 10 years. Registration is sold out...

Cycling

Events

Giving

Press Releases

October 18, 2021

IRONMAN Foundation to Provide $35,000 in Charitable Giveback to Northern California Community in Conjunction with IRONMAN California

SACRAMENTO, Calif./TAMPA, Fla. (October 18, 2021) – In conjunction with the IRONMAN® California triathlon, the IRONMAN Foundation® will continue its mission of creating tangible impact in IRONMAN race communities throughout Northern California next week, by distributing over $35,000 in grants to nonprofit initiatives within the region. In addition, the IRONMAN Foundation...

Events

Giving

Press Releases

Triathlon

October 15, 2021

Diamondback’s Eat My Dust Gravel Scholarship Returns for its Second Year

KENT, Wash., (October, 15, 2021) — Diamondback, a leader in the gravel cycling space, and professional triathlete and gravel racer Rach McBride have teamed up for the second annual Gravel Scholarship. This year with a new name, the Eat My Dust Gravel Scholarship, which will aim to encourage more female,...

Cycling

Giving

Press Releases

Triathlon

October 14, 2021

Free Shuffle for SHARE 5K

Vancouver WA The 2nd annual Shuffle for Share 5K is a FREE virtual event with a mission to make a difference and help those in need. Although walkers and runners won’t be together physically, they will be together in spirit as they raise funds for SHARE, a local non-profit who...

Giving

Press Releases

Running

October 13, 2021

Parcours and Kogel Bearings Partner to Offer The Ultimate Triathlon Bike Upgrade Package

British-brand Parcours (https://www.parcours.cc/)  are pleased to announce the launch of a competition sweepstake between themselves and Kogel Bearings, to take the winners' performance to the next level. The sweepstake prize will offer the lucky winner an upgrade package to vastly improve the aerodynamics and efficiency of a bike of their...

Cycling

Giving

Press Releases

Products

Triathlon

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