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

October 9, 2022

United Airlines Rock ‘N’ Roll Running Series San Jose Welcomes Over 8,000 Registered Participants to The Largest Running Block Party in Speed City, USA

SAN JOSE, Calif. (October 9, 2022) /ENDURANCE SPORTSWIRE/ - The Rock ‘n’ Roll Running Series returned to the streets of Speed City, USA as the United Airlines Rock ‘n’ Roll® Running Series San Jose event weekend saw over 8,000 registered participants and featured 5K and KiDS ROCK races on Saturday...

Events

Press Releases

Running

October 9, 2022

27 Age-Group Athletes from around the globe claim 2022 VinFast IRONMAN World Championship Division Titles in Kailua-Kona, Hawai`i

KAILUA-KONA, Hawai`i (October 9, 2022) /ENDURANCE SPORTSWIRE/ – It was a historical week for the 2022 VinFast IRONMAN World Championship as for the first time in the event’s history the race took place over two days on Thursday, Oct. 6 and Oct. 8. While the world saw the amazing races from...

Events

Press Releases

Triathlon

October 7, 2022

Professional Triathletes Organisation Applauds ‘Landmark’ Chelsea Sodaro Win In Kona

7 October 2022. London, UK /ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) shared its wholehearted congratulations with new IRONMAN World Champion Chelsea Sodaro this morning, following her fantastic win in Kona – the first woman or man to win their debut on the Big Island since Britain’s Chrissie Wellington in 2007 and the...

Events

Press Releases

Triathlon

October 7, 2022

H2O Audio Introduces “TRI Multi-Sport Headphones with Bluetooth and MP3”

KAILUA-KONA, Hawaii /ENDURANCE SPORTSWIRE/ - Concurrent to the 2022 IRONMAN World Championship and The Underpants Run in Kona, Hawaii, H2O Audio, the world leader in waterproof headphones and accessories, today launched its H2O TRI – Triathlon Multi-Sport Headphones. Designed specifically for triathletes and anyone active in water sports and outdoor activities,...

Cycling

Events

Press Releases

Running

Triathlon

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

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