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

September 22, 2021

Kodiak Steps into New Territory in Fall ’21 Collection

Cambridge, Ontario, September 22, 2021 /ENDURANCE SPORTSWIRE/ -- Kodiak, the 110-year-old boot brand, is adding both more trail and urban inspiration to its Fall 2021 line. A new “sniker” collection that blends sneaker comfort and aesthetics with legitimate hiker performance, as well as several new urban boot styles highlight the...

Press Releases

Products

September 21, 2021

100%® Launches 2021 Peter Sagan Limited-Edition Collection in Time For World Championships and Paris-Roubaix

SAN DIEGO, Calif. – September 21, 2021 /ENDURANCE SPORTSWIRE/ -- 100%®, the San Diego-based sports performance company, has announced the launch of the 2021 Peter Sagan Limited Edition Collection.  Just in time for one of the most highly-anticipated Paris-Roubaix races and on the heels of Sagan’s victory in the Tour...

Cycling

Press Releases

Products

September 21, 2021

Marathon-Photos LIVE reaches USA

September 21, 2021 /ENDURANCE SPORTSWIRE/ -- Hot on the heels of its Live photography launch in the UK, world-leading endurance photo company MarathonPhotos.Live has launched its ground-breaking new service in the United States. Runners in San Francisco Marathon had their photos online within seconds of passing photographers – both on...

Press Releases

Products

Running

Triathlon

September 21, 2021

Lucyd SMART Eyewear Launches Lyte Sport

Miami, FL: Lucyd, the brand of Bluetooth-enabled sunglasses announces today the launch of its lineup of SMART eyewear designed for the sports market. In addition to its current assortment of lifestyle-focused designs, Lucyd is rolling out the “Lyte Sport” capsule collection of its popular Lyte frames, which offer a sleek...

Press Releases

Products

September 20, 2021

Introducing The Lyric™ Therapeutic Massager, An Evolution in Self-Care

SANTA MONICA, Calif., Sept. 20, 2021 – Today marks an evolution in self-care with the launch of the new Wi-Fi-enabled Lyric™ therapeutic massager. Say goodbye to ugly, aggressive and heavy massage guns made only for elite athletes. The stylishly designed Lyric was developed with everybody – and every body –...

Business

Press Releases

Products

September 20, 2021

Gold-medal rowers turn to Myovolt technology during Olympic preparation

In preparation for this year's Olympic Games, getting treatments for warm-up or recovery physiotherapy was often limited to a Zoom session. Add to this the stress of being in travel quarantine and it’s clear that many athletes were forced out of their comfort zone, with  stark changes to their routines....

Press Releases

Products

September 20, 2021

Sports Photography makes a splash in Hyde Park at the Children with Cancer UK Swim Serpentine

Photography of mass sporting events has taken a leap forward thanks to a new space-enabled service used at the prestigious Children with Cancer UK Swim Serpentine. While swimmers taking part would have in the past expected to wait days for pictures from the event organisers, thousands of photos were today...

Events

Press Releases

Products

September 20, 2021

Supersapiens Launches New Real-Time Data Display Wearable, The Supersapiens Energy Band

ATLANTA, 20 September 2021 — Supersapiens ecosystem, powered by Abbott’s Libre Sense Glucose Sport Biosensor, announced today the first Supersapiens glucose display wearable designed specifically for athletes. The Supersapiens Energy Band, Version Zero is the first and only wearable device that can read sport glucose data directly from Abbott’s Libre...

Cycling

Press Releases

Products

Running

Triathlon

September 20, 2021

Mongoose Resurrects Legendary Designs In Classics Collection

MADISON, Wis. (September 20, 2021) – Few bikes have defined a generation of innovation and design the way Mongoose’s iconic designs of the 1970’s and 1980’s did for BMX. The brand’s Supergoose and California Special inspired generations of cyclists with new technologies, unique styling, and the professional athletes who rode them....

Cycling

Press Releases

Products