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

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

October 18, 2021

Showcased

The Giro D’italia Virtual Hosted by Bkool Started on Friday, October 15th

The Giro d’Italia Virtual hosted by BKOOL, an indoor cycling project developed by RCS Sport in collaboration with BKOOL, kicked off on Friday morning. The event offers cycling fans the opportunity to experience multiple stages of the Corsa Rosa from home, riding their own bike, through a high-definition video simulation...

Cycling

Events

Press Releases

October 18, 2021

Spaero Triathlon Launches with State-of-the-Art Performance Gear and New Ambassador Team

Vista, CA. (October 18, 2021) Spaero Triathlon - a California-based advanced technical triathlon apparel brand formerly known as Wattie Ink, announces its new brand name, Spaero Triathlon, with a new line of advanced technical triathlon gear and robust ambassador team program. Headquartered in the birthplace of the sport, San Diego,...

Business

Press Releases

Triathlon

October 17, 2021

Funk and Spirig Take Titles at Challenge Peguera-Mallorca

The CHALLENGEFAMILY European season closed in style today with world-class racing at CHALLENGEPEGUERA-MALLORCA and stunning wins from Frederic Funk (DEU) and Nicola Spirig (SUI). The day started with a calm swim in perfect conditions and Lucy Hall (GBR) showed her dominance in the women’s race, catching the back markers of the pro men, despite...

Events

Press Releases

Triathlon

October 16, 2021

Runners Complete 150-Mile Relay from Pittsburgh to Cumberland, Md. in the Fourth Annual GAP Relay Presented by UPMC Health Plan

PITTSBURGH (October 16, 2021) – The GAP Relay presented by UPMC Health Plan was back to a live start line with brave participants testing their grit and running the entire 150-mile Great Allegheny Passage. This year 40 relay teams, comprised of more than 240 runners from 16 states, participated in...

Events

Press Releases

Running

October 15, 2021

Diamondback’s Eat My Dust Gravel Scholarship Returns for its Second Year

KENT, Wash., (October, 15, 2021) — Diamondback, a leader in the gravel cycling space, and professional triathlete and gravel racer Rach McBride have teamed up for the second annual Gravel Scholarship. This year with a new name, the Eat My Dust Gravel Scholarship, which will aim to encourage more female,...

Cycling

Giving

Press Releases

Triathlon