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

September 8, 2022

Showcased

A Business as Secure as Your Bib: BibBoards Celebrates 5 Years

/ENDURANCE SPORTSWIRE/ - BibBoards is celebrating five years of serving endurance athletes, brands, and race coordinators. BibBoards has grown significantly in the last few years and has made a commitment to partnering with more brands, races, and organizations to get BibBoards into the hands and onto the shirts of more...

Awards

Business

Giving

Press Releases

Products

Sponsorship

Studies

Trade Shows

Triathlon

September 7, 2022

TriDot Welcomes Michellie Jones, Olympic Silver Medalist & IRONMAN World Champion, to the TriDot Coach Community

DALLAS, TX – September 7, 2022/ENDURANCE SPORTSWIRE/ – Michellie Jones, acclaimed triathlete and coach, has joined TriDot’s growing community of coaches that also includes ESPN’s “Greatest Endurance Athlete of All Time,” Mark Allen, who adopted the TriDot platform earlier this year. “I have been competing and coaching for over 30 years, and...

Press Releases

Sponsorship

Triathlon

September 7, 2022

Run • Tri • Bike Announces Sponsorship of MMTC Youth Team

PHOENIX – September 2022 /ENDURANCE SPORTSWIRE/ - Endurance Sports Investment Group, LLC (“ESIG”) dba Run • Tri • Bike moves forward with a youth initiative by becoming the presenting sponsor of the Mid-Maryland Triathlon Club (“MMTC”) Youth Team for the remainder of 2023. “I received an email from Lisa Steptoe...

Press Releases

Sponsorship

September 6, 2022

Specialized Supports The Cactus Cup For Iconic Mountain Bike Racing In 2023

/ENDURANCE SPORTSWIRE/ – Mountain bike racing returns to Arizona’s singletrack for a weekend of high-intensity racing and family fun at the 2023 Cactus Cup, March 10 through 12. Specialized Bicycles was the title sponsor of this iconic event throughout the 1990s and a supporter since its rebirth in 2017. Now, the...

Cycling

Events

Press Releases

Sponsorship

September 6, 2022

Zeinab Rezaie Will Be First-Ever Afghan Woman To Toe The Line At IRONMAN 70.3 World Championship

LOS ANGELES /ENDURANCE SPORTSWIRE/ – Punch Gunk has announced its sponsorship of endurance athlete Zeinab Rezaie, who will soon become the first-ever female athlete from Afghanistan to compete in the IRONMAN 70.3 World Championship. The award-winning pain relief brand is backing Rezaie and nonprofit She Can Tri as they advocate for...

Giving

Press Releases

Sponsorship

Triathlon

September 2, 2022

Super League Triathlon Announce FORM As Official Swim Goggles Partner

/ENDURANCE SPORTSWIRE/ – Super League Triathlon is the world’s premiere swim-bike-run Series, with its biggest ever Championship Series, featuring short, sharp, and exciting racing formats starring the best athletes in the world, kicking-off in London on Sunday, September 4. FORM is the tech-enabled swim platform with a simple mission: to break down...

Press Releases

Sponsorship

Triathlon

August 31, 2022

Pikes Peak APEX Adds Three New Partners for September Event

Colorado Springs, CO, September 1, 2022 /ENDURANCE SPORTSWIRE/ - Sports Strategies announces three new partners of The Pikes Peak APEX presented by RockShox. REI, Fat Tire and Flow Formulas have all partnered with the APEX to provide an enhanced experience to racers this September 22-25. “We always want to partner...

Cycling

Events

Press Releases

Sponsorship

August 31, 2022

2XU Brings Performance Compression to Long Beach

Long Beach, CA – August 31, 2022 /ENDURANCE SPORTSWIRE/ –  The Long Beach Marathon and Half Marathon today welcomed technical sports apparel company 2XU as a new community partner for the 2022 event. The partnership brings together one of Southern California’s premier fall road races with one of the world’s best...

Press Releases

Running

Sponsorship