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

September 15, 2022

BikeExchange Taps New US Head, Head of US Sales; Shuffle Other Key Positions

Asheville, North Carolina (September 15, 2022)/ENDURANCE SPORTSWIRE/ – Continuing to exceed expectations in growth and expansion in North America (NA), BikeExchange/Kitzuma Cycling Logistics – now operating under the same umbrella after merging last December – has added/shuffled some key North American positions for BikeExchange, including naming Cameron Simpson to Head of North...

Business

Cycling

Press Releases

Triathlon

September 15, 2022

ROUVY: La Vuelta Virtual ‘22 Summary – 7K riders worldwide, a winner from Belgium and 5K Euro for inclusive cycling

Madrid, Spain / September 15th, 2022 /ENDURANCE SPORTSWIRE/ – La Vuelta Virtual on ROUVY, last weekend, had a magnificent wrap up in Madrid. Everyone witnessed the amazing story of Ward Simons who became the first winner of La Vuelta Virtual ‘22 at the in-person Grand Final. The pharmacist from Belgium managed...

Cycling

Events

Press Releases

September 15, 2022

The Running Event Announces “For Every Run Film Festival” in Partnership with Pacers Running

PORTLAND, Maine (September 15, 2022)/ENDURANCE SPORTSWIRE/ – The Running Event (TRE), North America’s premier specialty retail conference and trade show, has partnered with Washington, DC-based retailer Pacers Running to present the first annual For Every Run Film Festival. The festival will take place December 1 at The Running Event in Austin, TX....

Press Releases

Running

Trade Shows

September 15, 2022

The AbbottWMM Global Run Club App is here!

MEDIA ALERT Thursday 15 September 2022 /ENDURANCE SPORTSWIRE/ – The Abbott World Marathon Majors (AbbottWMM) Global Run Club launched their first ever mobile App today bringing the virtual training and racing hub into the palm of thousands of runners’ hands around the world. The Global Run Club launched in 2020 to keep...

Press Releases

Products

Running

September 15, 2022

Spivey Hoping For Redemption As She Returns Home For Super League Triathlon Malibu

/ENDURANCE SPORTSWIRE/ - Taylor Spivey is hoping for redemption as she returns home to California, USA, for Super League Triathlon Malibu on Saturday (13:00 local time) with a chance of taking pole position in the race for the 2022 Championship Series. The American has been a resurgent force this year,...

Press Releases

Triathlon

September 15, 2022

6-Time IRONMAN World Champion Mark Allen Endorses Frontier X2

London, UK /ENDURANCE SPORTSWIRE/ – Mark Allen – dubbed the greatest endurance athlete of all time through an official ESPN poll – has partnered with pioneering medical technology start-up Fourth Frontier to help endurance athletes monitor their heart health and train at optimum levels. The company has made great strides to...

Cycling

Press Releases

Running

Sponsorship

Triathlon

September 15, 2022

RunSignup Endurance Industry 2022 YTD Update

September 15, 2022,  Moorestown, NJ /ENDURANCE SPORTSWIRE/ - RunSignup, the leading registration provider for U.S. endurance events, provides a September industry update. Recent data indicates the market is showing signs of improving. Previously, data on a per race basis revealed a decrease in the per event registrations and in repeat...

Business

Press Releases

Running

September 14, 2022

Rock ‘n’ Roll Running Series Las Vegas Extends Partnership with Resorts World Las Vegas Bringing The Health & Fitness Expo to The Las Vegas Strip for Three More Years

- 2023 Rock ‘n’ Roll Running Series Las Vegas Half Marathon taking place on Sunday, Feb. 26 will be streamed on Resorts World Las Vegas 100,000 square-foot West Tower LED screen - Registration for the 2023 Rock ‘n’ Roll Running Series Las Vegas with a distance for everyone including 5K,...

Press Releases

Running

Sponsorship

Trade Shows

September 14, 2022

IRONMAN 70.3 Perú returns to Lima, Peru for 2023

Lima, Perú (September 14, 2022)/ENDURANCE SPORTSWIRE/ – IRONMAN announced today that IRONMAN® 70.3® Perú triathlon will return to Lima, Perú for the first time since 2019. The fourth edition of IRONMAN 70.3 Perú triathlon is scheduled to take place on Sunday, April 23, 2023. Registration for the event opens on Thursday,...

Events

Press Releases

Triathlon

September 14, 2022

Handcyclists can now choose to ride an Adaptive Bike in Zwift

Long Beach, California, Sept. 14, 2022/ENDURANCE SPORTSWIRE/ – Zwift, the global online fitness platform for cyclists, is proud to announce the addition of a handcycle to their in-game bike options. The new handcycle is Zwift’s first adaptive bike and is designed to be used by Zwifters who ride handcycles at home, so...

Cycling

Press Releases

Products