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

October 7, 2022

O’Side Turkey Trot promises ‘swell’ holiday fun during King Tide

OCEANSIDE, Calif. /ENDURANCE SPORTSWIRE/ – The O’Side Turkey Trot, San Diego County’s largest Thanksgiving day running and walking event, returns for its 17th year on Nov. 24, promising a classic California coast experience. Participants will ‘move their feet before they eat’ through downtown Oceanside, along Pacific Coast Highway and the newly...

Events

Giving

Press Releases

Running

October 6, 2022

New Date and Strong Government Support for Challenge Malta 2023

6 October 2023 /ENDURANCE SPORTSWIRE/ – Malta is proud Challenge Family is returning to the Mediterranean island with a new date for the middle distance race – 1 October 2023. Strong support from the government has also given the race a new name – Visit Malta Challenge Malta – bringing pro...

Events

Press Releases

Triathlon

October 6, 2022

Wattbike Signs as Official Smart Bike of USA Cycling

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – USA Cycling and Wattbike are excited to announce their new partnership as Wattbike becomes the Official Sponsor of the USA Cycling National Team and the Official Smart Bike of USA Cycling. Wattbikes have been a proven training tool in the National Team’s training regimen for...

Cycling

Press Releases

Products

Sponsorship

October 6, 2022

Live Race Day Coverage for both Race Days of The 2022 Vinfast IRONMAN World Championship Featured on IRONMANnow.com & NBC’s Peacock

KAILUA-KONA, Hawai`i (October 5, 2022) /ENDURANCE SPORTSWIRE/ – For the first time in the event’s 40-plus year history, the 2022 VinFast IRONMAN® World Championship race will take place as a two-day event. Live race coverage of both race days will be aired on IRONMAN Now as well as nearly 10 hours...

Events

Press Releases

Triathlon

October 6, 2022

Pau Hana: 2022 VinFast IRONMAN World Championship Daily Recap for WEDNESDAY, October 5, 2022

KAILUA-KONA, Hawai`i (October 5, 2022) /ENDURANCE SPORTSWIRE/ – The energy continued to build today as athletes prepared for the first day of racing for the 2022 VinFast IRONMAN World Championship tomorrow, Thursday, October 6. Here is the daily Pau Hana, a Hawaiian phrase meaning “end of the workday,” recapping highlights from...

Events

Press Releases

Triathlon

October 6, 2022

Chelsea Sodaro Becomes First American Female to be Crowned IRONMAN World Champion in over 25 Years at The First-Ever Two-Day VinFast IRONMAN World Championship

KAILUA-KONA, Hawai`i (Oct. 6, 2022) /ENDURANCE SPORTSWIRE/ – Today, in the first-ever, two-day VinFast IRONMAN World Championship, a groundbreaking, dedicated women’s professional race took centerstage in the iconic town of Kailua-Kona, Hawai`i. Following a three-year hiatus from Kailua-Kona, Hawai`i being able to host the IRONMAN World Championship, it was 34 year-old...

Events

Press Releases

Triathlon

October 6, 2022

Hi-Tec Returns To Its Trail Running Roots With Three-Year Sponsorship Of Run Catalina Event Series

LOS ANGELES, October 6, 2022 /ENDURANCE SPORTSWIRE/ – Heritage outdoor footwear, apparel, and accessories brand Hi-Tec®, has announced its intended return to the forefront of trail running, beginning with the title sponsorship of the Run Catalina race series, which will now be called the Hi-Tec Run Catalina Series. Through this three-year...

Press Releases

Running

Sponsorship

October 6, 2022

Inaugural GFNY City Marathon Quito this Sunday

/ENDURANCE SPORTSWIRE/ - GFNY Endurance Sports Series is back in Ecuador with an inaugural running event: the GFNY Marathon Quito, the first ever marathon in Ecuador’s capital city. Start and finish will be hosted at the Olympic Stadium Atahualpa, at 2800m above sea level. GFNY Marathon Quito also offers a...

Cycling

Events

Press Releases

October 5, 2022

Life Time Miami Marathon Selects International Artist, Luis Valle, to Create Custom Medal Ribbon for 2023 Event

MIAMI, October 5, 2022 /ENDURANCE SPORTSWIRE/ – For nearly ten years, participants completing the Life Time Miami Marathon, Half Marathon, Tropical 5K and Kids Run Miami events have taken home a piece of collectible artwork. That’s because events owner and producer, Life Time (NYSE: LTH), selects Miami-based artists each year to...

Press Releases

Running