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

June 14, 2023

“Get 10% Fitter” or your money back on Wattbike purchases

/ENDURANCE SPORTSWIRE/ – Wattbike is the original, indoor smart bike innovator, offering the most accurate and reliable training tools used by champions, athletes and fitness enthusiasts worldwide. With a mission to improve the health and fitness of every athlete in the world, Wattbike’s most recent campaign ‘Get 10% fitter, Guaranteed’ is their...

Cycling

Press Releases

Products

June 13, 2023

KINeSYS Sunscreen Awarded Pro-Bono BibRave Program

/ENDURANCE SPORTSWIRE/ - KINeSYS Performance Sunscreen is excited to be a recipient of BibRave’s new pro-bono program, “BibRave Brand Picks.” BibRave Brand Picks is a return to the company’s roots of finding and promoting nascent, innovative, and creative new products and brands. Commencing early June, the KINeSYS x BibRave partnership...

Awards

Business

Press Releases

Products

Running

June 12, 2023

Next-generation marketing and communications platform for endurance events partners with Broken Arrow SkyRace

/ENDURANCE SPORTSWIRE/ - Capra is thrilled to announce their partnership with their first US race outside of Australia and New Zealand, Broken Arrow SkyRace in Palisades Tahoe that is taking place this week on June 16-18 (US). With Capra’s innovative mobile-first platform, Broken Arrow SKyRace race directors and event managers...

Business

Events

Press Releases

Products

Running

Sponsorship

June 12, 2023

Injinji Partners with Fellow San Diego-Based Sock Company

San Diego, Calif. (June 12, 2023) /ENDURANCE SPORTSWIRE/ – Injinji, the innovator of the patented five-toe Performance Toesock™ today announced its collaboration with fellow San Diego-based sock company, Pointe Studio on the new Injinji x Pointe Studio series. The partnership will create innovative and never-before seen Grip Socks for athletes who...

Business

Press Releases

Products

June 9, 2023

Royal Robbins Launches Spring 2024 Collection

SAN FRANCISCO (June 9, 2023) /ENDURANCE SPORTSWIRE/ - Royal Robbins is excited to launch its Spring 2024 apparel collection with focus on enabling adventure. As one of the outdoor apparel industry’s most authentic brands, Royal Robbins was started 55 years ago by Liz and Royal Robbins, iconic climbers and adventurers....

Press Releases

Products

June 8, 2023

ENVO Drive E-Mobility Brand Taps SIMBOL Communications as PR Agency of Record

Vancouver, Canada (June 8, 2023) /ENDURANCE SPORTSWIRE/ - Hoping to build on seven years of steady growth across North America, ENVO Drive Systems – designer of traditional e-bikes as well as unique, purpose-built e-vehicles for snow, water and 4-wheeling – is partner with SIMBOL Communications as their PR Agency of...

Business

Cycling

Press Releases

Products

Running

Triathlon