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 (11)
) 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 970, 10

July 17, 2023

De Rosa Bicycles announced as Official Bike Partner of RBC GranFondo Whistler 2023

[Vancouver, BC Canada]/ENDURANCE SPORTSWIRE/ - De Rosa Bicycles, one of the world’s most well-known and appreciated bike brands today announced a new partnership with RBC GranFondo Whistler, the first and largest Gran Fondo in North America, becoming the proud Official Bike Partner of the event. To celebrate, De Rosa will...

Business

Cycling

Events

Press Releases

Sponsorship

July 17, 2023

Lauren O’Brien introduced as the VIP and Volunteer Director for FRESHJUNKIE Racing

Baton Rouge, LA/ENDURANCE SPORTSWIRE/ – FRESHJUNKIE Racing (FJR), a leading sports event management company, is pleased to announce the appointment of Lauren O'Brien as the new VIP and Volunteer Director. Lauren brings with her a wealth of experience and a passion for community engagement, making her an invaluable addition to the...

Business

Press Releases

Running

July 12, 2023

Marathon Tours & Travel announces launch in Australia

/ENDURANCE SPORTSWIRE/ – Marathon Tours & Travel offers travel packages for runners, with guaranteed entry, transport, accommodation and ‘on the ground’ team support for some of the most famous running events around the world. The team offer an industry-leading line up of race packages from the famous Abbott World Marathon Majors,...

Business

Press Releases

Running

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

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

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