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

October 4, 2022

PeaceHealth AppleTree Marathon Festival offers a Run through History

Vancouver, WA /ENDURnce sportswire/ - The 5th annual Peacehealth Appletree Marathon festival on Sept 17th & 18th attracted 1125 athletes from two countries and 22 states. The race was on its way to becoming a northwest favorite with incredible waterfront scenery, a ‘run through history’ theme and a Boston-qualifying flat...

Events

Giving

Press Releases

Running

October 4, 2022

Speed & Stability Reinvented – Parcours Unveil Three Brand New Wheel Options, for Athletes Seeking Performance without Compromise

/ENDURANCE SPORTSWIRE/ – Offering a fusion of speed and stability, the new Chrono wheelset (68.6mm front, 75.7mm rear) is an extremely versatile race day wheelset option for triathletes, time trialists, or road racers. Maintaining the class-leading aerodynamics of the previous generation wheelset, the new Chrono offers an improvement of over 17%...

Cycling

Press Releases

Products

Triathlon

October 3, 2022

Rock ‘N’ Roll Elite Half Marathon Series Returns as Runners Prepare to Take on The United Airlines Rock ‘N’ Roll Running Series San Jose on October 8-9, 2022

SAN JOSE, Calif. (October 3, 2022) /ENDURANCE SPORTSWIRE/ - Speed City, USA is set to host the United Airlines Rock ‘n’ Roll® Running Series San Jose on Saturday and Sunday, October 8-9, 2022 as the Rock ‘n’ Roll EliteTM Half Marathon Series makes its return to the west coast. Race...

Events

Press Releases

Running

October 3, 2022

Top Running Podcast Helps Endurance Athletes Train Smarter

DENVER, CO (October 3, 2022) /ENDURANCE SPORTSWIRE/ – Strength Running, a top training and education company for distance runners, is excited to announce that its podcast has now been downloaded more than 6 million times. The Strength Running Podcast is one of the top 3 most popular running podcasts in the...

Press Releases

Products

Running

October 3, 2022

Nearly 1,000 Runners Take Flight at the FlyBy 5K and 2-Mile Fun Run/Walk at Pittsburgh International Airport

PITTSBURGH (October 1, 2022) /ENDURANCE SPORTSWIRE/ – Despite the rain, nearly 1,000 runners and walkers raced the runway and earned their wings at this morning’s FlyBy 5K and 2-Mile Fun Run/Walk presented by CNX Resources. This family-friendly race offered participants the rare opportunity to be up close to specialized aircraft and...

Events

Press Releases

Running

October 3, 2022

Showcased

Belgian Waffle Ride Registration Has Opened!

San Diego, CA – October 3, 2022 /ENDURANCE SPORTSWIRE/ Monuments of Cycling (MoC), a premier cycling events producer best known for its iconic Monument of Gravel, the Belgian Waffle Ride (BWR), has announced its burgeoning BWR calendar for the first half of 2023 with a North American expansion into Canada,...

Cycling

Events

Press Releases

October 3, 2022

Pau Hana: 2022 VinFast IRONMAN World Championship Daily Recap for Monday, October 3, 2022

KAILUA-KONA, Hawai`i (October 3, 2022) /ENDURANCE SPORTSWIRE/ – Race week for the 2022 VinFast IRONMAN World Championship continued today in Kailua-Kona, Hawai`i as both race days inched closer with the Parade of Nations and opening of VinFast IRONMAN World Championship Village expo. Here is the daily Pau Hana, a Hawaiian phrase...

Events

Press Releases

Triathlon

October 3, 2022

For the First Time in Three Years, Athletes from Across the Globe Head to The Island of Hawai`i for The 2022 Vinfast IRONMAN World Championship

KAILUA-KONA, Hawai`i (October 3, 2022) /ENDURANCE SPORTSWIRE/ – More than 5,000 registered athletes from around the globe will converge on the Island of Hawai`i for the 2022 VinFast IRONMAN® World Championship triathlon. For the first time in the event’s 40-plus year history, the 2022 VinFast IRONMAN World Championship will take place as...

Events

Press Releases

Triathlon

October 3, 2022

Showcased

Zoot Sports launches a revolutionary new triathlon racesuit – The Ultra P1

Carlsbad, CA /ENDURANCE SPORTSWIRE/ - Zoot Sports, the industry leader in triathlon apparel, launches its fastest and most comfortable racesuit ever, the Ultra P1. Zoot pioneered the first triathlon-specific racesuit in 1983 in Kona, Hi and forty years of triathlon apparel knowledge has led to the development of this incredibly...

Press Releases

Triathlon