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

April 14, 2022

Showcased

Liv introduces new Macha Pro Performance Road Cycling Shoe

NEWBURY PARK, Calif. (April 14, 2022)/ENDURANCE SPORTSWIRE/ – Liv, the company dedicated to getting more women on bikes, today introduced the new Macha Pro, its lightest and most efficient performance road cycling shoe. Designed to support riders’ efforts to get the most power out of every pedal stroke, WorldTour team riders...

Cycling

Press Releases

Products

SWW Syndication

April 13, 2022

2022 KINeSYS Champion Applications Now Open

/ENDURANCE SPORTSWIRE/ – KINeSYS Performance Sunscreen has opened applications for its 2022 Brand Ambassador Program. Now in its fourth year, the hugely successful program will once again be growing the Champion community, this year featuring over 80 Ambassadors. KINeSYS is inviting individuals from Canada and the USA who are passionate...

Press Releases

Products

Sponsorship

April 11, 2022

Powering Progress Indoors and Out: Wattbike to offer New Customers a Sigma Sports Voucher Plus Free Delivery on the Next Generation Wattbike Atom

ENDURANCE SPORTSWIRE/ – The mission at Wattbike has been the same for over 20 years, to create the ultimate indoor training bike. The Next Generation Atom is no different with a combination of industry leading accuracy, data measurement and design. Add in real ride feel, instant gear changes and the...

Cycling

Press Releases

Products

April 11, 2022

Showcased

Jan Frodeno joins Australian micronutrition start up

/ENDURANCE SPORTSWIRE/ - Australian sports micronutrition brand, PILLAR Performance has landed one of endurance sports biggest names, with Jan Frodeno signing on as the brand’s Global Ambassador. Widely considered the greatest triathlete of all time, Frodeno has an unrivalled resume over Olympic, 70.3 and full IRONMAN© distance in a career...

Press Releases

Products

Sponsorship

Triathlon

April 8, 2022

Giant and Stages Cycling Launch New GPS Cycling Computer

(Boulder, CO – 8 April, 2022) /ENDURANCE SPORTSWIRE/ - Stages Cycling and Giant are proud to announce the launch of two new GPS cycling computers. The Dash M200 and Dash L200 are available now  through both companies' existing global distribution networks. The Dash 200 features a brilliant full-color screen, cycling...

Business

Cycling

Press Releases

Products

April 7, 2022

BikeFlights Introduces New Bike Shipping Boxes

PORTLAND, OR (April 7, 2022) /ENDURANCE SPORTSWIRE/ - BikeFlights, a bicycle shipping service and supplier of bike boxes, is pleased to introduce its new line-up of BikeFlights Bike Shipping Boxes. After years of development, testing and continued improvements, BikeFlights now offers four patented bike shipping boxes engineered to give cyclists...

Cycling

Press Releases

Products