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

July 12, 2023

USA Cycling Announces 2023 BMX Racing World Championship Teams

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – The 2023 UCI Cycling World Championships will make history in Glasgow, Scotland as the first World Championship where 13 events will be contested across 7 disciplines. 20 Americans will compete in the BMX Racing events on August 12-13, 2023 at the Glasgow BMX Centre. This event marks another...

Cycling

Events

Press Releases

July 12, 2023

A Strong Men and Women’s British Professional Line-Up to Battle It Out at IRONMAN 70.3 Swansea, Wales on Sunday whilst Spain Welcomes a Women’s Professional Field to Vitoria-Gasteiz

SWANSEA, Wales / VITORIA-GASTEIZ, Spain (July 12, 2023)/ENDURANCE SPORTSWIRE/ – The 2023 triathlon season continues in Europe this Sunday with men and women pros battling it out at IRONMAN 70.3 Swansea, and a professional women’s only field racing at IRONMAN Vitoria-Gasteiz. IRONMAN 70.3 Swansea Following in the footsteps of Alistair Brownlee...

Events

Press Releases

Triathlon

July 12, 2023

The 14th Annual Giant Race Announces Historic All-Female Running Team

San Francisco, CA /ENDURANCE SPORTSWIRE/ – The Giant Race presented by Alaska Airlines today announces the first-ever all-female running team to participate in the event - the Alaska Airlines All-Stars. Captained by three-time Olympian Shannon Rowbury, the team of nine (9) female Bay Area athletes signifies the importance of representation in sports....

Events

Press Releases

Running

July 11, 2023

GFNY announces second race in Malaysia

/ENDURANCE SPORTSWIRE/ - GFNY Global Endurance Sports Series adds GFNY Kota Kinabalu, scheduled for December 10, 2023. It’s one of now six GFNY races in Asia aside from the Indonesian races in Bali and Mandalika, Krabi and Khao Yai in Thailand, and Kuala Lumpur in Malaysia. The competitive long distance...

Cycling

Events

Press Releases

July 11, 2023

USA Cycling Announces 2023 Mountain Bike World Championship Teams

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ – The 2023 UCI Cycling World Championships will make history in Glasgow, Scotland as the first World Championship where thirteen events will be contested across seven disciplines in ten days. Athletes will compete in the downhill races on August 3-5, Marathon on August 6, and Cross-Country events on...

Cycling

Events

Press Releases

July 11, 2023

Jan Van Berkel (CHE) claims victory on home-soil with a brilliant performance at this year’s IRONMAN Switzerland Thun Triathlon

THUN, Switzerland (July 11, 2023)/ENDURANCE SPORTSWIRE/ – Switzerland played host to the 5th edition of IRONMAN® Switzerland Thun this past Sunday. This race previously took place in Zurich for 23 years before moving to its new home in Thun. The day saw Switzerland’s Jan van Berkel take the spotlight by taking...

Events

Press Releases

Triathlon