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

March 4, 2022

Showcased

Race Roster introduces mobile scanning solutions for quick and easy check-in

London, ON (Friday, March 4, 2022) - With Race Roster’s new mobile scanning solutions, event organizers can reimagine their check-in process. “We are always thinking of ways we can help organizers streamline their race day experiences, which includes eliminating long check-in line-ups!" Says Emily Lutz, Product Manager at Race Roster....

Business

Press Releases

March 4, 2022

Kane Footwear collaborates with Brian Mazza to launch first athlete-designed shoe

Westport, CT (March 4, 2022) /ENDURANCE SPORTSWIRE/ - Kane Footwear is releasing their first collaborative design of the Revive recovery shoe with athlete and entrepreneur Brian Mazza. The shoe features earth tones and a printed message on the sole of the shoe that reflects Mazza's story and mission: Nothing Changes if Nothing...

Business

Press Releases

Products

March 4, 2022

Showcased

Dean Karnazes appointed Chief Exercise Officer for Afloat

TAMARAC, Fla. /ENDURANCE SPORTSWIRE/ - Afloat, the creators of the reimagined and technologically advanced waterbed, have announced a new partnership with ultrarunner Dean Karnazes. Taking on the honorary title of Chief Exercise Officer, Karnazes will act as an ambassador for the brand, sharing how waterbeds offer a superior level of...

Press Releases

Running

Sponsorship

March 3, 2022

Yamaha Bicycles Introduces Two New e-Bikes for the U.S. Market

Cypress, Calif. – March 3, 2022 //ENDURANCE SPORTSWIRE/ - Yamaha Motor Corp., USA, the pioneering brand in electric bicycles, is introducing two all-new, class 3, power assist bicycles: the Wabash RT and the CrossCore RC, e-Bikes built from the ground up with the all new Yamaha PWSeries ST drive unit,...

Cycling

Press Releases

Products

March 3, 2022

Showcased

Tucson Bicycle Classic THIS WEEKEND Brings Pro Teams, Novices Together for 3-Day Stage Race

March 3, 2022, Tucson, AZ /ENDURANCE SPORTSWIRE/ - The Tucson Bicycle Classic is excited to bring pro and novice cyclists together this weekend (March 4-6) for a challenging 3-day stage race! This race is in its 34th year, and has a reputation within the cycling community for being challenging, well-run...

Cycling

Events

Press Releases

March 3, 2022

BikeExchange Offers New Clients Free Membership To Professional Bicycle Mechanics Association

Asheville, North Carolina (March 3, 2022) /ENDURANCE SPORTSWIRE/ - Online bike marketplace BikeExchange (BEX) – fresh off their recent merger with Kitzuma Cycling Logistics, which allows clients to ship fully built, ready-to-ride bikes to their buyers – is again offering added value for its clients with a new initiative: All current and...

Business

Cycling

Press Releases

Triathlon

March 3, 2022

Virtual Tour of Africa by Giant & Liv welcomes all to explore Southern Africa with its prominent riders

South Africa/March 3rd, 2022  /ENDURANCE SPORTSWIRE/ - A big adventure awaits everyone in the vast deserts, steep mountain passes and rugged coastlines of Namibia, South Africa and Lesotho. Africa is really an amazing place and absolutely worth exploring. Though, for many reasons, it is not always very easy to scout it...

Cycling

Events

Press Releases

March 3, 2022

Showcased

Speed Hound to Be Recovery Partner for Clash Miami

Menlo Park, CA (March 3, 2022)/ENDURANCE SPORTSWIRE/ - Speed Hound is proud to announce a partnership with Clash Endurance and named the official recovery sponsor for the Clash Miami event. While athletes swim, bike, and run their way through the south Florida terrain, they’ll have the full support of Speed Hound...

Events

Press Releases

Sponsorship

Triathlon

March 3, 2022

Everything Set for The Citroën Ë-Tour by Bkool, The First Virtual Cycling Stage Race

Madrid, March 3, 2022 /ENDURANCE SPORTSWIRE/  Starting March 7, the Citroën ë-Tour by BKOOL will take place in four stages of between 14 and 25 km each, set on the virtual streets and highways of Spain and Portugal. There will be prizes for every participant who finishes at least one...

Cycling

Events

Press Releases

Sponsorship

Triathlon