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

February 21, 2022

Roark Run Amok Releases First Drop of Spring/Summer 2022

LAGUNA BEACH, CA. (Feb. 21,2022)/ENDURANCE SPORTSWIRE/ - The collections inspired by travel are neverending at Roark. The coastal landscapes of Oaxaca, on the southern point of Mexico inspire the colors and graphics that emblazon the new spring/summer collection of Run Amok trail running and active apparel, with vibes fit for...

Press Releases

Products

February 21, 2022

Sadhana Live Brings Together Yoga, Well-Being and a Thriving Community on One Platform

/ENDURANCE SPORTSWIRE/ - Sadhana Live offers thousands of live and on-demand yoga classes from globally renowned instructors, including three-time European and twice International Yoga Sport Champion, Almania Colombo; UK Yoga Champion Michael Eley; and former TV Gladiator, James ‘Hunter’ Crossley. The platform supports holistic health and well-being tools in the...

Press Releases

Products

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