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

November 22, 2023

Enduro Bearings Adds Linear Bearing Press Toolset to its Workshop Line

Oakland, California (November, 2023)/ENDURANCE SPORTSWIRE/ – Enduro Bearings understands the importance of careful bearing removal to avoid damaging expensive bicycle frames and wheel hubs, followed by precise bearing installation to optimize performance and longevity. For decades, the company has offered best-in-class bicycle bearing tools and today, as an example of the company’s...

Cycling

Press Releases

Products

Triathlon

November 22, 2023

Beyond Limits Running Debuts Rudolph’s Runderland Experience with Audio Enhanced Course

LAS VEGAS, NEVADA – November 22, 2023 /ENDURANCE SPORTSWIRE/ – Beyond Limits Running, the creative force behind the Happy Hippy Harvest Run and the Bee-utiful Sunflower Run, is thrilled to announce the inaugural Rudolph’s Runderland Experience, an unforgettable, family-friendly journey through the winter wonderland of historic Gilcrease Orchard in Las Vegas....

Events

Press Releases

Running

November 22, 2023

The RunnerBox and The RiderBox Announce Limited Edition Holiday Boxes

/ENDURANCE SPORTSWIRE/ – Leaders in the endurance sport gift industry, The RunnerBox and RiderBox, have released their highly anticipated Limited-Edition Holiday Box. This annual favorite has sold out every year since its debut and early indications show this year will be no different. Over 40% of the initial stock was...

Cycling

Press Releases

Products

Running

Triathlon

November 21, 2023

Canyon CLLCTV Rider Brad Simms Releases “Take Flight” Video Series

/ENDURANCE SPORTSWIRE/ – ANNOUNCEMENT: In collaboration with Brad Simms, Canyon Bicycles will release a new 4-part mini-series, "Take Flight," on November 21st at 17:00 CET. All four "Take Flight" episodes will be available for binge-watching on Canyon's YouTube channel, @CanyonBicycles. SERIES DESCRIPTION: Renowned BMX rider and Canyon CLLCTV rider Brad...

Cycling

Press Releases

Sponsorship

November 21, 2023

Only two more weeks until the runners from around the country descend upon the Mississippi Coast

BILOXI, MS./ENDURANCE SPORTSWIRE/ – Thousands of runners will converge on Coastal Mississippi on Dec. 8-10 to participate in the Mississippi Gulf Coast Marathon and Coastal Running Fest. The event, now in its 9th year, continues to grow, drawing participants from 46 states, the District of Columbia, Australia, Bahamas, Canada, Puerto Rico,...

Events

Press Releases

Running

November 21, 2023

The 2024 Austin Marathon Invites Local Bands to Set the Rhythm for Race Day

AUSTIN, Texas, November, 2023 /ENDURANCE SPORTSWIRE/ – The Ascension Seton Austin Marathon, Half Marathon & 5k, in collaboration with High Five Events, is calling on Austin's vibrant music scene to enhance the runner's journey by bringing the city's unmistakable sound to the 26.2-mile course on Sunday, February 18, 2024. For years, local...

Events

Press Releases

Running

November 21, 2023

Showcased

The Duel In The Desert: A Union Of Cycling Legends – Specialized Cactus Cup And Belgian Waffle Ride Arizona

Cave Creek and Fountain Hills, AZ /ENDURANCE SPORTSWIRE/ - In a soon to be historic collaboration, two iconic cycling races, the Specialized Cactus Cup and the Belgian Waffle Ride (BWR), are set to merge for a thrilling back-to-back cycling extravaganza, the "Duel in the Desert." Taking place on consecutive Saturdays, March...

Awards

Cycling

Events

Press Releases

Sponsorship

November 21, 2023

The Running Summit 2023: A Premier Gathering for Running Coaches, Athletes and Enthusiasts

November 21, 2023 , Rock Hill, SC /ENDURANCE SPORTSWIRE/ - The much-anticipated Running Summit is set to take place on December 9th - 10th, 2023, conveniently located near Charlotte, NC, at Winthrop University in Rock Hill. This two-day event is for runners, coaches, and fitness enthusiasts seeking insights, expertise, and...

Business

Events

Press Releases

Running

Triathlon

November 21, 2023

Team Magic Rebrands to Magic Sports: A New Era in Sport Event Production

Nashville, Tennessee – [November 21, 2023] /ENDURANCE SPORTSWIRE/ - Team Magic, a pioneering force in the world of endurance sports event production since its founding in 1985, is excited to announce its transformation into Magic Sports. This rebranding reflects the company's commitment to innovation, growth, and a continued dedication to...

Business

Press Releases

November 21, 2023

Dave McGillivray inducted into Medford High School’s Mustang Hall Of Fame

BOSTON, Mass. /ENDURANCE SPORTSWIRE/ – In a ceremony honoring and recognizing former exceptional athletes, coaches and community leaders who have made outstanding contributions to the Medford High School Athletics, Dave McGillivray was inducted into the Mustang Hall of Fame on Sunday. The Boston running legend was a member of the track...

Awards

Press Releases