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

August 19, 2024

Around the Crown 10K Together with Truist Announced as 100MilesofSummer Grand Finale

Charlotte, NC /ENDURANCE SPORTSWIRE/ – Around the Crown 10K Together with Truist, a Charlotte, NC running race with year-round activities focused on building community, celebrating diversity, and implementing sustainability in every facet of its event productions, proudly hosts the final event of the seventh year of the 100MilesofSummer, a large community...

Events

Press Releases

Running

August 19, 2024

Over 5,600 Participants Compete in America’s Finest City Half Marathon & 5K

SAN DIEGO, Calif. /ENDURANCE SPORTSWIRE/ - The 47th annual America’s Finest City Half Marathon & 5K welcomed over 5,600 participants from around the nation and world this morning. Participants traveled from 46 states, and from 20 countries including Belgium to participate in the America’s Finest City Half Marathon & 5K,...

Events

Press Releases

August 19, 2024

Boston Sports Mascots Race During the 2024 SBLI Family Fun Run in Falmouth

FALMOUTH, Mass. /ENDURANCE SPORTSWIRE/ - As part of ASICS Falmouth Road Race weekend, the first-ever Mascot Race kicked off the sold-out SBLI Family Fun Run races on Saturday, Aug. 17, where 1,000 kids ages 2-12 took part in a morning of festivities ahead of the 7-mile Falmouth Road Race the...

Events

Press Releases

Running

August 19, 2024

2025 AbbottWMM Marathon Tours & Travel Age Group World Championships head for New York City

AUGUST 19, 2024 /ENDURANCE SPORTSWIRE/ - The TCS New York City Marathon, produced by nonprofit New York Road Runners, will play host to the 2025 AbbottWMM Marathon Tours & Travel (MTT) Age Group World Championships. The championship race will make its return to the United States after visiting Chicago in...

Events

Press Releases

Running

August 19, 2024

XTERRA Germany Recap: Success for Serrières and Zehnder in Zittau

ZITTAU, GERMANY /ENDURANCE SPORTSWIRE/ - The 18th stop on the 2024 XTERRA EMEA Tour took place at the Zittau Mountains Nature Park on August 17, featuring Arthur Serrières (FRA) ad Anna Zehnder (CHE) as winners of the elite men’s and women’s Full Distance races, respectively. The event also served as...

Cycling

Events

Press Releases

Running

Triathlon

August 17, 2024

Speed In the Air, Drones in the Sky at Falmouth Track Festival

FALMOUTH, Mass. /ENDURANCE SPORTSWIRE/ - Speed was in the air at Falmouth High School Friday night as event records and four-minute miles were broken at the annual Falmouth Track Festival presented by ASICS. By the time the crowd of spectators was treated to a drone show grand finale, they had...

Events

Press Releases

Running

August 16, 2024

Excitement Builds In Frankfurt For The Mainova IRONMAN European Championship Frankfurt Press Conference

“I really, finally want to be able to take the top spot”– Patrick Lange (DEU) “I want to return to Kona, it is absolutely what dreams are made of” – Sam Long (USA) “It’s going to be tricky not to go too hard on the gas” – Kristian Blummenfelt (NOR)...

Events

Press Releases

August 16, 2024

Achieve Your Best IRONMAN & 70.3 Performance with Just 8-14 Hours of Training Per Week

/ENDURANCE SPORTSWIRE/ – Are you striving for a personal best at your next IRONMAN or IRONMAN 70.3, but finding it tough to balance intense training with the demands of daily life? Discover how you can achieve breakthrough performance without sacrificing your health, schedule, or sanity. Join Purple Patch Fitness founder...

Cycling

Events

Press Releases

Running

Triathlon