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 (8742)
) 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 5040, 10

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

GFNY Costa Rica: volcano and jungle

/ENDURANCE SPORTSWIRE/ – 700 riders are lining up this Sunday in La Fortuna for the third GFNY Costa Rica. The race through the jungle around El Arenal volcano is 152km long with an elevation gain of almost 3000m thanks to a relentlessly undulating course. Race week activities will take place at...

Cycling

Events

Press Releases

June 29, 2022

USA Cycling Announces 2022 BMX Racing World Championship Team

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – USA Cycling announced today the 22 athletes that will be representing the United States at the 2022 UCI BMX Racing World Championships in Nantes, France on July 30-31. The star-studded roster includes Tokyo 2020 Olympians Corben Sharrah (Tucson, Ariz.; Daylight Cycle Co.), Payton Ridenour (Tulsa; OK.; Mongoose Bicycles),...

Cycling

Events

Press Releases

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

USA’s Alyssa Sauro Wins 2022 International U18 Mountain Running Cup

/ENDURANCE SPORTSWIRE/ – The 15th annual International U18 Mountain Running Cup was held Sunday, June 26, in Saluzzo, Italy and the U.S. U18 Mountain Running Team was on hand to participate with a full squad of 4 girls and 4 boys. The team looked forward to the challenge of the 4.4...

Events

Press Releases

Running