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 (16)
) 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 4590, 10

July 3, 2022

Tabor Hemming and Andy Wacker Win USATF Mountain Running Championships

/ENDURANCE SPORTSWIRE/ - After last year’s championships event was hosted by the Gnar Gnar on Mt Hood in Oregon, the USATF Mountain Running Championship returned to the “Beast Coast” to be hosted by the Whiteface Mountain Races in the Adirondack Mountains of New York State. Perfect racing weather set the...

Events

Press Releases

Running

July 1, 2022

Endless Mountains Adventure Race Debuts in Adventure Racing World Series

/ENDURANCE SPORTSWIRE/ – The first Endless Mountains Adventure Race joined the Adventure Racing World Series this June as a demonstration race for 2022, attracting a strong entry of 32 teams. Most of the competitors were very experienced US racers, drawn by the reputation and organising talents of Brent Freedland and Abby...

Events

Press Releases

July 1, 2022

Priority Bicycles Announces Cruise the Coast Summer Tour

New York, NY /ENDURANCE SPORTSWIRE/ - Priority Bicycles, leaders in low maintenance bicycles, announces the Cruise the Coast summer tour designed to allow residents and vacationers to experience its market-leading, Gates belt-driven coastal beach cruiser first-hand in its natural habitat. In partnership with Gates Carbon Drive, the Cruise the Coast...

Business

Cycling

Events

Press Releases

July 1, 2022

Gran Fondo Asheville Keeps National Championship Cycling in North Carolina for Second Year

(Gettysburg, PA – July 1, 2022) /ENDURANCE SPORTSWIRE/ - On Sunday, July 17, 2022, the Gran Fondo National Series will hold the annual Gran Fondo Asheville, p/b Applewood Manor cycling event, which includes the official USA Cycling Gran Fondo National Championship competition. The event reached its sold-out capacity of 1,000...

Cycling

Events

Press Releases

June 30, 2022

XTERRA Short Track France LIVE this Saturday

June 30, 2022/ENDURANCE SPORTSWIRE/ – The 2022 XTERRA Short Track season gets underway this Saturday, July 2, in Xonrupt, France with the women’s race at 16:20 CEST, and the men to follow at 17:20 CEST. Commentators Paul Groves, Roger Serrano, and Chun de Stockel will provide play-by-play and analysis during free, live...

Events

Press Releases

Triathlon

June 30, 2022

WorldTour Teams EF Education-EasyPost and Israel-Premier Tech Added to the Line-up for September’s Maryland Cycling Classic

BALTIMORE, Md. – The Maryland Cycling Classic supported by UnitedHealthcare, America’s top-ranked professional road cycling race and highest-ranked UCI event, today announced seven additional teams for the inaugural event, scheduled for September 4, 2022, bringing the field up to 16 total teams. WorldTour teams EF Education-EasyPost, Israel-Premier Tech will be...

Cycling

Events

Press Releases

June 29, 2022

Sanchez and Santamaría win at GFNY Waco Texas

New York City, June 29, 2022 /ENDURANCE SPORTSWIRE/ - GFNY Waco Texas started off with a fresh morning but temperatures well above 100F were expected later in the day for riders on the long competitive racecourse of 85.7 miles with a total elevation gain of 2490 ft. The race started...

Cycling

Events

Press Releases

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