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 (21083)
) 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 140, 10

March 7, 2023

Tokyo Marathon Six Star Finishers set a new GUINNESS WORLD RECORDS™ title

March 7, 2023 /ENDURANCE SPORTSWIRE/ – The 2023 Tokyo Marathon set a new Guinness World Records title for the most people to earn a Six Star medal at a single marathon, on Sunday in Tokyo. 3,030 runners completed the race to earn their Six Star Medal, smashing the previous highest total set...

Awards

Events

Press Releases

Running

March 2, 2023

2022 IRONMAN 70.3 Athlete Choice Awards Announced for North American Region

TAMPA, Fla. (Mar. 2, 2023) /ENDURANCE SPORTSWIRE/ – IRONMAN today announced the North American regional results for the 2022 IRONMAN 70.3 Athlete Choice Awards, highlighting the highest-scoring events in a variety of categories based solely on athlete surveys from all the 2022 IRONMAN® 70.3 races across North America. Out of the all the...

Awards

Press Releases

Triathlon

February 22, 2023

2022 IRONMAN Athlete Choice Awards Announced for North American Region

TAMPA, Fla. (Feb 22, 2023) /ENDURANCE SPORTSWIRE/ – IRONMAN, today announced the North American regional results for the 2022 IRONMAN Athlete Choice Awards, highlighting the highest-scoring events in a variety of categories based solely on athlete surveys from all the 2022 IRONMAN® races across North America. Out of the all the...

Awards

Press Releases

Triathlon

February 21, 2023

Nominations Open for the Best Running Stores of 2023

PORTLAND, Maine (February 21, 2023) /ENDURANCE SPORTSWIRE/ – Best Running Stores, the awards program that recognizes and celebrates the best run specialty stores in the US, today announced 2023 nominations are open. The awards reception will be held on the last day of The Running Event (TRE), taking place in Austin,...

Awards

Press Releases

Running

Trade Shows

February 18, 2023

12 Finishers of the Original 1978 Hawaii Ironman Triathlon to be Inducted into USA Triathlon Hall of Fame

COLORADO SPRINGS, Colo. – The 12 finishers of the original Hawaii Ironman Triathlon held 45 years ago today, Feb. 18, off the coast of Hawaii’s Waikiki Beach today were announced as the 12th induction class of the USA Triathlon Hall of Fame. The 12 finishers of the original Hawaii Ironman...

Awards

Events

Giving

Press Releases

Triathlon

February 6, 2023

Tokyo Marathon Six Star Finishers going for GUINNESS WORLD RECORDS™ title

February 6, 2023 /ENDURANCE SPORTSWIRE/ – On Sunday March 5, more than 3,000 participants in the Tokyo Marathon will be aiming to complete their AbbottWMM Six Star journey and achieve a GUINNESS WORLD RECORDS title in the process. Going for the record of the ‘most people to earn a Six Star Medal...

Awards

Events

Press Releases

Running