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

August 23, 2024

In Partnership with Rush Running & Visit Bentonville Dirt Circus Bentonville Brings the Biggest Prize Purse and a Livestream to the USATF 10K National Championship

Bentonville, AR - August 23, 2024 /ENDURANCE SPORTSWIRE/ - Dirt Circus Bentonville is shaking up the industry with a game-changing approach to prize purses; it's all about empowering the community to support the sport's top talent. In partnership with Rush Running and Visit Bentonville, this year’s Dirt Circus Bentonville will...

Events

Press Releases

Running

August 22, 2024

The James Brand Expands North American Sales Team, Strengthens Support for Wholesale Partners

PORTLAND, OR /ENDURANCE SPORTSWIRE/ - The James Brand – makers of modern, minimal everyday carry products – announces a significant expansion of its sales representative team and overall brand growth through new and expanded partnerships with retailers and like-minded brands, including Timex and Huckberry. The strategic moves aim to provide...

Business

Press Releases

August 22, 2024

Sports Basement Expands Partnership with Motiv Sports, Becoming Official Retailer for Long Beach Marathon and Surf City 10

SOUTHERN CALIFORNIA – August 22, 2024 /ENDURANCE SPORTSWIRE/ - In a significant expansion of its long term partnership with Motiv Sports, Sports Basement, a leading specialty sporting goods retailer, has been named the Official Specialty Retailer for both the Long Beach Marathon and the Surf City 10 this fall. This...

Events

Press Releases

Running

Sponsorship

August 22, 2024

PAYNTR Golf and Carbitex Debut The TRAINER CARBON X

Portland, OR /ENDURANCE SPORTSWIRE/ – PAYNTR Golf, North America’s fastest growing golf footwear brand, today announces the launch of the TRAINER CARBON X, a revolutionary training shoe developed in collaboration with Carbitex®, a leading expert in high-performance materials. Engineered to elevate both on and off-course performance, the TRAINER CARBON X is...

Press Releases

Products

August 22, 2024

BibBoards Introduces Plant-Based Core Materials and Reduced Pricing for Events and Runners

San Ramon, CA] – [8/22/2024]/ENDURANCE SPORTSWIRE/ – BibBoards, the leading provider of innovative, eco-friendly race bib fasteners, is excited to announce a significant milestone in our commitment to sustainability and affordability. We are proud to introduce plant-based core materials in our products, reinforcing our dedication to protecting the environment while enhancing...

Press Releases

Products

Running

Triathlon

August 22, 2024

Double race weekend for GFNY in Europe

/ENDURANCE SPORTSWIRE/ – GFNY Sweden Uppsala The second edition of GFNY Uppsala offers racers a 133.5 km long course with 494m of climbing. Uppsala is less than an hour from Stockholm. The course will take riders along rolling hills of the Uppsala countryside. There will also be hard packed unpaved...

Cycling

Events

Press Releases

August 22, 2024

H2O Audio Launches TRI 2 Multi-Sport Series

SAN DIEGO, Aug. 22, 2024 /ENDURANCE SPORTSWIRE/ - H2O Audio, the leader in waterproof audio technology, proudly announces its latest innovation, the TRI 2 Multi-Sport Series. Building on over two decades of pioneering technology, these headphones set a new standard in bone conduction audio and represent the pinnacle of H2O...

Press Releases

Products

Wire Syndication

August 22, 2024

2024 XTERRA Costa Rica Preview: Lining Up at Las Catalinas

LAS CATALINAS, COSTA RICA /ENDURANCE SPORTSWIRE/ - Marking its return as the 18th stop on the 2024 XTERRA Americas Tour, XTERRA Costa Rica introduces a fresh team, course, and venue for an off-road racing weekend on August 24-25. Set in the holiday town of Las Catalinas, the Full Distance Triathlon...

Cycling

Events

Press Releases

Running

Triathlon

August 22, 2024

BibRave Steps Up to the Plate to Elevate The Giant Race

San Francisco, CA /ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency once again partnered with Giants Enterprises, the entrepreneurial arm of the San Francisco Giants Major League Baseball franchise, to elevate the 15th annual Giant Race, presented by Alaska Airlines. This successful collaboration resulted in an impressive...

Business

Press Releases

Running