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

September 17, 2024

Northern California’s Prestigious Endurance Race Returns to Cool, California

Cool, California /ENDURANCE SPORTSWIRE/ - Click here to register today for the 35th Annual Way Too Cool 50K & Inaugural 10 Mile Endurance Runs Presented by Altra. Registration is now open, and we expect both distances to sell out before the end of year. Secure early bird pricing through September...

Events

Press Releases

Running

September 17, 2024

41st Kaiser Permanente Corporate Run, Walk & Roll 5K inspires participants from every walk of life

ATLANTA, September 16, 2024 /ENDURANCE SPORTSWIRE/ - The 41st Kaiser Permanente Run, Walk & Roll created by Jeff Galloway is set to return to Piedmont Park September 25th. Known for being Atlanta’s largest office party, more than a team-building event, participant stories weave a fabric of inclusivity. Octavio Aguado shares their...

Business

Events

Press Releases

Running

Sponsorship

September 17, 2024

More than 1,000 cyclists registrated for the Gran Fondo World Tour ® event at Ciclobrava by Orbea.

/ENDURANCE SPORTSWIRE/ – The upcoming event, part of the Sea Otter Europe Expo program, brings together Girona and the World Tour Series for Gran Fondo enthusiasts. This non-competitive ride ensures that all cycling fans have the opportunity to enjoy the scenic beauty of Girona on the festival's Sunday. Professionals frequently...

Cycling

Events

Press Releases

September 17, 2024

Dream Run Camp to Host Special Retreat for Boston Marathon Qualifiers

Flagstaff, ARIZONA – September 17, 2024/ENDURANCE SPORTSWIRE/ – Dream Run Camp, a year-round residential training camp for adult runners, today announced plans to host a special retreat for Boston Marathon qualifiers next April. Boston Boot Camp is billed as a two-week pro-style training experience designed to prepare marathon enthusiasts for their best possible...

Events

Press Releases

Running

September 16, 2024

5 Mila Marche Next Stop of Gran Fondo World Tour ®

/ENDURANCE SPORTSWIRE/ – Get ready for an exhilarating two-day cycling program taking place on Saturday, September 20th, featuring two thrilling proposals: the Extreme road brevet 271 km, and a 69 km GPS-guided Gravel event. On Sunday, participants can enjoy two road distances, Medio Fondo and Gran Fondo, completing the full...

Cycling

Events

Press Releases

September 16, 2024

XTERRA Ruidoso Brings the Off-Road Challenge to New Mexico’s Sierra Blanca

RUIDOSO, NEW MEXICO, USA /ENDURANCE SPORTSWIRE/ – The first ever XTERRA event in Lincoln National Forest set in the Sierra Blanca mountain range will take place from August 15-17 as a major addition to the 2025 XTERRA Americas Tour. Off-road triathletes, trail runners and their families are invited to Grindstone...

Cycling

Events

Press Releases

Running

Triathlon

September 14, 2024

Svensson and de Boer Crowned European Champions at Challenge Almere-Amsterdam

/ENDURANCE SPORTSWIRE/ - With a European Long Distance title at stake, dozens of professional athletes took off Saturday morning at Challenge Almere-Amsterdam. After a spectacular race, decided only in the final stages, Jesper Svensson (SWE) and Marlene de Boer (NED) earned the European Champion titles. De Boer not only won...

Events

Press Releases

Triathlon

September 14, 2024

Thousands of Riders Participate in 41st Annual Life Time Chequamegon MTB Festival presented by Trek

Cable, Wis., (Sept. 14, 2024) /ENDURANCE SPORTSWIRE/ - The 2024 Life Time Chequamegon MTB Festival presented by Trek, owned and produced by Life Time (NYSE: LTH), brought more than 2,800 riders to northern Wisconsin on Saturday. The Chequamegon MTB Festival is the oldest and longest-running mountain bike race in the...

Cycling

Events

Press Releases