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

January 9, 2023

The RiderBox Highlights Female Professional Cyclists in its Latest Winter Edition

/ENDURANCE SPORTSWIRE/ – The RiderBox, a leader in the endurance gift and subscription industry, has debuted their Winter Edition which is receiving high acclaim due to its focus on female professional cyclists. The RiderBox, which itself was founded by two former professional female cyclists, has given back to the sport through...

Cycling

Press Releases

Products

Triathlon

January 6, 2023

UltrAspire Celebrates 10 Years of Hydration Innovation

St. George, Utah /ENDURANCE SPORTSWIRE/ – UltrAspire has been introducing concepts to drive the running industry forward since the company’s inception in 2012. Owner and founder, Bryce Thatcher, known as the “Father of Hydration” has designed hundreds of products over his 35-year career that have shaped the evolution of hydration carry options...

Business

Press Releases

Running

January 6, 2023

Belgian Waffle Ride presents FasCat as Official Coaching and Training Partner

(San Diego, CA) /ENDURANCE SPORTSWIRE/ - With six of the most challenging unroad events on the calendar, the Belgian Waffle Ride Series is proud to announce FasCat as its Official Coaching and Training Plan Technology Partner. All BWR riders now have access to training plans tailored to each event that...

Business

Cycling

Events

Press Releases

January 6, 2023

Gnarly Nutrition Partners with Method Outdoor Collective National Sales Agency

Salt Lake City, UT (January 6, 2023) /ENDURANCE SPORTSWIRE/ - Gnarly Nutrition, makers of clean, effective, and great-tasting sports nutrition supplements, is excited to announce a new sales partnership with specialty sales agency Method Outdoor Collective. Method Outdoor Collective was founded by Sasha Dietschi-Cooper, former Vice President of Sales at...

Business

Press Releases

Products

January 5, 2023

Enduro Proudly Sponsors Grasshopper Adventure Series

Oakland, California (January 5, 2023)/ENDURANCE SPORTSWIRE/ – Enduro Bearings, innovators of a wide range of bicycle bearings, seals, components and tools, recently signed on to sponsor the 2023 Grasshopper Adventure Series (GAS), a long-running mixed-terrain event series that has become a favorite of many of the top names in the sport. This...

Cycling

Press Releases

Sponsorship

January 5, 2023

IRONMAN Announces History-Filled Sporting Destination Nice, France as Men’s Race Location and Co-Host for 2023 VinFast IRONMAN World Championship

TAMPA, Fla./NICE, Fra. (Jan. 5, 2023) /ENDURANCE SPORTSWIRE/ – Following the previous announcement of the IRONMAN® World Championship continuing its commitment to dedicated race days for men and women, it was announced today that Nice, France will become the location for the 2023 men’s edition as co-host of the VinFast IRONMAN...

Events

Press Releases

Triathlon

January 5, 2023

P3R Announces Name, Image and Likeness Partnership with Nine Local College Athletes

PITTSBURGH /ENDURANCE SPORTSWIRE/ – P3R has announced a name, image and likeness (NIL) partnership with nine college student-athletes. As part of this opportunity, these P3R Athletes will create content for P3R’s social networks including instructional videos, blogs and other resources to inspire all ages to MOVE. The 2023 P3R Athletes include...

Press Releases

Running

Sponsorship

January 5, 2023

Sebastian Kienle Starts His Bucket List 2023 Season at Challenge Wanaka

/ENDURANCE SPORTSWIRE/ – Three-time world champion, Sebastian Kienle (GER), has confirmed his place on the start line at the first Challenge Family race of 2023 – New Zealand’s Integrity Homes Challenge Wanaka on 18 February. Challenge Wanaka marks the start of his year-long ‘retirement tour’ visiting his bucket list races before...

Events

Press Releases

Triathlon