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

December 12, 2022

Stages Cycling Dual Sided Power Meter for Dura-Ace 9200 Available Now

Boulder, CO – 12 December, 2022 /ENDURANCE SPORTSWIRE/ – Stages Cycling, a leading cycling technology company, today announced the launch of its dual sided power meter for Shimano’s latest 12-speed Dura-Ace 9200 cranksets. The drive-side Stages R crank arms and dual sided Stages LR cranksets for Shimano’s 12-speed groups feature a new power...

Cycling

Press Releases

Products

December 11, 2022

3Mgives Names FindingHomeATX the 2023 Beneficiary of 3M Half Marathon

AUSTIN, TX, December 11, 2022 /ENDURANCE SPORTSWIRE/ – 3Mgives selects FindingHomeATX as the beneficiary of the 2023 3M Half Marathon. This grant will allow the Austin-based community organization to help reach its goal of ending unsheltered homelessness in Austin by scaling up Austin’s Homelessness Operating System (OS) into one that's sustainable...

Events

Giving

Press Releases

Running

December 11, 2022

Marathon Maniacs & Half Fanatics To Meet-Up at Publix Florida Marathon Weekend

December 11, 2022 /ENDURANCE SPORTSWIRE/ – The 15th Annual Publix Florida Marathon Weekend is excited to announce the hosting of an event Meetup of Marathon Manics and Half Fanatics members during its February 12, 2023 weekend of running. The marathon and half-marathon have been recognized by Runner’s World Magazine as “One of...

Events

Press Releases

Running

December 10, 2022

Werner and Gilbert Win Singlespeed Titles on Day 5 of Cyclocross Nationals

HARTFORD, Conn. /ENDURANCE SPORTSWIRE/ – The 2022 USA Cycling Cyclocross National Championships continued on Saturday with freezing temperatures that changed the course conditions drastically. What were once pits of mud have now become deep, frozen ruts. The day began with the Industry races. Taking the lead right after the pit was...

Cycling

Events

Press Releases

December 10, 2022

Best of Challenge Family Announced at the 2022 Race Awards

/ENDURANCE SPORTSWIRE/ – The votes are in and the winners of the 2022 Challenge Family Race Awards announced at the annual race director’s meeting, this year held at Anfi Resorts on Gran Canaria, home to Anfi Challenge Mogán Gran-Canaria. The Challenge Family Awards provide recognition to the race directors for their...

Awards

Press Releases

Triathlon

December 9, 2022

Stelljes, Wells, Ryse, and Myerson Earn Masters Titles on Day 4 of Cyclocross Nationals

HARTFORD, Conn. /ENDURANCE SPORTSWIRE/ – The 2022 USA Cycling Cyclocross National Championships continued on Friday with colder temperatures and dryer conditions. With crowds growing each day, Friday’s racing saw a packed venue, where cowbells could be heard all around. Championship racing kicked off with the Master Men 40-44. Neff Cycle Service...

Cycling

Events

Press Releases

December 8, 2022

The Canyons Endurance Runs by UTMB selected as the third UTMB World Series Major for 2023

CHAMONIX, France/AUBURN, Calif. USA/TAMPA, Fla. USA (Dec. 8, 2022) /ENDURANCE SPORTSWIRE/ – The Canyons Endurance Runs™ by UTMB® has been selected as the first ever UTMB World Series Major to be hosted in the Americas. Taking place from the 28-29 April 2023 in Auburn, California, the event gives all finishers additional opportunities...

Events

Press Releases

Running

December 8, 2022

Ciele Athletics Announces B Corp Certification

MONTREAL (Dec. 8, 2022) /ENDURANCE SPORTSWIRE/ – Ciele Athletics, the high-end performance running brand from Montreal, Quebec, is proud to officially announce its Benefit Corporation (B Corp) certification, a label awarded exclusively to companies that voluntarily meet the highest standards for social and environmental performance. Since embarking on its application journey...

Business

Press Releases

Running