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

July 6, 2022

Expert Daily Insight on Tour de France: Feat. Brian Smith & Sportive Breaks

/ENDURANCE SPORTSWIRE/ – Sportive Breaks (https://sportivebreaks.com/) have teamed up with top cycling commentator Brian Smith to provide exclusive Tour de France ‘daily insight’ across their social platforms. Brian Smith is an ex pro cyclist, a previous British champion and Olympian, better known in cycling circles as “The Coach” who has now turned his hand to cycling...

Cycling

Events

Press Releases

July 6, 2022

Maine Summer Adventure Race named USARA Regional Championship

Portland, MAINE /ENDURANCE SPORTSWIRE/ - The sixth annual Maine Summer Adventure Race will take some of the most hardcore athletes in the United States on a 24-hour journey around the greater Portland, Maine area in July 2022. The 24-hour race, which will take teams of two to four people on...

Events

Press Releases

July 5, 2022

XTERRA France Weekend Wrap

/ENDURANCE SPORTSWIRE/ - Panagiotis Bitados (GRE) and Loanne Duvoisin (SUI) won the exciting new XTERRA Short Track France off-road triathlon titles with times of 39:35 and 46:10, respectively, on a beautiful day in Xonrupt on Saturday, July 2, 2022. It’s the first Short Track win for Bitados and the third...

Events

Press Releases

Triathlon

July 4, 2022

Break the Record. Break the Cycle.

YAKIMA, WA /ENDURANCE SPORTSWIRE/ - Rosalie Fish ran 12 miles for Miles Against Violence at the Downtown Yakima Mile, each mile she completed received over $4,400 pledged—over $53,000 in total pledge donations. Fish, internationally respected athlete and activist, ran the Yakima Mile this year “to demonstrate that every single one...

Events

Giving

Press Releases

Running

Sponsorship

July 4, 2022

‘La Vuelta Virtual 22’ Warm-Up Racing Weekend #2 – July

Madrid, Spain / July 4th, 2022 /ENDURANCE SPORTSWIRE/ – La Vuelta calls on cyclists and fans, of all fitness levels, to ride with the pros from the Equipo Kern Pharma to explore Spain. ROUVY’s augmented roads grant the ability to travel virtually around places one can only dream of visiting. Race virtually...

Cycling

Events

Press Releases

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