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

March 8, 2022

Ashworth Awards to Open Second U.S. Manufacturing Facility

/ENDURANCE SPORTSWIRE/ - Ashworth Awards is in the process of constructing their second manufacturing facility for their fully made in USA domestic medallions and awards line. In February of 2020, Ashworth Awards launched its new line of MADE IN USA medals and awards and it quickly became apparent that an...

Business

Press Releases

Products

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