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

May 14, 2023

Adventure Race Croatia 2023 – From the River to the Sea

/ENDURANCE SPORTSWIRE/ – Adventure Race Croatia is back as an ARWS Qualifier this year, with the defending champions returning, a new location and a few innovations to add to the race. Thirty-two teams will be on the start line, with racers representing France, Croatia, Poland, Czech Republic, Ireland, Belgium, Netherlands, Italy,...

Events

Press Releases

May 13, 2023

Alistair Brownlee wins XTERRA debut at Weston Park, Lizzie Orchard wins women’s race

/ENDURANCE SPORTSWIRE/ - Alistair Brownlee (GBR) and Lizzie Orchard (NZL) won the inaugural XTERRA Weston Park off-road triathlons with winning times of 2:04:27 and 2:36:06, respectively, on a beautiful sunny day at the centuries-old Weston Park House in Staffordshire, England on Saturday, May 13, 2023. It’s the first XTERRA World...

Events

Press Releases

Triathlon

May 12, 2023

USATF Team Roster for World Mountain and Trail Running Championships

/ENDURANCE SPORTSWIRE/ – A stellar group of 42 athletes have been named to the 2023 USATF Teams slated to compete in the 2nd World Mountain and Trail Running Championships June 7-10 in Stubai - Innsbruck, Austria. A handful of athletes – 5 in total - will double up to run more...

Events

Press Releases

Running

May 12, 2023

Yimer, Kalayu Win Bloomsday 12K at First 2023-24 PRRO Circuit Stop

SPOKANE, WA /ENDURANCE SPORTSWIRE/ – Under cool, cloudy, near ideal conditions at the 47th Lilac Bloomsday Run 12K on Sunday morning, May 7, Ethiopians Jemal Yimer and Yeshi Kalayu produced fast winning performances, 33 minutes, 58 seconds and 38:49, respectively. At the annual spring 7.46 mile road race, the first stop...

Events

Press Releases

Running

May 12, 2023

Tree House Brewing Company Half Marathon Sells Out In One Day

DEERFIELD, Mass. /ENDURANCE SPORTSWIRE/ – The inaugural Tree House Brewing Company Half Marathon has already sold out entries, registering 1,100 runners for the brand-new event in just one day. The race will take place on Sunday, Sept. 17 at their stunning sanctuary-like campus neighboring Mount Sugarloaf in the heart of Western...

Events

Press Releases

Running

May 11, 2023

Showcased

Alistair Brownlee to make XTERRA debut in UK this Saturday

/ENDURANCE SPORTSWIRE/ - XTERRA returns to England for the first time since 2015 when the fifth stop on the XTERRA EMEA Tour descends upon the centuries-old Weston Park House in Staffordshire on Saturday, May 13, 2023. The inaugural event has attracted more than 500 competitors to the West Midlands region...

Business

Events

Press Releases

Triathlon

May 11, 2023

Record Number of First-Time Riders Register for California Coast Classic Bike Tour, presented by Amgen

LOS ANGELES – May 11, 2023/ENDURANCE SPORTSWIRE/ – Three years after the bike boom that reintroduced millions of Americans to their bicycles, organizers of the 2023 California Coast Classic Bike Tour, presented by Amgen, note that a record number of first-time riders have registered for the Arthritis Foundation’s annual national destination fundraiser,...

Cycling

Events

Giving

Press Releases

May 11, 2023

PTO Adds Singapore’s Mediacorp to Growing Roster for 2023 PTO Tour

London, UK/ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) has added Singapore’s Mediacorp to its growing roster of broadcasters for the 2023 PTO Tour. Mediacorp is Singapore’s largest content creator and national media network, operating a suite of TV channels, radio stations and multiple digital platforms. It will show the PTO Asian...

Events

Press Releases

Triathlon

May 11, 2023

America’s Top Pro Cycling Race Maryland Cycling Classic, presented by UnitedHealthcare Reveals Official Commemorative Jersey for 2023

BALTIMORE, Maryland (May 11, 2023)/ENDURANCE SPORTSWIRE/ – The Maryland Cycling Classic, presented by UnitedHealthcare, America’s top-ranked cycling race, today revealed its official commemorative jersey for 2023 designed by Athlos Sportswear. Headquartered in Baltimore, the custom cycling apparel company is returning as technical partner of the event for a second year, which takes...

Cycling

Events

Press Releases