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

April 29, 2024

Showcased

KINeSYS Becomes First-Ever Sunscreen to Achieve Informed Sport Certification

/ENDURANCE SPORTSWIRE/ - KINeSYS announced today that their award-winning SPF 50 Fragrance Free Spray Sunscreen is the first-ever sunscreen to be certified with the Informed Sport program. Informed Sport certification provides the highest level of quality assurance by testing every batch of supplements, and now sunscreens, for substances banned in...

Awards

Business

Cycling

Press Releases

Products

Running

Triathlon

April 29, 2024

Central Illinois Runners Show Up and Show Out at Christie Clinic Illinois Race Weekend

CHAMPAIGN, Ill. /ENDURANCE SPORTSWIRE/ - After five years of laying dormant, the Christie Clinic Illinois Race Weekend reintroduced its full marathon distance on Saturday. Central Illinois residents took the top spots in the 26.2-mile race. Alexis Dorsey of Champaign, Ill. was first in the women’s marathon with a time of...

Events

Press Releases

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