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

March 10, 2022

Best Bike Split and EF Education-EasyPost Partner for the 2022 Season

Austin, TX /ENDURANCE SPORTSWIRE/ - Best Bike Split, the creator of pacing optimization software that helps cyclists get from point A to point B as fast as possible, and EF Education-EasyPost have announced that they will renew their partnership for the 2022 season with Best Bike Split continuing to be...

Cycling

Press Releases

Sponsorship

March 9, 2022

Enduro Bearings Announces Strong List of Sponsored Athletes/Teams for ‘22

Oakland, California (March 09, 2022)/ENDURANCE SPORTSWIRE/ - On the heels of announcing its groundbreaking Mechanics Ambassador Program, Enduro Bearings is proud to announce its 2022 athlete sponsorships, which includes a host of teams and individuals across a variety of cycling disciplines. All athletes will run industry-leading Enduro bearings and components including...

Cycling

Press Releases

Sponsorship

Triathlon

March 9, 2022

Intermountain Healthcare Named Title Partner for The 2021 IRONMAN World Championship taking place in St. George, Utah on May 7, 2022

TAMPA, Fla. / ST. GEORGE, Utah (Mar. 9, 2022)/ENDURANCE SPORTSWIRE/ - IRONMAN today announced Intermountain Healthcare as title partner for the 2021 IRONMAN World Championship taking place in St. George, Utah on Saturday, May 7, 2022. Intermountain Healthcare will also carry the title sponsorship for the 2022 IRONMAN 70.3 World...

Events

Press Releases

Sponsorship

Triathlon

March 9, 2022

Showcased

100% Announces Partnership with World No. 1 Triathlete Gustav Iden

SAN DIEGO, Calif. – March 9, 2022 /ENDURANCE SPORTSWIRE/ - 100%®, the San Diego-based sports performance company has announced a long-term partnership with the #1 ranked long-course Triathlete in the World, Gustav Iden. The 25-year-old Norwegian is recognized as the premier face of the next generation of triathlon. “We are excited...

Cycling

Press Releases

Sponsorship

Triathlon

March 9, 2022

Wearable Tech Brand INCUS Partner with Professional Triathlete Beth Potter

/ENDURANCE SPORTSWIRE/ - INCUS are delighted to be adding Beth Potter to an already impressive roster of INCUS Enabled athletes, including IRONMAN World Championship podium finisher David McNamee, paratriathlon World Champion Claire Cashmore, and three-times Ironman 70.3 champion Kimberley Morrison. INCUS’ mission is to push the boundaries of triathlon sports...

Press Releases

Running

Sponsorship

Triathlon

March 9, 2022

Challenge Family Partner with RemoteRacing

/ENDURANCE SPORTSWIRE/ - The partnership will allow athletes anywhere in the world to compete against those racing at Challenge Taiwan, The Championship, DATEV Challenge Roth powered by hep, and Challenge Almere-Amsterdam as though they were there with them. RemoteRacing creates a fair and level playing field for remote athletes with...

Press Releases

Sponsorship

Triathlon

March 8, 2022

Showcased

Colorado Classic Seeks Multi-Year Commitment to Relaunch Event

Denver, Colo. (March 8, 2022) /ENDURANCE SPORTSWIRE/ - The Colorado Classic®, America’s premier women’s only racing event, announces a public partnership request in a final effort to relaunch the event. In an open letter to supporters, the founder behind the event, Ken Gart, explains the current position of the Colorado...

Cycling

Events

Press Releases

Sponsorship

March 7, 2022

Publix named Title Partner for Rock ‘n’ Roll Running Series Clearwater Scheduled to take place October 1-2, 2022

TAMPA, Fla. (March 7, 2022) /ENDURANCE SPORTSWIRE/ - The Rock ‘n’ Roll® Running Series announced today that Publix Super Markets, Inc., the largest employee-owned grocery retailer in the country, will serve as the title partner for the inaugural Publix Rock ‘n’ Roll Running Series Clearwater scheduled to take place on Oct. 1-2,...

Press Releases

Running

Sponsorship