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 (22)
) 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 860, 10

August 18, 2022

Sportive Breaks comes on board for 2023 UCI Cycling World Championships

/ENDURANCE SPORTSWIRE/ – Global travel and VIP experience provider Sportive Breaks, part of Destination Sport Experiences, have been appointed as the Official Fan and Amateur Participant Travel Provider of the 2023 UCI Cycling World Championships, which are set to take place in Glasgow and across Scotland from 3rd to 13th August...

Cycling

Events

Press Releases

Sponsorship

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

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

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

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

August 12, 2022

Alex Dowsett becomes ambassador for WIn Your Dream Bike

/ENDURANCE SPORTSWIRE/ – Professional British cyclist Alex Dowsett has announced a long-term partnership with popular bike prize competition Win Your Dream Bike. Followers of Alex will note this is not the first time he’s teamed up with Win Your Dream Bike, with the company helping raise thousands for Alex’s charity, Little...

Cycling

Press Releases

Sponsorship

August 12, 2022

Maryland Cycling Classic Supported by UnitedHealthcare Announces Seven Brand Ambassadors

12 August 2022, BALTIMORE, Md. /ENDURANCE SPORTSWIRE/ - The Maryland Cycling Classic supported by United Healthcare today announced a roster of six world class athletes as brand and community ambassadors for its weekend of events taking place September 1-4, 2022. Nelson Vails, an Olympic silver medalist in track cycling; Rahsaan Bahati,...

Cycling

Events

Press Releases

Sponsorship