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

January 8, 2024

Phil Gyori Named Chief Executive Officer of United Sports Brands

Fountain Valley, CA (Jan 8, 2024) /ENDURANCE SPORTSWIRE/ - United Sports Brands is pleased to announce the appointment of Phil Gyori as Chief Executive Officer. Phil most recently served as the CEO of Pelican Products, and has also held past senior leadership roles at top outdoor and lifestyle brands such...

Business

Press Releases

January 5, 2024

Zoot Sports Signs The Real Triathlon Squad

SAN DIEGO, Calif. /ENDURANCE SPORTSWIRE/ - Zoot Sports, a global leader in triathlon apparel and gear, is proud to announce the signing of The Real Triathlon Squad (RTS) to its elite pro roster. Consisting of top pro triathletes Nick Chase, Tamara Jewett, Lesley Smith, Marc Dubrick, Jackson Laundry, Garric Loewen,...

Press Releases

Sponsorship

Triathlon

January 4, 2024

Showcased

Photo Finishes and Compelling Debuts Expected at the 52nd Annual Chevron Houston Marathon

HOUSTON, TX /ENDURANCE SPORTSWIRE/ - The woman who sits at the top of the Aramco Houston Half Marathon all-time list will attempt to race her way into the Chevron Houston Marathon record books later this month. The men’s race will feature a rematch of last year’s thrilling photo finish. The...

Events

Press Releases

Running

January 4, 2024

Free Fly Apparel Signs Pro Surfer Evan Geiselman

Charleston, SC (January 4, 2024) /ENDURANCE SPORTSWIRE/ - Free Fly, a pioneering brand in bamboo performance apparel built for the outdoors, is thrilled to announce the recent signing of professional surfer and passionate fisherman Evan Geiselman. Evan will be joining the growing Surf Ambassador Team and bringing his lifelong knowledge...

Press Releases

Sponsorship

January 4, 2024

Showcased

For Sale Memphis in May Triathlon

Memphis, TN /ENDURANCE SPORTSWIRE/ - P.R Event Management will offer to interested and qualified parties the opportunity to acquire the Legacy 40th Memphis in May Olympic and Sprint Triathlons in time for the 2024 season. Since the inception of the Memphis In May Triathlon in 1983 the event has been...

Business

Events

Press Releases

Triathlon

January 4, 2024

80/20 Endurance Launches Virtual Training and Plans on Velocity Indoor Cycling Platform

Highland Park, Illinois, January, 2024 /ENDURANCE SPORTSWIRE/ – 80/20 Endurance, a leader in the global endurance training and coaching industry, has launched its virtual cycling and enhanced training plan offerings on Velocity, with the Team 80/20 Virtual Cycling Club. 80/20 Endurance is currently leading Live, Replay and On-demand cycling workouts on...

Business

Cycling

Press Releases

Products

Triathlon