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

December 7, 2022

Pensacola’s Bayou Hills Run Returns To Spring Race Date

Pensacola, FL – (December 07, 2022) /ENDURANCE SPORTSWIRE/ – Pensacola Sports is excited to announce that the Bayou Hills Run will return to its traditional spring timeframe with the 2023 race taking place on Saturday, March 18, 2023. Registration for the race is now open. One of Pensacola’s oldest running events, the...

Events

Press Releases

Running

December 6, 2022

Iron Horse Bicycle Classic Announces 2023 Registration Dates and Schedule

Durango, Colo. /ENDURANCE SPORTSWIRE/ - Registration for the 51st Annual Iron Horse Bicycle Classic will open on Friday, Dec. 16. There will be a local registration party on Thursday, Dec. 15 from 5:00-8:30 p.m. at the Fort Lewis College Center of Southwest Studies in Durango. The annual celebration of cycling...

Events

Press Releases

December 6, 2022

Challenge Family Arrives in Colombia with Challenge Santa Marta

/ENDURANCE SPORTSWIRE/ – The balmy shores of the Caribbean, overlooked by the foothills of the Sierra Nevada mountains, is the latest setting for Challenge Family with today’s announcement of Challenge Santa Marta in Colombia, taking place over the middle distance on 11 June 2023. One of the oldest cities in South...

Events

Press Releases

Triathlon

December 6, 2022

New Signings for Virginia’s Blue Ridge TWENTY24

ROANOKE, Va. (December 2022)/ENDURANCE SPORTSWIRE/ – Virginia’s Blue Ridge TWENTY24 professional cycling has added four new cyclists to the team’s 2023 roster. Caileigh Filmer (CAN), Danielle Morshead (USA), Nicole Steinmetz (USA), and Laurel Quiñones (USA) have signed on to join the team in Roanoke in the new year, some already familiarizing themselves...

Cycling

Events

Press Releases

December 6, 2022

GFNY announces Inaugural GFNY Maryland (USA)

/ENDURANCE SPORTSWIRE/ – GFNY Maryland is the latest addition to the GFNY Global Endurance Sports Series, making it the fourth GFNY cycling race in the USA in 2023. Scheduled for October 1, 2023, riders compete on the flattest and likely fastest race of the GFNY circuit. GFNY Maryland race week activities...

Cycling

Events

Press Releases

December 6, 2022

Eight Tortola Torture Ultramarathon Set For April 2023

/ENDURANCE SPORTSWIRE/ – The eighth edition of the Tortola Torture ultramarathon will take place on Saturday, April 15, 2023 on the island of Tortola in the British Virgin Islands. The Tortola Torture is open to individuals, 2-person, and 3-person relay teams.  It’s a 33.74 mile (54km) ultramarathon that circumnavigates Tortola with...

Events

Press Releases

Running

December 6, 2022

Carmel Half Marathon Selected as Road Runners Club of America’s 2023 Central Region Championship Event

CARMEL, Ind. (Dec. 6, 2022) /ENDURANCE SPORTSWIRE/ – The Road Runners Club of America (RRCA) has designated the 2023 Carmel Half Marathon as its Central Region Championship event for its 13th annual race on Saturday, April 8. The RRCA Championship Event Series is the largest grassroots-organized running series in the U.S....

Events

Press Releases

Running

December 5, 2022

Rock ‘n’ Roll Running Series Announces 48-Hour Global Winter Sale to Provide Jump Start on New Years Fitness Goals

TAMPA, Fla. (Dec. 5, 2022) /ENDURANCE SPORTSWIRE/ – To celebrate the holidays and the year-long celebration of 25 Years Running, the Rock ‘n’ Roll® Running Series announced a 48-hour Winter Sale will begin at midnight Pacific time on Wednesday, Dec. 7, 2022, offering the lowest prices of the year for events...

Events

Press Releases

Running

December 5, 2022

Legendary speaker line-up announced for Run Show Boston, Feb 2023

/ENDURANCE SPORTSWIRE/ - Just two months before the debut of the Run Show USA opens its doors to the city of running, Boston, the organizers have announced a stellar line up of inspirational speakers. Two main stages will host Olympians and world record breaking athletes offering inspiration and insights into...

Events

Press Releases

Running

Triathlon

December 4, 2022

Sam Long (USA) And Paula Findlay (CAN) Claim Victories at the 2022 Trainual IRONMAN 70.3 Indian Wells-La Quinta Triathlon

INDIAN WELLS / LA QUINTA, Calif. (Dec. 4, 2022) /ENDURANCE SPORTSWIRE/ – Southern California’s Coachella Valley played host to approximately 1,700 athletes for the 2022 Trainual IRONMAN 70.3 Indian Wells-La Quinta triathlon on Sunday, Dec. 4 The event saw athletes take on a 70.3-mile journey through swim, bike, and run through...

Events

Press Releases

Triathlon