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

September 7, 2022

BibRave Leads First In-Person Brooks Running Ambassador Summit

Portland, OR /ENDURANCE SPORTSWIRE/ – BibRave, the leading-edge endurance and fitness marketing agency, brought to life the first in-person summit, called Camp Run Happy, for Brooks’ Run Happy Team ambassador program. The event took place both virtually and in-person in Park City, Utah, bringing together over 150 ambassadors for a three-day weekend...

Press Releases

Running

Trade Shows

September 6, 2022

A Family Affair at She Tris

Charleston, SC (September 6, 2022) /ENDURANCE SPORTSWIRE/ - If you’re local to the Charleston, SC area, you’ve probably heard or read about the all-women short distance triathlon events called She Tris Sprint Triathlon. Started by Angela Klick of Mt. Pleasant, the event series is designed to welcome women to a...

Events

Press Releases

Triathlon

September 6, 2022

Elevation Culture launches creative event services

/ENDURANCE SPORTSWIRE/ – Since 2015 Elevation Culture has designed and created for over 3,000 + trail/mountain sports events across the USA, in addition to working with some of the most influential outdoor industry brands. Founder and Designer of Elevation Culture Eric Chrisman pioneered the authentic finish line experience with the creation...

Business

Press Releases

September 6, 2022

Tifosi Optics Backs Breast Cancer Research with Awareness Collection

Watkinsville, GA (September 6, 2022)/ENDURANCE SPORTSWIRE/ – Tifosi Optics, a leading sport and lifestyle sunglasses brand, is proud to launch its Breast Cancer Awareness Collection featuring pink mirror lenses and pink frames. A portion of proceeds from each sale of the collection will be donated to the Lynn Sage Breast Cancer...

Giving

Press Releases

Products

September 6, 2022

Cycling Enthusiasts from Around The World Able to Experience 2022 Wollongong UCI Road World Championships Courses through FulGaz

WOLLONGONG, Australia/TAMPA, Fla. (September 6, 2022) /ENDURANCE SPORTSWIRE/ – FulGaz®, The IRONMAN Group’s cutting-edge indoor virtual cycling app, announced today that it would be partnering with Wollongong 2022 for the upcoming 2022 UCI Road World Championships, bringing the excitement of the event into homes around the world. The 2022 UCI Road...

Cycling

Events

Press Releases

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 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