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

July 20, 2023

World Class Field on Show at Challenge London

London, UK /ENDURANCE SPORTSWIRE/ – The professional field for this year’s Challenge London has been announced, with an array of international triathlon talent set to head to the world’s biggest city centre triathlon. Amongst the highlights announced to race the event’s new Middle distance are Fenella Langridge (GBR), ranked 13th in the...

Events

Press Releases

Triathlon

July 20, 2023

Bears, moose, mud, nasty bushwhacking – Teton Ogre’s ninth edition gets dirty

/ENDURANCE SPORTSWIRE/ - The ninth edition of the Teton Ogre Adventure Race took place June 24-25 in beautiful Teton Valley, Idaho, on the west side of the Teton range. The Ogre offers a 24-hour race as well as an 8-hour option. Racers must use map and compass to navigate via bike...

Events

Press Releases

July 19, 2023

Application Window Now Open for 2024 Boston Marathon Medical Research Funding Program

BOSTON /ENDURANCE SPORTSWIRE/ – The Boston Athletic Association (B.A.A.) is now accepting letter of intents from scientific researchers interested in being part of the 2024 Boston Marathon Medical Research Funding Program at the 128th Boston Marathon presented by Bank of America, to be run on April 15, 2024. The B.A.A. Medical...

Events

Press Releases

Running

Studies

July 19, 2023

RBC GranFondo Whistler announces new military categories in support of Invictus Games Vancouver Whistler 2025

[Vancouver / Whistler, BC]/ENDURANCE SPORTSWIRE/ - In April 2022, Prince Harry, The Duke of Sussex, announced as the Founding Patron of the Invictus Games Foundation that the bid for the Invictus Games 2025 had been awarded to Canada. The Games will occur from February 6 to 17, 2025, in Vancouver...

Business

Cycling

Events

Press Releases

July 19, 2023

2nd Annual Asheville Bike Fest Grows to Include Expo, Industry Night, Film Fest, and Gran Fondo

(Gettysburg, PA – July 19, 2023) /ENDURANCE SPORTSWIRE/ - The second annual Asheville Bike Fest, presented by Cane Creek, attracted cyclists from all over the nation to Asheville, North Carolina, on July 14-16. Activities included a cycling expo at Rabbit Rabbit in downtown Asheville, industry night, bicycle-themed film festival, and...

Cycling

Events

Press Releases

July 18, 2023

Hendersonville Local Luca Shaw and Anna Newkirk Win 2023 Elite Downhill National Titles at Ride Rock Creek

RIDE ROCK CREEK, N.C. /ENDURANCE SPORTSWIRE/ – The 2023 USA Cycling Gravity Mountain Bike National Championships concluded on Sunday in Zirconia, North Carolina. The final day of competition saw hundreds of athletes vying for the national downhill title across multiple age groups. Athletes from across the country took to the three-quarter...

Cycling

Events

Press Releases