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

January 4, 2024

Showcased

For Sale Memphis in May Triathlon

Memphis, TN /ENDURANCE SPORTSWIRE/ - P.R Event Management will offer to interested and qualified parties the opportunity to acquire the Legacy 40th Memphis in May Olympic and Sprint Triathlons in time for the 2024 season. Since the inception of the Memphis In May Triathlon in 1983 the event has been...

Business

Events

Press Releases

Triathlon

January 3, 2024

Registrations Open for the Ultimate Cycling Bucket List as Haute Route Welcomes New Ownership

3 January 2023 /ENDURANCE SPORTSWIRE/ – The recent transition of the Haute Route events in France from the Ironman Group to France Vélo Evénements (FVE) is set to deliver two extraordinary cycling adventures in 2024 in the Pyrenees and Alps. Under the guidance of its new deputy director, Marius Louvet, the quintessential look...

Business

Cycling

Events

Press Releases

January 1, 2024

RBC GranFondo Whistler Crowned #1 Best Gran Fondo in North America by GranFondoGuide.com

1/ JAN /2024, [Vancouver/Whistler, BC Canada] /ENDURANCE SPORTSWIRE/ - The 14th Annual RBC GranFondo Whistler was today announced as the Overall Best Gran Fondo in North America by GranFondoGuide.com. Held yearly on the 2nd Saturday of September, the event not only received overwhelming acclaim from participants and spectators but also clinched...

Awards

Cycling

Events

Press Releases

December 28, 2023

Discover Exciting Opportunities with the Austin Marathon at Upcoming Recruitment Event

AUSTIN, Texas /ENDURANCE SPORTSWIRE/ - High Five Events, the parent company of the Ascension Seton Austin Marathon and other premier endurance events, is thrilled to unveil an upcoming recruitment session targeting prospective part-time team members. Scheduled to take place at the High Five Events office in Austin, Texas, on Thursday,...

Business

Events

Press Releases

Running

Triathlon

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