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

January 17, 2023

IRC Tire Selected as Official Tire of Unbound Gravel

Davis, CA /ENDURANCE SPORTSWIRE/ – IRC Tire is pleased to announce that they have been chosen as the official tire of Garmin Unbound Gravel presented by Craft, the premier gravel cycling event in the world. Unbound Gravel, known for its challenging terrain, requires tires that can withstand the rigors of off-road...

Cycling

Press Releases

Sponsorship

January 17, 2023

Life Time Presents Gripping, Original Docuseries on Inaugural Life Time Grand Prix presented by Mazda

Boulder, Colo., (Jan. 17, 2023)/ENDURANCE SPORTSWIRE/ – Life Time (NYSE: LTH), the nation’s premier healthy lifestyle brand, announces “Call of a Life Time,” a docuseries made up of six binge-worthy episodes that follows the elite women and men in the inaugural Life Time Grand Prix presented by Mazda. Launching on January 27,...

Cycling

Events

Press Releases

Products

January 17, 2023

US Trail Running Conference opens regsitration for 2023 event

Nailsworth, England /ENDURANCE SPORTSWIRE/ – The eleventh annual US Trail Running Conference returns to Mukilteo, Washington, for the second consecutive year on October 18-20, 2023. The industry leading in person only event features presentations and panel discussions, morning trail runs and vendor displays. The event mission is to lead, educate, connect...

Press Releases

Running

Trade Shows

January 17, 2023

National Cycling League (NCL) announces ZIeL Concept Store as the Miami Race Fan Headquarters and Club House for the Miami Nights Cycling Club

Miami, FL, January 17, 2023 /ENDURANCE SPORTSWIRE/ – The National Cycling League, the first of its kind in professional sports built around 21st century values of diverse ownership, gender equality, technology, and sustainability, today announced that it has selected ZIeL Concept store, Miami’s preeminent cycling resource and lifestyle community store as the...

Business

Cycling

Events

Press Releases

January 16, 2023

IRC Expands Partnership with Belgian Waffle Ride

Davis, CA /ENDURANCE SPORTSWIRE/ IRC Tire (Inoue Rubber Company) is pleased to announce an expanded partnership with Monuments of Cycling (MOC)’s iconic Belgian Waffle Ride (BWR). IRC will continue as the Official Tire of the growing series of BWR’s ‘Unroad Races’, which are unique mixed-surface Classics-style events. New for 2023,...

Cycling

Press Releases

Sponsorship

January 15, 2023

Runners across the globe go the distance at the 2023 Louisiana Marathon and Half Marathon

BATON ROUGE, La. /ENDURANCE SPORTSWIRE/ – Under ideal running weather the Louisiana Marathon and Half Marathon runners braved the 26.2 and 13.1-mile distances on Sunday through downtown Baton Rouge. Crowds of racers gathered in front of the state Capitol at daybreak, and at the strike of 7:00 AM, they took off...

Events

Press Releases

Running

January 13, 2023

DMSE Sports Serves More Than 120,000 Participants In 2022

BOSTON /ENDURANCE SPORTSWIRE/ – DMSE Sports has released key facts and figures from their 2022 events, showing evidence of road racing’s recovery over the past year. The leading event operations organization founded and lead by Dave McGillivray assisted with the planning and production of 24 events this year, ushering more than...

Business

Events

Press Releases

January 12, 2023

eMSR – Open National Slovak Cycling eSport Finals on ROUVY

Bratislava, Slovakia / January 12, 2023 /ENDURANCE SPORTSWIRE/ - After 4 completed rounds of the Slovak eCup, the e-cycling series will culminate this Sunday, January 15th with a fight for the home championship jersey in virtual cycling. The best Slovak riders in each category will battle in Styla Arena in...

Cycling

Events

Press Releases