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

March 2, 2022

Napa Valley Marathon & Half Marathon Welcomes Strong Elite Field for 2022

NAPA, CA/ENDURANCE SPORTSWIRE/ - This Sunday, March 6th, wine country will play host to the Kaiser Permanente Napa Valley Marathon & Half Marathon as it welcomes its strongest elite field in the race’s 43-year history. The iconic race reached an early sell out this year across all three offered distances:...

Events

Press Releases

Running

March 2, 2022

Team Brazil Multisport Win AR Panama to Launch the 2022 Adventure Racing World Series

/ENDURANCE SPORTSWIRE/ - A new year of competition in the Adventure Racing World Series began in Panama last week, with the launch of a new race, in a spectacular new location. AR Panama is the latest AR World Series race, and was launched with the backing of the tourism authorities...

Events

Press Releases

March 2, 2022

Stages Cycling Introduces New App – Upgraded Experience for SB20, Dash and Power Meters

(Boulder, CO – 1 March, 2022) /ENDURANCE SPORTSWIRE/ - Stages Cycling today announced its new app, Stages Cycling, which replaces Stages Link and adds new features and functionality for Stages SB20 Smart Bike, Stages Dash and Stages Power meters. The Stages Cycling app includes an expanded list of sensor support to combine...

Cycling

Press Releases

Products

March 1, 2022

Sika Henry and HOKA Team Up with The IRONMAN Foundation to Increase Diversity in The Sport Of Triathlon Through Race For Change Program

TAMPA, Fla. /ENDURANCE SPORTSWIRE/ - The IRONMAN Foundation® today announced a partnership with Sika Henry, the USA’s first Black female professional triathlete, and HOKA to build awareness and expand outreach in support of the Race For Change® initiative. In partnership with HOKA, the IRONMAN Foundation, and Henry will work to...

Giving

Press Releases

Triathlon

March 1, 2022

Saucony® Wins Trifecta of Editor’s Choice Awards in Runner’s World Spring 2022 Shoe Guide

WALTHAM, MASS. (March 1, 2022)/ENDURANCE SPORTSWIRE/ - Global performance running lifestyle brand Saucony today announced that it has won three Editor's Choice Awards in the Runner's World Spring 2022 Shoe Guide. The completely redesigned Ride 15, the maximally cushioned Axon 2 and the light and speedy Peregrine 12 all rose to...

Awards

Press Releases

Products

March 1, 2022

Premier Time Trial Returns for 24th Annual Series

/ENDURANCE SPORTSWIRE/ - As the 24th Annual Blue Streak Time Trial registration opens today, March 1, the 2022 series celebrates the 75th Anniversary of the United States Air Force. Held at Wright-Patterson Air Force Base in Dayton, Ohio, this annual series is open to the public and welcomes cyclists of...

Cycling

Events

Press Releases

March 1, 2022

Colnago and L’Eroica Partner for the Next Three Years

Cambiago, Italy, March 1st 2022 /ENDURANCE SPORTSWIRE/ - It was destiny that Colnago and L’Eroica become partners. Both represent the deep and extraordinary passion for cycling, a sport that is increasingly widespread in every corner of the world. Both brands generate unique feelings and represent the success of  ‘Made in Italy’....

Business

Cycling

Press Releases

March 1, 2022

Challenge Family and Zone3 Announce Global Partnership

/ENDURANCE SPORTSWIRE/ - Challenge Family has announced a multi-year worldwide partnership with leading triathlon brand, Zone3. As Challenge Family’s Global Swim Partner, Zone3 will also support a number of individual Challenge Family races around the world as swim course partner, providing age group athletes with access to Zone3’s high-performing full wetsuit range....

Press Releases

Sponsorship

Triathlon

March 1, 2022

Destination Sport Experiences Announces Further Growth with the Acquisition of Cycling Travel Specialist Sportive Breaks

/ENDURANCE SPORTSWIRE/ - Hundreds of UK cyclists will benefit thanks to an asset purchase agreement between Sportive Breaks Ltd and Destination Sport Experiences.  The pandemic put unbearable pressure on the travel industry with two years of lockdowns and international travel restrictions, so being part of a much larger UK travel...

Business

Cycling

Press Releases