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

November 14, 2022

Safa Brian Drops New PRAY FOR SPEED Cycling Film + Pedal Mafia Custom Apparel Collection

/ENDURANCE SPORTSWIRE/ – Brian 'Safa' Wagner, cyclist and filmmaker, premieres PRAY FOR SPEED | 4 Days in Switzerland on November 9th, 2022, at 5:30 am PST on YouTube. Parallel to his film release, in collaboration with his sponsor Pedal Mafia, Safa is launching his second PRAY FOR SPEED collection, The Portal....

Cycling

Press Releases

Products

November 14, 2022

Triathlon Fall Fest calls on triathletes to train and race with Roth champion, Magnus Ditlev and a Challenge Family all-star cast

Almere, Netherlands / November 14th, 2022 /ENDURANCE SPORTSWIRE/ – The Triathlon Fall Fest on ROUVY is a series of unique online events that gives both experienced athletes and newbies the opportunity to train, compete and learn with and from some of the best professional triathletes in the world. There'll be rides...

Events

Press Releases

Triathlon

November 14, 2022

Speed Hound Enters Into Multiyear Agreement with SBT GRVL

Menlo Park, CA (November 14, 2022) /ENDURANCE SPORTSWIRE/ - While Speed Hound is on a mission to provide every day athletes with the tools they need to achieve the impossible, they’re also deeply committed to supporting other organizations within the racing community. Speed Hound has found a like-minded partner in...

Cycling

Events

Giving

Press Releases

Sponsorship

November 14, 2022

The RunnerBox and RiderBox Unveil Highly Anticipated Limited Edition Holiday Boxes Which Goes the Extra Mile to Outpace Inflation

November 14, 2022/ENDURANCE SPORTSWIRE/ - The Runner and The RiderBox, leaders in the endurance sport gift industry, have released a Limited-Edition Holiday Box which will be available for sale on a first-come, first-served basis. This limited run box is an annual favorite and has sold out every year it has...

Cycling

Press Releases

Products

Running

Triathlon

November 13, 2022

Roberts Wins Fourth World Title and Dowell Silver at the 2022 BMX Freestyle World Championships

November 13, 2022 /ABU DHABI, United Arab Emirates /ENDURANCE SPORTSWIRE/ - The 2022 UCI Urban Cycling World Championships concluded with the BMX Freestyle Park Finals. Twelve men and twelve women competed in the finals, with three men and three women from Team USA making the big show. Elite Women’s Finals...

Cycling

Events

Press Releases

November 13, 2022

The Monterey Bay Half Marathon Returns to a New Course Record

MONTEREY, CA /ENDURANCE SPORTSWIRE/ - For the first time in three years, the Monterey Bay Half Marathon took place in Downtown Monterey and along the Pacific Grove coastline on the second Sunday in November. Kenyan athlete David Bett, 30, took the top men’s spot in 1:02:11, thereby setting a new...

Press Releases

Running

November 12, 2022

Christopher, Dowell, and Sandoval Transfer to Elite Men’s BMX Freestyle Finals at the 2022 Urban Cycling World Championships

November 12, 2022, ABU DHABI, United Arab Emirates – Justin Dowell (Virginia Beach, V.A.; Hyper BMX), Brian Fox (Commerce, Ga.; Woodward Camp), Daniel Sandoval (Corona, Calif.; Free Agent Bikes), Marcus Christopher (Canton, Ohio; DK Bicycles), and Jacob Thiem (Kennard, Neb.; Free Agent Bikes) all competed in the Elite Men’s BMX Freestyle semi-finals today at the 2022...

Cycling

Events

Press Releases

November 11, 2022

2023 IRONMAN 70.3 Mont-Tremblant Complet Et Accueillera Le Plus Grand Nombre D’athlètes De L’histoire De L’événement; 2023 IRONMAN 70.3 Mont-Tremblant Sold Out and Will Host the Largest Number of Athletes in The Event’s History

MONT-TREMBLANT, QUEBEC, CANADA (Nov. 11, 2022) /ENDURANCE SPORTSWIRE/ - The 2023 IRONMAN® 70.3® Mont-Tremblant triathlon taking place on June 25, 2023, has officially sold out. The 2023 event will play host to the largest number of athletes in the events history with over 3,600 athletes registered to race. In addition...

Events

Press Releases

Triathlon

November 11, 2022

Five Elite Men Advance to BMX Freestyle Semi-Finals at the 2022 Urban Cycling World Championships

November 11, 2022 /ENDURANCE SPORTSWIRE/ – Dowell, Fox, Sandoval, Christopher, and Thiem qualified in the top 24, transferring to the next round of the World Championships. ABU DHABI, United Arab Emirates – Competition began on Friday for the Elite Men’s BMX Freestyle Park at the 2022 UCI Urban Cycling World Championships. 63...

Cycling

Events

Press Releases