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

March 28, 2023

Showcased

INFINIT Europe Launches Custom Formula Platform

Prague, Czech Republic, March 28, 2023 /ENDURANCE SPORTSWIRE/ – INFINIT Nutrition, the industry leader in personalized sports nutrition, has announced the launch of its patented Custom formula platform to the European market. For nearly 20 years, INFINIT has been at the forefront of creating customized, all-in-one isotonic solutions designed to fuel...

Cycling

Press Releases

Products

Running

Triathlon

March 27, 2023

The Pro’s Closet Rebrands as TPC with new logo.

LOUISVILLE, Colo. (Mar. 27, 2023) /ENDURANCE SPORTSWIRE/ - The Pro’s Closet is streamlining: The online retailer announced a new look, logo, and brand identity this week, embracing and codifying the “TPC” acronym. With the abbreviation at the forefront of the brand, the rebrand includes a new logo, color palette, and...

Business

Cycling

Press Releases

March 27, 2023

Maccabi USA Seeking Jewish Runners, Cyclists and Triathletes for Pan American Maccabi Games

Philadelphia, PA, March 27, 2023 /ENDURANCE SPORTSWIRE/ – Maccabi USA is seeking qualified Jewish runners, cyclists and triathletes to represent the USA delegation at the XV Pan American Maccabi Games in Buenos Aires, Argentina from December 26, 2023 to January 4, 2024. Maccabi USA is currently recruiting for the following teams:...

Cycling

Events

Press Releases

Running

Triathlon

March 27, 2023

Pressio Launches US Website and Spring 23 Collection

March 27, 2023 /ENDURANCE SPORTSWIRE/ – Pressio, a technical apparel company committed to unparalleled performance and sustainable procurement, announced today the launch of a new U.S. e-commerce website and the direct availability of a new Spring/Summer 2023 collection. The U.K.-based company announced its plan to enter the US market last November...

Press Releases

Products

Running

March 27, 2023

Athletic Brewing IRONMAN Lake Placid Triathlon, Part of The VinFast IRONMAN North America Series Latest Event to Sell Out General Registration; Limited Entries Remain for a Number of 2023 IRONMAN and IRONMAN 70.3 Triathlons In North America

TAMPA, Fla. (March 27, 2023) /ENDURANCE SPORTSWIRE/ – IRONMAN announced today that general registration for the Athletic Brewing IRONMAN® Lake Placid triathlon, part of the VinFast IRONMAN North America Series has now sold out while several other IRONMAN and IRONMAN 70.3 triathlons across North America are nearing sell out status. Athletic...

Events

Press Releases

Triathlon

March 27, 2023

UTMB® World Series welcomes Näak as Official On Course Sports Nutrition and Sports Hydration Supplier

Chamonix (France) March 2023 /ENDURANCE SPORTSWIRE/ – UTMB ® World Series has partnered with Näak, the performance nutrition and hydration brand made for trail and ultra-runners, to bring sustainable fuel to the global trail running community. As Official On Course Sports Nutrition and Sports Hydration Supplier of the UTMB World Series,...

Press Releases

Sponsorship

March 27, 2023

Showcased

Kim Conley and Drew Wartenburg Launch Next Best Run, an Online Coaching Service for Runners

FLAGSTAFF, ARIZONA .ENDURANCE SPORTSWIRE/ - U.S. Olympian Kim Conley and track and field coach Drew Wartenburg have announced the official launch of Next Best Run. This comprehensive online service allows runners of all backgrounds and abilities to receive personalized coaching across all events and distances. Conley is a professional runner...

Business

Events

Press Releases

Running

March 27, 2023

Athletic Brewing Company continues partnership with Canada Running Series, Named Official Non-Alcoholic Beer of 3 Marquee Races

TORONTO, CAN (March 27, 2023) /ENDURANCE SPORTSWIRE/ – Athletic Brewing Company, America’s leading producer of non-alcoholic craft beer, has renewed its partnership with Canada Running Series (CRS), today announcing its return as the official non-alcoholic beer partner of the 2023 TCS Toronto Waterfront Marathon, and the 2023 Vancouver Half Marathon. Additionally,...

Events

Press Releases

Running

Sponsorship