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 (16)
) 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 5350, 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 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 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 14, 2021

TCS London Marathon to host the 2022 AbbottWMM Wanda Age Group World Championships

Following the successful inaugural AbbottWMM Wanda Age Group World Championships in London earlier this month, organizers announced today that the 2022 edition will return to the British capital as part of the TCS London Marathon on October 2, 2022. Qualifying for the 2022 World Championships began on January 1, 2021...

Events

Press Releases

Running