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

June 15, 2023

Super League Triathlon Announce Fifth Anniversary Championship Series With Star Athlete Line-Ups

/ENDURANCE SPORTSWIRE/ – Super League Triathlon (SLT) has unveiled the dates of its fifth anniversary Championship Series and the first superstar athletes who will deliver the fastest racing on the planet. Super League has revolutionised triathlon with its unpredictable formats and innovations, exciting courses, Teams format and action-packed broadcasts that were...

Events

Press Releases

Triathlon

June 15, 2023

Annual Crown City Classic 4th of July Run Celebrates 50 Years Running

/ENDURANCE SPORTSWIRE/ - Celebrating its 50th year running, Coronado's annual 4th of July run returns with a remarkable display of consistency. The beloved event, renowned as one of the finest 4th of July running events in the country, invites runners of all ages and abilities to participate in a variety...

Awards

Events

Press Releases

Running

June 14, 2023

Historic Day in Maryland as Four Athletes with an Intellectual Disability (ID) Finish IRONMAN 70.3 Eagleman

TAMPA, Fla. (June 14, 2023)/ENDURANCE SPORTSWIRE/ – History was made at this Sunday’s 2023 IRONMAN® 70.3® Eagleman triathlon, as Chris Nikic (Clermont, Fla.), the first person with Down syndrome to complete a full-distance IRONMAN® triathlon, was joined by three friends from the Special Olympics, Kennet Lefkovic (Palm Coast, Fla.), Jonathan Sady...

Events

Press Releases

Triathlon

June 14, 2023

GFNY Lourdes Tourmalet: Dutch and French win after 4064m of climbing

New York City, June 14, 2023 /ENDURANCE SPORTSWIRE/ – The famous pilgrimage town of Lourdes hosted the second edition of GFNY Lourdes Tourmalet this past Sunday. The racecourse was 157 km long with an elevation gain of 4064 m and included the legendary Pyrenées climbs Col d’Aspin and Col du Tourmalet....

Cycling

Events

Press Releases

June 14, 2023

Cycling Time Trials Announce New Transgender Policy

14th June 2023, 9am BST /ENDURANCE SPORTSWIRE/ – The team at Cycling Time Trials (CTT) have today announced that transgender women (those who have transitioned from male to female) will no longer be eligible to ride in female competitions. CTT’s purpose is to facilitate and run time trials – where each...

Cycling

Events

Press Releases

June 14, 2023

Boulderthon® Debuts New Course That Will Start And Finish In Downtown Boulder

BOULDER, Colo./ENDURANCE SPORTSWIRE/ – Boulderthon®, the fastest-growing running series in Colorado, has announced a paramount change to their course for the Oct. 8 event. Runners will now start and finish off the Pearl Street Mall in the heart of Downtown Boulder, an unprecedented milestone for a marathon race series in Boulder....

Events

Press Releases

Running

June 14, 2023

International Field at Lotto Challenge Gdańsk This Weekend

/ENDURANCE SPORTSWIRE/ – With a start list of over 40 professional athletes at Lotto Challenge Gdańsk, some exciting racing is guaranteed for the Polish middle distance race this Sunday. Heading the field and fresh from his win at Challenge Geraardsbergen last weekend is Menno Koolhas (NED). Also doing back-to-back races are...

Events

Press Releases

Triathlon

June 14, 2023

tentree opens its first retail store in Washington D.C.

Vancouver, BC (June 14, 2023) /ENDURANCE SPORTSWIRE/ - tentreeⓇ, an earth-first lifestyle apparel brand whose mission is to plant 1 billion trees by 2030 to drastically reduce climate change, has opened its first-ever US retail store in Washington, D.C’s Shaw neighborhood. Since its start in 2012, each tentree purchase has...

Events

Press Releases