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

March 9, 2023

Showcased

Online Cycling Hub Offers Free Trial to Cyclists Everywhere

HOLLAND, MI (March 9, 2023) /ENDURANCE SPORTSWIRE/ – 10 Buck Bike Club, LLC—an online community created by cyclists, for cyclists—is now offering an easy, no-cost trial membership to cyclists of all abilities from around the world to continue building a safe, friendly, inclusive cycling community unlike any on the Internet. Created...

Cycling

Press Releases

Products

March 9, 2023

BikeInsure Announces Integration with Industry-Leading SmartEtailing Platform

March 9, 2023 / ENDURANCE SPORTSWIRE / – BikeInsure, an insurtech company specializing in affordable bicycle insurance for cyclists in the United States, is defining a new cycling industry standard for Bike Shop Retailers with a digital integration to SmartEtailing. SmartEtailing is best known as America’s largest provider of bike shop...

Cycling

Press Releases

Products

March 9, 2023

Altra Welcomes Adaptive Ultrarunner Jacky Hunt-Broersma to Altra Elite Athlete Team

DENVER (March 9, 2023) /ENDURANCE SPORTSWIRE/ – Altra, a leading innovator in performance running, is excited to welcome its newest ultra-athlete, Jacky Hunt-Broersma, to the Altra Elite Athlete Team. Ultra runner, cancer survivor and world record holder for running 104 marathons in 104 days, Hunt-Broersma is one of the most accomplished adaptive ultramarathoners...

Press Releases

Running

Sponsorship

March 9, 2023

The Berryman Adventure Race provides live tracking for the first time

Front Royal, Va. /ENDURANCE SPORTSWIRE/ – The Berryman Adventure Race will be incorporating live event tracking for the first time, thanks to GPS tracking services provided by Enabled Tracking. The race, hosted by Rolla Multisport, will take place on April 1st, 2023, in Eminence, MO. According to the event website, the...

Events

Press Releases

Products

March 9, 2023

GFNY Uruguay – Punta del Este 5th edition this Sunday

/ENDURANCE SPORTSWIRE/ - This Sunday, GFNY Punta del Este offers riders a demanding 146 km race course with an elevation gain of 1653 m. Start and finish will be at Parador Pedro Figari beach club in the heart of the swanky Punta del Este, one of Latin Americans most famous...

Cycling

Events

Press Releases

March 8, 2023

Sixteen Individuals Selected to be USABA Sport Ambassadors for 2023

Colorado Springs, Colo. (March 8, 2023) /ENDURANCE SPORTSWIRE/ - The U.S. Association of Blind Athletes (USABA) is pleased to announce 16 individuals who will serve as the organization’s sport ambassadors for 2023. Now in its second year, the USABA Sport Ambassador Program utilizes key stakeholders within the blind and visually...

Business

Press Releases

March 8, 2023

Enduro Bearings Solidifies Distribution Partners and Expands Product Availability in Canada and Central America

Oakland, California /ENDURANCE SPORTSWIRE/ - Enduro Bearings, in its ongoing efforts to grow distribution across the world, is announcing multi-year distribution agreements with Orange Sport Supply in Canada and Grupo GL in Central America. Grupo GL will represent Enduro Bearings in Costa Rica, El Salvador, Nicaragua, Guatemala, Honduras, Panama and Belize....

Business

Cycling

Press Releases

Products

Triathlon