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

June 24, 2022

Professional Triathletes Organisation Announces Appointment of Jane Hansom as Advisor to The PTO Athlete Board

London/ENDURANCE SPORTSWIRE/ - The Professional Triathletes Organisation (PTO) today announced that Jane Hansom, currently Head of Communications, will take up a new role advising the PTO Athlete Board alongside PTO Chairman, Charles Adamo. Anthony Scammell, a London-based sports communication specialist, also joins as Communications Director. Hansom has more than a...

Business

Events

Press Releases

Sponsorship

Triathlon

June 23, 2022

IRONMAN Coeur D’alene Triathlon Returns to Idaho in 2023

COEUR D’ALENE, Idaho / TAMPA, Fla. (June 23, 2023) /ENDURANCE SPORTSWIRE/ - The IRONMAN Group, announced today that the stunning city of Coeur d’Alene, Idaho will once again play host to a full-distance IRONMAN® triathlon on Sunday, June 26, 2023, as part of a unanimous vote in Tuesday’s City of...

Events

Press Releases

Triathlon

June 23, 2022

Another Mother Runner Celebrates Its 12th Year of Running Strong

Portland, OR – (June 2022) /ENDURANCE SPORTSWIRE/ - Another Mother Runner (AMR), founded by Dimity McDowell and Sarah Bowen Shea, is celebrating its 12th year of running strong with a virtual 12K over the course of this upcoming weekend, June 24 - 26. Designed to form-fit a woman’s schedule and...

Business

Events

Press Releases

Running

Sponsorship

June 23, 2022

Preparing for the Merrell Transkei Tuff, Round 4 of the Adventure Racing World Series Africa Region

/ENDURANCE SPORTSWIRE/ – The highly anticipated Merrell Transkei Tuff is just around the corner and adventurers from all over South Africa are gearing up for 100km of pure Wild Coast Adventure starting at Ocean View Hotel, Coffee Bay! The Merrell Transkei Tuff takes place from 30-31 July around the Coffee Bay...

Events

Press Releases

June 23, 2022

GFNY Waco Texas this Sunday

/ENDURANCE SPORTSWIRE/ – GFNY Waco Texas offers riders a fast racecourse of 85.7 miles with a total elevation gain of 2490 ft. Located in the heartland of Texas, the host town of Waco will hold race week activities at the Hilton Waco Hotel. “Waco is ideally located in the triangle between...

Cycling

Events

Press Releases

June 21, 2022

Sprint finish after 11,000ft of climbing

New York City, June 21, 2022 /ENDURANCE SPORTSWIRE/ - After last week’s GFNY Lourdes Tourmalet in the Pyrenees, the GFNY peloton headed to the Alps. GFNY La Vaujany had 145.1km with 3663m of climbing including L’Alpe d’Huez on the menu. The first obstacles of the day were Col de la...

Cycling

Events

Press Releases

June 21, 2022

USARA partnering with Adventure Racing World Series to launch ARWS North America Regional Series

Clarion, Pennsylvania, U.S.A./ENDURANCE SPORTSWIRE/ –The U.S. Adventure Racing Association and the Adventure Racing World Series have announced a collaborative partnership that will see the two organizations join forces to create the ARWS North America Regional Series. Announced on Sunday, June 19 at the start of the Endless Mountains Adventure Race in...

Events

Press Releases