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

October 19, 2021

Showcased

The Application Window for the 2022 Bank of America Chicago Marathon Opens Today

CHICAGO /ENDURANCE SPORTSWIRE/ - Today the Bank of America Chicago Marathon announced it is accepting applications for the 2022 event at chicagomarathon.com. The launch of the 2022 application continues Chicago’s return to racing and builds on the excitement seen over a week ago when 26,122 participants crossed the finish line...

Events

Press Releases

Running

October 19, 2021

USA Triathlon’s Together, We Thrive Initiative Wins USOPC Diversity Equity and Inclusion Award

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ - The United States Olympic & Paralympic Committee today announced USA Triathlon’s Together, We Thrive initiative as the recipient of its annual Diversity, Equity & Inclusion Choice Award, the fourth time the organization has been honored by the USOPC for its diversity and inclusion efforts since...

Awards

Press Releases

Triathlon

October 19, 2021

KOM Cycling Signs Deal with Bob Elliot & Co LTD, For UK Distribution

East Lansing, Michigan (October 19, 2021) /ENDURANCE SPORTSWIRE/ - With record numbers of people across the globe, KOM Cycling has been working to expand their distributor network, and they’ve found their ideal partners in Bob Elliot & CO Ltd, which boasts decades of relevant experience and the requisite network to maximize...

Business

Cycling

Press Releases

Triathlon

October 19, 2021

Showcased

BikeFlights Makes It Easier To Ship E-Bikes

PORTLAND, OR (October 19, 2021) /ENDURANCE SPORTSWIRE/ - BikeFlights.com, a bicycle shipping service and bike box supplier, has just made it easier for individual cyclists and businesses to ship e-bikes within the contiguous U.S. “As more people have purchased e-bikes, the need to buy and sell as well as travel...

Business

Cycling

Press Releases

Products

October 19, 2021

Elite Runner Releases New Book about Running and Training Throughout Pregnancy and into the Fourth Trimester

/ENDURANCE SPORTSWIRE/ - Natasha LaBeaud Anzures, an elite runner for Canada, has just released a new book entitled, “Pregruncy: An Elite Runner’s Journey Training Through Pregnancy.” The book details every day of pregnancy and the first 90 days postpartum, which workout logs, personal thoughts, and training notes from both the...

Press Releases

Products

Running

October 18, 2021

Ride Santa Barbara 100 Celebrates 10th Anniversary This Weekend

SANTA BARBARA, Calif. – Oct. 18, 2021 /ENDURANCE SPORTSWIRE/ - After a pandemic-forced hiatus in 2020, Ride Santa Barbara 100 (RideSB100), the premier cycling event set on California’s Central Coast, returns to Leadbetter Beach this Saturday October 23, 2021, with its largest event in 10 years. Registration is sold out...

Cycling

Events

Giving

Press Releases

October 18, 2021

IRONMAN Foundation to Provide $35,000 in Charitable Giveback to Northern California Community in Conjunction with IRONMAN California

SACRAMENTO, Calif./TAMPA, Fla. (October 18, 2021) – In conjunction with the IRONMAN® California triathlon, the IRONMAN Foundation® will continue its mission of creating tangible impact in IRONMAN race communities throughout Northern California next week, by distributing over $35,000 in grants to nonprofit initiatives within the region. In addition, the IRONMAN Foundation...

Events

Giving

Press Releases

Triathlon