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

June 30, 2022

Embrace Your Wild Side with The New Alta Gravel Wheelset from Parcours

/ENDURANCE SPORTSWIRE/ – Parcours is on a mission to encourage people to #ridefurther with their lightweight, versatile wheelsets. Their latest Alta is a gravel-focused wheelset, sporting an updated, wider hookless rim - optimised for gravel tyres to support cyclists on all types of adventures. From hard-packed Tuscan white gravel ‘strade bianche’...

Cycling

Press Releases

Products

June 29, 2022

Presca creates Heal Jersey to further their Charity Partnership with Heal Rewilding

/ENDURANCE SPORTSWIRE/ – Presca Sportswear (https://www.prescasportswear.com/), the world's first climate positive sportswear company, are helping to transition the fashion and sports industry towards a much more positive model. They do all they can to be part of the solution, not the continuation, of the climate problem. As well as overcoming issues...

Cycling

Giving

Press Releases

Products

June 29, 2022

Motiv Sports Gains a Competitive Edge with EventHub

Seattle, WA – June 29, 2022 /ENDURANCE SPORTSWIRE/ - EventHub, the leading expo software in the endurance racing industry, has announced a technology partnership with Motiv Sports as the exclusive expo management software for their race portfolio, which includes the Long Beach Marathon, Napa to Sonoma Wine Country Half Marathon,...

Events

Press Releases

Products

Running

Sponsorship

June 29, 2022

RunSignup Announces CheckIn App with Label Printing

June 29, 2022, Moorestown, NJ /ENDURANCE SPORTSWIRE/ - RunSignup, the leading registration provider for U.S. endurance events, announces RaceDay CheckIn now with custom label printing. Race events using the RaceDay CheckIn app are now able to print personalized participant information to create more efficient processing at packet pickup and on...

Cycling

Events

Press Releases

Products

Running

Triathlon

June 28, 2022

Barebells Protein Bars Welcomes TikTok Sensation Noah Beck to Brand Ambassador Team

LOS ANGELES /ENDURANCE SPORTSWIRE/ – Barebells – the delicious high-in-protein, no added sugar* protein bar brand designed to feed your cravings – is proud to welcome social media phenom and former D1 Athlete Noah Beck to their growing team of brand ambassadors. Committed to fitness and wellness, Noah will continue to...

Press Releases

Products

Sponsorship

June 28, 2022

Showcased

Predictive Fitness and TriDot Announce A Groundbreaking Technology Partnership With G.O.A.T. Mark Allen

DALLAS, TX – JUNE 28, 2022 /ENDURANCE SPORTSWIRE/ - TriDot, a division of Predictive Fitness, Inc. and Mark Allen, the Greatest Endurance Athlete of All Time and 6x IRONMAN Triathlon World Champion are proud to announce the creation of the TriDot Mark Allen Edition. The TriDot platform is the first...

Business

Cycling

Press Releases

Products

Running

Triathlon