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

April 29, 2024

Vendor Space Available for Gran Fondo Asheville Outdoor Expo

Gettysburg, PA /ENDURANCE SPORTSWIRE/ – The SUAREZ Gran Fondo National Series and Gran Fondo Asheville are proud to offer an economical and highly-effective marketing opportunity to cycling and outdoor industry brands in Asheville, North Carolina on the weekend of July 13-14, 2024. The two-day event will take place at Rabbit...

Cycling

Press Releases

Trade Shows

April 29, 2024

Colnago 2023

The financial statements of Colnago Ernesto & C. S.r.l. were approved today by the Shareholders' Meeting. Both turnover (+33%) and, above all, EBITDA (+106%) are growing compared to 2022. The satisfaction of CEO Nicola Rosin. Cambiago /ENDURANCE SPORTSWIRE/ – The Shareholders' Meeting of Colnago Ernesto & C. S.r.l. has approved the...

Business

Cycling

Press Releases

April 28, 2024

Over 23,000 Registered Runners Take on the 2024 St. Jude Rock ‘N’ Roll Running Series Nashville for A Running Tour of Music City

NASHVILLE, Tenn. /ENDURANCE SPORTSWIRE/ - The St. Jude Rock ‘n’ Roll Running Series Nashville event provided an unforgettable running tour of Music City for over 23,000 registered runners. With a distance for everyone, Saturday’s distances included a 5K, 10K, half marathon and marathon. The event continues Sunday with a 1-mile,...

Events

Press Releases

Running

April 28, 2024

Tomas Rodriguez Hernandez (MEX) And Kat Matthews (GBR) Victorious at 2024 Memorial Hermann IRONMAN North American Championship Texas Triathlon Claiming Maximum IRONMAN Pro Series Points

THE WOODLANDS, Texas /ENDURANCE SPORTSWIRE/ - The Lone Star state and The Woodlands, Texas played host to the 2024 Memorial Hermann IRONMAN® North American Championship Texas, part of the VinFast IRONMAN North America Series, doubling as the second event of the IRONMAN Pro Series™, on April 27. In the first...

Events

Press Releases

Triathlon

April 28, 2024

Wins for Jack Moody and Els Visser at Challenge Taiwan

/ENDURANCE SPORTSWIRE/ - Over 8,000 athletes lined up in spectacular Taitung this weekend with Jack Moody (NZL) and Els Visser (NED) taking out the 12th Challenge Taiwan titles in 3:49:16 and 4:08:39 respectively. The day started overcast and warm with high humidity levels and a water temperature of 24C meaning...

Events

Press Releases

Triathlon

April 26, 2024

Denver Colfax Marathon Introduces New “Colfax FLY Feet” Program

Denver, CO /ENDURANCE SPORTSWIRE/ - The 18th Denver Colfax Marathon, presented by Cigna Healthcare, is thrilled to introduce a new youth-focused element to its race weekend in May. In its inaugural year, the “Colfax FLY Feet” program, is a platform for at-risk Colorado kids to participate in Denver’s largest running...

Business

Events

Giving

Press Releases

Running

Sponsorship

April 25, 2024

Mount to Coast™ Emerges as First Performance Footwear Brand in the World to Specialize in Ultrarunning

HONG KONG (April 26, 2024)/ENDURANCE SPORTSWIRE/ – Today, Mount to Coast™, a new technical footwear brand dedicated to long-distance running, debuts its first two shoes designed for high-mileage road runners: the R1, created for race days, and the S1, tailored for daily training sessions. Engineered in Mount to Coast’s cutting-edge biomechanics...

Press Releases

Products

Running

April 25, 2024

ENVO Veemo SE and New LT Version Available Now for Pre-Order, May Shipping

Vancouver, Canada (April, 25, 2024)/ENDURANCE SPORTSWIRE/ – Following its acquisition last July of the Veemo velomobile, and the subsequent overhaul of some of the technology along with production and bring-to-market strategies of the unique, electric-assist e-trike, the electric micro-mobility gurus at ENVO Drive Systems are thrilled to announce the original weather-protected...

Cycling

Press Releases

Products

April 25, 2024

Verge Cycling Apparel Partners with the Bicycle Racing League to Empower Youth Cyclists

NEW YORK, April 25, 2024/ENDURANCE SPORTSWIRE/ – Verge, the innovative leader in custom cycling apparel, is thrilled to announce its sponsorship of the Bicycle Racing League (BRL) at Pennsylvania's Valley Preferred Cycling Center, reaffirming its commitment to fostering the growth of cycling in the U.S. from the grassroots level up....

Cycling

Press Releases

Sponsorship

April 25, 2024

HOKA Kodiak Ultra Marathons by UTMB Designated as UTMB World Series Major for 2025

- 2025 HOKA Kodiak Ultra Marathons by UTMB to serve as the UTMB World Series Americas Major in 2025, giving all finishers more opportunities to qualify for the iconic UTMB World Series Finals at HOKA UTMB Mont-Blanc - 2024 UTMB World Series Americas Major takes place at HOKA Canyons Endurance...

Events

Press Releases