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 23, 2023

Malibu Triathlon Returns to Benefit Pediatric Cancer Research Program at Children’s Hospital Los Angeles

MALIBU, Calif. /ENDURANCE SPORTSWIRE/ - The Malibu Triathlon, presented by Super League Triathlon returns to Zuma Beach for its 38th Annual swim-bike-run race weekend on Sept. 30 - Oct. 1, 2023. More than 5,000 athletes, including Hollywood celebrities, will test their fitness as they raise critical funds for the Pediatric Cancer...

Giving

Press Releases

Triathlon

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