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

December 22, 2022

USA Triathlon 2023 National Championships Return to Fayetteville

FAYETTEVILLE, Ark. (Dec. 22, 2022)/ENDURANCE SPORTSWIRE/ – USA Triathlon (USAT) recently announced its full slate of National Championship events and locations in 2023, and for the second consecutive year, Fayetteville will host four national championship races – Off-Road (mountain bike) Triathlon and Duathlon (run-bike-run), and Gravel Triathlon and Duathlon – as...

Events

Press Releases

Triathlon

December 21, 2022

SUAREZ Gran Fondo National Series and Wahoo X Announce Schedule for 6-Event E-Fondo Series on virtual cycling platform Wahoo RGT

(Gettysburg, PA – December 21, 2022) /ENDURANCE SPORTSWIRE/ - The SUAREZ Gran Fondo National Series and Wahoo X today announced the event schedule for the 3rd Annual e-Fondo Series, which will run on virtual cycling platform Wahoo RGT. The 6-event e-Sports cycling competition features timed segments and leverages Wahoo RGT’s...

Cycling

Events

Press Releases

Sponsorship

December 21, 2022

BibRave Brings A Record Number of Santas to Pacific Beach for the 2022 San Diego Santa Run

Honolulu, HI /ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, recently partnered with the San Diego Running Co. (SDRC) to provide comprehensive marketing services and complete digital media management for the San Diego Santa Run leading to a record number of participants for this annual event. SDRC is a...

Events

Press Releases

Running

December 20, 2022

Two New Events Confirmed in the USA for the 2023 UTMB World Series

CHAMONIX, France / TAMPA, Fla. USA (Dec. 20, 2022) /ENDURANCE SPORTSWIRE/ – UTMB® World Series organizers have today confirmed two long-standing events in the USA will be added to the global UTMB World Series circuit in 2023, totalling a now official calendar of 34 events. Celebrating its 20th anniversary on the...

Events

Press Releases

Running

December 20, 2022

Organisers announce the return of historic Windsor Trail Run UK event for 2023

(20th December 2022, UK) /ENDURANCE SPORTSWIRE/ – Steeped in history, the Windsor Trail Run is set to return to Berkshire on Sunday 21st May and Sunday 19th November 2023. Runners will be able to choose from three event distances, 10km, half marathon and marathon, with each run course weaving along some...

Events

Press Releases

Running

December 20, 2022

Whitefish Marathon Returns in 2023 with Course Changes and State Championship Title

WHITEFISH, Mont. (Dec. 20, 2022) /ENDURANCE SPORTSWIRE/ - Runners at the 2023 Whitefish Marathon Powered by Hammer will be competing for records on an updated course, while vying for an extra championship medal thanks to the Road Runners Club of America (RRCA). The 16th annual event in Whitefish, Mont. on...

Events

Press Releases

Running

December 20, 2022

Live tracking on tap for 2023 Endless Mountains Expedition Race

December 20, 2022 / Front Royal, Va. /ENDURANCE SPORTSWIRE/ – Back for the second year, the Endless Mountains Expedition Race, a 5-day adventure race across the Pennsylvania Wilds hosted by Rootstock Racing, has once again recruited Enabled Tracking to implement live tracking for the event. The race starts on June 26 and...

Events

Press Releases

Products

December 19, 2022

L’Etape Canada by Tour de France lands in Strathcona County

December 19, 2022 /ENDURANCE SPORTSWIRE/ – Get ready to experience the atmosphere and passion of the Tour de France, in a new, amateur, mass participation cycling event. Join L’Étape Canada by Tour de France in Strathcona County, Alberta in Canada on August 12 and 13, 2023. The event offers a distance for...

Cycling

Events

Press Releases