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

November 22, 2022

Leading tour operator industry body T.O.U.R.S announce election of Jeff Adams as new president

Tuesday 22nd November 2022 - UK /ENDURANCE SPORTSWIRE/ – T.O.U.R.S - also known as Tour Operators United for Runners, are a leading industry body that represents 41 running tour organisations across 26 different countries. As a working group it helps to send over 200,000 runners to events around the globe, by working...

Business

Press Releases

Running

November 22, 2022

Nearly 2,000 Runners Kick Off The Holiday Hustle at Pumpkin Spice Half Marathon

FORT WORTH, Texas /ENDURANCE SPORTSWIRE/ – As holiday lights begin to twinkle across the Metroplex, the season for festive gatherings was officially kicked off at the Pumpkin Spice Half Marathon in Forth Worth on Saturday. The seventh annual run, which also featured a 10K and 5K option, had nearly 2,000 runners...

Events

Giving

Press Releases

Running

November 22, 2022

Virginia’s Blue Ridge TWENTY24 Cycling Returns to UCI Status

ROANOKE, Va. (November 2022) /ENDURANCE SPORTSWIRE/ – Virginia’s Blue Ridge TWENTY24 is announcing its transition back to a Union Cycliste Internationale (UCI) team. The team has a roster representing dynamic and diverse professionals in road, track, mountain biking, gravel, ultra, eSports, and para-cycling. Since its inception 18 years ago, VBR TWENTY24...

Business

Cycling

Press Releases

November 22, 2022

Expedition Canada to use live tracking services by Enabled Tracking

Front Royal, Va. /Adventure Enablers. November 22, 2022 /ENDURANCE SPORTSWIRE/ – Expedition Canada is a multi-day expedition race that kicks off May 23, 2023 and will run through May 29, 2023. The event is in its third year and will once again work with Enabled Tracking to provide real-time tracking for the...

Events

Press Releases

Products

November 21, 2022

ROUVY drops the best deal of the year on a Black Friday Week

November 21st, 2022 /ENDURANCE SPORTSWIRE/ – It is time for great deals, and ROUVY’s indoor cycling platform is no exception. Providing a great service and marquee events all year round non-stop, ROUVY always offers some options of small discounts here and there, which are devoted to various specific cycling and tri...

Cycling

Press Releases

Products

Triathlon

November 21, 2022

2023 Air Force Marathon Registration Opens Cyber Monday

/ENDURANCE SPORTSWIRE/ - Holiday shopping deals will not end after Thanksgiving weekend as Air Force Marathon participants will have the chance to earn early savings on their 2023 event registrations Cyber Monday. Registration opens for the Air Force Marathon at 9 a.m. Nov. 28 with participants receiving an early bird...

Events

Press Releases

Running

November 21, 2022

3M Half Marathon Continues Partnership with Nuun

AUSTIN, Texas /ENDURANCE SPORTSWIRE/ – High Five Events, one of the largest privately owned event production companies in the United States, welcomes back Nuun as the Official Hydration of the 3M Half Marathon. The agreement means Nuun will hydrate runners chasing their half marathon Personal Records (PR) through 2023. The 29th...

Press Releases

Running

Sponsorship

November 20, 2022

3,000 Runners hit the streets of Norfolk for the 9th Annual Chartway Norfolk Harbor Half Marathon

NOVEMBER 20, 2022 – NORFOLK, VIRGINIA /ENDURANCE SPORTSWIRE/ –  Over 3,000 runners made their way down the historic streets of Norfolk during the Chartway Norfolk Half Marathon presented by Bon Secours. Runners from 35 states crossed the finish line both Saturday and Sunday. Runners began their weekend with packet pickup on Friday...

Events

Giving

Press Releases

Running

November 20, 2022

Joe Skipper (GBR) and Sarah True (USA) Victorious at the 2022 Biostarks IRONMAN Arizona Triathlon, part of the VinFast IRONMAN U.S. Series

TEMPE, Arizona (November 20, 2022) /ENDURANCE SPORTSWIRE/ – The Valley of the Sun and Tempe played host to the 17th edition of the Biostarks IRONMAN Arizona triathlon, part of the VinFast IRONMAN U.S. Series on Sunday, Nov. 20. This year’s edition of the event saw athletes swim 2.4 miles, bike 112...

Events

Press Releases

Triathlon