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

June 24, 2023

Labecki and Lamperti Add to Their Medal Tally at Pro Criterium National Championships

KNOXVILLE, Tenn. /ENDURANCE SPORTSWIRE/ - Coryn Labecki (Tustin, Calif.; Team Jumbo-Visma) and Luke Lamperti  (Sebastopol, Calif.; Trinity Racing) earned the Elite Criterium National Titles on the second day of the 2023 USA Cycling Professional Road Championships. The 1.1-mile course, held in downtown Knoxville, Tenn., proved challenging with its six corners...

Cycling

Events

Press Releases

June 23, 2023

Wattbike support the first ever Esports Olympic Series

23rd June 2023 - UK/ENDURANCE SPORTSWIRE/ – The original, indoor smart bike innovator Wattbike is the choice of both elite athletes and fitness enthusiasts around the globe, and the team were delighted that the Olympic Esports Finals chose their award-winning Wattbike Atom for their cycling event which took place today. Presented...

Cycling

Events

Press Releases

Sponsorship

June 23, 2023

IRONMAN and North Idaho Sports Commission Agree to Host the IRONMAN 70.3 Coeur d’Alene Triathlon for Additional Three Years

COEUR D’ALENE, Idaho / TAMPA, Fla. (June 23, 2023)/ENDURANCE SPORTSWIRE/ – Following a vote at Tuesday’s City of Coeur d’Alene council meeting, a new three-year host venue agreement was agreed upon between IRONMAN and the North Idaho Sports Commission to host an IRONMAN® 70.3® triathlon in the City of Coeur d’Alene,...

Events

Press Releases

Triathlon

June 23, 2023

Vittoria Expands Terreno Gravel Line with New Sizes 

BENTONVILLE, AR (June 23, 2023) /ENDURANCE SPORTSWIRE/ - Vittoria announces the expansion of their Terreno line of gravel tires in response to the growing demand for larger tire sizes. The new sizes enhance the versatility of the Terreno line-up, allowing riders to find the right size for their gravel adventures....

Cycling

Press Releases

June 23, 2023

Ekoi celebrates Independence Day with incredible 50% off deal

Ekoi is delighted to wish their American friends a very happy Independence Day on the 4th July by offering a massive 50% off everything on the Ekoi.com website. Ekoi is delighted to wish their American friends a very happy Independence Day on the 4th July by offering a massive 50% off everything...

Cycling

Press Releases

Triathlon

June 23, 2023

46th HAP Crim Festival of races

Flint, MI /ENDURANCE SPORTSWIRE/ - The HAP Crim Festival of Races, the signature event of the Crim Fitness Foundation, is returning to the historic bricks of downtown Flint for the 46th time August 25-26. The Festival, home to one of the nation’s largest and oldest 10-mile races also has 5-Mile,...

Events

Press Releases

Running

June 23, 2023

Teams to Watch at the 2023 Endless Mountains Adventure Race

/ENDURANCE SPORTSWIRE/ – Thirty-three teams will line up at the start of the second edition of Endless Mountains Adventure Race next week, the only US qualifier for the 2023 Adventure Racing World Championship. Seventy percent of the field is returning from the 2022 Endless Mountains, including reigning champions Bend Racing and...

Events

Press Releases

June 23, 2023

Kinane Events passes the baton to San Diego Running Co. with the sale of the O’Side Turkey Trot

OCEANSIDE, Calif. /ENDURANCE SPORTSWIRE/ – After nearly two decades of producing the most popular Thanksgiving Day running and walking event in San Diego County, Kinane Events has announced the sale of the O’Side Turkey Trot. San Diego Running Co. has purchased the event, a move that was made public during the...

Business

Events

Press Releases

Running

June 23, 2023

Super League Triathlon Launches Documentary Series with Behind The Scenes Look at Hayden Wilde v Alex Yee

/ENDURANCE SPORTSWIRE/ – Super League Triathlon has launched the first of eight documentaries giving incredible behind the scenes access to the world’s best triathletes with the first episode taking a special look at the rivalry between Alex Yee and Hayden Wilde. The eight stand-alone episodes will initially be released exclusively on...

Press Releases

Products

Triathlon