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

November 7, 2023

Wattbike appoints e-commerce specialist Ahmed Khodja as Direct to Consumer Director, to spearhead international growth plans

7th November 2023, Nottingham, UK/ENDURANCE SPORTSWIRE/ – E-commerce and digital transformation expert Khodja joins the Wattbike team as Direct-to-Consumer (DTC) Director, a brand new role which will see him responsible for setting Wattbike’s global DTC vision by unlocking the potential of the brand. Khodja will be responsible for the transformation of...

Business

Cycling

Press Releases

November 7, 2023

PTO European Open returns to Ibiza and is elevated to also become The Official European Championship

London, UK/ENDURANCE SPORTSWIRE/ – The PTO European Open will return to Ibiza next year on 28-29 September, 2024, with the title of ‘European Champion’ now at stake for its professional female and male triathletes and Age Groupers - thanks to the PTO’s new partnership with World Triathlon that recognises the 2024...

Events

Press Releases

Triathlon

November 7, 2023

ARWS Announces Canada as the 2025 AR World Championship Destination

/ENDURANCE SPORTSWIRE/ - After the recent announcement of their new, heavy hitting organizing team, Expedition Canada has officially released their next big news. At the awards ceremony for World Championships in Expedition Africa, the announcement was made that Canada will be the host of the World Championships of Adventure Racing...

Events

Press Releases

November 7, 2023

Ashworth Awards’ Made in USA Sustainable Medals will Now be Made with 100% Recycled Material

/ENDURANCE SPORTSWIRE/ – Ashworth Awards has led the charge in sustainable recognition awards, developing and being the sole entrepreneur of their sustainable, recycled material awards line. The company started their efforts in 2017, determining the best machinery and material to ensure quality, top-of-the-line products. In 2019, they launched their Made...

Awards

Cycling

Press Releases

Products

Running

Triathlon

November 7, 2023

Snowshoe, West Virginia to Host 2024 U.S. Adventure Racing Association National Championship

/ENDURANCE SPORTSWIRE/ – The United States Adventure Racing Association National Championship will take place in Snowshoe, West Virginia on September 27 and 28, 2024. Based out of Snowshoe Resort, the event will entail teams of three from across the country biking, paddling, and trekking for 30 hours nonstop through the...

Events

Press Releases

November 7, 2023

The Wizard Run Returns to Philly With Unique Race Features

PHILADELPHIA, Pa. /ENDURANCE SPORTSWIRE/ - The Wizard Run returns to Philadelphia on Dec. 9 at 9:30 a.m. Created to bring magic-loving people together in an inclusive and lively manner, the Wizard Run will fill South Philadelphia’s Navy Yard with wizards and witches. After switching to virtual races during the COVID-19...

Events

Press Releases

Running

November 7, 2023

Wild Willies to be the Official Beard Products and Soap of Tough Mudder Dallas and Central Florida

BOSTON, MASS. (11/7/23) /ENDURANCE SPORTSWIRE/ - Tough Mudder, the global extreme wellness brand, announces that Wild Willies will become an official sponsor, to offer their top-of-the-line portfolio of leading men’s grooming and styling products, to participants at select Tough Mudder events. “We are excited to have Wild Willies - a...

Business

Events

Press Releases

Products

Sponsorship

November 6, 2023

2023 Polartec Apex Award Winners Announced

Planet Earth, (November 6th, 2023) /ENDURANCE SPORTSWIRE/ - Polartec®, a Milliken™ & Company brand, and premium creator of innovative and more sustainable textile solutions, is excited to announce the winners of the 2023 Polartec Apex Awards. The annual design awards celebrate the brands and designers who embody the ethos, Made...

Awards

Press Releases

Products