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

September 13, 2021

IRONMAN Foundation to Support Local Initiatives in St. George, Utah in Conjunction with 2021 Intermountain Healthcare IRONMAN 70.3 World Championship Presented by Utah Sports Commission

GEORGE, Utah. / TAMPA, Fla. (September 13, 2021) – The IRONMAN Foundation® will distribute more than $45,000 in giveback to charitable initiatives and groups in the greater St. George region in conjunction with the 2021 Intermountain Healthcare IRONMAN® 70.3® World Championship presented by Utah Sports Commission, including a service project...

Giving

Press Releases

September 13, 2021

Medal revealed for the inaugural AbbottWMM Wanda Age Group World Championships!

Monday 13 Sept. 2021 - The Abbott World Marathon Majors today launched the medal for the inaugural AbbottWMM Wanda Age Group World Championships which will take place on Sunday 3 October, as part of the Virgin Money London Marathon. The World Championships will include runners, aged 40 and above, who...

Events

Press Releases

Running

September 13, 2021

Run Show USA Partners with the Chicago Area Runners Association

Run Show USA, the inaugural consumer running exposition scheduled June 4-5, 2022, at DES Convention Center in Rosemont, IL, today announced that the Chicago Area Runners Association (CARA), the non-profit organization known as Chicagoland’s running club will be a key partner for the event. Run Show, USA, Chicago is set...

Business

Press Releases

Running

Trade Shows

September 13, 2021

Rewire Fitness Launches First-To-Market Neuro Performance Mobile Platform for Athletes

NEW YORK, Sept. 13, 2021 – Rewire Fitness today announced the launch of its first-to-market neuro performance mobile platform designed to holistically quantify athlete readiness, build mental resilience, and improve mind/body recovery. To further elevate the athlete experience, Rewire’s training hardware solution will be available for preorder later this month...

Cycling

Press Releases

Products

Running

Triathlon