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

September 13, 2023

IRONMAN Events in Cambridge, Maryland and Dorchester County Extended for An Additional Five Years

CAMBRIDGE, Md. / TAMPA, Fla. (Sept. 13, 2023) /ENDURANCE SPORTSWIRE/ - IRONMAN and the Dorchester County Department of Tourism, in conjunction with the County Council of Dorchester County, Commissioners of Cambridge, and Sheriff of Dorchester County, have agreed to a five-year agreement to keep the IRONMAN® Maryland triathlon, part of...

Events

Press Releases

Triathlon

September 13, 2023

Standard Chartered Singapore Marathon 2022 named Best Sports Event of the Year at the 2023 Singapore Sports Awards

Standard Chartered Singapore Marathon 2022 won Best Sports Event of the Year in the Community and Mass Participation Category at the Singapore Sports Awards 2023 Organised by the Singapore National Olympic Council (SNOC) and Sport Singapore (SportSG), the awards honoured and celebrated the best of Singapore sports over the past...

Awards

Events

Press Releases

Running

September 12, 2023

46th HAP Crim Festival of Races

Flint, MI /ENDURANCE SPORTSWIRE/ – The Crim Fitness Foundation hosted the 46th edition of the HAP Crim Festival of Races August 24-26 with nearly 9,000 participants toeing the historic blue starting line on the bricks of Saginaw Street marking a return to pre-pandemic numbers. The week started with the opening of...

Events

Press Releases

Running

September 12, 2023

Competitive Field Heads to Uzbekistan for Inaugural Challenge Samarkand

/ENDURANCE SPORTSWIRE/ - A small but quality international pro field is making its way to arguably the most exciting new triathlon destination this weekend for the inaugural Challenge Samarkand in Uzbekistan. The likes of Sebastian Kienle (GER), Frederick Funk (GER) and Emma Pallant-Browne (GBR) will join close to 1,000 age...

Events

Press Releases

Triathlon

September 12, 2023

“Boulderthon’s Next Top Influencer” Competition Announced

BOULDER, Colo. /ENDURANCE SPORTSWIRE/ – Boulderthon®, the fastest-growing marathon series in Colorado, has announced the addition of “Boulderthon’s Next Top Influencer'' to its race weekend festivities. This will be the first year of the competition taking place, and will allow participants the opportunity to compete with each other off the race...

Events

Press Releases

Running

September 12, 2023

California Classic Partners with NNormal at Lake Sonoma – A Late-Season Western States Qualifier

/ENDURANCE SPORTSWIRE/ - Healdsburg Running Company and NNormal are partnering on October 21, 2023 to bring the vineyards and trails alive this fall with the third annual California Classic race series at Lake Sonoma. The race includes a 100K (a rare late-season Western States qualifier) and a 55K with a...

Events

Press Releases

Running

September 12, 2023

ReSport provides advanced tracking technology for Paulie’s Push: Newark to Shanksville

/ENDURANCE SPORTSWIRE/ - ReSport provided technological support and live GPS tracking for Paulie's Push, an anniversary tribute to the flight crews who lost their lives during the 9/11 terrorist attacks. From mid-August to September 11, former flight attendant Paulie Veneto pushed a beverage cart over 300 miles from Newark Airport...

Business

Events

Press Releases

September 12, 2023

Expedition Ozark Returns in April 2024

BENTONVILLE /ENDURANCE SPORTSWIRE/ – Ozark Foundation has announced the date of the 2nd annual Expedition Ozark, a multi-day, expedition level adventure race in Northwest Arkansas in April 2024. The race start coincides with the solar eclipse on April 8. Most of Arkansas will be on the total eclipse path providing a dramatic...

Events

Press Releases

Running