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 (8742)
) 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 7270, 10

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 4, 2022

St. Jude Rock ‘n’ Roll Running Series Washington Welcomes Back Over 9,000 Registered Participants to The Pacific Northwest for The Ultimate Foot Tour of Bellevue

BELLEVUE, Wash. (September 4, 2022) /ENDURANCE SPORTSWIRE/ – The Rock ‘n’ Roll Running Series made its return to the Pacific Northwest for the first time since 2019 as the St. Jude Rock ‘n’ Roll® Running Series Washington took to the streets of Bellevue this weekend. Known for Bringing the Fun to...

Events

Press Releases

Running

September 2, 2022

Steve Lenz Jr. Helps bring BibBoard’s Partnerships across the Finish Line

/ENDURANCE SPORTSWIRE/ – As BibBoards continues to grow and partner with endurance events around North America it is important to bring in industry experts to help manage sponsorships and partnerships. BibBoards are the perfect tool for endurance event coordinators to provide added value to their events while factoring in marketing potential....

Business

Cycling

Press Releases

Running

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

September 1, 2022

Sea to Summit Triathlon moves to Kennebunkport, Maine

/ENDURANCE SPORTSWIRE/ – Maine’s coastal villages of Kennebunkport and Kennebunk will host the swim segment as well as the start of the bike leg for 2023’s Sea to Summit Adventure Triathlon. The announcement was made by the race organizer, New England Endurance Events. For the past decade the point-to-point race has...

Events

Press Releases

Triathlon

September 1, 2022

Red Kite Ride & Bike Club issue commemorative NFT jersey for all participants

/ENDURANCE SPORTSWIRE/ – Red Kite Ride, a UK charity ride benefitting multiple charities, has partnered with Bike Club to issue the first-ever NFT jersey as a participation reward. “We are thrilled to give every participant a timeless digital collectible as a keepsake from our ride this year,” says Kylie Grant, event...

Cycling

Events

Press Releases

Products

September 1, 2022

Lakeshore Athletic Services West Region Expansion

Lakeshore Athletic Services is pleased to announce the move to our new and improved office and warehouse location in Mesa, Arizona. Our new AZ headquarters are located in a brand new construction building, boasting a 1700 square foot office and warehouse facility. Event Equipment & Services Lakeshore Athletic Services has...

Business

Cycling

Press Releases

Products

Running

Triathlon

September 1, 2022

Elite: Iconic Canadian brand Ciele Athletics launches a top-of-the-line collection

MONTREAL (Sep. 1, 2022) /ENDURANCE SPORTSWIRE/ – Ciele Athletics, the high-end performance running brand from Montréal, Québec, is proud to announce the launch of Elite, a new collection for runners who want the very best in quality, comfort and technical innovation. “Elite is a key step in our continued commitment to...

Press Releases

Products

Running

September 1, 2022

CADEX Releases New Film Documenting Kristian Blummenfelt’s Historic Sub7 Triathlon Achievement

/ENDURANCE SPORTSWIRE/ - CADEX, a leading brand of high-performance cycling products, is set to release “Impossibly Fast: Kristian Blummenfelt’s Pursuit of Sub7,” a new film that documents the Norwegian’s journey to becoming the first athlete to complete the full Ironman triathlon distance in less than 7 hours. “The world sees...

Press Releases

Triathlon