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

August 4, 2023

Cape Cod Coffee Releases a Special Edition Coffee in Honor of Rick and Dick Hoyt

FALMOUTH, Mass. /ENDURANCE SPORTSWIRE/ – In anticipation of the ASICS Falmouth Road Race, sponsor Cape Cod Coffee has released a special new roast that pays tribute to two of the most iconic participants in the famous road race. The Coffee for a Cause program has chosen The Hoyt Foundation, which was...

Giving

Press Releases

Products

Running

August 2, 2023

Bikeflights Expands Buck Up For Bikes

PORTLAND, OR (August 2, 2023) /ENDURANCE SPORTSWIRE/ – Bikeflights, a bicycle shipping service trusted by riders worldwide, is pleased to announce the addition of World Bicycle Relief to its Buck Up For Bikes program. Since its launch in 2016, Buck Up For Bikes has raised more than $120,000 for non-profit...

Cycling

Giving

Press Releases

July 28, 2023

USA Triathlon Foundation Supports i-tri as First Founding Impact Partner

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – The USA Triathlon Foundation today announced a five-year partnership with nonprofit i-tri, which empowers adolescent girls through the sport of triathlon, as the organization’s first Founding Impact Partner. Through the Founding Impact Partner Program, the USA Triathlon Foundation supports community organizations dedicated to making an impact related...

Giving

Press Releases

Triathlon

July 26, 2023

ASICS Falmouth Road Race Renews Numbers for Nonprofits Partnership with Iconic Massachusetts Charities

FALMOUTH, Mass. /ENDURANCE SPORTSWIRE/ – As the ASICS Falmouth Road Race on Aug. 20 draws near, the Dana-Farber Cancer Institute and the Jimmy Fund has partnered with the event again to present the Numbers for Nonprofits Program (NFNP). This collaboration powers the fundraising efforts of more than 3500 runners who choose...

Events

Giving

Press Releases

Running

July 21, 2023

Louisiana Half Marathon Champion, Jarrett Leblanc, Sets Out to Break World Record and Raise Funds for Children’s Heart Health

Lafayette, LA/ENDURANCE SPORTSWIRE/ – Louisiana Half Marathon 2021 Champion and Ochsner cardiac sonographer, Jarrett Leblanc, is gearing up for an extraordinary feat as he attempts to overtake the world record for the fastest half-marathon run on a treadmill. The remarkable event is scheduled to take place at Red Lerille's Health and...

Giving

Press Releases

Running

July 17, 2023

Inaugural PNC Presents Rush to Crush Cancer Raised More than $600,000 for UPMC Hillman Cancer Center

PITTSBURGH, PA (July 17, 2023) /ENDURANCE SPORTSWIRE/ – The inaugural PNC presents Rush to Crush Cancer, held on May 19-20, raised more than $600,000 for cancer research at the UPMC Hillman Cancer Center. During the event, 828 riders from 20 states cycled 16,480 miles while inspiring more than 4,000 charity donations....

Cycling

Events

Giving

Press Releases

July 14, 2023

Recovery Footwear Leader OOFOS, 98.5 The Sports Hub & Boston Bruins Goalie Jeremy Swayman Present $24,730 “Kick Saves for Cancer” Check to Dana-Farber Cancer Institute

July 14, 2023 /ENDURANCE SPORTSWIRE/ – The “Kick Saves for Cancer'' campaign check presentation to Dana-Farber Cancer Institute from Bruin's Goalie and OOFOS OOcrew member Jeremy Swayman recently took place at The Dana1Farber Cancer Institute in Brookline, MA. Throughout the Bruins season and the playoffs, OOFOS, the global leader in recovery...

Giving

Press Releases

July 13, 2023

National Cycling League and Wish For Wheels Forge Community-Based Partnership

DENVER/ENDURANCE SPORTSWIRE/ – The National Cycling League (NCL) and Wish for Wheels are thrilled to announce a continuation of their partnership to promote cycling to drive community-building in Denver, Colorado. The NCL, the first gender-equal professional sports league in the U.S. and the first majority women-and minority-owned league, is committed to reimagining...

Cycling

Giving

Press Releases

Sponsorship

Triathlon