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

August 18, 2023

Austin Marathon Donates over $600,000 to Charity

AUSTIN, Texas /ENDURANCE SPORTSWIRE/ – The Ascension Seton Austin Marathon is excited to announce the total amount of money raised for the selected 2023 charities for their Austin Marathon Gives program. Austin Marathon Gives, presented by the Moody Foundation, is the Official Charity Program for the Austin Marathon®. Each non-profit raised awareness...

Events

Giving

Press Releases

Running

August 14, 2023

USA Triathlon Foundation Raises $180k at the USA Triathlon Foundation Gala and Hall of Fame Induction

MILWAUKEE, Wis. /ENDURANCE SPORTSWIRE/ - More than $180,000 was raised to support the USA Triathlon Foundation’s mission of swim, bike and run for all during the 2023 USA Triathlon Foundation Gala and Hall of Fame Induction, which was attended by more than 430 people on Aug. 3 at Discovery World...

Events

Giving

Press Releases

Triathlon

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