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 (22)
) 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

May 22, 2023

Intelligentsia Coffee Returns as Title Sponsor for the Intelligentsia Cup

May 22, 2023 Chicago, IL /ENDURANCE SPORTSWIRE/ - The Intelligentsia Cup is pleased to announce Intelligentsia Coffee is returning as the Title Sponsor for the 2023 race series. “Nothing goes together quite like coffee and cycling and we are so grateful for the partnership and support we have received from...

Cycling

Events

Press Releases

Sponsorship

May 18, 2023

Champion Vibram U.S. Athlete Heads to Denali for FKT

Boston, Massachusetts, May 18th, 2023 /ENDURANCE SPORTSWIRE/ - Meredith Edwards, a US mountain endurance athlete and member of Team Vibram is headed to Alaska to start her FKT attempt of Denali – the highest mountain peak in North America. With a summit elevation of 20,310 feet above sea level, and...

Press Releases

Sponsorship

May 18, 2023

FRESHJUNKIE Racing named as a Finalist for Sports ETA – Event Partnership of the Year with the War Eagle Run Fest

AUBURN, AL./ENDURANCE SPORTSWIRE/ – FRESHJUNKIE Racing, a leading event management company, is proud to announce its recognition as a finalist for Sports Events and Tourism Association Event Partnership of the Year in markets under 500,000 with the War Eagle Run Fest. The annual event, which took place in its inaugural year...

Awards

Events

Press Releases

Running

Sponsorship

May 18, 2023

VALR Fitness Welcomes Two-time Olympic Gold Medalist and World Champion Triathlete Alistair Brownlee to Team

RESTON, Virginia – May 18, 2023 / ENDURANCE SPORTSWIRE / – VALR, a fitness training technology company based in the Washington, DC area, announces the addition of Alistair Brownlee to its team as Senior Advisor. The first triathlete to successfully defend an Olympic Gold Medal, Alistair will advise on training...

Cycling

Press Releases

Running

Sponsorship

Triathlon

May 18, 2023

DoorDash joins 2023 Zappos Bay to Breakers as Premier Partner

San Francisco, CA - May 18, 2023 /ENDURANCE SPORTSWIRE/ – The Zappos Bay to Breakers, one of America's most historic and beloved road races, is delighted to welcome DoorDash as the “Official Food Delivery Service” for the annual running of the San Francisco classic on Sunday, May 21, 2023 “The Zappos...

Press Releases

Running

Sponsorship

May 18, 2023

ATriathletesDiary.com Seeks Sponsors to Support Continued Growth and Valuable Content for Endurance Sports Enthusiasts

Merrick, NY - [May 18, 2023] /ENDURANCE SPORTSWIRE/ - ATriathletesDiary.com, a leading blog dedicated to the endurance sports community, is calling for sponsors to help support its continued growth and provide even more valuable content to its readers. The blog was recently named one of the top six triathlon blogs...

Business

Cycling

Press Releases

Products

Running

Sponsorship

Triathlon

May 17, 2023

Blueseventy Named As Official Wetsuit Partner of Super League Triathlon’s 2023 USA Events

/ENDURANCE SPORTSWIRE/ – Super League Triathlon can today announce Blueseventy as the Official Wetsuit Partner of its 2023 USA events. Blueseventy will partner with SLT across its three races in North America - the Malibu Triathlon, Chicago Triathlon and New York City Triathlon. SLT acquired the Chicago and New York City...

Press Releases

Sponsorship

Triathlon

May 16, 2023

US Trail Running Conference Announces RouteArrows.com As Run Sponsor & Exhibitor

Nailsworth, England /ENDURANCE SPORTSWIRE/ – US Trail Running Conference, presented by Marathon Printing, announces that conference exhibitor RouteArrows.com will be the Official Supplier of Route Marking Products for the 2023 USTRC Fun Runs. The 2023 edition takes place in Mukilteo, Washington, October 18-20, remaining in the Pacific Northwest for the second...

Press Releases

Running

Sponsorship

Trade Shows

May 16, 2023

Powering Performance: INFINIT Nutrition Announced as Official Nutrition Partner of TRI AMSTERDAM

(Prague, Czech Republic)/ENDURANCE SPORTSWIRE/ – INFINIT Nutrition, a leading player in the US sports nutrition market since 2003, is focusing more on Europe with immediate effect and will therefore become Official Nutrition Sponsor of TRI AMSTERDAM. Athletes will be offered sports drinks from INFINIT during and after the race. "As an...

Press Releases

Sponsorship

Triathlon