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

July 11, 2023

Showcased

UNDRBUDR Launches New ULTRABUDR Product Line and Shifts Toward More Sustainable Packaging

UNDRBUDR® Launches New ULTRABUDR® Product Line and Shifts Toward More Sustainable Packaging Launches new line of consumer-focused, athletic massage oil product family Introduces limited “Summer Edition” massage oil Introduces more sustainable packaging July 10, 2023 - Montclair NJ /ENDURANCE SPORTSWIRTE/ - UNDRBUDR, LLC, developer of high performance, natural derived skincare,...

Business

Cycling

Press Releases

Products

Running

Triathlon

July 11, 2023

RunSignup Reports Strong Q2 2023 Business Growth and Positive Market Trends

Moorestown, NJ - July 11, 2023/ENDURANCE SPORTSWIRE/ – RunSignup, the leading provider of race registration and technology solutions for endurance events in the U.S., announces its Q2 2023 business update, highlighting significant growth and positive trends in the company's performance. RunSignup's Q2 results demonstrate a strong recovery from the pandemic and...

Business

Press Releases

Running

Triathlon

July 11, 2023

HOKA joins the 2023 Oasis ZooRun as official Footwear and Apparel Partner

TORONTO, CAN (July 11, 2023) – HOKA and Canada Running Series (CRS) are excited to announce a partnership between the two brands today, as the popular shoe brand becomes the official footwear and apparel partner of the 2023 Oasis ZooRun. The new deal will see HOKA bring their signature shoes...

Events

Press Releases

Running

Sponsorship

July 11, 2023

Two More Tour de France Teams Added to September’s Maryland Cycling Classic

BALTIMORE, Maryland /ENDURANCE SPORTSWIRE/ – The Maryland Cycling Classic, presented by UnitedHealthcare, America’s top cycling race and highest-ranked UCI event, announced the participation of two World Tour teams currently participating in the Tour de France - Team Cofidis and Astana Qazaqstan Team - for the September 3, 2023 race. One of...

Cycling

Events

Press Releases

July 11, 2023

XTERRA Québec this Weekend in Manoir du Lac Delage

/ENDURANCE SPORTSWIRE/ - The 9th annual XTERRA Québec off-road triathlon takes place Sunday, July 16, at Manoir du Lac Delage in the French-speaking region of eastern Canada. It’s the 14th of 25 stops on the XTERRA Americas Tour and one of 22 majors in the XTERRA pro series, attracting a...

Events

Press Releases

Triathlon

July 11, 2023

Life Time Silver Rush 50 Welcomes More Than 1,600 Runners and Riders to the Beautiful Leadville High Country

Leadville, Colo./ENDURANCE SPORTSWIRE/ - The Life Time Silver Rush 50 Run presented by La Sportiva and Stages Cycling Silver Rush 50 MTB events, owned and produced by Life Time (NYSE: LTH), took place on back-to-back days this weekend, bringing more than 1,600 runners and cyclists representing 43 states and 10...

Cycling

Events

Press Releases

Running

July 11, 2023

Showcased

Summit Cycling Adventures

/ENDURANCE SPORTSWIRE/ - Summit Cycling Adventures has added four new fully supported, professionally guided bike tours through Oregon’s varied landscapes, from forests to high deserts, coasts to mountains, oceans to hot springs. Tours cover mixed terrain, blending road and gravel to take riders off the beaten path and explore backroads,...

Cycling

Press Releases

July 11, 2023

Liv Cycling Hosts Watch Parties Across the Globe for the Tour de France Femmes avec Zwift

NEWBURY PARK, CA — JULY 11, 2023 /ENDURANCE SPORTSWIRE/ - Liv Cycling, official partner of the Tour de France Femmes avec Zwift and sponsor of the white jersey for the ‘Best Young Rider Classification’ , today announces a global series of watch parties to encourage more viewership of the iconic race...

Business

Cycling

Events

Press Releases

Sponsorship

July 10, 2023

Fitscope Launches Revenue Sharing Program for Equipment Manufacturers

Los Angeles (July 10, 2023) /ENDURANCE SPORTSWIRE/ - Fitscope, a leader in the production of studio classes for connected fitness equipment, announced today they will now offer free content and a share of affiliate revenue to OEM (original equipment manufacturer) partners that bundle Fitscope’s content with their equipment following the...

Press Releases

Products

July 10, 2023

FRESHJUNKIE Racing Launches New AmBADASSador Program to Empower Athletes and Promote Healthy Lifestyles

Baton Rouge, LA /ENDURANCE SPORTSWIRE/ - FRESHJUNKIE Racing, a leading event production company known for its exceptional race experiences, is thrilled to announce the launch of its highly anticipated AmBADASSador program. The program aims to inspire, support, and empower athletes of all levels while fostering a community dedicated to health,...

Business

Events

Press Releases

Running