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

July 19, 2022

BikeFlights Promotes Moir and Potter

PORTLAND, OR (Tuesday, July 19, 2022)/ENDURANCE SPORTSWIRE/ – BikeFlights, a bicycle shipping service and supplier of bike boxes, has promoted two employees: Sparky Moir and Michael Potter. Moir moves up into the role of BikeFlights’ Support Team Director while Michael Potter has stepped up to become BikeFlights’ Partnership Director. William Alcorn,...

Business

Cycling

Press Releases

Triathlon

July 18, 2022

Wine Country welcomes 4,000 runners for 18th running of Napa to Sonoma Half Marathon Weekend

Sonoma, California /ENDURANCE SPORTSWIRE/ - Sonoma County is blessed with more than 425 wineries, and on a sun-kissed Sunday morning, thousands of runners scampered past many of them for the 18th Napa to Sonoma Wine Country Half Marathon. No one was faster than the Reno, Nev., husband-wife tandem of Dominic...

Events

Press Releases

Running

July 18, 2022

Scott Randall Named Global VP of Product at SMITH

PORTLAND, Oregon (July 18, 2022) /ENDURANCE SPORTSWIRE/ - SMITH – global market leader in snow goggles and helmets and industry innovator across bike helmets, sport, lifestyle, and prescription eyewear – is excited to announce the appointment of Scott Randall to the role of Global Vice President of Product. With over...

Business

Press Releases

July 18, 2022

Tune In: New Season of Quest For The IRONMAN World Championship Fueled By Gatorade Endurance To Air Tuesday, July 19 on IRONMAN YouTube Channel

TAMPA, Fla. (July 18, 2022) /ENDURANCE SPORTSWIRE/ - IRONMAN announced today that the latest season of Quest for the IRONMAN World Championship fueled by Gatorade Endurance will air on the IRONMAN YouTube channel starting Tuesday, July 19. Each episode will take viewers behind-the-scenes to highlight the journey athletes take on...

Press Releases

Triathlon

July 18, 2022

Middaugh, Paterson win XTERRA USA Championship

/ENDURANCE SPORTSWIRE/ – Teenage phenom Sullivan Middaugh and five-time World Champion Lesley Paterson captured the 21st annual XTERRA USA Championship off-road triathlon elite titles on a picture-perfect blue sky day at Beaver Creek Resort near Avon, Colorado on Saturday, July 16, 2022. It’s the first elite win for the 18-year-old Middaugh,...

Events

Press Releases

Triathlon

July 18, 2022

Showcased

Project FUERZA Launches NFT Collection from Cycling Icon Peter Sagan

Bedford, Virginia (July 18, 2022) /ENDURANCE SPORTSWIRE/ - One of the most successful and popular pro cyclists to come around in many years, Peter Sagan, will launch his collection of NFT art as part of Project FUERZA. The power and biometric data-inspired NFT art program launched on July 1, with...

Business

Cycling

Press Releases

Products

Sponsorship

Triathlon

July 15, 2022

Ultra Marathon Legend Charlie Engle’s ‘Movement For Recovery’ July Event Draws Star-Studded Participation

Havre de Grace, Md. (July 15, 2022) /ENDURANCE SPORTSWIRE/ - The Penguin: Movement for Recovery – a live and virtual event held July 23-24 - launches a worldwide campaign to celebrate addiction recovery using movement as a tool to not just survive but to thrive. In the middle of an...

Events

Giving

Press Releases

Running

July 15, 2022

Mar del Plata Set to Host IRONMAN 70.3 Triathlon on December 4, 2022

BUENOS AIRES, Argentina / TAMPA, Fla. (July 15, 2022)/ENDURANCE SPORTSWIRE/ – IRONMAN announced today that the city of Mar del Plata, Argentina will host the inaugural edition of the IRONMAN® 70.3® Mar del Plata triathlon with competition set to take place on Sunday, December 4, 2022. The event will coincide with the...

Events

Press Releases

Triathlon

July 15, 2022

Wanjiru Defends PRRO Title, Wins $10,000 PRRO Super Bonus at 45th Boilermaker 15K

UTICA, NY /ENDURANCE SPORTSWIRE/ - On Sunday morning July 10th under sunny, temperate conditions, the 45th Boilermaker 15K hosted the 25th PRRO Championship, and Jemal Yimer Mekonnen of Ethiopia and Rosemary Wanjiru of Kenya won the PRRO titles, the second for both, in 42 minutes, 38 seconds and 48:54, respectively....

Events

Press Releases

Running