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

December 14, 2022

The Winter Wildcat Rogaine uses Enabled Tracking again in 2023

/ENDURANCE SPORTSWIRE/ - Enabled Tracking will be back for the fourth year in a row to provide real-time GPS tracking and SportIdent ePunch timing for the Winter Wildcat, a 2-day Rogaine event hosted by TanZ Navigation to be held at the Summit Bechtel Family National Scout Reserve near Glen Jean,...

Business

Events

Press Releases

Products

December 14, 2022

More Than A Quarter Century Of Fast Times, Frigid Temps At The Too Cold To Hold Half

DALLAS /ENDURANCE SPORTSWIRE/ –The Too Cold To Hold Half Marathon, 10K and 5k returns to White Rock Lake on Jan. 28. Hosted by the locally-owned and operated Run Project series, the event has dared runners to brave the chilly temps to earn hot times on a fast and flat course along...

Events

Press Releases

Running

December 13, 2022

Olympic Gold Medalist Gwen Jorgensen Returning to the Sport of Triathlon

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ - U.S. Olympic gold medalist Gwen Jorgensen today announced her plans to return to elite short-course triathlon competition. Jorgensen in 2016 won the United States’ first-ever Olympic gold medal in the sport of triathlon, and in 2017 transitioned to a professional running career following the...

Events

Press Releases

Running

Triathlon

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 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