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

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

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

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

Ford GFNY Zapopan- Guadalajara: Rios and Muñiz win

New York City, October 5, 2022 /ENDURANCE SPORTSWIRE/ – Zapopan-Guadalajara hosted the first edition of Ford GFNY Zapopan 2022 this past Sunday. The racecourse was 129.3km with an elevation gain of only 875m making it the fastest GFNY ever held in Mexico. Under overcast skies and in perfect temperatures, the race...

Cycling

Events

Press Releases