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

January 26, 2024

USA Triathlon Foundation Announces 7 New Board Trustees for 2024

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – The USA Triathlon Foundation today announced the addition of seven new Board Trustees: Justin Model, Marci Jenkins, Mike Wien, Rick Hrabchak, Rosalind Jarrett-Sepulveda, Nathan Stuhlmacher and Cameron Hamilton. Represented by a strong group of business and non-profit professionals and age group athletes, the USA Triathlon Foundation Board of...

Giving

Press Releases

Triathlon

January 26, 2024

Challenged Athletes Foundation Rolls Out Five Top-Notch Cycling Experiences in 2024 to Raise Crucial Funds for Athletes with Physical Disabilities

SAN DIEGO, CA. /ENDURANCE SPORTSWIRE/ - Celebrating its 30th anniversary of empowering individuals through sports, the Challenged Athletes Foundation (CAF) proudly announces the launch of the 2024 CAF Cycling Challenge, a series of first-class riding experiences that embody inclusivity, celebrate community, and provide hope and inspiration for athletes with physical...

Cycling

Giving

OSW Syndicated

Press Releases

January 25, 2024

Explore Orange County While Pedaling For a Cause at Tour de Saddleback

IRVINE, Calif. /ENDURANCE SPORTSWIRE/ – The Tour de Saddleback returns for its annual event and will be offering 50, 35 and 15-mile ride options through scenic parts of Orange County. Participants have the opportunity to ride through seven different communities and cities, including Laguna Hills, Santiago Canyon, Rancho Santa Margarita and...

Cycling

Events

Giving

Press Releases

January 23, 2024

Red Knot Development releases Pasha, a film about cycling in Tanzania

Arusha, Tanzania /January, 2024/ENDURANCE SPORTSWIRE/ – Red Knot Development and Red Knot Racing Company have released PASHA, a film about Tanzanian cyclist and now coach Richard Laizer. Laizer grew up in the village of Olasiti, where he found success on a bike as a youngster, despite the disapproval of others in his...

Cycling

Giving

OSW Syndicated

Press Releases

Products

January 19, 2024

KeyBank Named Title Partner of the Run for a Reason Charity Program for the 2024 DICK’S Sporting Goods Pittsburgh Marathon

PITTSBURGH, PA (January 19, 2024) /ENDURANCE SPORTSWIRE/ – P3R, the engine behind Pittsburgh's most exhilarating sporting events, has announced that KeyBank has been named title partner of the Run for a Reason Charity Program for the 2024 DICK’S Sporting Goods Pittsburgh Marathon Weekend of Events. More than 2,700 charity runners are...

Events

Giving

Press Releases

Running

Sponsorship

January 16, 2024

California Coast Classic Raises Total Fundraising Goal for 2024 after Banner Year

LOS ANGELES – January 16, 2024 /ENDURANCE SPORTSWIRE/ – The California Coast Classic, known as “The Ride of a Lifetime” for its fully supported format and epic route from San Francisco to Los Angeles along the California Coast, is back for 2024 with a bigger-than-ever fundraising goal of $1.5 million. “With...

Cycling

Events

Giving

Press Releases