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

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

January 3, 2024

Varlo Sports Secures Seed Funding for Growth and Innovation, Attracts Investment from REI Co-op Path Ahead Ventures

CHERRY HILL, N.J. (Jan. 3, 2024)/ENDURANCE SPORTSWIRE/ – Varlo Sports, a trailblazing company at the intersection of design and performance in the sports apparel industry, proudly announces the successful completion of its most recent seed funding round. This significant milestone ensures the company's continued growth and operational excellence as it embarks on...

Business

Cycling

Press Releases

Running

Triathlon

Wire Syndication

January 3, 2024

Strava Releases Year In Sport Trend Report, Showing What Makes and Breaks Motivation Across Generations

SAN FRANCISCO – January 3, 2024 /ENDURANCE SPORTSWIRE/ –  Strava, the leading digital community for active people with more than 120 million athletes, today announced the release of Year In Sport: The Trend Report, highlighting the global trends among active people across generations. It’s no surprise that Gen Z’s behaviors and...

Cycling

Press Releases

Running

Studies

Triathlon

January 3, 2024

Verge Launches Cutting-Edge 2024 Custom Apparel

NEW YORK, January 3rd, 2024 /ENDURANCE SPORTSWIRE/ – Verge founder Mike Magur began making custom cycle apparel in New York since 1996, driven by two passions: technical innovation and a love of cycling. Over two decades later, we proudly introduce our 2024 custom apparel collection - crafted to help riders of...

Cycling

Press Releases

Products