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 (11)
) 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 1930, 10

March 7, 2022

Super League Triathlon Secures Live and Highlights Coverage Across Europe on Eurosport and discovery+ in 2022

SLT’s Arena Games Triathlon and Championship Series to air in 50 markets in Europe across Discovery’s network of channels and platforms Live and on-demand coverage of SLT events to reach more than 200 million viewers via broad television coverage and streaming via discovery+ and the Eurosport App /ENDURANCE SPORTSWIRE/ -...

Business

Press Releases

Triathlon

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 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

NWSL Rookie of the Year Trinity Rodman Partners with Youth Athletes United

New York, March 3, 2022 /ENDURANCE SPORTSWIRE/ - Youth Athletes United, one of America's fastest-growing multi-sport programs, with 291 territories nationwide and more than 200,000 children instructed each year, continues to catch on in communities throughout the U.S. The multi-brand franchisor includes Soccer Stars, Amazing Athletes, TGA Premier Sports, Little Rookies Baseball...

Business

Press Releases

Sponsorship

March 3, 2022

Leon Cycle Hires SIMBOL Communications as PR Agency of Record

Seattle, Washington (March 3, 2022)/ENDURANCE SPORTSWIRE/ - Since its inception in Germany in 2014, Leon Cycle has grown into one of the biggest e-bike brands in Europe by focusing on its mission to offer high-quality bikes at affordable prices in every category. Now they’re bringing on SIMBOL Communications as its PR...

Business

Cycling

Press Releases

Triathlon

March 3, 2022

Cirrus Cycles’ Kinekt Partners with Dutch Cargo

BELLINGHAM, Wash. March 3rd, 2022 /ENDURANCE SPORTSWIRE/ - Cirrus Cycles, the maker of the KINEKT suspension post and KINEKT suspension stem, proudly announces the addition of Dutch Cargo, the well-known Australian and New Zealand distributor, thereby increasing product available to customers worldwide. “Though we’re a small company based in Bellingham, Washington,...

Business

Cycling

Press Releases

Products