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

April 5, 2023

KINeSYS Sunscreen Announces 2023 Brand Ambassadors

Vancouver, Canada, 05th April 2023 /ENDURANCE SPORTSWIRE/ - KINeSYS Performance Sunscreen is proud to announce our roster of 2023 KINeSYS Champions. Now in its fifth year, the Brand Ambassador program is a group of 35 individuals from all walks of life. A mix of professional athletes and keen amateur sporting enthusiasts,...

Cycling

Press Releases

Products

Running

Sponsorship

April 4, 2023

Thousand Prioritizes Inclusivity and Rider Diversity in Heritage 2.0 – An Innovative Evolution of its Best-Selling Helmet

Los Angeles (April 4, 2023) /ENDURANCE SPORTSWIRE/ – Thousand, creators of vintage-inspired, innovative bicycle helmets and safety accessories, is proud to announce the launch of its Heritage 2.0 helmet, the next evolution of the brand's flagship model. Thousand prioritized diversity and inclusivity in designing the new helmet, hosting a comfort study performed...

Cycling

Press Releases

Products

April 3, 2023

The Woman-Owned Brand Fierce Hazel Launch Their First Ever On-The-Bike Bags

Los Angeles, CA (April 3, 2023) /ENDURANCE SPORTSWIRE/ - Fierce Hazel, the woman-owned, sustainable cycling accessory company, just released its first line of on-the-bike bags. The True Grit Collection are the first-ever cycling bags constructed from factory deadstock material Olefin. This eco-friendly fabric is durable, weatherproof, and stain-resistant, making it...

Cycling

Press Releases

Products

SWW Syndication

April 1, 2023

Tifosi Optics Celebrates 20th Anniversary with Platinum Giveaway Package

Watkinsville, GA (April 1, 2023) /ENDURANCE SPORTSWIRE/ – Tifosi Optics, the #1 brand of cycling eyewear in the United States, is thrilled to celebrate its 20th anniversary with an exciting giveaway promotion throughout the month of April. Beginning on April 1st, 2023, Tifosi fans can enter for the chance to win...

Business

Cycling

Press Releases

Products

Running

Triathlon

March 31, 2023

Tifosi Expands Swank Series Sunglasses with Smirk

Watkinsville, GA (March 31, 2023) /ENDURANCE SPORTSWIRE/ – Tifosi Optics, a leading sport and lifestyle eyewear brand, is thrilled to announce the launch of its newest lifestyle sunglass: Smirk. Designed for everyday wear and casual outdoor activities, Smirk is a fashionable yet functional pair of durable eyewear that won’t break the...

Cycling

Press Releases

Products

Running

Triathlon

March 31, 2023

Live tracking comes to the Buck Fifty

Front Royal, Va. /ENDURANCE SPORTSWIRE/ – The Buck Fifty, a popular 150-mile overnight relay race based out of Chillicothe, Ohio, is gearing up for their 2023 event on April 21-22. To help enhance the experience for participants and event directors alike, the Buck Fifty has partnered with Enabled Tracking, a real-time...

Events

Press Releases

Products

March 30, 2023

Showcased

Feature Documentary Film Announced with Support from DeFeet and Repreve

Hildebran, NC, March 30, 2023 /ENDURANCE SPORTSWIRE/ – Producer Shane Cooper and director Paul Willerton have teamed up to create a new feature-length documentary film, Flandrien. The film is set in the Flanders region of Belgium and explores the past, present, and future of cycling and local culture. The Tour of...

Cycling

OSW Syndicated

Press Releases

Products

SWW Syndication