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

March 27, 2024

Wattbike Atom now available for purchase in Ireland

27th March 2024, Nottingham, UK - Leading indoor cycling brand Wattbike have announced that their award winning Wattbike Atom is now available to purchase directly by their Irish customers. Wattbike is the original indoor smart bike innovator, offering the most accurate and reliable training tools used by champions, athletes, and...

Cycling

Press Releases

Products

March 27, 2024

Verge Launches Gravel Apparel Range: Empowering riders to explore in their own style.

NEW YORK, March 27th 2024 - Verge, the forward-thinking custom cycling apparel brand, today introduces its Gravel Range - a collection designed for riders who seek adventure both on and off the beaten path. This versatile line offers a perfect blend of performance, comfort, and style, allowing cyclists to confidently...

Cycling

Press Releases

Products

March 26, 2024

Eastern Mountain Sports to Make Debut Appearance at The Boston Outdoor Expo, Showcasing Premier Outdoor Brands and Interactive Tent Showcase

Boston, MA /ENDURANCE SPORTSWIRE/ – Set to be a highlight event for the Spring season, the debut of The Boston Outdoor Expo will take place at the Boston Convention & Exhibition Center, April 27-28, 2024. The organizers have announced a collaboration with Eastern Mountain Sports which promises to bring an...

OSW Syndicated

Press Releases

Products

Trade Shows

March 26, 2024

Altra’s New Vanish Carbon 2 Unites Speed and Comfort

DENVER, Colo. (March 26, 2024) /ENDURANCE SPORTSWIRE/ - Altra, a leading innovator in performance running, announces the second iteration of the award-winning Vanish Carbon road racing shoe. “After years of working with elite athletes, we were beyond excited to launch the original Vanish Carbon back in 2022”, according to Altra...

Press Releases

Products

March 26, 2024

Rudy Project North America Introduces Kelion Sunglasses in NEW Frame Colors

San Clemente, CA, March 26, 2024 /ENDURANCE SPORTSWIRE/ - Rudy Project, renowned Italian creators of sports performance eyewear and helmets, unveils the latest addition to the Kelion lineup with new frame colors including crystal blue and olive matte. Crafted to elevate athletes' performance, Kelion combines comfort, functionality, and striking design...

Cycling

Press Releases

Products

Running

March 26, 2024

BibRave Presents Exclusive Press Event for Haptic Technology Company, Mojawa

Los Angeles, CA /ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, recently launched a partnership with the ascendent bone conduction headphone company, Mojawa. To showcase and celebrate the launch of Mojawa’s revolutionary new fitness tracker, the HaptiFit Terra, BibRave is hosting an exclusive press event on March...

Events

Press Releases

Products

March 21, 2024

Article One Recruits Elite Endurance Athlete and Creative Designer César Villalba in Bespoke Performance Eyewear Collaboration

FLINT, Mich. (March 21, 2024) /ENDURANCE SPORTSWIRE/ - Article One, the independent eyewear brand creating handcrafted active and optical frames, and César Villalba, creative designer and elite triathlete, are excited to debut performance sunglasses crafted to counter traditional styles of eyewear in competitive fields. With flames emblazoned along the sides...

Cycling

Press Releases

Products

Running

Triathlon