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

January 29, 2024

Showcased

XLAB introduces the Aero Carbon Wing

Escondido, CA (Jan 29, 2024)/ENDURANCE SPORTSWIRE/ – Celebrating its 30th Anniversary, XLAB is very pleased to announce the release of the fastest rear hydration system ever, the Aero Carbon Wing. Three years of design, CFD simulations, and rigorous testing has gone into producing a system that is more than just a replacement...

Cycling

Press Releases

Products

Triathlon

January 29, 2024

BKOOL Announces Exclusive Partnership with Deutschland Tour to Bring the Prestigious Race to Virtual Cycling Enthusiasts

Madrid & Berlin, 29/1/2024 - /ENDURANCE SPORTSWIRE/ – BKOOL, the pioneering virtual cycling simulator, is thrilled to announce a groundbreaking partnership with the prestigious Deutschland Tour. This strategic collaboration marks a significant milestone for both BKOOL and the renowned German cycling event, as it brings the excitement and challenge of Deutschland...

Cycling

Press Releases

Products

Sponsorship

January 29, 2024

Ascension Seton Austin Marathon and OOFOS Forge Exciting Partnership for 2024

Austin, TX – January 29, 2024 /ENDURANCE SPORTSWIRE/ – The Ascension Seton Austin Marathon, Half Marathon, and 5k is thrilled to announce a dynamic partnership with OOFOS, the global leader in Active Recovery footwear, for the upcoming 2024 event. This sponsorship marks a significant milestone for both organizations, bringing together a...

Events

Press Releases

Running

Sponsorship

January 29, 2024

Tifosi Optics Welcomes Runner Hellah Sidibe to Brand Ambassador Program

Watkinsville, GA (January 29, 2023)/ENDURANCE SPORTSWIRE/ – Tifosi Optics, a leading sport and lifestyle sunglasses brand, has announced a partnership with runner, speaker, and content creator, Hellah Sidibe. As a Tifosi athlete ambassador, Hellah will inspire the Tifosi community to live their passion and reach their goals through creative and uplifting...

Press Releases

Running

Sponsorship

January 27, 2024

Winners Revealed at Challenge Family Race Awards 2023

/ENDURANCE SPORTSWIRE/ - The votes are in, and the winners of the Challenge Family Race Awards 2023 were announced last night at the global triathlon series’ annual Race Directors’ Meeting in Barcelona. The Awards were developed in 2019 to provide recognition to the global team of race directors and teams...

Press Releases

Triathlon

January 26, 2024

Life Time releases Season 2 of “Call of a Life Time” Docuseries

Boulder, Colo., (Jan. 26, 2024) /ENDURANCE SPORTSWIRE/ - Today, Life Time (NYSE: LTH), the nation’s premier healthy lifestyle brand, releases “Call of a Life Time” Season 2. The docuseries is made up of six binge-worthy episodes following the elite women and men of the 2023 Life Time Grand Prix presented...

Cycling

Events

Press Releases

January 26, 2024

USA Triathlon Foundation Announces 7 New Board Trustees for 2024

COLORADO SPRINGS, Colo./ENDURANCE SPORTSWIRE/ – The USA Triathlon Foundation today announced the addition of seven new Board Trustees: Justin Model, Marci Jenkins, Mike Wien, Rick Hrabchak, Rosalind Jarrett-Sepulveda, Nathan Stuhlmacher and Cameron Hamilton. Represented by a strong group of business and non-profit professionals and age group athletes, the USA Triathlon Foundation Board of...

Giving

Press Releases

Triathlon

January 26, 2024

RunSignup Race Website V2 Beta to Release in February

Moorestown, NJ - January 25, 2024 /ENDURANCE SPORTSWIRE/ - RunSignup, the leading registration and technology provider for races in the U.S, is releasing a beta of Race Websites V2 to all customers in late February. Any RunSignup customer will be able to test the next generation website builder and switch...

Events

Press Releases

Products

Running

Triathlon

January 26, 2024

Canyon Coureur Cycling Announces San Diego Based Scalar Wheels as Premier Wheel Partner For 2024

San Diego, CA - January 26, 2024 /ENDURANCE SPORTSWIRE/ - Canyon Coureur Cycling presented by The Feed, San Diego's premier cycling team with over 300 members is proud to announce Scalar Wheels as its premier wheel partner in 2024. Scalar Wheels, also based in San Diego, launched in early 2023...

Business

Cycling

Press Releases

Sponsorship