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 (11)
) 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 1410, 10

May 21, 2024

Mauna Lani, Auberge Resorts Collection Partners With 3x Hawaii IRONMAN® Champ Craig “Crowie” Alexander for Exclusive Triathlon Training Experience

Kohala Coast, Hawai’i /ENDURANCE SPORTSWIRE/ - Mauna Lani, Auberge Resorts Collection, is excited to announce its exclusive partnership with 3x Hawaii IRONMAN World Champion Craig “Crowie” Alexander in the creation of its Kona Triathlon Experience, a six-day training camp that will take place August 11-16, 2024. Train side-by-side with Alexander at...

Business

Press Releases

May 21, 2024

Anti-doping: UTMB Group strengthens its commitment to clean trail-running

100,000 Euro investment in 2024 Tests conducted by the International Testing Agency (ITA), an independent organization Creation of UTMB World Series anti-doping rules in line with the World Anti-Doping Agency (WADA) Educative training program for elite athletes and their managers to support and guide them in their practices Chamonix (France),...

Business

Press Releases

Running

May 21, 2024

Ashworth Awards Welcomes Mike Schmitz as its Director of Strategic Development

/ENDURANCE SPORTSWIRE/ – Mike Schmitz, previously of Electric City Printing (Vice President Competition Media Division & President), emediagroup (Event Media Consultant), and, most recently, MYLAPS Sports Technology (Managing Director of the Americas), has joined Ashworth Awards as its Director of Strategic Development. Dan and Kim Ashworth as well as our...

Business

Press Releases

May 20, 2024

Summer Sips: Electrolit Launches Watermelon Lime for Hydration with a Tangy Twist

Houston, TX (May 20, 2024) /ENDURANCE SPORTSWIRE/ - Electrolit – the preferred, premium hydration beverage crafted with pharmaceutical quality grade ingredients – combines the tangy zest of lime with the nostalgic summer taste of watermelon with the debut of its new limited edition, scientifically formulated Watermelon Lime flavor, now on...

Business

Press Releases

Products

Running

May 20, 2024

Murf Electric Bikes Empowers Riders with Tips for Bike Safety Awareness Month

San Clemente, CA /ENDURANCE SPORTSWIRE/ - Murf Electric Bikes, a pioneering force in the e-bike industry since its inception in 2016, is committed to promoting road safety for cyclists in honor of National Bicycle Safety Month this May. In recognition of the shared responsibility on the roads, Murf emphasizes the critical...

Business

Press Releases

Products

May 20, 2024

Monari Federzoni Signs On to Sponsor Gran Fondo National Series

(Gettysburg, PA – May, 2024) /ENDURANCE SPORTSWIRE/ - Gran Fondo National Series today announced that Monari Federzoni has signed on as a Series sponsor for 2024 and 2025. Age group winners at six annual Series-owned events will take home bottles of Monari Federzoni “Passion of Family” high-density Balsamic Vinegar of...

Business

Cycling

Events

Press Releases

Sponsorship

May 17, 2024

Sports Tours International Acquires U.S. Running Tour Operator, Destination Marathons

Charlotte, NC /ENDURANCE SPORTSWIRE/ - Industry-leading running tour operator, Sports Tours International, has completed the acquisition of US based tour operator, Destination Marathons. This strategic move marks an exciting new chapter for both companies. Destination Marathons joins the Sports Tours International Group, providing American runners with greater opportunity than ever...

Business

Events

Press Releases

Running

May 17, 2024

RunSignup Reports 2024 Technology Development Update

Moorestown, NJ /ENDURANCE SPORTSWIRE/ - RunSignup, the leading registration and technology provider for races in the U.S., is excited to announce significant advancements in its platform, showcasing cutting-edge solutions for events in the United States. Highlighting recent technological strides for event organizers and timers within the endurance industry and adjacent...

Business

Cycling

Events

Giving

Press Releases

Products

Running

Triathlon