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

August 2, 2023

Helijet Superweek announced in celebration of RBC GranFondo Whistler 2023 partnership

[Vancouver, BC] /ENDURANCE SPORTSWIRE/ - RBC GranFondo Whistler today announced the week of August 7-13, 2023 will be designated as Helijet Superweek. Helijet is the official air transport partner of the event which holds the title of North America’s largest Gran Fondo, a mass-participation cycling challenge. Helijet Superweek is a new...

Business

Cycling

Events

Press Releases

Sponsorship

August 2, 2023

Elite Podiatrist and Footwear Developer Simon Bartold Backs Innovative Vimazi, Will Exclusively Distribute in AU and NZ

Portland, Ore., (August 2, 2023) /ENDURANCE SPORTSWIRE/ - Vimazi, maker of the first ever pace-tuned running shoes, and Simon Bartold, globally recognized podiatrist to the running elite and advanced development consultant for industry leaders ASICS and Salomon, announce today a partnership to have Bartold be Vimaz’s exclusive distributor for Australia...

Business

Press Releases

Running

August 2, 2023

The IRONMAN brand is back in Cebu in 2024

LAPU-LAPU CITY, Philippines /ENDURANCE SPORTSWIRE/ - The Philippines’ most awarded triathlon, the IRONMAN® 70.3® Philippines, is now rebranded as the IRONMAN 70.3 Lapu-Lapu and  is set to take place on Sunday, 21 April 2024. The 2024 edition of the popular triathlon event featuring a 1.9km ocean swim, 90km bike and...

Events

Press Releases

Triathlon

August 2, 2023

Bikeflights Expands Buck Up For Bikes

PORTLAND, OR (August 2, 2023) /ENDURANCE SPORTSWIRE/ – Bikeflights, a bicycle shipping service trusted by riders worldwide, is pleased to announce the addition of World Bicycle Relief to its Buck Up For Bikes program. Since its launch in 2016, Buck Up For Bikes has raised more than $120,000 for non-profit...

Cycling

Giving

Press Releases

August 2, 2023

RTS Warriors USA And Proud In Super League Triathlon’s 2023 Championship Series

LONDON, UK/ENDURANCE SPORTSWIRE/ – RTS (Real Triathlon Squad) have promised to bring short-course racing back to the fore in the USA - and their actions are already speaking louder than words with the announcement of an RTS Warriors team that delivers stars of the present and the future. While other teams have...

Events

Press Releases

Triathlon

August 2, 2023

British Dream Team For RTP Sharks in Super League Triathlon’s Championship Series

LONDON, UK /ENDURANCE SPORTSWIRE/ – Super League Triathlon's 2023 Championship Series will boast arguably the strongest British triathlon team ever assembled with the RTP Sharks announcing a squad that features some of the biggest names in the sport. The team, managed by two-time British Olympian Michelle Dillon, includes Alex Yee, Jonathan Brownlee,...

Press Releases

Triathlon

August 2, 2023

Cycling Time Trials reveal important update to National Championship Conditions

2nd August 2023 - UK/ENDURANCE SPORTSWIRE/ – Cycling Time Trials (CTT) is the governing body for time trials in the UK, and the team promotes a wide range of events across the UK, set over a variety of distances, locations and terrains. Events span across fast and flat “drag strips”, in which...

Cycling

Events

Press Releases

August 2, 2023

Sofia Gomez Villafane, Sami Inkinen, and Holly Guymon Take Overall Wins at the Stages Cycling Leadville Stage Race produced by Life Time

Leadville, Colo. /ENDURANCE SPORTSWIRE/ - The Stages Cycling Leadville Stage Race, owned and produced by Life Time (NYSE: LTH) as part of the Leadville Race Series, took place this past weekend from July 28-30. The event’s stage race format spreads out the Stages Cycling Leadville Trail 100 MTB course over three...

Cycling

Events

Press Releases

August 2, 2023

Race Results for the 24th Molokaˈi-2-Oˈahu Paddleboard World Championship

HONOLULU, HI (August 2, 2023) – The 24th Molokaʻi-2-O’ahu Paddleboard World Championships (M2O), presented by the Hawai’i Tourism Authority returned to racing today after a three-year hiatus due to the pandemic. Racers were greeted with favorable conditions with trade winds blowing at 20 knots and wind swell at six feet....

Events

Press Releases