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

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

May 15, 2023

Sportive Breaks announces launch of travel & spectator packages for the 2023 UCI Cycling World Championships

15th May 2023 - Manchester UK /ENDURANCE SPORTSWIRE/ – Sports travel experts Sportive Breaks offer bespoke premium travel packages for cyclists looking to take part in Europe’s most prestigious cycling events, cycling breaks and weekenders. Be it that you are looking for your next big endurance challenge or simply some time away...

Cycling

Events

Press Releases

Sponsorship

May 15, 2023

Pho3nix Announce Athlete Program Paris 2024

/ENDURANCE SPORTSWIRE/ - The Pho3nix Foundation has today announced the initial ten athletes who will receive support in their campaigns to qualify for the 2024 Paris Olympic Games via the Pho3nix Athlete Program. Now in its third Olympic cycle, the Pho3nix Athlete Program aims to assist Olympic athletes from any...

Press Releases

Sponsorship

May 12, 2023

CapTex Tri Taps EIGHT Beer as Official Beer Sponsor

AUSTIN, Texas, May 12, 2023/ENDURANCE SPORTSWIRE/ – High Five Events, one of the largest privately owned event production companies in the United States, pens sponsorship deal with EIGHT Beer making it the Official Beer of the Ascension Seton CapTex Tri. This inaugural agreement means EIGHT Beer will feature its Texas-brewed beer...

Cycling

Press Releases

Running

Sponsorship

Triathlon

May 11, 2023

PTO Signs Up ROUVY as New Partner of PTO Tour

London/ENDURANCE SPORTSWIRE/ – The Professional Triathletes Organisation (PTO) has announced a new partnership with ROUVY, who will become the Official Virtual Ride Partner of the 2023 PTO Tour. As part of the partnership, the leading indoor cycling platform will give amateur triathletes the exclusive opportunity to join a Virtual Ride by ROUVY...

Press Releases

Sponsorship

Triathlon

May 11, 2023

Nulo & Spartan Team Up to Promote Proper Nutrition for Pets Across the U.S.

Boston, MA and Austin, TX, May 11, 2023 /ENDURANCE SPORTSWIRE/ – Nulo, the innovative pet nutrition brand that believes that inside our best friend lives an incredible canine or feline athlete, today announced their partnership with Spartan, making Nulo the Official Pet Food and Pet Treat of Spartan Race U.S. For...

Press Releases

Products

Running

Sponsorship

May 10, 2023

Long Beach Runners Have New Opportunities to Prepare for October Marathon

Long Beach, CA – May 10, 2023/ENDURANCE SPORTSWIRE/ – The Long Beach Marathon and Half Marathon today announced a new partnership with specialty outdoor retailer REI for the 2023 event, including a series of events leading up to the races. The marathon is Southern California’s largest fall road race and will...

Press Releases

Running

Sponsorship