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 (21084)
) 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 310, 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

Lisa Foxx to Host the 2XU Malibu Triathlon

Malibu, CA – September 7, 2022 /ENDURANCE SPORTSWIRE/ – The 2XU Malibu Triathlon is excited to announce 104.3 MYfm radio personality, Lisa Foxx, as the host of its 36th annual event taking place at Zuma Beach in Malibu, CA on September 17 and 18. Lisa Foxx joins Super League Triathlon athletes...

Giving

Press Releases

Triathlon

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

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

August 29, 2022

Registration Open for Inaugural Rush to Crush Cancer Benefiting UPMC Hillman Cancer Center

PITTSBURGH (August 29, 2022) /ENDURANCE SPORTSWIRE/ – Registration is now open for the first-ever Rush to Crush Cancer benefitting UPMC Hillman Cancer Center. This inaugural event is expected to bring hundreds of participants to the Pittsburgh region to help raise awareness and dollars to support innovative research that will someday lead...

Cycling

Events

Giving

Press Releases

August 20, 2022

Record Number of Participants Celebrate 10th Anniversary of the Yinzer 4.12K

PITTSBURGH (August 20, 2022) /ENDURANCE SPORTSWIRE/ – A record number of nearly 800 yinzers wore their finest Pittsburgh attire while celebrating the 10th anniversary of the Yinzer 4.12K on the North Shore or participating virtually this morning. This year’s event raised more than $93,000 for the Light of Life Rescue Mission...

Events

Giving

Press Releases

Running

August 19, 2022

Run4Recovery Celebrates 15 Years of Running, Riding, and Raising Funds for Addiction Recovery

COVINA, Calif. /ENDURANCE SPORTSWIRE/ – Run4Recovery has announced that its founder Robin McGeough is making final preparations for this year’s edition of their annual endurance challenge and community event. Beginning Sept. 26, McGeough will ride 502 miles in just five days with the goal of raising $50,000. The event benefits the...

Cycling

Events

Giving

Press Releases

Running

August 17, 2022

Riders Around the World to Experience the Best Sights of Down Under with FulGaz Hope Cycle Tour of Australia

MELBOURNE, AUS/TAMPA, Fla. (August 17, 2022) ENDURANCE SPORTSWIRE/ - FulGaz®, The IRONMAN Group’s cutting-edge indoor virtual cycling app, announced today that cyclists from around the world will have the chance to experience the highlights of riding down under without leaving their homes with the Hope Cycle Tour of Australia. The...

Cycling

Giving

Press Releases

Products