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

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

July 10, 2023

USA Cycling Announces 2023 Road World Championship Teams

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – The 2023 UCI Cycling World Championships will make history in Glasgow, Scotland as the first World Championship where 13 events will be contested across 7 disciplines. 32 athletes will compete in the road events on August 5-12, 2023. This event is one of the first automatic Olympic qualifiers...

Cycling

Events

Press Releases

July 10, 2023

Blunk and Blevins Double Down Wins at 2023 Elite Short Track National Championships

MACUNGIE, Pa. /ENDURANCE SPORTSWIRE/ – The last day of the 2023 USA Cycling Cross-Country Mountain Bike National Championships was all about Short Track racing. Every category of the day was set to race on the explosive track through the ski slopes of Bear Creek Mountain Resort in Macungie, Pa. In the...

Cycling

Events

Press Releases

July 10, 2023

San Francisco Marathon Unveils Alexi Pappas as Global Ambassador for an Unforgettable Race Experience

San Francisco, CA - JULY 10, 2023 /ENDURANCE SPORTSWIRE/ – The San Francisco Marathon is thrilled to announce a momentous partnership with renowned athlete and advocate Alexi Pappas as a Global Ambassador and introduce the highly anticipated "Alexi Pappas SFM 10K" race. This race is designed to capture the essence of...

Events

Press Releases

Running

Sponsorship

July 10, 2023

USA Triathlon Officials Program Now Recognized as a World Triathlon Accredited Technical Officials Education Program

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – USA Triathlon today announced the organization’s Officials Program is now recognized as a World Triathlon Accredited Technical Officials Education Program (ATOEP), joining 16 other leading world federations with the designation and global recognition. “Being recognized by World Triathlon accreditation is a major step forward in USA Triathlon’s...

Business

Press Releases

Triathlon

July 10, 2023

Juice Plus+ Announces Travis Garza as New Global Chief Executive Officer

COLLIERVILLE, TN (July 10th, 2023)/ENDURANCE SPORTSWIRE/ – Leading global health and wellness company, Juice Plus+, has announced today that Travis Garza has been appointed as Global Chief Executive Officer (CEO). A veteran in the industry, Garza has two decades of experience driving strategy, growth, and innovation within leading direct sales and...

Business

Press Releases

July 8, 2023

Sofia Gomez Villafane and Keegan Swenson Win and Set Course Records at the Life Time Crusher in the Tushar presented by The Creamery

Beaver, Utah, (July 8, 2023) /ENDURANCE SPORTSWIRE/ - Sofia Gomez Villafane and Keegan Swenson won and set course records at the Crusher in the Tushar presented by The Creamery, a gravel cycling event owned and produced by Life Time, which welcomed a field of approximately 600 riders representing 37 states...

Cycling

Events

Press Releases