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

December 13, 2022

Marathon Tours & Travel to be Exclusive International Tour Operator for Comrades Marathon

(13th December, UK) /ENDURANCE SPORTSWIRE/ – Marathon Tours & Travel offers comprehensive travel packages for the very best running events around the world and the team is thrilled to become the exclusive international tour operator for the 96th Comrades Marathon, to be held on Sunday 11th June 2023. Recognised internationally as ‘The...

Events

Press Releases

Running

December 13, 2022

Gran Fondo National Series and Zigbone Farm Retreat Announce Cycling Retreat in Maryland

Gettysburg, PA – December 13, 2022 /ENDURANCE SPORTSWIRE/ – The SUAREZ Gran Fondo National Series and ZigBone Farm Retreat have partnered to offer a luxurious cycling retreat May 7-12, 2023. The one-of-a-kind Zigbone Farm Tour de Fondo will be led by 4-time Gran Fondo Maryland winner Cheryl Sornson and feature guided rides...

Cycling

Events

Press Releases

December 13, 2022

The XTERRA World Cup has Arrived!

December 13, 2022 /ENDURANCE SPORTSWIRE/ – In 2023, for the first-time in XTERRA off-road triathlon history, the most compelling World Tour events from the EMEA, Americas, and Asia-Pacific regions will unite to create a premier series of events that will award roughly $350,000 to XTERRA’s fastest professional athletes. The seven-stop, 12-race XTERRA...

Events

Press Releases

Triathlon

December 12, 2022

Legendary IRONMAN Announcer Mike Reilly Hangs Up the Mic After Making His Final Calls at Nutri Grain IRONMAN New Zealand

TAUPŌ, New Zealand / TAMPA, Fla. (Dec.12, 2022) /ENDURANCE SPORTSWIRE/ - The IRONMAN community has bid an emotional farewell to Mike Reilly, the most famous voice in the sport of triathlon, after a storied career spanning 33 years, 33 IRONMAN World Championship events, and a total of 214 IRONMAN events...

Events

Giving

Press Releases

Triathlon

December 12, 2022

Stages Cycling Dual Sided Power Meter for Dura-Ace 9200 Available Now

Boulder, CO – 12 December, 2022 /ENDURANCE SPORTSWIRE/ – Stages Cycling, a leading cycling technology company, today announced the launch of its dual sided power meter for Shimano’s latest 12-speed Dura-Ace 9200 cranksets. The drive-side Stages R crank arms and dual sided Stages LR cranksets for Shimano’s 12-speed groups feature a new power...

Cycling

Press Releases

Products

December 11, 2022

3Mgives Names FindingHomeATX the 2023 Beneficiary of 3M Half Marathon

AUSTIN, TX, December 11, 2022 /ENDURANCE SPORTSWIRE/ – 3Mgives selects FindingHomeATX as the beneficiary of the 2023 3M Half Marathon. This grant will allow the Austin-based community organization to help reach its goal of ending unsheltered homelessness in Austin by scaling up Austin’s Homelessness Operating System (OS) into one that's sustainable...

Events

Giving

Press Releases

Running

December 11, 2022

Marathon Maniacs & Half Fanatics To Meet-Up at Publix Florida Marathon Weekend

December 11, 2022 /ENDURANCE SPORTSWIRE/ – The 15th Annual Publix Florida Marathon Weekend is excited to announce the hosting of an event Meetup of Marathon Manics and Half Fanatics members during its February 12, 2023 weekend of running. The marathon and half-marathon have been recognized by Runner’s World Magazine as “One of...

Events

Press Releases

Running

December 10, 2022

Werner and Gilbert Win Singlespeed Titles on Day 5 of Cyclocross Nationals

HARTFORD, Conn. /ENDURANCE SPORTSWIRE/ – The 2022 USA Cycling Cyclocross National Championships continued on Saturday with freezing temperatures that changed the course conditions drastically. What were once pits of mud have now become deep, frozen ruts. The day began with the Industry races. Taking the lead right after the pit was...

Cycling

Events

Press Releases

December 10, 2022

Best of Challenge Family Announced at the 2022 Race Awards

/ENDURANCE SPORTSWIRE/ – The votes are in and the winners of the 2022 Challenge Family Race Awards announced at the annual race director’s meeting, this year held at Anfi Resorts on Gran Canaria, home to Anfi Challenge Mogán Gran-Canaria. The Challenge Family Awards provide recognition to the race directors for their...

Awards

Press Releases

Triathlon