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 (21085)
) 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 1230, 10

August 18, 2022

Parcours to Partner with Roam Sports for South African Wheel Sales

/ENDURANCE SPORTSWIRE/ – British wheel brand Parcours is rolling out in South Africa, through a partnership with Roam Sports for distribution, sales and support for riders and retailers in South Africa. Roam Sports will be featuring the range of Parcours offerings as the first wheelset brand to feature in their digital...

Cycling

Press Releases

Products

August 18, 2022

EventHub Returns as Official Expo Software Partner for 2023 Running USA Industry Conference

(Aug. 18, 2022)/ENDURANCE SPORTSWIRE/ – Running USA announces that EventHub, the leading Endurance Sponsorship and Expo Platform, will continue in the role of Official Expo Software Partner for the 19th Running USA Industry Conference at the Hyatt Regency Denver at Colorado Convention Center set for Feb. 12-14, 2023. Registration is now...

Press Releases

Products

Running

Sponsorship

Trade Shows

August 17, 2022

Riders Around the World to Experience the Best Sights of Down Under with FulGaz Hope Cycle Tour of Australia

MELBOURNE, AUS/TAMPA, Fla. (August 17, 2022) ENDURANCE SPORTSWIRE/ - FulGaz®, The IRONMAN Group’s cutting-edge indoor virtual cycling app, announced today that cyclists from around the world will have the chance to experience the highlights of riding down under without leaving their homes with the Hope Cycle Tour of Australia. The...

Cycling

Giving

Press Releases

Products

August 17, 2022

John Wall Teams Up With McDavid

/ENDURANCE SPORTSWIRE/ – McDavid, a global leader in sports medicine products and maker of best-selling McDavid HEX® padded basketball apparel, is excited to announce a partnership with NBA superstar John Wall. A five-time NBA All-Star, Wall has worn McDavid HEX® padded apparel throughout his professional basketball career and will now be...

Press Releases

Products

Sponsorship

Wire Syndication

August 16, 2022

The RunnerBox Named to Gear Junkie’s Best Subscription Boxes for Outdoor Enthusiasts

/ENDURANCE SPORTSWIRE/ - The RunnerBox has been named as “The Best Subscription Box for Runners” by Gear Junkie, a top source for outdoor news, trends, and gear reviews. Published to help outdoor enthusiasts find the best subscription boxes that are tailored to their athletic needs, the list contains products ranging from...

Awards

Cycling

Press Releases

Products

Running

Triathlon

August 16, 2022

One Water Race Starts August 23rd

/ENDURANCE SPORTSWIRE/ - On August 23rd -25th, the first official One Water Race will take place. One Water Race is the world's toughest endurance race. The race has gained a lot of attention and the world's best endurance athletes visit to Stockholm to challenge all physical and mental limits and...

Events

Press Releases

Products

Running

Sponsorship

Studies

Triathlon

August 15, 2022

XTERRA European Championship Rewind from Prachatice

/ENDURANCE SPORTSWIRE/ - Arthur Serrieres from France and Sandra Mairhofer from Italy captured the XTERRA European Championship in conjunction with the 18th annual XTERRA Czech off-road triathlon with winning times of 2:30:16 and 2:57:39, respectively, on Saturday, August 13, 2022, in Prachatice, then put their speed and skill on full...

Business

Events

Press Releases

Products

Triathlon

August 15, 2022

hDrop Technologies Launches Partnership With USA Cycling

/ENDURANCE SPORTSWIRE/ - hDrop Technologies has launched a Member Benefit with USA Cycling, the national governing body for cycling in the United States. As a result of the partnership, all USA Cycling members can get the hDrop device at a 20% discount. While the USA Cycling High Performance Team will...

Cycling

Press Releases

Products

Running

Sponsorship

Triathlon