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

February 21, 2022

Special-Edition Ready.Set.MOVE. Box Celebrates International Women’s Day

PITTSBURGH, PA (February 21, 2022) /ENDURANCE SPORTSWIRE/ - P3R has revealed this year’s women-themed Ready.Set.MOVE. box that celebrates International Women’s Day. Back by popular demand, the limited-edition box is curated with fitness items and goodies that will support and empower women along their wellness journeys. This box is available for purchase...

Press Releases

Products

Running

February 17, 2022

Spoked makes it simple for Every Cyclist to Train Smarter

/ENDURANCE SPORTSWIRE/ - Richard Lang is a decorated former professional cyclist turned tech entrepreneur. Starting his cycling career at the age of 16, Lang went on to represent his home country of Australia, achieving wins in numerous events including 1st place overall at the UCI Oceania Tour 2011. At the age...

Cycling

Press Releases

Products

February 17, 2022

Acer Group subsidiary, Xplova, launches official demo events in collaboration with ROUVY

Taipei, Taiwan / February 17, 2022 /ENDURANCE SPORTSWIRE/ - What kind of gaming can take you from Berlin to Paris to London in one single day? In the times of the pandemic era, ROUVY provides anyone with the opportunity to travel around the world without even leaving their home. ROUVY...

Press Releases

Products

Trade Shows

February 16, 2022

Quintana Roo breaks fit paradigm with unisex fit in new HYDROsix2 and HYDROfive2 wetsuit

Chattanooga, TN (Feb. 16, 2021) /ENDURANCE SPORTSWIRE/ - Quintana Roo announces the debut of the all-new HYDROsix2 and HYDROfive2 triathlon wetsuit range, a series of triathlon wetsuits delivering a performance-focused industry first: a Unisex Fitting System, presenting a range of wetsuit sizes based around body measurements, rather than gender. As the company...

Press Releases

Products

Triathlon

February 16, 2022

Leading Compression Wear Brand CEP Launch a New Range of Run Socks For 2022

/ENDURANCE SPORTSWIRE/ - CEP’s new Run Sock Collection includes five products to suit all needs - knee-high socks, calf sleeves, mid-cut, low cut, and no show socks. Each product is packed with intelligent features to improve performance, reduce fatigue, and provide unbeatable comfort. CEP’s compression technology stimulates blood flow, reduces muscle...

Press Releases

Products

Running

February 16, 2022

Groundbreaking Sports Documentary Series Released by Super League Triathlon

/ENDURANCE SPORTSWIRE/ - Super League Triathlon’s groundbreaking documentary series Every Second Counts has been released today. Episode 1: The Golden Quartet is available exclusively through Super League Triathlon’s YouTube channel. It tells the story of the four British Olympic gold medal winning heroes and their homecoming race in London to...

Press Releases

Products

Triathlon

February 15, 2022

Personal Training Reimagined: P3RFORM is an Individualised Coaching Service from the team at Game Changer Performance

/ENDURANCE SPORTSWIRE/ - Physical performance specialists Game Changer Performance have launched their own coaching app - P3RFORM - to bring their world-class performance services to a wider audience. The 24/7 holistic offering prioritises lifestyle, movement, and each individual’s own personal circumstances and goals.  At the heart of the brand is quality:...

Press Releases

Products

February 15, 2022

GO Sleeves Brings Kinesiology Technology to Arms

San Jose, CA (February 15, 2022) /ENDURANCE SPORTSWIRE/ - GO Sleeves, the company that introduced the world’s first and only compression sleeve with built-in kinesiology strips, announced today two new product releases: GO Sleeves® Elbow Sleeve and the Acupressure Elbow Strap by GO Sleeves®. The two products can be worn separately or...

Press Releases

Products