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

January 19, 2024

KeyBank Named Title Partner of the Run for a Reason Charity Program for the 2024 DICK’S Sporting Goods Pittsburgh Marathon

PITTSBURGH, PA (January 19, 2024) /ENDURANCE SPORTSWIRE/ – P3R, the engine behind Pittsburgh's most exhilarating sporting events, has announced that KeyBank has been named title partner of the Run for a Reason Charity Program for the 2024 DICK’S Sporting Goods Pittsburgh Marathon Weekend of Events. More than 2,700 charity runners are...

Events

Giving

Press Releases

Running

Sponsorship

January 19, 2024

Zoot Sports Signs Triathlon Star Jackie Hering to Multi-Year Partnership Starting in 2024

Carlsbad, California /ENDURANCE SPORTSWIRE/ – Zoot Sports, the global leader in high-performance triathlon apparel and gear, is thrilled to announce the signing of professional triathlete Jackie Hering to a multi-year sponsorship agreement beginning in 2024. “We’re thrilled to stand behind Jackie as she competes at the pinnacle of this sport in...

Press Releases

Sponsorship

Triathlon

January 18, 2024

Tennis Maestro J.J. Wolf Takes Center Court as the New Ambassador for Electrolit’s Tennis Lineup

Houston, TX. (January, 2024)/ENDURANCE SPORTSWIRE/ – Electrolit – the preferred, premium hydration beverage made from pharmaceutical quality grade ingredients – today announces the signing of rising tennis star J.J. Wolf as an Electrolit athlete. "J.J. Wolf's relentless drive to push US Tennis forward inspires us at Electorlit and we're excited to be...

Press Releases

Sponsorship

January 18, 2024

Quintana Roo Announced as Challenge Family Global Swim Partner

/ENDURANCE SPORTSWIRE/ – Quintana Roo and Challenge Family announce a multi-year partnership naming Quintana Roo the Official Global Swim Partner of Challenge Family, beginning a collaboration that brings the original triathlon wetsuit brand to Challenge Family events throughout Europe, Asia and beyond. Now in its 21st year, Challenge Family hosts...

Press Releases

Sponsorship

Triathlon

January 18, 2024

Publix and Magic Sports Announce Major Strategic Partnership in Triathlon and Running Races Across Tennessee and Kentucky

Nashville, TN – January 18, 2024 /ENDURANCE SPORTSWIRE/ –Magic Sports, a leading organizer of triathlons and running races across the Southeast, is thrilled to announce a groundbreaking strategic partnership with Publix, one of the largest and fastest-growing supermarket chains in the United States. This partnership marks the largest sponsorship in the...

Events

Press Releases

Running

Sponsorship

Triathlon

January 17, 2024

PEARL iZUMi Announces 2024 Team and Athlete Roster

Broomfield, Colorado (January 17, 2024) /ENDURANCE SPORTSWIRE/ - PEARL iZUMi, the Colorado-based global leader in cycling apparel and footwear, proudly announces its 2024 athlete roster. PEARL iZUMi welcomes back veterans Alexey Vermeulen, Hannah Shell, Whit Allison, Zack Allison, Mark Mathews, and Jake Magee, while expanding their team with 41 new...

Cycling

Press Releases

Sponsorship

January 16, 2024

Verge Renews Sponsorship of Hot Tubes Cycling Team, Paving the Way for Future Cycling Champions.

NEW YORK, January 16, 2023 /ENDURANCE SPORTSWIRE/ – Verge, the innovative leader in custom cycling apparel, is excited to announce the continuation of its partnership with Hot Tubes, the most successful junior cycling team in the U.S. This renewed commitment underscores Verge's dedication to supporting the development of young talent in...

Cycling

Press Releases

Sponsorship

January 16, 2024

X-BIONIC® and Challenge Family Announce Multi-Year Partnership

/ENDURANCE SPORTSWIRE/ - Challenge Family and X-BIONIC® have announced a four-year partnership that positions the Swiss high-tech performance sportswear company as Official Functional Apparel Partner to the global triathlon series. The partnership will see the two leaders in their fields work together, along with both age group and elite Challenge...

Press Releases

Sponsorship

Triathlon

January 16, 2024

GU Energy Labs and 3M Half Marathon Collaborate for Ultimate Race-Day Fueling in the 30th Anniversary Edition

AUSTIN, Texas, January 16, 2024 /ENDURANCE SPORTSWIRE/ - High Five Events, a leading event production company in the United States, proudly names GU Energy Labs (GU) as the Official Energy Gel and Chew sponsor for the 30th annual 3M Half Marathon. This renewed collaboration solidifies GU's role in supporting participants...

Events

Press Releases

Running

Sponsorship