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

January 27, 2022

deboer wetsuits introduces the deboer ProAm Team

Stamford, CT, Release: January 27, 2022 /ENDURANCE SPORTSWIRE/ - deboer wetsuits is proud to introduce the deboer ProAm Team.  The deboer ProAm Team allows professional triathletes (Pro) as well as amateurs (Am) to share more than the course – ‘it's one thing to race alongside your favourite triathletes, it's another to...

Business

Press Releases

Sponsorship

Triathlon

January 27, 2022

Mana Signs Marquee IRONMAN For Argon Bikes

/ENDURANCE SPORTSWIRE/ - MANA Sports & Entertainment Group are proud to announce MANA athlete Joe Skipper has signed on to ride Argon18 bicycles. The British Ironman champion will be riding the E-119 Tri+ Disc with two Ironman World Championship races on completely different courses in his sights for 2022. He...

Press Releases

Sponsorship

January 27, 2022

Supersapiens and EOLO-KOMETA Cycling Team Announce Partnership

ATLANTA, 27 January 2022  /ENDURANCE SPORTSWIRE/ - Powered by Abbott’s Libre Sense Glucose Sport Biosensor, a revolutionary window into the body, Supersapiens delivers innovative insights that will help the Italian-registered team make informed fueling decisions to optimize training and recovery. The EOLO-KOMETA Cycling Team is a UCI ProTeam and in 2021,...

Cycling

Press Releases

Sponsorship

January 26, 2022

“The Ride for Mental Health” Gears Up to Pass $1 Million In Donations for Mclean Hospital

NEW YORK CITY and BOSTON (Jan. 26, 2022) /ENDURANCE SPORTSWIRE/ -  The Ride for Mental Health, a weekend of cycling and camaraderie in the picturesque Hudson Valley just 90 minutes north of Manhattan, is on pace to surpass the $1 million mark in total donations when it returns to New...

Business

Cycling

Events

Giving

Press Releases

Products

Sponsorship

Triathlon

January 26, 2022

Professional Triathletes Organisation Announce Partnership with USA Triathlon and Dallas Sports Commission to Establish The PTO US Open in Las Colinas-Irving, Texas

LONDON /ENDURANCE SPORTSWIRE/ - The Professional Triathletes Organisation (PTO) today announced the first ever stateside PTO Tour event – The PTO US Open – in partnership with USA Triathlon, the Dallas Sports Commission and the City of Irving on 17-18th September in  Las Colinas-Irving, Texas. The inaugural PTO USA Open is...

Events

Press Releases

Sponsorship

Triathlon

January 25, 2022

Hyperice Becomes the Official Recovery Technology of The Global IRONMAN Triathlon Series

TAMPA, Fla. (January 25, 2022) /ENDURANCE SPORTSWIRE/ - IRONMAN today announced that Hyperice, a global high-performance wellness brand, have entered into a new long-term, global partnership making Hyperice the Official Recovery Technology of the Global IRONMAN® Triathlon Series. After a near 10-year successful relationship across the U.S. region between IRONMAN...

Events

Press Releases

Sponsorship

Triathlon

January 25, 2022

Team Bend Racing’s Jason Magness to Compete in Sweden’s One Water Race

Bend, Oregon (January 25, 2022) /ENDURANCE SPORTSWIRE/ - With nearly two decades of experience under his belt, Jason Magness has earned a reputation as one of the toughest and most savvy adventure racers in the world. This summer he will put his tenacity and experience to the test as he...

Events

Press Releases

Running

Sponsorship

Triathlon

January 25, 2022

WOLFpak Returns as Official Backpack Partner of 2022 Surf City Marathon

HUNTINGTON BEACH – January 25, 2022 /ENDURANCE SPORTSWIRE/ - The Surf City Marathon, today welcomed a renewed partnership with motivational lifestyle brand WOLFpak, as the official backpack partner of the 2022 event. The 26th edition of the Surf City Marathon and Half Marathon will welcome thousands of runners to Huntington...

Events

Press Releases

Running

Sponsorship

January 25, 2022

US Trail Running Conference announces Marathon Printing as Presenting Sponsor for 2022 Webinar Series

Estes Park, CO /ENDURANCE SPORTSWIRE/ - US Trail Running Conference organizers Active at Altitude, announces that Marathon Printing is the Presenting Sponsor for the 2022 Webinar Series. The USTRC webinar series is geared to trail race directors and features monthly presentations on key subject areas that are critical for race directors to...

Press Releases

Running

Sponsorship