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 (8742)
) 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 30, 10

September 27, 2024

TruMoo Named Official Chocolate Milk Partner for 40th Long Beach Marathon

LONG BEACH, Calif. — September 27, 2024 /ENDURANCE SPORTSWIRE/ - In celebration of National Chocolate Milk Day, the Long Beach Marathon and Half Marathon is proud to announce a renewed partnership with TruMoo, naming it the official chocolate milk partner for the 40th edition of the race on October 6,...

Events

Press Releases

Running

Sponsorship

September 27, 2024

Treat Public Relations Takes Home Five Trophies at 2024 PROTOS Awards

MISSION VIEJO, Calif. /ENDURANCE SPORTSWIRE/ – Treat Public Relations, the endurance sports industry’s premier public relations partner, added five more trophies to their collection at the Public Relations Society of America Orange County chapter’s annual PROTOS Awards on Thursday night. Treat PR took home one PROTOS Award and four Awards...

Awards

Press Releases

September 27, 2024

Tadej Pogacar’s Limited Edition Colnago V4RS

Colnago and Tadej Pogačar are pleased to present a special bike, the limited edition Colnago V4Rs Tadej, that he will use to race at the World Championships in Zurich on September 29th. The colorful livery is inspired by all the successes collected by the Slovenian so far. Zurich, September 2024...

Cycling

Press Releases

Products

September 27, 2024

CrewLAB and Rowing New Zealand Launch Strategic Partnership to Revolutionize Talent Pathways for All National Teams

AUCKLAND, NEW ZEALAND - September 27, 2024 /ENDURANCE SPORTSWIRE/ - CrewLAB, a leading sports technology company, and Rowing New Zealand (RNZ) today announced a groundbreaking partnership aimed at transforming the talent pathway system for rowing in New Zealand. This collaboration will leverage CrewLAB's cutting-edge technology and data intelligence to enhance...

Business

Press Releases

Products

Sponsorship

September 27, 2024

PeopleForBikes Celebrates One Year Helping Transform Communities by Advancing Thousands of Bicycle Projects Nationwide.

BOULDER, COLO. /ENDURANCE SPORTSWIRE/ - One year after launching, PeopleForBikes, a national bicycle advocacy organization and the U.S. bicycle industry’s trade association, is proud to share progress from its Great Bike Infrastructure Project (GBIP). The ambitious initiative is fast-tracking thousands of bike projects and policies across all 50 states, focused...

Business

Cycling

Events

Giving

Press Releases

Studies

September 26, 2024

Showcased

The NJCX Project, a USA Cycling Center of Excellence, Adds Road Program for 2025

/ENDURANCE SPORTSWIRE/ - Founded in 2017, the NJCX Project aimed to develop more student-athlete cyclists through cyclocross development. In 2023, after several years of cyclocross success in the Mid-Atlantic Conference and at the USCX National Series, the team expanded into road racing through a major partnership with Verge Sport’s American...

Cycling

Press Releases

September 26, 2024

Middaugh, Billouin Capture Final Short Track Victories of the 2024 XTERRA World Cup

MOLVENO, TRENTINO, ITALY /ENDURANCE SPORTSWIRE/ – On September 26, the 2024 XTERRA World Championship four-day festivities aired live with the Short Track Race as Sullivan Middaugh (USA) and Solenne Billouin (FRA) secured their wins in a made-for-TV competition at the penultimate showdown of the 2024 XTERRA World Cup. Set against...

Cycling

Events

Press Releases

Running

Triathlon