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

November 26, 2024

Gift Health, Happiness, and AI Innovation with Humango

Boulder, CO. (November 26, 2024) /ENDURANCE SPORTSWIRE/ – As the holiday and gift-giving season approaches, Humango™, a digital training platform for endurance athletes that provides personalized and adaptive training plans, is set to release a series of incredible discounts for the health and wellness enthusiast close to you. In a...

Press Releases

Products

November 20, 2024

Suunto Race S Titanium Courtney – The special glow-in-the-dark watch, designed with Courtney Dauwalter

VANTAA (19. November 2024). /ENDURANCE SPORTSWIRE/ - Courtney Dauwalter, the expert of ultra running, is known for her unmatched mental toughness. She breaks down races into manageable sections, focusing on the next milestone, and uses positive self-talk to stay driven. Phrases like "embrace the pain" and "right foot, left foot"...

Business

Products

Sponsorship

Trade Shows

November 20, 2024

Colnago Steelnovo: The Art of Steel Bikes Reinvented

November 20th. /ENDURANCE SPORTSWIRE/ - Colnago celebrates 70 years of history with Steelnovo, a bicycle that brings steel back into the spotlight. Launched as a 70-piece limited edition, it features premium, custom components crafted exclusively by Colnago Italian partners for this release. In a carbon-dominated market, Steelnovo is a return...

Cycling

Press Releases

Products

November 19, 2024

The James Brand Unveils The Bolen: Premium Titanium, Twist Pen for Everyday Carry

PORTLAND, OR (November 19, 2024) /ENDURANCE SPORTSWIRE/ - The James Brand - makers of modern, minimal everyday carry products – announces the expansion of its Communication Category with the launch of The Bolen, the brand’s first twist-retractable pen, complementing its assortment of writing tools. The premium titanium pen elevates the...

Press Releases

Products

November 19, 2024

Selkirk Sport Launches Pro Line Apparel Collection, designed with performance and style in mind

Professional pickleball player Judit Castillo wears the Women’s Pro Dress in Atmosphere blue from the new Selkirk Sport Pro Line Apparel collection. COEUR D’ALENE, Idaho – Nov. 19, 2024 /ENDURANCE SPORTSWIRE/ – Selkirk Sport, a leader in pickleball innovation, is expanding its product lineup with the debut of the Pro...

Press Releases

Products