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

July 19, 2022

Wiley X to Showcase New Jacob Wheeler Signature Eyewear at ICAST Show, Invites Fans to Meet Professional Anglers

Livermore, CA (July 19, 2022)/ENDURANCE SPORTSWIRE/ – Wiley X®, the leader and innovator in premium protective eyewear, will showcase its newest and best-selling designs at ICAST from July 19 through 21, 2022. As a family-owned and operated company, Wiley X focuses on providing premium protective eyewear for a diverse array of professional...

Press Releases

Products

Trade Shows

July 19, 2022

Runners Value Sports Sponsors More than the General Public According to Recent Survey by Elevent

MONTRÉAL – July 19, 2022/ENDURANCE SPORTSWIRE/ – Elevent, North America’s leading provider of sponsorship lifecycle management software, consulting services, and research, today unveiled the results of a recent survey of American adult runners and their unique perceptions of sports sponsors. The results reveal a dedicated fanbase with a positive perception of...

Press Releases

Running

Sponsorship

Studies

July 19, 2022

Hot Temperatures and Hot Competition Highlight 8-Hour Dream Endurance Race

CARMEL, Ind. (July 19, 2022) /ENDURANCE SPORTSWIRE/ - A sold-out field stood at the start line of the 8-Hour Dream Endurance Race and Cat Nap 5K on Saturday, July 16 in Indianapolis with fresh legs and smiles, and ended the day with a combined total of 6,491.48 miles on those...

Events

Press Releases

Running

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