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

November 18, 2021

USA Triathlon Announces 2022 National Championships Calendar

COLORADO SPRINGS, Colo. /ENDURANCE SPORTSWIRE/ - USA Triathlon today unveiled the dates and locations for its 2022 National Championships, a robust calendar of triathlon and multisport events across the United States. At USA Triathlon National Championships, athletes will have the opportunity to compete against the top multisport athletes in the country,...

Events

Press Releases

Triathlon

November 18, 2021

ATRA to lead Discussion at TRE on the Future of Trail Running

/ENDURANCE SPORTSWIRE/ - The Running Event (TRE), is the premier conference and trade show for running specialty retailers and includes networking opportunities, educational content, and offers sneak peaks to attendees of new products coming on the market. Attendees include run specialty store owners and managers, race directors, brands, and organizations.  The...

Press Releases

Running

Trade Shows

November 18, 2021

NYCRUNS Announces Official Charity Partner Program for 2022 Brooklyn Marathon & Half Marathon

Brooklyn, NY November 18, 2021/ENDURANCE SPORTSWIRE/ - NYCRUNS, one of the fastest growing consumer health and wellness businesses and the organizer of the 2022 NYCRUNS Brooklyn Marathon & Half Marathon, today announced the Official Charity Partner Program. The 2022 NYCRUNS Brooklyn Marathon & Half Marathon, which will be the largest...

Events

Press Releases

Running

November 18, 2021

Bioracer UK Launches to Roll Out Custom Cycling Speedwear For All

/ENDURANCE SPORTSWIRE/ - Founded 35 years ago in Belgium, the spiritual home of cycling, Bioracer Speedwear has a strong heritage of designing, innovating and producing speedwear for cyclists to help maximise performance and comfort in the saddle. Over the past 20 years the custom clothing has been distributed in the UK...

Business

Cycling

Press Releases

November 18, 2021

Showcased

Quintana Roo introduces Fit-Ready build service

Chattanooga, TN  (Nov. 18, 2021) /ENDURANCE SPORTSWIRE/ - Quintana Roo announces the debut of Fit-Ready, an industry first that delivers a QR V-PR triathlon bike to a customer’s home, built to their exact fit requirements, making it truly set up to their fit coordinates from the moment it arrives in their...

Cycling

Press Releases

Products

Triathlon

November 18, 2021

‘The Digital Swiss 5’ kicks off tomorrow – The Start List and Where to Watch

Zurich, Switzerland / November 18, 2021 /ENDURANCE SPORTSWIRE/  PRO RACE FORMAT Athletes will compete in five digital races of about one hour each (the first four being lapped races) in Swiss cities. Each team is named by  the respective host cities of Lucerne, Lugano, Lausanne, Basel and Zurich. With a...

Cycling

Events

Press Releases

Triathlon

November 18, 2021

Life Time Foundation Announces Commitment to Youth Movement with new “Get Kids Moving!” National Initiative

CHANHASSEN, Minn., Nov. 18, 2021 /ENDURANCE SPORTSWIRE/ - Life Time Foundation, the 501(c)(3) nonprofit charitable arm of Life Time (NYSE: LTH) today announced a massive commitment to improving children’s health with the launch of Get Kids Moving! The new youth movement focus will fund initiatives of schools and community organizations nationwide...

Events

Giving

Press Releases

November 18, 2021

Revelshine Sustainable Wines Partners With New WineShine Half Marathon

NAPA, Calif. /ENDURANCE SPORTSWIRE/ - The WineShine Half Marathon is thrilled to welcome Revelshine as the sustainable-premium-wine partner for its 2022 inaugural event. Revelshine, a premium, world-class wine in a sustainable, portable and recyclable aluminum bottle, will provide a bottle of wine to each half-marathon participant in the July 16, 2022...

Press Releases

Running

Sponsorship

November 18, 2021

Bearclaw Bicycle Co. Named ‘Ultra Series’ Sponsor for 2022 Michigan Gravel Race Series

/ENDURANCE SPORTSWIRE/ -As part of the upcoming 2022 Michigan Gravel Race Series (MGRS), Bearclaw Bicycle Co. has renewed its sponsorship for the second year running as the official Ultra Series sponsor. The Bearclaw Bicycle Co. Ultra Series includes seven 100+ mile gravel bike races among the 15 events within the...

Cycling

Events

Press Releases

Sponsorship