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

October 29, 2024

VeloSwap Returns to Denver on November 2nd

DENVER, Colo • October 29, 2024 /ENDURANCE SPORTSWIRE/ - Gear up at VeloSwap with epic end-of-the-season deals and fun for the whole family. Join us at VeloSwap on November 2nd at the National Western Complex in Denver. Over 200 local and national vendors will be selling bikes, wheels, tires, clothing,...

Cycling

Events

Giving

Press Releases

October 28, 2024

Gran Fondo World Tour® adds a new event in Spain, Desafio Maestrat by Panama Van

/ENDURANCE SPORTSWIRE/ - Desafio Maestrat by Panama Van has officially joined the Gran Fondo World Tour® 2025 calendar , June 1st, when this epic event kicks off in Benicarló and takes riders through the beautiful, rugged landscapes of Castellón’s interior. Cyclists and gran fondo fans will face challenging roads designed...

Cycling

Events

Press Releases

October 28, 2024

Old Point National Bank Wicked 10K & 5K Carves Out a Successful Sold-Out 15th Anniversary Event

October 28, 2024 – VIRGINIA BEACH, VIRGINIA /ENDURANCE SPORTSWIRE/ – The Old Point National Bank Wicked 10K & 5K, presented by Bon Secours, proved to be a hauntingly good time as thousands of runners and spectators came out to participate in the Halloween-themed event. The race, which took place on...

Events

Press Releases

Running

October 28, 2024

Priority Tickets For The 2025 Etape Loch Ness Cycle Sportive Event Go Live

Inverness, Scotland 28th October /ENDURANCE SPORTSWIRE/– The countdown to Scotland’s largest closed-road cycle sportive 2025 is on. The highly anticipated Etape Loch Ness, now in its 11th year, will officially open priority entry on 29th October at 10am, offering cycling enthusiasts an exclusive 48-hour window to secure their spot. With...

Cycling

Events

Press Releases

October 28, 2024

Caldwell’s Joey Datta Takes Unprecedented Third Straight CACC Cross Country Championship, Named Runner of the Year

PHILADELPHIA /ENDURANCE SPORTSWIRE/- As Caldwell University senior Joey Datta (Edison, N.J./Edison H.S.) came through the finish line at Sunday's Central Atlantic Athletic Conference (CACC) Men's Cross Country Championships in a meet record time of 26:14.70, he brought with him an unprecedented third consecutive title and third CACC Runner of the...

Awards

Events

Press Releases

Running

October 27, 2024

Historic Day Sees Germany’s Patrick Lange Crowned 2024 Vinfast IRONMAN World Champion In Kailua-Kona, Hawai’i

KAILUA-KONA, Hawai`i /ENDURANCE SPORTSWIRE/ - It was a race for the ages in Kailua-Kona, as Patrick Lange (DEU) broke the tape with a new course best time of 7:35:53 and was crowned the 2024 VinFast IRONMAN World Champion, taking home $125,000 USD in prize money. In a race that saw...

Events

Press Releases

Triathlon

October 25, 2024

How To Watch: 2024 Vinfast IRONMAN World Championship in Kona, Hawai’i

- Live race day coverage of the professional men’s race will air around the world on Saturday 26 October beginning with body marking at 4:30 a.m. HST - Broadcast can be viewed globally (except for US & Canada) on proseries.ironman.com, DAZN and YouTube; Viewers in the U.S. and Canada can...

Events

Press Releases

Triathlon

October 25, 2024

2025 Ascension Seton Austin Marathon Opens Elite Athlete Program

AUSTIN, Texas, October 24, 2024 /ENDURANCE SPORTSWIRE/ - The Ascension Seton Austin Marathon is accepting applications from elite runners for the 2025 event taking place in Austin, Texas on Sunday, February 16th. Returning for its ninth year, the Elite Athlete Program creates a competitive field of elite male and female...

Events

Press Releases

Running

October 25, 2024

Challenged Athletes Foundation to Host CAF Community Weekend Fueled by Toyota Supporting Athletes with Physical Disabilities

SAN DIEGO, CA /ENDURANCE SPORTSWIRE/ – Challenged Athletes Foundation (CAF), a global leader in adaptive sports, is gearing up for its annual CAF Community Weekend fueled by Toyota. The flagship fundraising event, featuring the iconic San Diego Triathlon Challenge, will run from Friday, November 1 to Sunday, November 3 in...

Cycling

Events

Giving

Press Releases

Triathlon