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

April 11, 2024

Outside Interactive & Brooks Running Launch Personalized Content for Runners

BOULDER, CO, April 11, 2024/ENDURANCE SPORTSWIRE/ – Outside Interactive Inc, the world’s leading creator of outdoor content, services, events, and experiences, along with Brooks Running, a global leader in performance run footwear and apparel, join forces to bring local, personalized content to active lifestyle enthusiasts and outdoor adventurers across the United...

Business

Cycling

Press Releases

Products

Running

Triathlon

April 11, 2024

Snowbound Expo 2024 offers more for visitors to buy, by welcoming Official Retail Partner, Colorado Ski Shop

/ENDURANCE SPORTSWIRE/ – Snowbound Expo, the leading annual event for winter sport enthusiasts, is thrilled to announce their collaboration with Colorado Ski Shop as its official retail partner for the return of the renown ski and snowboard expo in November 2024. This new partnership brings together two leaders in their...

OSW Syndicated

Press Releases

Sponsorship

April 11, 2024

supertri Secures Live Coverage Agreement with Eurosport

/ENDURANCE SPORTSWIRE/ - supertri and Warner Bros Discovery (WBD) have agreed a partnership that will deliver live coverage of all supertri events in 2024 to a huge international audience via Eurosport as well as live and on-demand streaming on discovery+ and Max* in Europe. The agreement begins with the supertri...

Press Releases

Triathlon

April 11, 2024

DEKA FIT Announces Partnership with GET RX’D to Introduce Xebex Sleds for Zone 9

BOSTON, MASS. (4/11/2023) /ENDURANCE SPORTSWIRE/ – DEKA FIT, the leading fitness event series revolutionizing the way athletes train and compete, is thrilled to announce a new partnership with GET RX’D, a premier provider of high-quality fitness equipment. This collaboration marks a significant milestone in enhancing the DEKA FIT experience. Together,...

Press Releases

Products

Sponsorship

April 11, 2024

GoFundraise & Motiv Sports Announce Multi-Year Partnership to Supercharge Fundraising Across North American Events

New York City, USA, April 11 2024 /EINDURANCE SPORTSWIRE/ - GoFundraise, a leading global fundraising platform, and Motiv Sports, a North American leader in mass-participation events, today announce a long-term strategic partnership to increase charitable giving across all Motiv Sports events in the United States and Canada. This partnership brings...

Business

Events

Press Releases

Running

Wire Syndication

April 10, 2024

RaceWire Launches New Summer Fun Run, Run Your Buns Off 5K, at Mayflower Brewing Company

Plymouth, MA – April 10, 2024 /ENDURANCE SPORTSWIRE/ - RaceWire and Stack Endurance are excited to announce the launch of a new summer fun run, the Run Your Buns Off 5K. A community-focused run celebrating health, happiness, and getting outdoors this summer. The event will take place at Mayflower Brewing...

Events

Press Releases

Running

April 10, 2024

Highway 1 Slip-Out Near Rocky Creek Bridge Causes Big Sur Marathon Course Re-Route

CARMEL, CA – April 10, 2024 /ENDURANCE SPORTSWIRE/ - The 37th Annual Big Sur International Marathon, set to take place on Sunday, April 28th, will be re-routed to a mostly out-and-back course along Highway 1 due to a slip-out on the course after a rainy winter on California’s Central Coast....

Events

Press Releases

Running

April 10, 2024

Gran Fondo Hincapie Launches New Multi-day Event in Bentonville, Ark.

Greenville, S.C., (April 10, 2024)/ENDURANCE SPORTSWIRE/ – Gran Fondo Hincapie has been creating cycling experiences for over 12 years and recently announced the launch of its latest event taking place in Bentonville, Ark. Join the Hincapie team Sept. 6 - 8 for a weekend of riding, good food, entertainment, and more....

Cycling

Events

Press Releases

April 10, 2024

4iiii and BMC collaborate to integrate the new PRECISION 3+ PRO Powermeter into 2024 road bike range.

COCHRANE, ALBERTA/ENDURANCE SPORTSWIRE/ –  4iiii is proud to announce their collaboration with BMC, which will see the integration of their new PRECISION 3+ PRO Powermeter across the 2024 range of BMC road bikes, specifically the Teammachine R 01 and Teammachine SLR 01 and the just recently launched new Roadmachine 01....

Cycling

Press Releases

Products

Triathlon