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

October 19, 2021

Showcased

BikeFlights Makes It Easier To Ship E-Bikes

PORTLAND, OR (October 19, 2021) /ENDURANCE SPORTSWIRE/ - BikeFlights.com, a bicycle shipping service and bike box supplier, has just made it easier for individual cyclists and businesses to ship e-bikes within the contiguous U.S. “As more people have purchased e-bikes, the need to buy and sell as well as travel...

Business

Cycling

Press Releases

Products

October 19, 2021

Elite Runner Releases New Book about Running and Training Throughout Pregnancy and into the Fourth Trimester

/ENDURANCE SPORTSWIRE/ - Natasha LaBeaud Anzures, an elite runner for Canada, has just released a new book entitled, “Pregruncy: An Elite Runner’s Journey Training Through Pregnancy.” The book details every day of pregnancy and the first 90 days postpartum, which workout logs, personal thoughts, and training notes from both the...

Press Releases

Products

Running

October 15, 2021

ROUVY releases the augmented city tours around the European capitals with language localization

Prague, Czech Republic / October 15, 2021 - If anyone ever dreamed of a trip around the European capitals, he or she can do one from home on ROUVY’s indoor cycling reality platform now! The release brings the possibility to cruise through and get familiar with the impressive historic streets...

Cycling

Press Releases

Products

October 15, 2021

Nathan Sports Launches First Collection of Polarized Performance Eyewear

Fountain Valley, CA (October 15, 2021) – Nathan Sports, the performance running company specializing in hydration, storage, safety and apparel, is excited to announce their entry into the eyewear market with their first-ever line of performance-quality polarized sunglasses. Nathan strives to find purpose-driven solutions to offer the best quality products...

Cycling

Press Releases

Products

Running

October 14, 2021

UCAN Expands Product Assortment With New Strawberry Banana Edge

(Woodbridge, CT) The UCAN Company is expanding on its extraordinary innovation in sports fueling with the launch of new Strawberry Banana UCAN Edge. The new formula features a delicious fruit flavor that goes down smooth to drive optimal performance. Edge is a convenient, portable pouch that puts the power of...

Cycling

Press Releases

Products

Running

Triathlon

October 14, 2021

Showcased

F2C Nutrition Official Nutrition Partner of the Norco Canadian Enduro Championship

Vancouver, B.C. – October 14, 2021 – F2C Nutrition is set to supply the Norco Canadian Enduro Championship with nutritional products made from clean, naturally sourced ingredients supported by innovative scientific research. Internationally known and recognized for quality and innovation.  F2C Nutrition was born from the vision and passion of...

Press Releases

Products

Sponsorship

October 13, 2021

Parcours and Kogel Bearings Partner to Offer The Ultimate Triathlon Bike Upgrade Package

British-brand Parcours (https://www.parcours.cc/)  are pleased to announce the launch of a competition sweepstake between themselves and Kogel Bearings, to take the winners' performance to the next level. The sweepstake prize will offer the lucky winner an upgrade package to vastly improve the aerodynamics and efficiency of a bike of their...

Cycling

Giving

Press Releases

Products

Triathlon

October 13, 2021

InsideTracker Integrates Blood, DNA, Fitness Tracking Data to Deliver Personalized Performance, Nutrition Plans on Android-Compatible Devices

CAMBRIDGE, Mass.— Oct. 13, 2021— InsideTracker, the leading truly personalized performance and nutrition system, today announced the availability of the InsideTracker app for Android™, marking a revolution in personalized health and wellness for Android users by bringing together blood biometric data, DNA insights and fitness tracker data to create science-backed...

Cycling

Press Releases

Products

Running

Triathlon