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

December 27, 2023

UltraRunning Magazine Launches Old School Ultras Calendar

December 27, 2023, Bend, OR /ENDURANCE SPORTSWIRE/ - UltraRunning Magazine is proud to announce the launch of our 2024 Old School Ultras calendar. These events are a collection of legendary races that have stood the test of time and represent the ethos of ultrarunning. Each race was hand-selected for its...

Events

Press Releases

Running

Sponsorship

December 27, 2023

Showcased

CREDOTri Enters into Agreement with IRONMAN

Fort-Lauderdale, FL December 27th , 2023 /ENDURANCE SPORTSWIRE/ - CREDOTri, the revolutionary, go-to application for triathletes worldwide, announced today that the company has inked an agreement with IRONMAN, which will see triathlons from the IRONMAN® Series, IRONMAN® 70.3® Series, and 5150™ Triathlon series officially included on the platform. Launched in December...

Business

Events

Press Releases

Products

Triathlon

December 26, 2023

SUAREZ and Gran Fondo National Series Release 2024 Event Apparel Collection

(Gettysburg, PA – December 26, 2023) /ENDURANCE SPORTSWIRE/ - Gran Fondo National Series and SUAREZ Cycling Apparel today released the designs for event-specific cycling jerseys that will be included with registration for 2024 Gran Fondo National Series owned events. Now in its third year as the title sponsor of the...

Business

Cycling

Events

Press Releases

Sponsorship

December 26, 2023

NorCalUltras Announces its 2024 Race Line Up with Holiday Deals!

Cool, CA /ENDURANCE SPORTSWIRE/ - On Saturday, March 2, 2024, more than 600 ultra-runners will travel from around the globe to race in the 34th Annual Way Too Cool 50K Endurance Run (WTC50K). The 50K race is known as one of the most popular trail and ultra-running endurance events in...

Events

Press Releases

Running

December 26, 2023

Final Call for 2024 Ascension Seton Austin Marathon Elite Field

AUSTIN, Texas, December 27, 2023 /ENDURANCE SPORTSWIRE/ - High Five Events, the organization behind the Ascension Seton Austin Marathon, is inviting elite runners to submit applications before December 31 for participation in the 2024 Ascension Seton Austin Marathon’s Elite Athlete Field. Celebrating its seventh consecutive year, the Elite Athlete Field...

Events

Press Releases

Running

December 22, 2023

Mountain Outpost to Broadcast the 2024 Hardrock 100

/ENDURANCE SPORTSWIRE/ - The Hardrock Hundred Mile Endurance Run (Hardrock) is excited to announce a partnership with Mountain Outpost (a division of Aravaipa Running) to deliver the 2024 Livestream of the Hardrock. Building on the excitement generated from the 2023 Livestream, Hardrock is looking forward to working with Mountain Outpost...

Business

Events

Press Releases

Running

Sponsorship

December 21, 2023

USA Triathlon Partners with RipRoar Events and Flatland Cup Triathlon to Host 2024 USA Triathlon Youth & Junior Nationals in West Des Moines

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ - USA Triathlon, in partnership with RipRoar Events and the Flatland Cup Triathlon today announced the 2024 USA Triathlon Youth & Junior Nationals will be held July 12-14, 2024 in West Des Moines, Iowa. USA Triathlon Youth & Junior Nationals welcomes youth athletes of all...

Events

Press Releases

Triathlon

December 21, 2023

Pensacola Double Bridge Run Registrations Are Going Fast!

/ENDURANCE SPORTSWIRE/ Pensacola, FL (December 21, 2023) – The 2024 Publix Pensacola Double Bridge Run presented by aDoor Real Estate is always a fan favorite for its challenging course and spectacular scenery. The 2024 race is limited to 4,000 runners and slots are filling up quickly. Runners are encouraged to...

Events

Press Releases

Running

Wire Syndication